CREATE TABLE `ayn_towns` (
`id` int(11) NOT NULL auto_increment,
`town` varchar(128) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `town` (`town`),
KEY `area` (`area`)
) TYPE=MyISAM AUTO_INCREMENT=1;
CREATE TABLE `qa_local` (
`id` int(11) NOT NULL auto_increment,
`q_id` int(11) NOT NULL default '0',
`town_id` int(11) NOT NULL default '0',
`user_id` int(11) default NULL,
`datetime` int(11) NOT NULL default '0',
`name` varchar(64) NOT NULL default '',
`text` text NOT NULL,
`active` int(11) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `town_id` (`town_id`),
KEY `user_id` (`user_id`),
KEY `active` (`active`),
KEY `q_id` (`q_id`),
KEY `datetime` (`datetime`)
) TYPE=MyISAM AUTO_INCREMENT=3788 ;
CREATE TABLE `qa_uk` (
`id` int(11) NOT NULL auto_increment,
`q_id` int(11) NOT NULL default '0',
`town_id` int(11) NOT NULL default '0',
`user_id` int(11) default NULL,
`datetime` int(11) NOT NULL default '0',
`name` varchar(64) NOT NULL default '',
`host` varchar(255) default NULL,
`text` text NOT NULL,
`active` int(11) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `q_id` (`q_id`),
KEY `town_id` (`town_id`),
KEY `user_id` (`user_id`),
KEY `active` (`active`),
KEY `datetime` (`datetime`)
) TYPE=MyISAM AUTO_INCREMENT=7530 ;
CREATE TABLE `qq_local` (
`id` int(11) NOT NULL auto_increment,
`q` int(11) NOT NULL default '0',
`q_town_id` int(11) NOT NULL default '0',
`datetime` int(11) NOT NULL default '0',
`user_id` int(11) default NULL,
`town_id` int(11) NOT NULL default '0',
`name` varchar(64) NOT NULL default '',
`text` text NOT NULL,
`active` int(11) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `q` (`q`),
KEY `q_town_id` (`q_town_id`),
KEY `user_id` (`user_id`),
KEY `town_id` (`town_id`),
KEY `active` (`active`),
KEY `datetime` (`datetime`),
) TYPE=MyISAM AUTO_INCREMENT=51558 ;
CREATE TABLE `qq_uk` (
`q` int(11) NOT NULL default '0',
`datetime` int(11) NOT NULL default '0',
`user_id` int(11) default NULL,
`town_id` int(11) NOT NULL default '0',
`name` varchar(64) NOT NULL default '',
`text` text NOT NULL,
`del_date` int(11) default NULL,
`active` int(11) NOT NULL default '1',
KEY `q` (`q`),
KEY `datetime` (`datetime`),
KEY `user_id` (`user_id`),
KEY `town_id` (`town_id`),
KEY `active` (`active`)
) TYPE=MyISAM;