View file angrm/sql.sql

CREATE TABLE `anagramma` (
  `id` int(11) NOT NULL auto_increment,
  `original_text` varchar(32) NOT NULL default '0',
`balls` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE `anagramma_form` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL,
  `msg` varchar(1024) character set utf8 collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `user` ADD `angrm_point` int(11) NOT NULL default '0';