| CREATE TABLE `board_category` ( |
| `id` int(11) unsigned NOT NULL auto_increment, |
| `refid` int(11) unsigned NOT NULL, |
| `name` varchar(50) NOT NULL, |
| `text` text NOT NULL, |
| `count` int(11) unsigned NOT NULL default '0', |
| `amount` int(11) unsigned NOT NULL default '0', |
| PRIMARY KEY (`id`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| |
| CREATE TABLE `board` ( |
| `id` int(11) unsigned NOT NULL auto_increment, |
| `refid` int(11) unsigned NOT NULL, |
| `cat` int(11) unsigned NOT NULL, |
| `users` int(11) unsigned NOT NULL, |
| `type` tinyint(4) NOT NULL, |
| `city` int(11) NOT NULL, |
| `name` varchar(100) NOT NULL, |
| `text` text NOT NULL, |
| `date` int(11) NOT NULL, |
| `timedel` int(11) NOT NULL, |
| PRIMARY KEY (`id`), |
| KEY `city` (`city`), |
| KEY `cat` (`cat`), |
| FULLTEXT KEY `text` (`text`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| |
| CREATE TABLE IF NOT EXISTS `board_сomplaint` ( |
| `id` int(11) unsigned NOT NULL auto_increment, |
| `refid` int(11) unsigned NOT NULL, |
| `users` int(11) unsigned NOT NULL, |
| `type` tinyint(4) NOT NULL, |
| `text` text NOT NULL, |
| `soft` text NOT NULL, |
| `ip` text NOT NULL, |
| PRIMARY KEY (`id`) |
| ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
