[attachment=604:elf.rar]
CREATE TABLE `{prefix}_elf_cat` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`description` text NOT NULL,
`sort` text NOT NULL,
`parent` text NOT NULL,
`ico` text NOT NULL,
`top` int(11) default '0',
`ans` int(11) default '0',
`last` text,
`last_u` text NOT NULL,
`last_d` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM CHARSET=cp1251;
CREATE TABLE `{prefix}_elf_mass` (
`id` int(11) unsigned NOT NULL auto_increment,
`tid` int(11) unsigned default NULL,
`date` datetime NOT NULL,
`uid` int(11) unsigned NOT NULL,
`name` varchar(25) NOT NULL,
`ip` varchar(15) NOT NULL,
`text` text NOT NULL,
`karma` int(11) unsigned NOT NULL,
`karma_ids` text NOT NULL,
PRIMARY KEY (`id`),
KEY `mid` (`tid`)
) ENGINE=MyISAM CHARSET=cp1251;
CREATE TABLE `{prefix}_elf_topics` (
`id` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL,
`name` text NOT NULL,
`status` text NOT NULL,
`ico` text NOT NULL,
`ans` int(11) NOT NULL default '0',
`views` int(11) NOT NULL default '0',
`author` text NOT NULL,
`last_d` datetime default NULL,
`last_u` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM CHARSET=cp1251;
