--
-- `ban`
--
CREATE TABLE `ban` (
`id` int(11) NOT NULL auto_increment,
`ip` char(11) default NULL,
`user` char(75) default NULL,
`username` char(15) default NULL,
`time` int(15) default NULL,
`mess` varchar(600) default NULL,
`moder` char(15) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- `ban`
--
-- --------------------------------------------------------
--
-- `counter`
--
CREATE TABLE `counter` (
`id` int(15) NOT NULL auto_increment,
`username` varchar(15) NOT NULL,
`fid` int(11) NOT NULL,
`time` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
--
-- `counter`
--
-- --------------------------------------------------------
--
-- `forums`
--
CREATE TABLE `forums` (
`id` int(11) NOT NULL auto_increment,
`name` text,
`pos` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- `forums`
--
-- --------------------------------------------------------
--
-- `ignore`
--
CREATE TABLE `ignore` (
`id` mediumint(9) NOT NULL auto_increment,
`uid` mediumint(9) NOT NULL,
`ignore_user` varchar(15) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- `ignore`
--
-- --------------------------------------------------------
--
-- `posts`
--
CREATE TABLE `posts` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`post` text NOT NULL,
`crc32` int(10) NOT NULL,
`id_theme` int(11) NOT NULL,
`time` int(15) NOT NULL,
`useragent` text,
`ip` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
--
-- `posts`
--
-- --------------------------------------------------------
--
-- `private`
--
CREATE TABLE `private` (
`id` int(11) NOT NULL auto_increment,
`mess` text NOT NULL,
`name` varchar(15) NOT NULL default '0',
`mod` char(1) NOT NULL default '',
`tname` varchar(15) NOT NULL default '0',
`new` int(1) NOT NULL default '1',
`time` int(14) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- `private`
--
-- --------------------------------------------------------
--
-- `session`
--
CREATE TABLE `session` (
`sid` text NOT NULL,
`nickname` text NOT NULL,
`password` text NOT NULL,
`time` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- `session`
--
-- --------------------------------------------------------
--
-- `themes`
--
CREATE TABLE `themes` (
`id` int(11) NOT NULL auto_increment,
`tname` varchar(50) NOT NULL,
`name` text,
`close` text,
`id_forum` int(11) NOT NULL,
`time` int(15) NOT NULL,
`pos` int(1) default '1',
`del` int(1) default '0',
`mdel` char(15) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- `themes`
--
-- --------------------------------------------------------
--
-- `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(15) NOT NULL,
`password` varchar(15) NOT NULL,
`regdate` int(15) default NULL,
`status` varchar(10) default NULL,
`last_time` int(22) default NULL,
`realname` varchar(15) default NULL,
`rdate` varchar(10) default NULL,
`icq` int(15) default NULL,
`site` varchar(20) default NULL,
`mail` varchar(35) default NULL,
`sex` varchar(1) default NULL,
`about` varchar(1024) default NULL,
`shrift` varchar(6) default NULL,
`ps` int(11) NOT NULL,
`style` varchar(15) default NULL,
`transl` varchar(3) default NULL,
`order` int(1) default NULL,
`rating` int(15) default NULL,
`antirating` int(15) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- `users`
--
INSERT INTO `users` VALUES (1, 'Admin', '123456', 0, 'admin', 1221057337, '', '27-09-1988', 0, '', '', 'm', '', 'normal', 3000, 'sea', 'off', 1, 10000041, 0);
