Просмотр архива БД ОКМОБ

DROP TABLE IF EXISTS `adm_ch_file`;

CREATE TABLE `adm_ch_file` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
 
`name_file` varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`admin_chat`;

CREATE TABLE `admin_chat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `msg` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
 
`avtor` int(11) NOT NULL,
  `id_komu` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `ads`;

CREATE TABLE `ads` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255)
DEFAULT NULL,
  `time_srok` varchar(255) DEFAULT NULL,
  `kogda`
varchar(255) DEFAULT NULL,
  `color` varchar(244) CHARACTER SET utf8 NOT
NULL,
  `b` int(11) NOT NULL DEFAULT '0',
  `i` int(11) NOT NULL DEFAULT
'0',
  `tip` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=cp1251;




DROP TABLE IF
EXISTS `antispam`;

CREATE TABLE `antispam` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `news` varchar(244) NOT NULL,
  `stena` varchar(244) NOT
NULL,
  `chat` varchar(244) NOT NULL,
  `forum_tema` varchar(255) NOT
NULL,
  `forum_post` varchar(255) NOT NULL,
  `guest` varchar(255) NOT
NULL,
  `blog` varchar(244) NOT NULL,
  `mes` varchar(244) NOT NULL,
 
`down` varchar(244) NOT NULL,
  `repa` varchar(255) NOT NULL,
  `friends`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`ban_list`;

CREATE TABLE `ban_list` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `kto` varchar(255) DEFAULT NULL,
  `about` varchar(255)
DEFAULT NULL,
  `time_play` varchar(255) DEFAULT NULL,
  `time_end`
varchar(255) DEFAULT NULL,
  `add_ban` varchar(255) DEFAULT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2863 DEFAULT
CHARSET=cp1251;




DROP TABLE IF EXISTS `blog_com`;

CREATE TABLE
`blog_com` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` text NOT
NULL,
  `avtor` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
 
`blog` varchar(244) NOT NULL,
  `avtorlogin` varchar(100) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `blog_r`;

CREATE TABLE `blog_r` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`blog_reit`;

CREATE TABLE `blog_reit` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `stat` varchar(244) NOT NULL,
  `r` varchar(244) NOT
NULL,
  `kto` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `blog_search`;

CREATE TABLE
`blog_search` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `meta`
varchar(100) NOT NULL,
  `kto` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`blog_stat`;

CREATE TABLE `blog_stat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `titlename` varchar(100) NOT NULL,
  `text` text NOT
NULL,
  `meta` varchar(100) NOT NULL,
  `razdel` varchar(100) NOT NULL,
 
`avtor` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `readlen`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `cena`;

CREATE TABLE `cena` (
 
`summa_post` varchar(5) NOT NULL,
  `summa_them` varchar(5) NOT NULL,
 
`guest_post` varchar(5) NOT NULL,
  `repa_plus` varchar(11) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`chat_post`;

CREATE TABLE `chat_post` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `room` int(10) NOT NULL,
  `msg` text NOT NULL,
  `avtor`
varchar(244) NOT NULL,
  `avtorlogin` varchar(244) NOT NULL,
  `time`
varchar(244) NOT NULL,
  `color` varchar(25) NOT NULL,
  `emotion`
varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `chat_room`;

CREATE TABLE
`chat_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(244)
NOT NULL,
  `about` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `clan`;

CREATE TABLE `clan`
(
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `us` int(15) DEFAULT NULL,
 
`name` varchar(50) DEFAULT NULL,
  `about` varchar(255) DEFAULT NULL,
 
`time` int(15) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `xp`
varchar(15) DEFAULT '0',
  `xp_day` varchar(15) NOT NULL DEFAULT '0',
 
`gold` int(15) NOT NULL DEFAULT '0',
  `ser` int(15) NOT NULL DEFAULT '0',

 `bro` int(15) NOT NULL DEFAULT '0',
  `div` int(1) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `clan_us`;

CREATE TABLE `clan_us`
(
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `user` int(15) DEFAULT NULL,
 
`idclan` int(15) DEFAULT NULL,
  `time` int(15) DEFAULT NULL,
  `money`
int(15) NOT NULL DEFAULT '0',
  `level` int(1) NOT NULL DEFAULT '0',
 
`polza` int(15) DEFAULT NULL,
  `xp` varchar(15) NOT NULL DEFAULT '0',
 
`xp_day` varchar(15) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `config`;

CREATE TABLE `config` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `style` varchar(244) NOT NULL DEFAULT 'style',
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT
INTO config VALUES("1","default");



DROP TABLE IF
EXISTS `forum_file`;

CREATE TABLE `forum_file` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `name_file` varchar(244)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=94 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `forum_kat`;

CREATE TABLE
`forum_kat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel`
varchar(244) NOT NULL,
  `name` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `forum_opros`;

CREATE TABLE `forum_opros` (
  `id` int(10)
unsigned NOT NULL AUTO_INCREMENT,
  `surv` varchar(1024) NOT NULL,
  `time`
int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `them` int(11) NOT NULL,

 `time_close` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `time_close`
(`time_close`),
  KEY `time` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=30
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `forum_opros_r`;

CREATE
TABLE `forum_opros_r` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `them`
int(11) NOT NULL,
  `id_sur` int(11) NOT NULL,
  `msg` varchar(1024) NOT
NULL,
  PRIMARY KEY (`id`),
  KEY `id_sur` (`id_sur`)
) ENGINE=MyISAM
AUTO_INCREMENT=104 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`forum_opros_v`;

CREATE TABLE `forum_opros_v` (
  `id_s` int(11) NOT
NULL,
  `id_r` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  KEY `id_s` (`id_s`,`id_r`,`id_user`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `forum_post`;

CREATE TABLE
`forum_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel` int(11)
NOT NULL,
  `kat` int(11) NOT NULL,
  `tema` int(11) NOT NULL,
  `text`
mediumtext NOT NULL,
  `us` varchar(255) NOT NULL,
  `time` varchar(255)
NOT NULL,
  `citata` mediumtext NOT NULL,
  `citata_us` varchar(255) NOT
NULL,
  `rating` int(11) NOT NULL,
  `kto_plus` int(11) NOT NULL,
 
`rating_p` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=7206 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`forum_razdel`;

CREATE TABLE `forum_razdel` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(244) NOT NULL,
  `opis` varchar(255) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `forum_temass`;

CREATE TABLE
`forum_temass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel` int(11)
NOT NULL,
  `kat` int(11) NOT NULL,
  `text` varchar(244) NOT NULL,
 
`name` varchar(244) NOT NULL,
  `us` varchar(224) NOT NULL,
  `time`
varchar(244) NOT NULL,
  `status` int(11) NOT NULL,
  `up` varchar(244) NOT
NULL,
  `new` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=1705 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`forum_zaklad`;

CREATE TABLE `forum_zaklad` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `tema` varchar(244) NOT NULL,
  `us` varchar(244) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `friends`;

CREATE TABLE `friends`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `us_a` int(11) NOT NULL,
 
`us_b` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `time` varchar(244)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `gift`;

CREATE TABLE `gift` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `cat` int(11) NOT NULL DEFAULT
'0',
  `name` varchar(100) DEFAULT NULL,
  `gift` varchar(244) NOT NULL,
 
`money` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `gift_cat`;

CREATE TABLE
`gift_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `gift_us`;

CREATE TABLE `gift_us`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` varchar(100) DEFAULT
NULL,
  `kto` int(11) NOT NULL,
  `komy` int(11) NOT NULL,
  `gift`
varchar(100) DEFAULT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`guest`;

CREATE TABLE `guest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`msg` text NOT NULL,
  `avtorlogin` varchar(244) NOT NULL,
  `avtor`
varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `jalob_ba`;

CREATE TABLE `jalob_ba` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `about` text NOT NULL,
  `avtor` varchar(244) NOT
NULL,
  `komy` varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `ked_list`;

CREATE TABLE `ked_list`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` int(11) NOT NULL,
 
`add_ked` int(11) NOT NULL,
  `about` varchar(222) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`lenta`;

CREATE TABLE `lenta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`text` text NOT NULL,
  `kto` varchar(100) NOT NULL,
  `komy` varchar(100)
NOT NULL,
  `time` varchar(100) NOT NULL,
  `readlen` varchar(1) NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11833 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `lib_razdel`;

CREATE TABLE
`lib_razdel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(100) DEFAULT NULL,
  `opis` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `lib_stat`;

CREATE TABLE `lib_stat` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `razdel` int(11) NOT NULL,
  `name` varchar(100)
DEFAULT NULL,
  `opis` varchar(244) NOT NULL,
  `meta` varchar(100) NOT
NULL,
  `files` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `load_ban`;

CREATE TABLE
`load_ban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id` int(11)
NOT NULL,
  `addban_user` int(11) NOT NULL,
  `cause` varchar(244) NOT
NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`load_com`;

CREATE TABLE `load_com` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `time` varchar(244) NOT NULL,
  `msg` text NOT NULL,
 
`avtorlogin` varchar(244) NOT NULL,
  `file` varchar(244) NOT NULL,
  `ip`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `load_dir`;

CREATE TABLE `load_dir`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_dir` int(11) NOT NULL
DEFAULT '0',
  `url` text,
  `name` varchar(100) DEFAULT NULL,
  `icon`
varchar(244) NOT NULL,
  `files` varchar(1) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `load_file`;

CREATE TABLE `load_file` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_dir` int(11) NOT NULL,
  `name` varchar(100)
DEFAULT NULL,
  `url` text,
  `time` int(11) NOT NULL,
  `avtor`
varchar(25) NOT NULL,
  `format` varchar(244) NOT NULL,
  `about` text NOT
NULL,
  `files` varchar(244) NOT NULL,
  `mod` int(11) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=574 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `load_reit`;

CREATE TABLE
`load_reit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file` varchar(244)
NOT NULL,
  `r` varchar(244) NOT NULL,
  `kto` varchar(100) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `load_screen`;

CREATE TABLE
`load_screen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id` int(11)
NOT NULL,
  `name_screen` varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`logs`;

CREATE TABLE `logs` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
 
`login` varchar(20) NOT NULL,
  `time` int(255) NOT NULL,
  `ip`
varchar(16) NOT NULL,
  `ua` varchar(100) NOT NULL,
  `method` int(1) NOT
NULL,
  `success` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1206 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`message`;

CREATE TABLE `message` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `kto` varchar(244) NOT NULL,
  `komy` varchar(244) NOT
NULL,
  `text` text NOT NULL,
  `time` varchar(244) NOT NULL,
  `readlen`
varchar(1) NOT NULL,
  `file` varchar(244) NOT NULL DEFAULT '',
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `message_c`;

CREATE TABLE
`message_c` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` varchar(244)
NOT NULL,
  `kogo` varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
 
`ignor` varchar(1) NOT NULL,
  `posl_time` int(11) NOT NULL,
  `del`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=99
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `message_save`;

CREATE
TABLE `message_save` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text`
text NOT NULL,
  `kto` varchar(244) NOT NULL,
  `ktoavtor` varchar(244) NOT
NULL,
  `uid` varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `mysite`;

CREATE TABLE `mysite` (
  `id` int(11) NOT NULL
AUTO_INCREMENT COMMENT 'id сайта',
  `us` int(11) DEFAULT NULL COMMENT
'id создателя',
  `domain` varchar(99) DEFAULT NULL COMMENT
'Домен',
  `name` varchar(99) DEFAULT NULL COMMENT
'Название',
  `zona` varchar(20) DEFAULT NULL COMMENT
'Доменная зона',
  `time` int(22) DEFAULT NULL COMMENT
'Время создания',
  `money` int(11) DEFAULT NULL COMMENT
'Деньги сайта',
  `tarif` int(11) NOT NULL DEFAULT '100' COMMENT
'Тариф сайта',
  `mb` int(11) DEFAULT '0' COMMENT
'Заполненого тарифа',
  `about` varchar(555) DEFAULT NULL
COMMENT 'Описание сайта',
  `level` int(2) NOT NULL DEFAULT
'1' COMMENT 'Уровень',
  `host` int(55) NOT NULL DEFAULT '0' COMMENT
'Хосты',
  `hit` int(55) NOT NULL DEFAULT '0' COMMENT 'Хиты',
 
`kod` varchar(5555) NOT NULL DEFAULT 'Создатель еще не
редактировал свой сайт :(' COMMENT 'HTML',
  `timered`
int(11) DEFAULT NULL COMMENT 'Время последнего
редактирования',
  `css` varchar(5555) DEFAULT NULL,
 
`favicon` varchar(55) DEFAULT NULL,
  `title` varchar(40) DEFAULT
'Сайт',
  `cena` int(11) NOT NULL DEFAULT '100',
  `dolg` int(11)
DEFAULT '0',
  `reg` int(11) DEFAULT '0',
  `time_h` int(11) DEFAULT NULL,

 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `mysite_ads`;

CREATE TABLE
`mysite_ads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(255) DEFAULT NULL,
  `ids` int(11) DEFAULT NULL,
  `url`
varchar(255) DEFAULT NULL,
  `time_srok` varchar(255) DEFAULT NULL,
 
`kogda` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251;




DROP TABLE IF EXISTS `mysite_host`;

CREATE
TABLE `mysite_host` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `us`
int(15) DEFAULT NULL,
  `idsait` int(15) DEFAULT NULL,
  `time` int(22)
DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `mysite_log_dom`;

CREATE TABLE
`mysite_log_dom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `us` int(11)
DEFAULT NULL,
  `old` varchar(99) DEFAULT NULL,
  `new` varchar(99) DEFAULT
NULL,
  `time` int(15) DEFAULT NULL,
  `money` int(7) DEFAULT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `mysite_reg`;

CREATE TABLE
`mysite_reg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ids` int(11)
DEFAULT NULL,
  `login` varchar(99) DEFAULT NULL,
  `pol` int(1) DEFAULT
NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`n_history`;

CREATE TABLE `n_history` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `user_login` varchar(211) NOT NULL,
  `new_login`
varchar(211) NOT NULL,
  `id_komu` int(11) NOT NULL,
  `id_kto` int(11) NOT
NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`text` text NOT NULL,
  `avtor` varchar(244) NOT NULL,
  `time`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`news_com`;

CREATE TABLE `news_com` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `time` varchar(244) NOT NULL,
  `msg` text NOT NULL,
 
`avtor` int(244) NOT NULL,
  `avtorlogin` varchar(244) NOT NULL,
  `news`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`operation`;

CREATE TABLE `operation` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `us` int(11) NOT NULL DEFAULT '0',
  `sum` int(11) NOT
NULL DEFAULT '0',
  `text` varchar(100) DEFAULT NULL,
  `time` int(11)
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=129
DEFAULT CHARSET=cp1251 PACK_KEYS=0;




DROP TABLE IF EXISTS
`opov`;

CREATE TABLE `opov` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`readlen` int(1) NOT NULL,
  `time` int(11) NOT NULL,
  `komy` int(11) NOT
NULL,
  `kto` int(11) NOT NULL,
  `text` varchar(255) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `perevod`;

CREATE TABLE `perevod` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `us` int(11) NOT NULL DEFAULT '0',
  `kem` int(11)
NOT NULL DEFAULT '0',
  `sum` int(11) NOT NULL DEFAULT '0',
  `text`
varchar(100) DEFAULT NULL,
  `time` int(11) DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=191 DEFAULT CHARSET=cp1251
PACK_KEYS=0;




DROP TABLE IF EXISTS `photo_album`;

CREATE TABLE
`photo_album` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `us` int(11) NOT
NULL,
  `name` varchar(244) NOT NULL,
  `info` varchar(244) NOT NULL,
 
`tip` int(11) NOT NULL,
  `time` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`photo_files`;

CREATE TABLE `photo_files` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `album_id` int(11) NOT
NULL,
  `time` varchar(100) NOT NULL,
  `files` varchar(255) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `photo_reit`;

CREATE TABLE `photo_reit` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `foto` varchar(244) NOT NULL,
  `r` varchar(244) NOT
NULL,
  `kto` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `post_reit`;

CREATE TABLE
`post_reit` (
  `id` int(11) NOT NULL,
  `post` varchar(244) NOT NULL,
 
`r` varchar(244) NOT NULL,
  `kto` varchar(100) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `reklama`;

CREATE TABLE
`reklama` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32)
NOT NULL,
  `url` text NOT NULL,
  `date_last` int(11) NOT NULL,
  `color`
varchar(12) NOT NULL,
  `bold` int(1) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `repa_user`;

CREATE TABLE `repa_user` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `text` text NOT NULL,
  `kto` varchar(244) NOT NULL,
 
`komy` varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
  `repa`
varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`rul`;

CREATE TABLE `rul` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`text` varchar(222) NOT NULL,
  `avtor` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`rules`;

CREATE TABLE `rules` (
  `site` text NOT NULL,
  `forum` text NOT
NULL,
  `chat` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `settings`;

CREATE TABLE `settings` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `key` text NOT NULL,
  `des` text NOT NULL,
  `cop`
varchar(50) NOT NULL,
  `reg_on` int(11) NOT NULL,
  `load_mod` int(11) NOT
NULL,
  `counter` varchar(10000) NOT NULL,
  `counter_all` varchar(10000)
NOT NULL,
  `forum_post_m` int(11) NOT NULL,
  `forum_tem_m` int(11) NOT
NULL,
  `down_file_m` int(11) NOT NULL,
  `guest_post_m` int(11) NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `sivor`;

CREATE TABLE `sivor` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) DEFAULT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `sivor_user`;

CREATE TABLE `sivor_user` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_ank` int(11) NOT NULL,

 `name` varchar(150) DEFAULT NULL,
  `golos` int(11) NOT NULL,
  `win`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `smile`;

CREATE TABLE `smile` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(244) NOT NULL,
 
`icon` varchar(244) NOT NULL,
  `papka` varchar(30) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `smile_p`;

CREATE TABLE `smile_p` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `stena`;

CREATE TABLE `stena` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `msg` text NOT NULL,
  `avtor` varchar(244) NOT NULL,
 
`ukogo` varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `u_do`;

CREATE TABLE `u_do` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `doki` varchar(255) NOT NULL,
  `ked_id` int(11) NOT
NULL,
  `time` int(11) NOT NULL,
  `avtor` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `login` varchar(20) NOT NULL,
  `pass` varchar(255) NOT
NULL,
  `sex` varchar(1) NOT NULL,
  `name` varchar(30) NOT NULL,
  `email`
varchar(40) NOT NULL,
  `strana` varchar(255) NOT NULL,
  `gorod`
varchar(255) NOT NULL,
  `osebe` varchar(555) NOT NULL,
  `stat`
varchar(555) NOT NULL,
  `skype` varchar(555) NOT NULL,
  `icq`
varchar(555) NOT NULL,
  `url` varchar(555) NOT NULL,
  `money` varchar(50)
NOT NULL DEFAULT '0',
  `style` varchar(255) DEFAULT 'default',
  `news`
int(11) NOT NULL,
  `datareg` varchar(255) NOT NULL,
  `level` varchar(1)
NOT NULL,
  `browser` varchar(250) NOT NULL,
  `ip` varchar(250) NOT NULL,

 `viz` varchar(250) NOT NULL,
  `online` varchar(250) NOT NULL,
  `gde`
varchar(255) NOT NULL,
  `xstatus` varchar(255) NOT NULL,
  `color_nick`
varchar(255) NOT NULL,
  `max` int(30) NOT NULL DEFAULT '10',
  `avatar`
varchar(255) NOT NULL,
  `new_tem` int(11) NOT NULL,
  `new_files` int(11)
NOT NULL,
  `rating` varchar(244) DEFAULT '0',
  `form_file` int(11) NOT
NULL DEFAULT '1',
  `bb_panel` int(11) NOT NULL DEFAULT '1',
  `web` int(1)
NOT NULL,
  `n_color` varchar(6) DEFAULT NULL,
  `k_color` varchar(6)
DEFAULT NULL,
  `oplata_grad` int(1) NOT NULL DEFAULT '0',
  `ico_nick`
varchar(255) NOT NULL,
  `oplata_ico` int(2) NOT NULL,
  `wmr` varchar(12)
NOT NULL,
  `wmid` varchar(12) NOT NULL,
  `game_a` int(1) NOT NULL DEFAULT
'0',
  `pers` varchar(255) NOT NULL,
  `oplata_pers` int(1) NOT NULL,
 
`allonline` int(25) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8;

INSERT INTO users
VALUES("1","MrFoxD","c56d0e9a7ccec67b4ea131655038d604","1","Костя","anonimyZer@bk.ru","","","","","","","","0","default","0","1423987391","3","Mozilla/5.0
(Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/40.0.2214.111
Safari/537.36","94.230.112.163","1423987577","183","/exit.php?okda","","","10","","0","0","0","1","1","0","","","0","","0","","","0","","0","183");



DROP
TABLE IF EXISTS `users_f`;

CREATE TABLE `users_f` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `forum_count` int(11)
NOT NULL,
  `summa` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `vip`;

CREATE TABLE `vip` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `us` int(11) NOT NULL,
  `time_play` int(11) NOT NULL,
 
`time_and` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`vivod`;

CREATE TABLE `vivod` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`wmr` varchar(12) NOT NULL,
  `summa` int(11) NOT NULL,
  `status` int(1)
NOT NULL,
  `id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `wap_site`;

CREATE TABLE `wap_site`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_u` int(11) NOT NULL,
 
`link` text NOT NULL,
  `name` varchar(99) DEFAULT NULL,
  `zona`
varchar(10) DEFAULT NULL,
  `link_opis` text NOT NULL,
  `host` int(11) NOT
NULL,
  `hit` int(11) NOT NULL,
  `host_day` int(11) NOT NULL,
  `hit_day`
int(11) NOT NULL,
  `type` text NOT NULL,
  `dengi` int(11) NOT NULL,
 
`tarif` int(11) NOT NULL,
  `time_h` int(11) NOT NULL,
  `time_r` int(11)
NOT NULL,
  `tarif_abs` int(11) NOT NULL,
  `reg` int(11) NOT NULL,
 
`level` int(11) NOT NULL,
  `rekl_h` int(11) NOT NULL,
  `rekl_cost`
int(11) NOT NULL,
  `rekl_my` int(11) NOT NULL,
  `kod` varchar(5555) NOT
NULL DEFAULT 'Создатель еще не редактировал
свой сайт :(',
  `timered` varchar(25) DEFAULT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `webmoney`;

CREATE TABLE `webmoney` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `wmid` varchar(15) NOT
NULL,
  `wmr` varchar(15) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;