Файл: base_ony_su.sql
Строк: 83
--
-- `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);