CREATE TABLE `banned` (
`id_ban` int(10) NOT NULL auto_increment,
`srok` int(255) NOT NULL,
`id_user` int(10) default NULL,
`kto_zabanil` int(10) default NULL,
`dopinf` varchar(5000) NOT NULL,
`prich` int(2) default NULL,
`timer` int(255) NOT NULL,
PRIMARY KEY (`id_ban`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `chat` (
`id_soob` int(15) NOT NULL auto_increment,
`id_user` int(15) NOT NULL,
`soob` varchar(5000) character set utf8 default NULL,
`dater` varchar(50) NOT NULL,
`timer` int(100) NOT NULL,
`id_group` int(15) NOT NULL,
KEY `id_soob` (`id_soob`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `forum_kategory` (
`id_forum` int(10) NOT NULL auto_increment,
`fname` varchar(300) NOT NULL,
`fopis` varchar(5000) NOT NULL,
`gde` int(10) default NULL,
`rasp` int(10) NOT NULL,
KEY `id_forum` (`id_forum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `forum_messages` (
`id_mes` int(25) NOT NULL auto_increment,
`id_them` int(15) NOT NULL,
`id_user` int(15) NOT NULL,
`fmtext` varchar(5000) NOT NULL,
`fmdater` varchar(40) NOT NULL,
`id_kat` int(10) NOT NULL,
`timer` int(100) NOT NULL,
`id_pkat` int(255) NOT NULL,
`kolred` int(5) NOT NULL,
`datered` varchar(50) NOT NULL,
`namered` varchar(100) NOT NULL,
KEY `id_mes` (`id_mes`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `forum_themes` (
`id_them` int(15) NOT NULL auto_increment,
`id_user` int(15) NOT NULL,
`id_kat` int(10) NOT NULL,
`ftname` varchar(300) NOT NULL,
`fttext` varchar(5000) NOT NULL,
`ftdater` varchar(40) NOT NULL,
`updater` int(100) NOT NULL,
`timer` int(100) NOT NULL,
`pervoe` varchar(50) NOT NULL,
`zakr` int(1) NOT NULL default '0',
`otkr` int(1) NOT NULL default '0',
`id_pkat` int(255) NOT NULL,
`kolred` int(5) NOT NULL,
`datered` varchar(50) NOT NULL,
`namered` varchar(100) NOT NULL,
KEY `id_them` (`id_them`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `groups` (
`id_group` int(10) NOT NULL auto_increment,
`gname` varchar(1000) NOT NULL,
`gopis` varchar(4000) NOT NULL,
`status` varchar(10) NOT NULL default 'moderate',
`gdater` varchar(30) NOT NULL,
`gadmin` int(15) NOT NULL,
`temami` varchar(300) NOT NULL,
KEY `id_group` (`id_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `koments` (
`id_kom` int(11) NOT NULL auto_increment,
`id_user` varchar(11) NOT NULL,
`dater` varchar(30) NOT NULL,
`text` varchar(2000) NOT NULL,
`id_kogo` int(11) NOT NULL,
`type` varchar(40) NOT NULL,
KEY `id_kom` (`id_kom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `load_files` (
`id_file` int(15) NOT NULL auto_increment,
`name` varchar(500) NOT NULL,
`opis` varchar(5000) NOT NULL,
`screen` varchar(500) NOT NULL,
`typer` varchar(30) NOT NULL,
`nastna` varchar(200) NOT NULL,
`format` varchar(10) NOT NULL,
`razmer` float NOT NULL,
`loads` int(15) NOT NULL default '0',
`put` varchar(1000) NOT NULL,
`avtor` varchar(300) NOT NULL,
`dobav` int(255) NOT NULL,
KEY `id_file` (`id_file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `news` (
`id_news` int(10) NOT NULL auto_increment,
`dater` varchar(20) NOT NULL,
`ntext` varchar(5000) NOT NULL,
`id_group` int(15) NOT NULL default '0',
`timer` int(255) NOT NULL,
KEY `id_news` (`id_news`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `online` (
`id_on` int(10) NOT NULL auto_increment,
`iper` varchar(100) NOT NULL,
`uaer` varchar(200) NOT NULL,
`timer` int(255) NOT NULL,
`query` varchar(300) NOT NULL,
KEY `id_on` (`id_on`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `photos` (
`id_photo` int(15) NOT NULL auto_increment,
`id_user` int(15) NOT NULL,
`opis` varchar(500) NOT NULL,
`format` varchar(10) NOT NULL,
`kogda` varchar(100) NOT NULL,
`glavn` varchar(1) NOT NULL default '0',
`loads` int(15) NOT NULL default '0',
`rplus` int(15) NOT NULL default '0',
`rminus` int(15) NOT NULL default '0',
KEY `id_photo` (`id_photo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `post` (
`id_post` int(15) NOT NULL auto_increment,
`id_ot` int(15) NOT NULL,
`id_komu` int(15) NOT NULL,
`ptext` varchar(2000) NOT NULL,
`pdater` varchar(40) NOT NULL,
`ptyper` varchar(2) NOT NULL,
`pstatus` varchar(10) default NULL,
`ptimer` int(100) NOT NULL,
KEY `id_post` (`id_post`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `rating` (
`id_rat` int(15) NOT NULL auto_increment,
`kto` varchar(200) NOT NULL,
`zakogo` varchar(200) NOT NULL,
`type` varchar(20) NOT NULL,
KEY `id_rat` (`id_rat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `referers` (
`id_ref` int(15) NOT NULL auto_increment,
`referer` varchar(300) NOT NULL,
`perehody` int(15) default NULL,
KEY `id_ref` (`id_ref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `syspost` (
`id_sys` int(10) NOT NULL auto_increment,
`text` varchar(5000) NOT NULL,
`id_user` int(10) NOT NULL,
`id_them` int(10) NOT NULL,
`pstatus` varchar(10) NOT NULL,
`timer` int(100) NOT NULL,
`typer` varchar(10) NOT NULL,
`newmes` int(10) NOT NULL,
PRIMARY KEY (`id_sys`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `system` (
`name` varchar(200) NOT NULL,
`value` varchar(200) NOT NULL,
`dvalue` varchar(2000) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `system` VALUES ('obn', '23.03.2010', '');
INSERT INTO `system` VALUES ('guestsk', '1', '');
INSERT INTO `system` VALUES ('zc_top', '10', '');
INSERT INTO `system` VALUES ('creater', '1', '');
INSERT INTO `system` VALUES ('zc_new', '172800', '');
CREATE TABLE `uchast` (
`id_uchast` int(10) NOT NULL,
`id_group` int(11) NOT NULL,
`status` varchar(10) NOT NULL,
KEY `id_uchast` (`id_uchast`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `users` (
`id_user` int(11) NOT NULL auto_increment,
`login` varchar(25) character set utf8 NOT NULL,
`pass` varchar(25) character set utf8 default NULL,
`ldate` varchar(30) character set utf8 NOT NULL,
`lip` varchar(20) character set utf8 NOT NULL,
`lua` varchar(200) character set utf8 NOT NULL,
`online` int(50) NOT NULL,
`age` varchar(3) character set utf8 default NULL,
`status` int(1) NOT NULL default '0',
`name` varchar(100) character set utf8 NOT NULL,
`surname` varchar(100) character set utf8 NOT NULL,
`pol` int(1) NOT NULL,
`about` varchar(5000) character set utf8 NOT NULL,
`balls` int(11) NOT NULL default '0',
`prating` int(15) NOT NULL default '0',
`mrating` int(15) NOT NULL default '0',
`gdeon` varchar(200) character set utf8 NOT NULL,
`lastplus` varchar(40) character set utf8 NOT NULL,
`lastphoto` varchar(40) character set utf8 NOT NULL,
`photos` int(15) NOT NULL default '0',
`site` varchar(300) NOT NULL,
`icq` varchar(9) NOT NULL,
`otkuda` varchar(1000) NOT NULL,
`forkol` int(6) NOT NULL,
`tforkol` int(6) NOT NULL,
`email` varchar(100) NOT NULL,
`vost` int(1) NOT NULL,
KEY `id_user` (`id_user`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `votes` (
`id_vote` int(10) NOT NULL auto_increment,
`vopros` varchar(5000) NOT NULL,
`type` varchar(2000) NOT NULL,
`otvet1` varchar(2000) NOT NULL,
`otvet2` varchar(2000) NOT NULL,
`otvet3` varchar(2000) NOT NULL,
`otvet4` varchar(2000) NOT NULL,
`otvet5` varchar(2000) NOT NULL,
`otvet6` varchar(2000) NOT NULL,
`otvet7` varchar(2000) NOT NULL,
`konec` int(1) NOT NULL default '0',
`kogda` int(255) NOT NULL,
PRIMARY KEY (`id_vote`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `votes_otv` (
`id_otv` int(10) NOT NULL auto_increment,
`id_user` int(10) default NULL,
`id_otvet` int(10) default NULL,
`id_vote` int(10) default NULL,
PRIMARY KEY (`id_otv`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;