Вход Регистрация
Файл: 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);
Онлайн: 1
Реклама