CREATE TABLE IF NOT EXISTS `batches` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, `type` smallint(6) NOT NULL default '0', `time` bigint(20) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `channels` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, `link` text NOT NULL, `desc` text NOT NULL, `copy` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `dict` ( `id` int(11) NOT NULL auto_increment, `dictionary_id` int(11) NOT NULL default '0', `word` text NOT NULL, `values` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `dictionaries` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, `editable` enum('0','1') NOT NULL default '1', `deletable` enum('0','1') NOT NULL default '1', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `generate-items` ( `id` int(11) NOT NULL auto_increment, `project_id` int(11) NOT NULL default '0', `trainer_id` int(11) NOT NULL default '0', `title` text NOT NULL, `title_length` int(11) NOT NULL default '0', `text_length` int(11) NOT NULL default '0', `links` text NOT NULL, `density` int(11) NOT NULL default '0', `granularity` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `generate-projects` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, `link` text NOT NULL, `desc` text NOT NULL, `copy` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `lsa-groups` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `lsa-items` ( `id` int(11) NOT NULL auto_increment, `group_id` int(11) NOT NULL default '0', `url` text NOT NULL, `words` text NOT NULL, `phrases` text NOT NULL, `used` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `relations` ( `host_id` text NOT NULL, `syn_id` text NOT NULL ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `services` ( `name` text NOT NULL, `email` text NOT NULL, `pin` text NOT NULL, `article_delimiter` text NOT NULL, `title_delimiter` text NOT NULL, `end_title_delimiter` text NOT NULL, `footer` text NOT NULL, `template` text NOT NULL, `url` text NOT NULL, `purl` text NOT NULL, `license` text NOT NULL ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `spinners` ( `id` int(11) NOT NULL auto_increment, `channels_id` mediumint(9) NOT NULL default '0', `title` text NOT NULL, `content` text NOT NULL,`titles` text NOT NULL, `variables` text NOT NULL, `links` text NOT NULL, `time` bigint(20) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `training-items` ( `id` int(11) NOT NULL auto_increment, `source` text NOT NULL, `trainer_id` int(11) NOT NULL default '0', `title` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `training-trainers` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `units` ( `id` int(11) NOT NULL auto_increment, `batch_id` int(11) NOT NULL default '0', `title` text NOT NULL, `content` text NOT NULL, `wordcount` int(11) NOT NULL default '0', `time` bigint(20) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `words` ( `id` int(11) NOT NULL auto_increment, `word` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `counters` (  `id` int(11) NOT NULL auto_increment,  `channels_id` int(11) NOT NULL,  `spinners_id` int(11) NOT NULL,  `marker` varchar(255) NOT NULL,  `cnt` int(11) NOT NULL,  PRIMARY KEY  (`id`)) ENGINE=MyISAM;