Вход Регистрация
Просмотр архива Вобля чат 5
Файл: install/MySQL_cp1251.sql
Строк: 1432
CREATE TABLE `friends` ( `id` int(20) NOT NULL auto_increment,
`user_id` int(20) NOT NULL default '0', `fr_id` int(20) NOT NULL default
'0', `yes` int(20) NOT NULL default '0', `no` int(20) NOT NULL default
'0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=0; CREATE TABLE `ignor` ( `id` int(20) NOT NULL
auto_increment, `user_id` int(20) NOT NULL default '0', `ig_id` int(20)
NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `levels` ( `id` int(20)
NOT NULL auto_increment, `level` int(5) NOT NULL default '0', `name`
blob, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; CREATE
TABLE `chats` ( `sid` int(20) NOT NULL auto_increment, `link`
varchar(200) character set cp1251 collate cp1251_bin NOT NULL default
'waphp.ru', `link_name` varchar(50) character set cp1251 collate
cp1251_bin NOT NULL default 'waphp.ru', `rus` int(1) NOT NULL default
'1', `reg` int(1) NOT NULL default '1', `umnik` varchar(50) character
set cp1251 collate cp1251_bin NOT NULL default 'umnik', `shut`
varchar(50) character set cp1251 collate cp1251_bin NOT NULL default
'shut', `anek` varchar(50) character set cp1251 collate cp1251_bin NOT
NULL default 'anek', `tupica` varchar(50) character set cp1251 collate
cp1251_bin NOT NULL default 'tupica', `svaisch` varchar(50) character set
cp1251 collate cp1251_bin NOT NULL default 'svaisch', `system`
varchar(50) character set cp1251 collate cp1251_bin NOT NULL default
'system', `baryga` varchar(50) character set cp1251 collate cp1251_bin
NOT NULL default 'baryga', `znatok` varchar(50) character set cp1251
collate cp1251_bin NOT NULL default 'znatok', `flyder` varchar(50)
character set cp1251 collate cp1251_bin NOT NULL default 'flyder',
`mafiozi` varchar(50) character set cp1251 collate cp1251_bin NOT NULL
default 'mafiozi', `victint` int(20) NOT NULL default '10', `shuttime`
int(20) NOT NULL default '1800', `znatoktime` int(20) NOT NULL default
'1800', `anektime` int(20) NOT NULL default '1800', `vict` int(1) NOT
NULL default '1', `cena_answ` int(20) NOT NULL default '100',
`timesdvig` int(20) NOT NULL default '0', `time_aut` int(20) NOT NULL
default '300', `head` text character set cp1251 collate cp1251_bin NOT
NULL default '', `antir` text character set cp1251 collate cp1251_bin NOT
NULL default '', `avtorega` int(2) NOT NULL default '0', `privat`
int(2) NOT NULL default '9', `posts_pr` int(20) NOT NULL default '0',
`posts_vph` int(20) NOT NULL default '0', `posts_vus` int(20) NOT NULL
default '0', `posts_nik` int(20) NOT NULL default '150', `size_photo`
int(20) NOT NULL default '250', `w_photo` int(20) NOT NULL default
'200', `h_photo` int(20) NOT NULL default '200', `size_foto` int(20)
NOT NULL default '500', `w_foto` int(20) NOT NULL default '100',
`h_foto` int(20) NOT NULL default '100', `w_foto2` int(20) NOT NULL
default '50', `h_foto2` int(20) NOT NULL default '50', `size_img_sten`
int(20) NOT NULL default '50', `w_img_sten` int(20) NOT NULL default
'100', `h_img_sten` int(20) NOT NULL default '100', `kom_p_posts`
int(20) NOT NULL default '10', `min_p_posts` int(20) NOT NULL default
'50', `max_p_posts` int(20) NOT NULL default '1000', `kom_p_rur`
int(20) NOT NULL default '100', `min_p_rur` int(20) NOT NULL default
'20', `max_p_rur` int(20) NOT NULL default '100', `kurs_bank_ob`
int(20) NOT NULL default '20', `size_lich` int(20) NOT NULL default
'20', `size_video` int(20) NOT NULL default '1000', `size_audio`
int(20) NOT NULL default '1000', `size_for` int(20) NOT NULL default
'1000', `size_vvod_for` int(20) NOT NULL default '1024', `for_time_p`
int(20) NOT NULL default '10', `for_time_t` int(20) NOT NULL default
'60', `for_cit` int(20) NOT NULL default '200', `for_privat` int(20)
NOT NULL default '9', `kik_notify` int(20) NOT NULL default '1',
`ban_notify` int(20) NOT NULL default '1', `ban2_notify` int(20) NOT NULL
default '1', `reg_notify` int(20) NOT NULL default '1', `style`
varchar(50) character set cp1251 collate cp1251_bin NOT NULL default
'sasisa', `alignpr` varchar(50) character set cp1251 collate cp1251_bin
NOT NULL default 'left', `objavs_rur` int(20) NOT NULL default '1',
`name` varchar(50) character set cp1251 collate cp1251_bin NOT NULL default
'waphp.ru', `p_add_gr` int(20) NOT NULL default '500', `w_logo_gr`
int(20) NOT NULL default '200', `h_logo_gr` int(20) NOT NULL default
'100', `fo_day_new` int(20) NOT NULL default '2', `prev_size`
varchar(50) character set cp1251 collate cp1251_bin NOT NULL default
'80*80', `marker` int(20) NOT NULL default '0', `text_marker`
varchar(50) character set cp1251 collate cp1251_bin NOT NULL default
'waphp.ru', `rur_1mb` int(20) NOT NULL default '0', `top_num` int(20)
NOT NULL default '0', PRIMARY KEY (`sid`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `users` ( `id` int(20)
NOT NULL auto_increment, `user` varchar(50) character set cp1251 collate
cp1251_bin NOT NULL default '', `pass` varchar(500) character set cp1251
collate cp1251_bin default NULL, `name` varchar(30) character set cp1251
collate cp1251_bin default NULL, `surname` varchar(30) character set
cp1251 collate cp1251_bin default NULL, `sex` int(1) NOT NULL default
'1', `semia` int(1) NOT NULL default '0', `day` int(2) NOT NULL default
'0', `month` int(2) NOT NULL default '0', `year` int(5) NOT NULL
default '0', `politic` int(1) NOT NULL default '0', `city` varchar(50)
character set cp1251 collate cp1251_bin NOT NULL default '', `country`
varchar(50) character set cp1251 collate cp1251_bin NOT NULL default '',
`religia` varchar(50) character set cp1251 collate cp1251_bin NOT NULL
default '', `mail` varchar(50) character set cp1251 collate cp1251_bin
NOT NULL default '', `mobtel` varchar(30) character set cp1251 collate
cp1251_bin default NULL, `hometel` varchar(30) character set cp1251
collate cp1251_bin default NULL, `icq` varchar(30) character set cp1251
collate cp1251_bin default NULL, `site` varchar(30) character set cp1251
collate cp1251_bin default NULL, `deiat` blob, `interes` blob,
`likemuz` blob, `likefil` blob, `liketel` blob, `likebook` blob,
`likegames` blob, `likecit` blob, `infa` blob, `obcoun` varchar(50)
character set cp1251 collate cp1251_bin default NULL, `obcity`
varchar(50) character set cp1251 collate cp1251_bin default NULL,
`school` varchar(50) character set cp1251 collate cp1251_bin default NULL,
`vuz` varchar(50) character set cp1251 collate cp1251_bin default NULL,
`ptu` varchar(50) character set cp1251 collate cp1251_bin default NULL,
`valcoun` varchar(50) character set cp1251 collate cp1251_bin default
NULL, `valcity` varchar(50) character set cp1251 collate cp1251_bin
default NULL, `val` varchar(50) character set cp1251 collate cp1251_bin
default NULL, `valyear1` varchar(50) character set cp1251 collate
cp1251_bin default NULL, `valyear2` varchar(50) character set cp1251
collate cp1251_bin default NULL, `position` varchar(50) character set
cp1251 collate cp1251_bin default NULL, `milcoun` varchar(50) character
set cp1251 collate cp1251_bin default NULL, `milcity` varchar(50)
character set cp1251 collate cp1251_bin default NULL, `fsize` varchar(10)
character set cp1251 collate cp1251_bin NOT NULL default 'medium',
`nastroi` varchar(100) character set cp1251 collate cp1251_bin NOT NULL
default '', `ver` varchar(25) character set cp1251 collate cp1251_bin NOT
NULL default '', `daya` int(20) NOT NULL default '0', `dayp` int(20)
NOT NULL default '0', `style` varchar(50) character set cp1251 collate
cp1251_bin NOT NULL default 'shaxty-style', `xstatus` tinyint(1) NOT NULL
default '1', `photo` varchar(200) character set cp1251 collate cp1251_bin
NOT NULL default '', `vote_photo` int(200) NOT NULL default '0',
`credits` int(20) NOT NULL default '0', `gposts` int(20) NOT NULL default
'0', `translit` tinyint(1) NOT NULL default '0', `visit` timestamp NOT
NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `ruser`
varchar(30) character set cp1251 collate cp1251_bin NOT NULL default '',
`onl` int(20) NOT NULL default '0', `posts` int(20) NOT NULL default
'0', `status` varchar(100) character set cp1251 collate cp1251_bin NOT
NULL default 'User', `date` varchar(50) character set cp1251 collate
cp1251_bin default NULL, `timereg` varchar(50) character set cp1251
collate cp1251_bin default NULL, `max` int(2) NOT NULL default '10',
`max_pr` int(2) NOT NULL default '5', `pole1` int(2) NOT NULL default
'2', `pole2` int(2) NOT NULL default '20', `pic_stat` int(2) NOT NULL
default '1', `level` int(6) NOT NULL default '0', `user_ip` varchar(20)
character set cp1251 collate cp1251_bin NOT NULL default '', `user_soft`
varchar(200) character set cp1251 collate cp1251_bin NOT NULL default '',
`inv` tinyint(1) NOT NULL default '0', `kik` int(20) NOT NULL default
'0', `whokik` varchar(20) character set cp1251 collate cp1251_bin NOT
NULL default '', `whykik` varchar(200) character set cp1251 collate
cp1251_bin NOT NULL default '', `bann` int(20) NOT NULL default '0',
`whobann` varchar(20) character set cp1251 collate cp1251_bin NOT NULL
default '', `whybann` varchar(200) character set cp1251 collate
cp1251_bin NOT NULL default '', `byeotv` int(20) NOT NULL default '0',
`alltraf` varchar(255) character set cp1251 collate cp1251_bin NOT NULL
default '0', `lasttraf` varchar(255) character set cp1251 collate
cp1251_bin NOT NULL default '0', `costtraf` int(255) NOT NULL default
'0', `creditsingame` int(20) NOT NULL default '0', `mafcredits` int(20)
NOT NULL default '0', `avtootvet` blob NOT NULL, `binds` varchar(255)
character set cp1251 collate cp1251_bin NOT NULL default '', `para`
varchar(50) character set cp1251 collate cp1251_bin NOT NULL default '',
`myavatar` varchar(50) character set cp1251 collate cp1251_bin NOT NULL
default '', `anketa` varchar(255) character set cp1251 collate cp1251_bin
NOT NULL default '', `rur` int(20) NOT NULL default '0', `rurmag`
int(20) NOT NULL default '0', `postsf` int(20) NOT NULL default '0',
`vote_us` int(20) NOT NULL default '0', `poias` varchar(50) character set
cp1251 collate cp1251_bin NOT NULL default '', `pp_m_s` int(2) NOT NULL
default '0', `pp_c_fr` int(2) NOT NULL default '0', `pp_c_st` int(2)
NOT NULL default '0', `pp_st_s` int(2) NOT NULL default '0', `pp_f_s`
int(2) NOT NULL default '0', `pp_al` int(2) NOT NULL default '0',
`pp_al_k` int(2) NOT NULL default '0', `pp_gifts` int(2) NOT NULL default
'0', `fr_notify` int(2) NOT NULL default '1', `pm_notify` int(2) NOT
NULL default '1', `st_notify` int(2) NOT NULL default '1', `ph_notify`
int(2) NOT NULL default '1', `gr_notify` int(2) NOT NULL default '1',
`gifts_notify` int(2) NOT NULL default '1', `avr` int(20) NOT NULL
default '0', `color_nik` varchar(50) character set cp1251 collate
cp1251_bin NOT NULL default '', `effnik` varchar(50) character set cp1251
collate cp1251_bin NOT NULL default '', `odobr` int(2) NOT NULL default
'0', `razd` int(2) NOT NULL default '1', `forma` int(2) NOT NULL
default '1', `redp` int(2) NOT NULL default '1', `formf` int(2) NOT
NULL default '1', `sizep` int(2) NOT NULL default '512', `diaries`
int(20) NOT NULL default '0', `viz` int(20) NOT NULL default '0', `dd`
int(20) NOT NULL default '1', `emo` int(20) NOT NULL default '1',
`color` int(20) NOT NULL default '1', `softk` int(20) NOT NULL default
'0', `polevv` int(2) NOT NULL default '2', `email` varchar(50)
character set cp1251 collate cp1251_bin NOT NULL default '', PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0
; CREATE TABLE `bannlist` ( `id` int(20) NOT NULL auto_increment, `ip`
varchar(255) character set cp1251 collate cp1251_bin NOT NULL default '',
`soft` varchar(255) character set cp1251 collate cp1251_bin NOT NULL
default '', `user_id` varchar(255) character set cp1251 collate
cp1251_bin NOT NULL default '', `who_id` varchar(255) character set
cp1251 collate cp1251_bin NOT NULL default '', `why` varchar(255)
character set cp1251 collate cp1251_bin NOT NULL default '', PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=0 ; CREATE
TABLE `rooms` ( `rm` int(255) NOT NULL auto_increment, `name`
varchar(255) character set cp1251 collate cp1251_bin NOT NULL default '',
`topic` varchar(255) character set cp1251 collate cp1251_bin NOT NULL
default '', `umnik` tinyint(1) NOT NULL default '0', `shut` tinyint(1)
NOT NULL default '1', `anek` tinyint(1) NOT NULL default '1', `tupica`
tinyint(1) NOT NULL default '0', `svaisch` tinyint(1) NOT NULL default
'0', `system` tinyint(1) NOT NULL default '1', `baryga` tinyint(1) NOT
NULL default '0', `znatok` tinyint(1) NOT NULL default '1', `flyder`
tinyint(1) NOT NULL default '1', `flyd` tinyint(5) NOT NULL default '0',
`antir` tinyint(1) NOT NULL default '1', `antim` tinyint(1) NOT NULL
default '1', `pinban` tinyint(1) NOT NULL default '1', `sartir`
tinyint(1) NOT NULL default '0', `intim` tinyint(1) NOT NULL default
'1', `inkog` tinyint(1) NOT NULL default '1', `level` tinyint(1) NOT
NULL default '0', `pos` tinyint(255) NOT NULL default '0', PRIMARY KEY
(`rm`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=0; CREATE TABLE `who` ( `id` int(20) NOT NULL
auto_increment, `user` int(20) NOT NULL default '0', `time` varchar(40)
character set cp1251 collate cp1251_bin NOT NULL default '', `room`
varchar(40) character set cp1251 collate cp1251_bin NOT NULL default '',
`rm` int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE
`message` ( `id` int(255) NOT NULL auto_increment, `user` varchar(40)
character set cp1251 collate cp1251_bin NOT NULL, `user_id` int(20) NOT
NULL default '0', `komu` varchar(40) character set cp1251 collate
cp1251_bin NOT NULL default '0', `time` varchar(40) character set cp1251
collate cp1251_bin NOT NULL, `msg` blob, `rm` int(20) NOT NULL default
'0', `emo` int(20) NOT NULL default '0', `bb` int(20) NOT NULL default
'0', `color` int(20) NOT NULL default '0', `privat` int(20) NOT NULL
default '0', `inps` int(20) NOT NULL default '0', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE
TABLE `vopros` ( `ids` int(255) NOT NULL auto_increment, `number`
int(11) NOT NULL default '0', `time` int(11) NOT NULL default '0',
`question` blob NOT NULL, `answer` varchar(100) character set cp1251
collate cp1251_bin NOT NULL default '', `tran` varchar(100) character set
cp1251 collate cp1251_bin NOT NULL default '', PRIMARY KEY (`ids`) )
TYPE=MyISAM; CREATE TABLE `vopros2` ( `ids` int(255) NOT NULL
auto_increment, `number` int(11) NOT NULL default '0', `time` int(11)
NOT NULL default '0', `question` blob NOT NULL, `answer` varchar(100)
character set cp1251 collate cp1251_bin NOT NULL default '', `tran`
varchar(100) character set cp1251 collate cp1251_bin NOT NULL default '',
PRIMARY KEY (`ids`) ) TYPE=MyISAM; CREATE TABLE `question` ( `number`
int(5) NOT NULL default '0', `vopros` blob NOT NULL, `answer`
varchar(100) character set cp1251 collate cp1251_bin NOT NULL default '',
`tran` varchar(60) character set cp1251 collate cp1251_bin NOT NULL default
'', PRIMARY KEY (`number`) ) TYPE=MyISAM; CREATE TABLE `botst` (
`id` int(11) NOT NULL auto_increment, `shut` varchar(100) character set
cp1251 collate cp1251_bin NOT NULL default '', `znatok` varchar(100)
character set cp1251 collate cp1251_bin NOT NULL default '', `anek`
varchar(100) character set cp1251 collate cp1251_bin NOT NULL default '',
`tupica` varchar(100) character set cp1251 collate cp1251_bin NOT NULL
default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; CREATE TABLE `shutki` (
`ids` int(11) NOT NULL auto_increment, `message` blob NOT NULL,
PRIMARY KEY (`ids`) ) TYPE=MyISAM AUTO_INCREMENT=0 ; CREATE TABLE
`anekdot` ( `ids` int(11) NOT NULL auto_increment, `message` blob NOT
NULL, `who` int(11) NOT NULL default '0', PRIMARY KEY (`ids`) )
TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE `frazi` ( `ids` int(11) NOT
NULL auto_increment, `message` blob NOT NULL, PRIMARY KEY (`ids`) )
TYPE=MyISAM AUTO_INCREMENT=0 ; CREATE TABLE `privat` ( `id` int(255) NOT
NULL auto_increment, `user` varchar(40) binary NOT NULL default '',
`user_id` int(12) NOT NULL default '0', `msg` blob NOT NULL, `to_user`
varchar(40) binary NOT NULL default '', `to_id` int(12) NOT NULL default
'0', `time` int(11) NOT NULL default '0', `readin` tinyint(1) NOT NULL
default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `xstatus` ( `id` int( 11 )
NOT NULL AUTO_INCREMENT , `user` text CHARACTER SET cp1251 NOT NULL ,
`stat` text CHARACTER SET cp1251 NOT NULL , `name` text CHARACTER SET
cp1251 NOT NULL , `content` text CHARACTER SET cp1251 NOT NULL ,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=0 ; CREATE TABLE `vote_photo` ( `id` int(20) NOT NULL
auto_increment, `user_id` int(20) NOT NULL default '0', `vote_id`
int(20) NOT NULL default '0', `znak` int(20) NOT NULL default '1',
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=0 ; CREATE TABLE `komm_photo` ( `id` int(20) NOT NULL
auto_increment, `user_id` int(20) NOT NULL default '0', `mgs_id`
int(20) NOT NULL default '0', `msg` blob NOT NULL, `time` int(20) NOT
NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `stena` (
`id` int(20) NOT NULL auto_increment, `user_id` int(20) NOT NULL default
'0', `mgs_id` int(20) NOT NULL default '0', `msg` blob NOT NULL,
`time` int(20) NOT NULL default '0', `img` text CHARACTER SET cp1251 NOT
NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `vote_us` ( `id` int(20) NOT
NULL auto_increment, `user_id` int(20) NOT NULL default '0', `vote_id`
int(20) NOT NULL default '0', `znak` int(20) NOT NULL default '1',
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=0 ; CREATE TABLE `opinions` ( `id` int(20) NOT NULL
auto_increment, `user_id` int(20) NOT NULL default '0', `mgs_id`
int(20) NOT NULL default '0', `msg` blob NOT NULL, `time` int(20) NOT
NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `questions` (
`id` int(20) NOT NULL auto_increment, `user_id` int(20) NOT NULL default
'0', `vote` blob NOT NULL, `vars` text CHARACTER SET cp1251 NOT NULL ,
`time` int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE
`perevod` ( `id` int(11) NOT NULL auto_increment, `tip` varchar(100)
character set cp1251 collate cp1251_bin NOT NULL default '', `user_id`
int(20) NOT NULL default '0', `to_id` int(20) NOT NULL default '0',
`kol` int(20) NOT NULL default '0', `time` int(20) NOT NULL default '0',
`kom` text CHARACTER SET cp1251 NOT NULL , PRIMARY KEY (`id`) )
TYPE=MyISAM AUTO_INCREMENT=0 ; CREATE TABLE `foto_add` ( `id` int(11)
NOT NULL auto_increment, `user_id` text NOT NULL, `kom` text NOT NULL,
`album` int(20) NOT NULL default '0', `prosm` int(20) NOT NULL default
'0', `time` text CHARACTER SET cp1251 NOT NULL, `adres` text
CHARACTER SET cp1251 NOT NULL, `format` text CHARACTER SET cp1251 NOT
NULL, `razmer` text CHARACTER SET cp1251 NOT NULL, `level` int(20) NOT
NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `foto_albom` ( `id`
int(20) NOT NULL auto_increment, `name` text CHARACTER SET cp1251 NOT
NULL , `user_id` int(11) NOT NULL default '0', `kom` text CHARACTER SET
cp1251 NOT NULL , `level` int(2) NOT NULL default '0', `pp_al` int(2)
NOT NULL default '0', `pp_al_k` int(2) NOT NULL default '0', `time_s`
int(20) NOT NULL default '0', `time_izm` int(20) NOT NULL default '0',
`prosm` int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `foto_komm` (
`id` int(20) NOT NULL auto_increment, `user_id` int(20) NOT NULL default
'0', `mgs_id` int(20) NOT NULL default '0', `msg` blob NOT NULL,
`time` int(20) NOT NULL default '0', `foto` int(20) NOT NULL default
'0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE IF NOT EXISTS `opsos` (
`min` bigint(11) default NULL, `max` bigint(11) default NULL, `opsos`
varchar(64) default NULL, KEY `min` (`min`,`max`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251; CREATE TABLE `bannip` ( `id` int(10) NOT NULL
auto_increment, `ip` varchar(20) NOT NULL, `who_id` int(20) NOT NULL
default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; CREATE TABLE `gifts` ( `id` int(20) NOT NULL
auto_increment, `user_id` int(20) NOT NULL default '0', `gift_id`
int(20) NOT NULL default '0', `time` int(20) NOT NULL default '0',
`kom` text CHARACTER SET cp1251 NOT NULL , `gift` text CHARACTER SET
cp1251 NOT NULL , `anonim` int(20) NOT NULL default '0', `publ` int(20)
NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `news` ( `id`
int(20) NOT NULL auto_increment, `user_id` int(20) NOT NULL default '0',
`time` int(20) NOT NULL default '0', `msg` text CHARACTER SET cp1251 NOT
NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `newskom` ( `id` int(20) NOT
NULL auto_increment, `new` int(20) NOT NULL default '0', `user_id`
int(20) NOT NULL default '0', `time` int(20) NOT NULL default '0',
`msg` text CHARACTER SET cp1251 NOT NULL , PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; --
------------------------------------------------------------ CREATE TABLE
`forum_b` ( `id` int(11) NOT NULL auto_increment, `t_id` text NOT
NULL, `time` text NOT NULL, `user_id` text NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE
TABLE `forum_msg` ( `id` int(11) NOT NULL auto_increment, `f_id`
int(11) NOT NULL, `r_id` int(11) NOT NULL, `t_id` int(11) NOT NULL,
`user_id` text NOT NULL, `msg` text NOT NULL, `time` text NOT NULL,
`file` text NOT NULL, `fname` text NOT NULL, `fsize` text NOT NULL,
`sfile` int(11) NOT NULL default '0', `izm` text NOT NULL, `izmk` text
NOT NULL, `cit` text NOT NULL, `privat` text NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE
TABLE `forum_s` ( `id` int(11) NOT NULL auto_increment, `search` text
NOT NULL, `time` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `forum_f` ( `id`
int(11) NOT NULL auto_increment, `name` text NOT NULL, `time` int(11)
NOT NULL default '0', `pos` int(11) NOT NULL default '0', PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE
TABLE `forum_r` ( `id` int(11) NOT NULL auto_increment, `f_id` int(11)
NOT NULL default '0', `name` text NOT NULL, `pos` int(11) NOT NULL
default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; CREATE TABLE `forum_t` ( `id` int(11) NOT NULL
auto_increment, `f_id` int(11) NOT NULL, `r_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL, `name` text NOT NULL, `close` int(11) NOT
NULL default '0', `time` int(11) NOT NULL default '0', `zak` int(11)
NOT NULL default '0', `privat` int(11) NOT NULL default '0', PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
; ALTER TABLE `forum_t` ADD `times` int(20) NOT NULL default '0'; CREATE
TABLE `audio` ( `id` int(11) NOT NULL auto_increment, `user_id` text
NOT NULL, `name` text NOT NULL, `kom` text NOT NULL, `prosm` int(20)
NOT NULL default '0', `time` text CHARACTER SET cp1251 NOT NULL,
`adres` text CHARACTER SET cp1251 NOT NULL, `format` text CHARACTER SET
cp1251 NOT NULL, `razmer` text CHARACTER SET cp1251 NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
; CREATE TABLE `audio_komm` ( `id` int(20) NOT NULL auto_increment,
`user_id` int(20) NOT NULL default '0', `mgs_id` int(20) NOT NULL default
'0', `msg` blob NOT NULL, `time` int(20) NOT NULL default '0',
`audio` int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `video`
( `id` int(11) NOT NULL auto_increment, `user_id` text NOT NULL,
`name` text NOT NULL, `kom` text NOT NULL, `prosm` int(20) NOT NULL
default '0', `time` text CHARACTER SET cp1251 NOT NULL, `adres` text
CHARACTER SET cp1251 NOT NULL, `format` text CHARACTER SET cp1251 NOT
NULL, `razmer` text CHARACTER SET cp1251 NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE
TABLE `video_komm` ( `id` int(20) NOT NULL auto_increment, `user_id`
int(20) NOT NULL default '0', `mgs_id` int(20) NOT NULL default '0',
`msg` blob NOT NULL, `time` int(20) NOT NULL default '0', `video`
int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `oko` ( `id`
int(20) NOT NULL auto_increment, `user_id` int(20) NOT NULL default '0',
`who_id` int(20) NOT NULL default '0', `msg` blob NOT NULL, `time`
int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `diaries` (
`id` int(20) NOT NULL auto_increment, `user_id` int(20) NOT NULL default
'0', `name` blob NOT NULL, `msg` blob NOT NULL, `time` int(20) NOT
NULL default '0', `chit` int(20) NOT NULL default '0', `vote` int(20)
NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `vote_diaries`
( `id` int(20) NOT NULL auto_increment, `vote_id` int(20) NOT NULL
default '0', `did` int(20) NOT NULL default '0', `znak` int(20) NOT
NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `board` (
`id` int(20) NOT NULL auto_increment, `name` text NOT NULL, `who` text
NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `objavs` ( `id` int(20) NOT
NULL auto_increment, `user_id` int(20) NOT NULL default '0', `name`
blob NOT NULL, `msg` blob NOT NULL, `time` int(20) NOT NULL default
'0', `chit` int(20) NOT NULL default '0', `srok` int(20) NOT NULL
default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `fo_cat` ( `id` int(11) NOT
NULL auto_increment, `path` text NOT NULL, `infolder` text NOT NULL,
`name` varchar(255) NOT NULL, `priority` tinyint(3) NOT NULL default
'0', `time` int(11) NOT NULL default '0', `pos` int(11) NOT NULL
default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; CREATE TABLE `fo_cat2` ( `id` int(11) NOT NULL
auto_increment, `fid` int(11) NOT NULL default '0', `path` text NOT
NULL, `infolder` text NOT NULL, `name` varchar(255) NOT NULL,
`priority` tinyint(3) NOT NULL default '0', `time` int(11) NOT NULL
default '0', `pos` int(11) NOT NULL default '0', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE IF
NOT EXISTS `fo_files` ( `id` int(20) NOT NULL auto_increment, `user_id`
int(20) NOT NULL default '0', `path` text NOT NULL, `infolder` text NOT
NULL, `name` varchar(255) NOT NULL, `priority` tinyint(3) NOT NULL
default '0', `size` bigint(20) NOT NULL, `about` text NOT NULL,
`pass` text NOT NULL, `price` int(11) NOT NULL default '0', `fastabout`
text NOT NULL, `loads` int(11) NOT NULL default '0', `timeload` int(11)
unsigned NOT NULL, `timeupload` int(11) NOT NULL, `ips` text NOT NULL,
`yes` int(11) NOT NULL default '0', `no` int(11) NOT NULL default '0',
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; CREATE TABLE `fo_komm` ( `id` int(20) NOT NULL
auto_increment, `file` int(20) NOT NULL default '0', `user_id` int(20)
NOT NULL default '0', `time` int(20) NOT NULL default '0', `msg` text
CHARACTER SET cp1251 NOT NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; ALTER TABLE `users`
ADD `fo_files` int(20) NOT NULL default '0'; CREATE TABLE `diaskomm` (
`id` int(20) NOT NULL auto_increment, `did` int(20) NOT NULL default
'0', `user_id` int(20) NOT NULL default '0', `time` int(20) NOT NULL
default '0', `msg` text CHARACTER SET cp1251 NOT NULL , PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0
; CREATE TABLE `groups` ( `id` int(11) NOT NULL auto_increment,
`lider_id` int(20) NOT NULL default '0', `name` text NOT NULL, `opis`
text NOT NULL, `time` int(20) NOT NULL default '0', `users` int(20) NOT
NULL default '0', `logo` text NOT NULL, `icon` text NOT NULL, `tip`
int(11) NOT NULL, `infa` text NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE
`group_users` ( `id` int(20) NOT NULL auto_increment, `gid` int(20) NOT
NULL default '0', `user_id` int(20) NOT NULL default '0', `access`
int(1) NOT NULL default '0', `time` int(20) NOT NULL default '0',
`level` int(1) NOT NULL default '0', `posts` int(20) NOT NULL default
'0', `status` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `group_news` (
`id` int(20) NOT NULL auto_increment, `gid` int(20) NOT NULL default
'0', `user_id` int(20) NOT NULL default '0', `time` int(20) NOT NULL
default '0', `msg` text CHARACTER SET cp1251 NOT NULL , PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0
; CREATE TABLE `group_newskom` ( `id` int(20) NOT NULL auto_increment,
`gid` int(20) NOT NULL default '0', `new` int(20) NOT NULL default '0',
`user_id` int(20) NOT NULL default '0', `time` int(20) NOT NULL default
'0', `msg` text CHARACTER SET cp1251 NOT NULL , PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE
TABLE `group_chat` ( `id` int(20) NOT NULL auto_increment, `gid`
int(20) NOT NULL default '0', `user_id` int(20) NOT NULL default '0',
`time` int(20) NOT NULL default '0', `msg` text CHARACTER SET cp1251 NOT
NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `logs` ( `id` int(255) NOT
NULL auto_increment, `log` varchar(255) NOT NULL default '', `msg` text
NOT NULL, `time` int(20) NOT NULL default '0', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE
`vstr` ( `id` int(20) NOT NULL auto_increment, `user_id` int(20) NOT
NULL default '0', `time` int(20) NOT NULL default '0', `msg` text
CHARACTER SET cp1251 NOT NULL , `org` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=0 ; CREATE TABLE `akcyi` ( `id` int(20) NOT NULL
auto_increment, `user_id` int(20) NOT NULL default '0', `time` int(20)
NOT NULL default '0', `msg` text CHARACTER SET cp1251 NOT NULL , `org`
varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE
`konkurs` ( `id` int(20) NOT NULL auto_increment, `user_id` int(20) NOT
NULL default '0', `time` int(20) NOT NULL default '0', `msg` text
CHARACTER SET cp1251 NOT NULL , `org` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=0 ; CREATE TABLE `snews` ( `id` int(20) NOT NULL
auto_increment, `user_id` int(20) NOT NULL default '0', `time` int(20)
NOT NULL default '0', `msg` text CHARACTER SET cp1251 NOT NULL ,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=0 ; CREATE TABLE `snewskom` ( `id` int(20) NOT NULL
auto_increment, `new` int(20) NOT NULL default '0', `user_id` int(20)
NOT NULL default '0', `time` int(20) NOT NULL default '0', `msg` text
CHARACTER SET cp1251 NOT NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; --
--------------------------------------------------------------------------- CREATE
TABLE `bomj` ( `klu4` int(11) NOT NULL default '0', `night_act` text
NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251; INSERT INTO `bomj` (`klu4`, `night_act`) VALUES (1,
'Городской
бомж,
оставив
помойку,
wарит
своими
грязными
руками
по
карманам
прохожих...'), (2,
'Вонючий
бомж
wныряет
по
переулкам,
и между
очередной
мусоркой
копается
в
чьих-то
карманах...'), (3,
'Бомж,
распространяя
по
городу
чудесный
аромат
своих
подмыwек,
умудряется
еще
проверять
карманы
горожан...'); CREATE
TABLE `doktor` ( `klu4` int(11) NOT NULL default '0', `night_act` text
NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251; INSERT INTO `doktor` (`klu4`, `night_act`) VALUES (1,
'Доктор,
захватив
с собой
wприц
побольwе,
рыщет
по
городу,
кому же
и куда
его
вставить...'), (2,
'Доктор,
наглотавwись
дури,
реwил
залечить
что-нибудь
у
кого-нибудь
этой
ночью...'), (3,
'Наw
бравый
городской
врач
выwел на
охоту
за
пациентами.
У него
так и
чеwутся
руки
кого-нибудь
вылечить...'); CREATE
TABLE `komissar` ( `klu4` int(11) NOT NULL default '0', `night_act`
text NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251; INSERT INTO `komissar` (`klu4`, `night_act`) VALUES (1,
'Комиссар
Катани,
сев в
свой
бобик,
поехал
искать
преступников...'), (2,
'Комиссар
Катани,
наглотавwись
колес,
ходит
по
комнате
и
вычисляет
мафию...'), (3,
'Комиссар
Катани
лежит в
засаде
в куче
навоза
и
следит
за
мафией...
Фуу-у, ну
и
запаwок:)'); CREATE
TABLE `mafia` ( `klu4` int(11) NOT NULL default '0', `night_act` text
NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251; INSERT INTO `mafia` (`klu4`, `night_act`) VALUES (1,
'Мафиози,
вооруживwись
до
зубов,
направляются
навстречу
своей
жертве...'), (2,
'Главарь
мафии
высматривает
свою
жертву.
За ним,
лизоблюдя,
следуют
его
wестерки...'), (3,
'Мафия
на
четырех
маwинах
носится
по
ночному
городу
и
пугает
редких
прохожих...'); CREATE
TABLE `maniac` ( `klu4` int(11) NOT NULL default '0', `night_act` text
NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251; INSERT INTO `maniac` (`klu4`, `night_act`) VALUES (1,
'Маньяк
носится
с
топором
в руках
по
темным
переулкам...'), (2,
'Маньяк
с
гадкой
ухмылкой
на лице
точит
свой
топор...'), (3,
'Маньяк
сидит в
засаде
с
оружием
наготове
и
поджидает
случайных
прохожих...'); CREATE
TABLE `wluha` ( `klu4` int(11) NOT NULL default '0', `night_act` text
NOT NULL, PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251; INSERT INTO `wluha` (`klu4`, `night_act`) VALUES (1,
'Wлюха
выwла из
дома,
кому-то
сегодня
не
удастся
поспать...'), (2,
'Девка,
виляя
бедрами,
ходит
ночью
по
городу,
не
пропуская
ни
одного
мужчины.'), (3,
'Городская
wлюwка в
откровенном
виде
wастает
по
улицам,
выбирая
жертву...'); CREATE
TABLE `ingame1` ( `gamer_id` int(11) NOT NULL default '0', `role`
varchar(100) NOT NULL default '', `gamer_act` varchar(50) NOT NULL
default '', `id_in_game` int(11) NOT NULL default '0', `dvote` int(11)
NOT NULL default '0', `wholin` int(11) NOT NULL default '0', `onl`
int(12) NOT NULL default '0', `state` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`gamer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; CREATE
TABLE `mafaction1` ( `klu4` tinyint(1) NOT NULL default '0', `action`
varchar(100) NOT NULL default '', `nexttime` int(11) NOT NULL default
'0', `kiked` tinyint(1) NOT NULL default '0', `prevprev` int(11) NOT
NULL default '0', `prev` int(11) NOT NULL default '0', `current`
int(11) NOT NULL default '0', `cround` smallint(2) NOT NULL default '0',
PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; CREATE
TABLE `maf1` ( `klu4` int(8) NOT NULL default '0', `time` varchar(5)
NOT NULL default '', `who` varchar(100) NOT NULL default '', `message`
text NOT NULL, `messagewosm` text NOT NULL, `messagewoasm` text NOT
NULL, `id` double NOT NULL default '0', `towhom` varchar(12) NOT NULL
default '', `hid` smallint(1) NOT NULL default '0', `usid` int(12) NOT
NULL default '0', `gamemes` tinyint(1) NOT NULL default '0', `komu`
varchar(40) NOT NULL default '', PRIMARY KEY (`klu4`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251; CREATE TABLE `scores1` ( `gamer_id` int(11) NOT
NULL default '0', `score` int(11) NOT NULL default '0', PRIMARY KEY
(`gamer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; INSERT INTO `scores1`
(`gamer_id`, `score`) VALUES (1457, 0), (913, 20), (839, 60), (1472,
75); INSERT INTO `mafaction1` (`klu4`, `action`, `nexttime`, `kiked`,
`prevprev`, `prev`, `current`, `cround`) VALUES (1, 'nogame', 1172463028,
0, 200, 3, 2, 2); CREATE TABLE `omessage` ( `id` int(255) NOT NULL
auto_increment, `user` varchar(40) character set cp1251 collate
cp1251_bin NOT NULL, `user_id` int(20) NOT NULL default '0', `komu`
varchar(40) character set cp1251 collate cp1251_bin NOT NULL default '0',
`time` varchar(40) character set cp1251 collate cp1251_bin NOT NULL,
`msg` blob, `rm` int(20) NOT NULL default '0', `emo` int(20) NOT NULL
default '0', `bb` int(20) NOT NULL default '0', `color` int(20) NOT
NULL default '0', `privat` int(20) NOT NULL default '0', `inps` int(20)
NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; ALTER TABLE `chats` ADD
`oroom` int(1) NOT NULL default '1'; ALTER TABLE `chats` ADD `foto_index`
int(1) NOT NULL default '1'; ALTER TABLE `chats` ADD `oroom_name`
varchar(50) character set cp1251 collate cp1251_bin NOT NULL default
''; ALTER TABLE `users` ADD `ormod` int(1) NOT NULL default '0'; --
---------------------------------- ALTER TABLE `chats` ADD `oforum` int(1)
NOT NULL default '1'; CREATE TABLE `oforum_b` ( `id` int(11) NOT NULL
auto_increment, `t_id` text NOT NULL, `time` text NOT NULL, `user_id`
text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; CREATE TABLE `oforum_msg` ( `id` int(11) NOT NULL
auto_increment, `f_id` int(11) NOT NULL, `r_id` int(11) NOT NULL,
`t_id` int(11) NOT NULL, `user_id` text NOT NULL, `msg` text NOT NULL,
`time` text NOT NULL, `file` text NOT NULL, `fname` text NOT NULL,
`fsize` text NOT NULL, `sfile` int(11) NOT NULL default '0', `izm` text
NOT NULL, `izmk` text NOT NULL, `cit` text NOT NULL, `privat` text
NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; CREATE TABLE `oforum_s` ( `id` int(11) NOT NULL
auto_increment, `search` text NOT NULL, `time` text NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
; CREATE TABLE `oforum_f` ( `id` int(11) NOT NULL auto_increment,
`name` text NOT NULL, `time` int(11) NOT NULL default '0', `pos`
int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `oforum_r` ( `id` int(11)
NOT NULL auto_increment, `f_id` int(11) NOT NULL default '0', `name`
text NOT NULL, `pos` int(11) NOT NULL default '0', PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE
TABLE `oforum_t` ( `id` int(11) NOT NULL auto_increment, `f_id` int(11)
NOT NULL, `r_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `name`
text NOT NULL, `close` int(11) NOT NULL default '0', `time` int(11) NOT
NULL default '0', `zak` int(11) NOT NULL default '0', `privat` int(11)
NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; ALTER TABLE `oforum_t` ADD `times`
int(20) NOT NULL default '0'; ALTER TABLE `chats` ADD `logo` varchar(20)
character set cp1251 collate cp1251_bin NOT NULL default ''; CREATE TABLE
`banners` ( `id` int(11) NOT NULL auto_increment, `link` varchar(100)
character set cp1251 collate cp1251_bin NOT NULL default 'waphp.ru',
`link_name` varchar(100) character set cp1251 collate cp1251_bin NOT NULL
default 'waphp.ru', `tip` int(20) NOT NULL default '0', `gde` int(20)
NOT NULL default '0', `v_n` int(20) NOT NULL default '0', PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE
TABLE `support` ( `id` int(255) NOT NULL auto_increment, `user`
varchar(40) binary NOT NULL default '', `user_id` int(12) NOT NULL
default '0', `msg` blob NOT NULL, `to_user` varchar(40) binary NOT NULL
default '', `to_id` int(12) NOT NULL default '0', `time` int(11) NOT
NULL default '0', `readin` tinyint(1) NOT NULL default '0', PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0
; CREATE TABLE `zags` ( `id` int(20) NOT NULL auto_increment, `j_id`
int(20) NOT NULL default '0', `n_id` int(20) NOT NULL default '0',
`frj_id` int(20) NOT NULL default '0', `frn_id` int(20) NOT NULL default
'0', `yes` int(20) NOT NULL default '0', `no` int(20) NOT NULL default
'0', `time` int(20) NOT NULL default '0', `day` varchar(255) NOT NULL
default '', `month` varchar(255) NOT NULL default '', `year`
varchar(255) NOT NULL default '', `chs` varchar(255) NOT NULL default
'', `min` varchar(255) NOT NULL default '', `timesv` int(11) NOT NULL
default '0', `opov` int(20) NOT NULL default '0', `cer` int(20) NOT
NULL default '0', `razvod` int(20) NOT NULL default '0', `j_t` int(20)
NOT NULL default '0', `n_t` int(20) NOT NULL default '0', `frj_t`
int(20) NOT NULL default '0', `frn_t` int(20) NOT NULL default '0',
`kolco` int(20) NOT NULL default '0', `msg` blob, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=0; --
------------------------------------------------------------- ALTER TABLE
`users` ADD `fermer_money` int(11) NOT NULL default '0'; ALTER TABLE
`users` ADD `fermer_oput` int(11) NOT NULL default '0'; CREATE TABLE IF NOT
EXISTS `fermer_gr` ( `id` int(11) NOT NULL auto_increment, `id_user`
int(11) NOT NULL, `semen` int(11) NOT NULL, `woter` int(11) NOT NULL
default '0', `kol` varchar(1024) default NULL, `time` varchar(1024)
default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1036 ; CREATE TABLE IF NOT EXISTS `fermer_dog` ( `id`
int(11) NOT NULL auto_increment, `id_user` int(11) NOT NULL, `time`
varchar(1024) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1036 ; CREATE TABLE IF NOT EXISTS
`fermer_vor` ( `id` int(11) NOT NULL auto_increment, `id_user` int(11)
NOT NULL, `gr` int(11) default NULL, `time` varchar(1024) default
NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1036 ; CREATE TABLE IF NOT EXISTS `fermer_sclad` ( `id`
int(11) NOT NULL auto_increment, `id_user` int(11) NOT NULL, `semen`
int(11) NOT NULL, `kol` int(11) NOT NULL, `time` varchar(1024) default
NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1036 ; CREATE TABLE IF NOT EXISTS `fermer_semen` ( `id`
int(11) NOT NULL auto_increment, `id_user` int(11) NOT NULL, `semen`
int(11) NOT NULL, `kol` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1036 ; CREATE TABLE
IF NOT EXISTS `fermer_udobr` ( `id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL, `udobr` int(11) NOT NULL, `kol` int(11) NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1036 ; CREATE TABLE IF NOT EXISTS `fermer_udobr_name` (
`id` int(10) unsigned NOT NULL auto_increment, `name` varchar(1024) NOT
NULL, `cena` varchar(1024) NOT NULL, `time` varchar(1024) default
NULL, `img` int(20) NOT NULL default '0', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 ; CREATE TABLE IF NOT EXISTS
`fermer_name` ( `id` int(10) unsigned NOT NULL auto_increment, `name`
varchar(1024) NOT NULL, `cena` varchar(1024) NOT NULL, `dohod`
varchar(1024) NOT NULL, `rand1` varchar(1024) NOT NULL, `rand2`
varchar(1024) NOT NULL, `oput` varchar(1024) NOT NULL, `time`
varchar(1024) default NULL, `level` int(10) unsigned NOT NULL default
'0', `img` int(20) NOT NULL default '0', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 ; CREATE TABLE `cat` ( `id`
int(11) NOT NULL auto_increment, `mesto` int(11) NOT NULL, `name`
varchar(70) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE
`sms` ( `id` int(11) NOT NULL auto_increment, `cat` int(11) NOT NULL,
`add` varchar(50) NOT NULL, `sms` varchar(400) NOT NULL, `rating`
int(11) NOT NULL, `data` int(11) NOT NULL, `moder` int(1) NOT NULL,
`user_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE
`st_cat` ( `id` int(11) NOT NULL auto_increment, `mesto` int(11) NOT
NULL, `img` varchar(70) NOT NULL, `name` varchar(70) NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; CREATE TABLE `status` ( `id` int(11) NOT NULL
auto_increment, `cat` int(11) NOT NULL, `add` varchar(50) NOT NULL,
`status` varchar(400) NOT NULL, `rating` int(11) NOT NULL, `data`
int(11) NOT NULL, `moder` int(1) NOT NULL, `user_id` int(11) NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `bar_cat` ( `id` int(11)
NOT NULL auto_increment, `pos` int(11) NOT NULL, `img` varchar(70) NOT
NULL, `name` varchar(70) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE
`barmen` ( `id` int(11) NOT NULL auto_increment, `msg` varchar(400) NOT
NULL, `name` varchar(100) NOT NULL, `img` varchar(100) NOT NULL,
`proc` int(11) NOT NULL, `time` int(20) NOT NULL, `cena` int(11) NOT
NULL, `cat` int(11) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; ALTER TABLE `users` ADD `bar_proc` int(11) NOT NULL
default '0'; ALTER TABLE `users` ADD `bar_time` int(11) NOT NULL default
'0'; ALTER TABLE `users` ADD `bar_ik` int(11) NOT NULL default '0'; ALTER
TABLE `users` ADD `bar_ryg` int(11) NOT NULL default '0'; ALTER TABLE
`users` ADD `bar_slyn` int(11) NOT NULL default '0'; ALTER TABLE `users`
ADD `bar_pad` int(11) NOT NULL default '0'; ALTER TABLE `rooms` ADD
`barmen` tinyint(1) NOT NULL default '0'; ALTER TABLE `chats` ADD `barmen`
varchar(50) character set cp1251 collate cp1251_bin NOT NULL default
'barmen'; ALTER TABLE `botst` ADD `barmen` int(11) NOT NULL default
'0'; CREATE TABLE `otzyvy` ( `id` int(20) NOT NULL auto_increment,
`bal` int(20) NOT NULL default '0', `user_id` int(20) NOT NULL default
'0', `time` int(20) NOT NULL default '0', `msg` text CHARACTER SET
cp1251 NOT NULL , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `online` (
`id` int(20) NOT NULL auto_increment, `onl` int(20) NOT NULL default
'0', `date` text NOT NULL, `time` int(20) NOT NULL default '0',
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
; CREATE TABLE `onlines` ( `id` int(20) NOT NULL auto_increment, `onl`
int(20) NOT NULL default '0', `date` text NOT NULL, `time` int(20) NOT
NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `sbanners` ( `id`
int(11) NOT NULL auto_increment, `link` varchar(100) character set cp1251
collate cp1251_bin NOT NULL default 'waphp.ru', `link_name` varchar(100)
character set cp1251 collate cp1251_bin NOT NULL default 'waphp.ru',
`tip` int(20) NOT NULL default '0', `gde` int(20) NOT NULL default '0',
`v_n` int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `votes` ( `id`
int(2) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '',
`avtor` varchar(20) NOT NULL default '', `date` varchar(10) NOT NULL
default '', `vopros` varchar(200) default NULL, `v1` varchar(100) NOT
NULL default '', `v2` varchar(100) NOT NULL default '', `v3`
varchar(100) NOT NULL default '', `v4` varchar(100) NOT NULL default '',
`v5` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE
`voting` ( `klu4` int(3) NOT NULL auto_increment, `vote` int(2) NOT
NULL default '0', `date` varchar(10) NOT NULL default '', `var`
smallint(1) NOT NULL default '0', `who` int(5) NOT NULL default '0',
PRIMARY KEY (`klu4`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; ALTER TABLE `rooms` ADD `tip` tinyint(1) NOT NULL
default '0'; -- меню и градиент ALTER TABLE `users` ADD
`menu` int(11) NOT NULL default '1'; ALTER TABLE `users` ADD `gradient`
varchar(500) NOT NULL default ''; -- Знакомства! CREATE TABLE
`regions` ( `region_id` int(11) NOT NULL default '0', `region_rus`
varchar(255) NOT NULL default '', `region_eng` varchar(255) NOT NULL
default '', `country_id` int(11) NOT NULL default '0' ) ENGINE = MYISAM
DEFAULT CHARSET = cp1251 PACK_KEYS =0 AUTO_INCREMENT =0; CREATE TABLE
`cities` ( `city_id` int(11) NOT NULL default '0', `city_rus`
varchar(255) NOT NULL default '', `city_eng` varchar(255) NOT NULL
default '', `region_id` int(11) NOT NULL default '0' ) ENGINE = MYISAM
DEFAULT CHARSET = cp1251 PACK_KEYS =0 AUTO_INCREMENT =0; CREATE TABLE
`country` ( `country_id` int(11) NOT NULL default '0', `country_rus`
varchar(255) NOT NULL default '', `country_eng` varchar(255) NOT NULL
default '' ) ENGINE = MYISAM DEFAULT CHARSET = cp1251 PACK_KEYS =0
AUTO_INCREMENT =0; ALTER TABLE `users` ADD `love_country` int(11) NOT
NULL; ALTER TABLE `users` ADD `love_region` int(11) NOT NULL; ALTER TABLE
`users` ADD `love_city` int(11) NOT NULL; ALTER TABLE `users` ADD `rost`
int(11) NOT NULL; ALTER TABLE `users` ADD `ves` int(11) NOT NULL; ALTER
TABLE `users` ADD `sexlove` int(11) NOT NULL; ALTER TABLE `users` ADD `cel`
int(11) NOT NULL; ALTER TABLE `users` ADD `telo` int(11) NOT NULL; ALTER
TABLE `users` ADD `kogo` int(11) NOT NULL; ALTER TABLE `users` ADD `ishy`
varchar(500) NOT NULL; ALTER TABLE `users` ADD `volos` int(11) NOT
NULL; ALTER TABLE `users` ADD `vozrast` int(11) NOT NULL; ALTER TABLE
`users` ADD `orientacia` int(11) NOT NULL; ALTER TABLE `users` ADD `brak`
int(11) NOT NULL; ALTER TABLE `users` ADD `deti` int(11) NOT NULL; ALTER
TABLE `users` ADD `matpod` int(11) NOT NULL; ALTER TABLE `users` ADD
`matpol` int(11) NOT NULL; ALTER TABLE `users` ADD `regimdnya` int(11) NOT
NULL; ALTER TABLE `users` ADD `jivu` int(11) NOT NULL; ALTER TABLE `users`
ADD `spotr` int(11) NOT NULL; ALTER TABLE `users` ADD `kury` int(11) NOT
NULL; ALTER TABLE `users` ADD `alkogol` int(11) NOT NULL; ALTER TABLE
`users` ADD `narkotik` int(11) NOT NULL; ALTER TABLE `users` ADD `prior`
varchar(500) NOT NULL; ALTER TABLE `users` ADD `sexch` int(11) NOT
NULL; ALTER TABLE `users` ADD `sexrol` int(11) NOT NULL; --
------------- ALTER TABLE `users` ADD `love` int(11) NOT NULL; ALTER TABLE
`users` ADD `poznak` int(11) NOT NULL; ALTER TABLE `users` ADD `sex2`
int(11) NOT NULL; ALTER TABLE `users` ADD `tatu` int(11) NOT NULL; ALTER
TABLE `users` ADD `getop` int(11) NOT NULL; ALTER TABLE `users` ADD `vozb`
varchar(500) NOT NULL; ALTER TABLE `users` ADD `love_pr` int(11) NOT
NULL; ALTER TABLE `users` ADD `vnesh` int(11) NOT NULL; --
просмотров анкеты CREATE TABLE `love_posm` ( `id` int( 20
) NOT NULL AUTO_INCREMENT , `user_id` int( 20 ) NOT NULL default '0',
`pr_id` int( 20 ) NOT NULL default '0', `date` int( 20 ) NOT NULL default
'1', PRIMARY KEY ( `id` ) ) ENGINE = MYISAM DEFAULT CHARSET = cp1251
PACK_KEYS =0 AUTO_INCREMENT =0; ALTER TABLE `users` ADD `love_posm`
int(20) NOT NULL; -- фото и голоса CREATE TABLE
`love_vote_photo` ( `id` int(20) NOT NULL auto_increment, `user_id`
int(20) NOT NULL default '0', `vote_id` int(20) NOT NULL default '0',
`znak` int(20) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; ALTER TABLE `users`
ADD `love_vote_photo` int(20) NOT NULL; ALTER TABLE `users` ADD
`love_photo` varchar(500) NOT NULL; CREATE TABLE `love_komm_photo` (
`id` int(20) NOT NULL auto_increment, `user_id` int(20) NOT NULL default
'0', `mgs_id` int(20) NOT NULL default '0', `msg` blob NOT NULL,
`time` int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; -- рейтинг
пользователя CREATE TABLE `love_vote_us` ( `id` int(20) NOT
NULL auto_increment, `user_id` int(20) NOT NULL default '0', `vote_id`
int(20) NOT NULL default '0', `znak` int(20) NOT NULL default '1',
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=0 ; ALTER TABLE `users` ADD `love_vote_us` int(20) NOT
NULL; CREATE TABLE `love_stena` ( `id` int(20) NOT NULL auto_increment,
`user_id` int(20) NOT NULL default '0', `mgs_id` int(20) NOT NULL
default '0', `msg` blob NOT NULL, `time` int(20) NOT NULL default '0',
`img` text CHARACTER SET cp1251 NOT NULL , PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE
TABLE `love_b` ( `id` int(20) NOT NULL auto_increment, `inf_id` int(20)
NOT NULL default '0', `time` int(20) NOT NULL default '0', `user_id`
int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; ALTER TABLE `users` ADD `mvozrast`
int(11) NOT NULL; ALTER TABLE `users` ADD `love_tr` int(20) NOT
NULL; CREATE TABLE `love_msg` ( `id` int(255) NOT NULL auto_increment,
`user` varchar(40) binary NOT NULL default '', `user_id` int(12) NOT NULL
default '0', `msg` blob NOT NULL, `to_user` varchar(40) binary NOT NULL
default '', `to_id` int(12) NOT NULL default '0', `time` int(11) NOT
NULL default '0', `rm` int(11) NOT NULL default '0', `readin`
tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE
`love_ostena` ( `id` int(20) NOT NULL auto_increment, `mgs_id` int(20)
NOT NULL default '0', `msg` blob NOT NULL, `time` int(20) NOT NULL
default '0', `img` text CHARACTER SET cp1251 NOT NULL , PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0
; CREATE TABLE `report` ( `id` int(20) NOT NULL auto_increment,
`user_id` int(20) NOT NULL default '0', `time` int(20) NOT NULL default
'0', `msg` text CHARACTER SET cp1251 NOT NULL , PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0
; CREATE TABLE `refusers` ( `id` int(20) NOT NULL auto_increment,
`user_id` int(20) NOT NULL default '0', `ref_id` int(20) NOT NULL default
'0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `refchats` ( `id` int(20)
NOT NULL auto_increment, `ref_id` int(20) NOT NULL default '0', PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=0 ; -- прихожка CREATE TABLE `enter_menu` ( `id`
int(255) NOT NULL auto_increment, `tip` int(20) NOT NULL default '0',
`img` int(20) NOT NULL default '0', `imges` text CHARACTER SET cp1251 NOT
NULL default '', `link` text CHARACTER SET cp1251 NOT NULL default '',
`name` text CHARACTER SET cp1251 NOT NULL default '', `pos` int(20) NOT
NULL default '0', `rooms` int(20) NOT NULL default '0', PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0
; -- градиент в комнаты ALTER TABLE `message` ADD
`grad` varchar(500) NOT NULL default ''; ALTER TABLE `omessage` ADD `grad`
varchar(500) NOT NULL default ''; -- Тотализатор CREATE TABLE
`total_chemp` ( `id` int(20) NOT NULL auto_increment, `name` text NOT
NULL, `opis` text NOT NULL, `dost` int(20) NOT NULL default '0',
`nach` int(20) NOT NULL default '0', `konec` int(20) NOT NULL default
'0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
PACK_KEYS=0 AUTO_INCREMENT=0 ; CREATE TABLE `total_mach` ( `id` int(11)
NOT NULL auto_increment, `nawan1` text NOT NULL, `nazwan2` text NOT
NULL, `daten` text NOT NULL, `status` int(11) NOT NULL default '0',
`infa` text NOT NULL, `chet1` int(11) NOT NULL default '0', `chet2`
int(11) NOT NULL default '0', `kartochka` int(11) NOT NULL default '0',
`pervgol1` int(11) NOT NULL default '0', `pervgol2` int(11) NOT NULL
default '0', `itog` int(11) NOT NULL default '0', `chemp` int(11) NOT
NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `total_prizi` ( `id`
int(11) NOT NULL auto_increment, `chemp` int(11) NOT NULL default '0',
`val` int(11) NOT NULL default '0', `mesto1` text NOT NULL, `mesto2`
text NOT NULL, `mesto3` text NOT NULL, `mesto4` text NOT NULL,
`mesto5` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `total_stawka` ( `id`
int(11) NOT NULL auto_increment, `user_id` int(20) NOT NULL default '0',
`chet1` int(11) NOT NULL default '0', `chet2` int(11) NOT NULL default
'0', `kartochka` int(11) NOT NULL default '0', `pervgol1` int(11) NOT
NULL default '0', `pervgol2` int(11) NOT NULL default '0', `mach`
int(11) NOT NULL default '0', `chemp` int(11) NOT NULL default '0',
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
; CREATE TABLE `total_top` ( `id` int(20) NOT NULL auto_increment,
`user_id` int(20) NOT NULL default '0', `chemp` int(11) NOT NULL default
'0', `ochki` int(20) NOT NULL default '0', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=0
; CREATE TABLE `articles_cat` ( `id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL, `pos` int(11) NOT NULL default '0',
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
; CREATE TABLE `articles_msg` ( `id` int(11) NOT NULL auto_increment,
`cat` int(20) NOT NULL default '0', `name` varchar(255) NOT NULL, `pos`
int(11) NOT NULL default '0', `msg` text NOT NULL, `time` int(20) NOT
NULL default '0', `user_id` int(20) NOT NULL default '0', `chit`
int(20) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; ALTER TABLE `botst` ADD `chistka`
int(11) NOT NULL default '0'; ALTER TABLE `users` ADD `filtr` int(20) NOT
NULL; -- журнал CREATE TABLE `zhurnal_rub` ( `id` int(11) NOT
NULL auto_increment, `name` varchar(255) NOT NULL, `pos` int(11) NOT
NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE `zhurnal_razd` ( `id`
int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `rub`
int(11) NOT NULL default '0', `time` int(20) NOT NULL default '0',
`user_id` int(20) NOT NULL default '0', PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; CREATE TABLE
`zhurnal_msg` ( `id` int(11) NOT NULL auto_increment, `name`
varchar(255) NOT NULL, `rub` int(11) NOT NULL default '0', `razd`
int(11) NOT NULL default '0', `time` int(20) NOT NULL default '0',
`user_id` int(20) NOT NULL default '0', `msg` text NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
; CREATE TABLE `my_smiles` ( `id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL, `smile` varchar(255) NOT NULL, `user_id`
int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ; INSERT INTO `chats` (`sid`, `link`,
`link_name`, `rus`, `reg`, `umnik`, `shut`, `anek`, `tupica`, `svaisch`,
`system`, `baryga`, `znatok`, `flyder`, `mafiozi`, `victint`, `shuttime`,
`znatoktime`, `anektime`, `vict`, `cena_answ`, `timesdvig`, `time_aut`,
`head`, `antir`, `avtorega`, `privat`, `posts_pr`, `posts_vph`,
`posts_vus`, `posts_nik`, `size_photo`, `w_photo`, `h_photo`, `size_foto`,
`w_foto`, `h_foto`, `w_foto2`, `h_foto2`, `size_img_sten`, `w_img_sten`,
`h_img_sten`, `kom_p_posts`, `min_p_posts`, `max_p_posts`, `kom_p_rur`,
`min_p_rur`, `max_p_rur`, `kurs_bank_ob`, `size_lich`, `size_video`,
`size_audio`, `size_for`, `size_vvod_for`, `for_time_p`, `for_time_t`,
`for_cit`, `for_privat`, `kik_notify`, `ban_notify`, `ban2_notify`,
`reg_notify`, `style`, `alignpr`, `objavs_rur`, `name`, `p_add_gr`,
`w_logo_gr`, `h_logo_gr`, `fo_day_new`, `prev_size`, `marker`,
`text_marker`, `rur_1mb`, `top_num`, `oroom`, `foto_index`, `oroom_name`,
`oforum`, `logo`, `barmen`) VALUES (1, 'waphp.ru', 'waphp.ru', 1, 1,
'umnik', 'shut', 'anek', 'tupica', 'svaisch', 'system', 'baryga', 'znatok',
'flyder', 'mafiozi', 10, 1800, 1800, 1800, 1, 100, 0, 300,
0xd0a0d08ed0a1d193d0a0d197d0a0c2b5d0a1d08220d0a1e280a1d0a0c2b0d0a1e2809a,
'', 0, 9, 0, 0, 0, 150, 250, 200, 200, 500, 100, 100, 50, 50, 50, 100, 100,
10, 50, 1000, 100, 20, 100, 20, 20, 1000, 1000, 1000, 1024, 10, 60, 200, 9,
1, 1, 1, 1, 'go-wap', 'left', 1, 'waphp.ru', 500, 200, 100, 2, '80*80', 0,
'waphp.ru', 0, 0, 1, 1, '', 1, '', 'barmen'); CREATE TABLE `smiles` (
`id` int(11) NOT NULL auto_increment, `smile` text default NULL, `cat`
int(11) default NULL, `1` text default NULL, `2` text default NULL,
`3` text default NULL, `4` text default NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251; INSERT INTO
`enter_menu` (`img`, `name`, `link`, `pos`, `tip`, `rooms`) VALUES (0,
'Информация:', 'infa_b', 1, 0, 0), (0, 'Правила
чата', 'ustav', 2, 1, 0), (0, 'Информация', 'faq', 3, 1,
0), (0, 'Новости', 'news', 4, 1, 0), (0, 'Конкурсы',
'konkurs', 5, 1, 0), (0, 'Акции', 'akcyi', 6, 1, 0), (0,
'Встречи', 'vstr', 7, 1, 0), (0, 'Объявления', 'objavs',
8, 1, 0), (0, 'Осн. меню:', 'osn_b', 9, 0, 0), (0, 'Личный
кабинет', 'my/index', 10, 1, 0), (0, 'Знакомства',
'love/index', 11, 1, 0), (0, 'ЗАГС', 'zags/index', 12, 1, 0), (0,
'Игровая зона', 'games/', 13, 1, 0), (0,
'Спорт-тотализатор', 'total/index', 14, 1, 0), (0,
'Журнал чата', 'zhurnal/', 14, 1, 0), (0,
'Фото-Альбомы', 'albums', 15, 1, 0), (0, 'Видео чата',
'videos', 16, 1, 0), (0, 'Галерея чата', 'galery', 16, 1,
0), (0, 'Группы', 'groups/', 17, 1, 0), (0, 'Дневники',
'diaries', 18, 1, 0), (0, 'Кто где?', 'who', 19, 1, 0), (0,
'Комнаты:', 'rooms_b', 20, 0, 0), (0, 'Комнаты', 'rooms',
30, 1, 1), (0, 'Посольства', 'pos', 21, 1, 0), (0, 'Доп.
меню:', 'dop_b', 22, 0, 0), (0, 'Голосования', 'votes', 23,
1, 0), (0, 'Форум', 'forum/index', 24, 1, 0), (0,
'Файлообменник', 'fo/index', 25, 1, 0), (0, 'СМС и
Статусы', 'bash/', 26, 1, 0), (0, 'Полезные статьи',
'articles', 23, 1, 0); INSERT INTO `barmen` (`id`, `msg`, `name`,
`img`, `proc`, `time`, `cena`, `cat`, `user_id`) VALUES (1, '!апер',
'Аперетив "Кампари Биттер"',
'drink/68.gif', 25, 15, 25, 1, 0), (3, '!банзай', 'Саке',
'drink/31.gif', 27, 40, 45, 1, 0), (4, '!бит', 'Коктейль
«Bitter Fairy»', 'drink/74.gif', 7, 10, 13, 1, 0), (5,
'!брага', 'Брага свекловая', 'drink/42.gif', 13, 45, 35,
1, 0), (6, '!вино', 'Вино *Тамянка*', 'drink/45.gif', 12,
15, 20, 1, 0), (7, '!вино1', 'Вино *Кагор*', 'drink/47.gif',
15, 20, 35, 1, 0), (8, '!вино2', 'Вино *Бордо*',
'drink/48.gif', 14, 20, 40, 1, 0), (9, '!виски', 'Виски
"Grant`s"', 'drink/70.gif', 29, 20, 25, 1, 0), (11,
'!водка', 'Водка *Cтоличная*', 'drink/49.gif', 40, 50,
35, 1, 0), (12, '!джин', 'Джин тоник', 'drink/18.gif', 6, 10,
20, 1, 0), (13, '!кальян', 'Кальян
"Убийственны" )))', 'drink/77.jpg', 40, 25,
75, 1, 0), (14, '!кк', 'Coca-Cola', 'drink/65.gif', 0, 10, 10, 1,
0), (15, '!коктейль', 'Коктейль "Водка
Мартини"', 'drink/78.gif', 25, 25, 15, 1, 0), (16,
'!коньяк', 'Коньяк *Жан-Жак*', 'drink/52.gif', 40, 45,
20, 1, 0), (17, '!коньяк2', 'Коньяк
"Хеннесси"', 'drink/66.gif', 10, 20, 20, 1,
0), (18, '!космо', 'Коктейль
"Космополитен"', 'drink/73.gif', 6, 10, 16,
1, 0), (19, '!кофе', 'Кофе *Нескафе*', 'drink/58.gif', 1,
10, 10, 1, 0), (20, '!ликер', 'Ликер *Crema*', 'drink/32.gif',
24, 20, 15, 1, 0), (21, '!мартини', 'Мартини *Bianco*',
'drink/26.gif', 15, 20, 35, 1, 0), (22, '!минералка',
'Минеральная вода', 'drink/61.gif', 0, 10, 10, 1, 0), (23,
'!молоко', 'Молоко', 'drink/62.gif', 0, 10, 5, 1, 0), (24,
'!мохито', 'Коктейль "Мохито"',
'drink/72.gif', 8, 10, 15, 1, 0), (25, '!отвертка',
'Отвертка', 'drink/19.gif', 10, 10, 25, 1, 0), (26, '!пепси',
'Pepsi', 'drink/60.gif', 0, 10, 10, 1, 0), (27, '!пиво', 'Пиво
*Балтика 7*', 'drink/54.gif', 5, 10, 20, 1, 0), (28, '!пиво2',
'Пиво "Stella Artois"', 'drink/63.gif', 5, 10, 23, 1,
0), (29, '!портвейн', 'Портвейн', 'drink/30.gif', 18, 35,
35, 1, 0), (30, '!ром', 'Ром "Бакарди
Блэк"', 'drink/67.gif', 30, 30, 25, 1, 0), (31,
'!самогон', 'Самогон *приятный*', 'drink/44.gif', 50,
80, 50, 1, 0), (32, '!сигара', 'Сигара
"Raices"', 'drink/75.jpg', 4, 10, 10, 1, 0), (33,
'!сигарета', 'Сигареты "Davidoff"',
'drink/76.gif', 3, 10, 7, 1, 0), (34, '!сок', 'Сок
*Гранатовый*', 'drink/57.gif', 0, 10, 15, 1, 0), (35, '!сок2',
'Сок "Апельсиновый"', 'drink/64.gif', 0,
10, 10, 1, 0), (36, '!суицид', 'Зелье бабы Зины',
'drink/41.gif', 100, 180, 100, 1, 0), (37, '!текила', 'Текила',
'drink/38.gif', 50, 60, 70, 1, 0), (38, '!чай', 'Чай *Lipton*',
'drink/59.gif', 1, 10, 5, 1, 0), (39, '!шампанское',
'Шампанское *Советское Игристое*',
'drink/23.gif', 13, 25, 25, 1, 0), (40, '!шампанское2',
'Шампанское *Дом Периньон*', 'drink/25.gif', 14, 25,
35, 1, 0), (41, '!шоко', 'Горячий шоколад',
'drink/79.gif', 0, 10, 7, 1, 0), (42, '!яд', 'Яд Кобры',
'drink/71.gif', 99, 120, 30, 1, 0), (43, '!биф', 'Бифштекс
"Лакомый кусочек"', 'appetizer/30.gif', -7,
-10, 15, 2, 0), (44, '!блин', 'Блины
"Масленица"', 'appetizer/31.gif', -1, -5, 9, 2,
0), (45, '!борщ', 'Борщ "Украинский"',
'appetizer/22.gif', -10, -12, 15, 2, 0), (46, '!буж',
'Буженина', 'appetizer/29.gif', -5, -15, 13, 2, 0), (47,
'!верт', 'Поросенок на вертеле', 'appetizer/33.gif',
-10, -20, 30, 2, 0), (48, '!виноград', 'Виноград',
'appetizer/3.gif', -5, -4, 10, 2, 0), (49, '!вишня', 'Вишенка',
'appetizer/8.gif', -10, -9, 15, 2, 0), (50, '!гамб',
'Гамбургер', 'appetizer/9.gif', -5, -3, 10, 2, 0), (51,
'!гриб', 'Грибочки', 'appetizer/20.gif', -5, -7, 13, 2,
0), (52, '!картошка', 'Карточешка', 'appetizer/19.gif',
-15, -11, 24, 2, 0), (53, '!клубника', 'Клубничка',
'appetizer/14.gif', -5, -8, 10, 2, 0), (54, '!курица', 'Курица
Гриль', 'appetizer/15.gif', -15, -17, 20, 2, 0); -- -- Дамп
данных таблицы `bar_cat` -- INSERT INTO `bar_cat` (`id`,
`pos`, `img`, `name`) VALUES (1, 1, '', 'Напитки'), (2, 2, '',
'Закуски');
К файлу
К просмотру архива
Онлайн: 1
Реклама
Купить рекламу