
CREATE TABLE `adver` (
  `id_adv` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `colday` int(11) NOT NULL,
  `ts` int(11) NOT NULL,
  `timeadd` datetime NOT NULL,
  PRIMARY KEY (`id_adv`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0;


CREATE TABLE `chat` (
  `id_mess` int(11) NOT NULL AUTO_INCREMENT,
  `id_zver` int(11) NOT NULL,
  `admin` int(11) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `text` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id_mess`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE `comm` (
  `id_comm` int(11) NOT NULL AUTO_INCREMENT,
  `id_new` int(11) NOT NULL,
  `id_zver` int(11) NOT NULL,
  `text` varchar(1024) CHARACTER SET utf8 NOT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id_comm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `forum` (
  `id_post` int(11) NOT NULL AUTO_INCREMENT,
  `id_theme` int(11) NOT NULL,
  `id_zver` int(11) NOT NULL,
  `text` varchar(1024) CHARACTER SET utf8 NOT NULL,
  `date` datetime NOT NULL,
  `admin` int(11) NOT NULL,
  PRIMARY KEY (`id_post`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `mail` (
  `id_mail` int(11) NOT NULL AUTO_INCREMENT,
  `id_to` int(11) NOT NULL,
  `id_from` int(11) NOT NULL,
  `subj` varchar(1024) CHARACTER SET utf8 NOT NULL,
  `text` varchar(1024) CHARACTER SET utf8 NOT NULL,
  `date` datetime NOT NULL,
  `folder` enum('new','view') DEFAULT 'new',
  PRIMARY KEY (`id_mail`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `money` (
  `sheif` int(11) DEFAULT '0',
  `min` float DEFAULT '10',
  `premium` int(11) NOT NULL DEFAULT '5',
  `gold` int(11) NOT NULL DEFAULT '10',
  `ref` int(11) NOT NULL DEFAULT '10',
  `clickSM` int(11) DEFAULT '0',
  `clickVM` int(11) DEFAULT '0',
  `clickSO` int(11) NOT NULL DEFAULT '0',
  `clickVO` int(11) NOT NULL DEFAULT '0',
  `clickSC` int(11) NOT NULL DEFAULT '0',
  `clickVC` int(11) NOT NULL DEFAULT '0',
  `clickS` int(11) NOT NULL DEFAULT '0',
  `clickV` int(11) NOT NULL DEFAULT '0',
  `1` float DEFAULT '3000',
  `2` float DEFAULT '3000',
  `3` float DEFAULT '600',
  `4` float DEFAULT '600',
  `5` float DEFAULT '3000',
  `6` float DEFAULT '600',
  `7` float DEFAULT '600',
  `8` float DEFAULT '600',
  `9` float DEFAULT '600',
  `10` float DEFAULT '600',
  `11` float DEFAULT NULL,
  `12` float DEFAULT NULL,
  `13` float DEFAULT NULL,
  `14` float DEFAULT NULL,
  `15` float DEFAULT NULL,
  `16` float DEFAULT NULL,
  `17` float DEFAULT NULL,
  `18` float DEFAULT NULL,
  `19` float DEFAULT NULL,
  `20` float DEFAULT NULL,
  `21` float DEFAULT NULL,
  `22` float DEFAULT NULL,
  `23` float DEFAULT NULL,
  `24` float DEFAULT NULL,
  `25` float DEFAULT NULL,
  `26` float DEFAULT NULL,
  `27` float DEFAULT NULL,
  `28` float DEFAULT NULL,
  `29` float DEFAULT NULL,
  `30` float DEFAULT NULL,
  `31` float DEFAULT NULL,
  `32` float DEFAULT NULL,
  `33` float DEFAULT NULL,
  `34` float DEFAULT NULL,
  `35` float DEFAULT NULL,
  `36` float DEFAULT NULL,
  `37` float DEFAULT NULL,
  `38` float DEFAULT NULL,
  `39` float DEFAULT NULL,
  `40` float DEFAULT NULL,
  `41` float DEFAULT NULL,
  `42` float DEFAULT NULL,
  `43` float DEFAULT NULL,
  `44` float DEFAULT NULL,
  `45` float DEFAULT NULL,
  `46` float DEFAULT NULL,
  `47` float DEFAULT NULL,
  `48` float DEFAULT NULL,
  `49` float DEFAULT NULL,
  `50` float DEFAULT NULL,
  `51` float DEFAULT NULL,
  `52` float DEFAULT NULL,
  `53` float DEFAULT NULL,
  `54` float DEFAULT NULL,
  `55` float DEFAULT NULL,
  `56` float DEFAULT NULL,
  `57` float DEFAULT NULL,
  `58` float DEFAULT NULL,
  `59` float DEFAULT NULL,
  `60` float DEFAULT NULL,
  `61` float DEFAULT NULL,
  `62` float DEFAULT NULL,
  `63` float DEFAULT NULL,
  `64` float DEFAULT NULL,
  `65` float DEFAULT NULL,
  `66` float DEFAULT NULL,
  `67` float DEFAULT NULL,
  `68` float DEFAULT NULL,
  `69` float DEFAULT NULL,
  `70` float DEFAULT NULL,
  `71` float DEFAULT NULL,
  `72` float DEFAULT NULL,
  `73` float DEFAULT NULL,
  `74` float DEFAULT NULL,
  `75` float DEFAULT NULL,
  `76` float DEFAULT NULL,
  `77` float DEFAULT NULL,
  `78` float DEFAULT NULL,
  `79` float DEFAULT NULL,
  `80` float DEFAULT NULL,
  `81` float DEFAULT NULL,
  `82` float DEFAULT NULL,
  `83` float DEFAULT NULL,
  `84` float DEFAULT NULL,
  `85` float DEFAULT NULL,
  `86` float DEFAULT NULL,
  `87` float DEFAULT NULL,
  `88` float DEFAULT NULL,
  `89` float DEFAULT NULL,
  `90` float DEFAULT NULL,
  `91` float DEFAULT NULL,
  `92` float DEFAULT NULL,
  `93` float DEFAULT NULL,
  `94` float DEFAULT NULL,
  `95` float DEFAULT NULL,
  `96` float DEFAULT NULL,
  `97` float DEFAULT NULL,
  `98` float DEFAULT NULL,
  `99` float DEFAULT NULL,
  `100` float DEFAULT NULL,
  `101` float DEFAULT NULL,
  `102` float DEFAULT NULL,
  `103` float DEFAULT NULL,
  `104` float DEFAULT NULL,
  `105` float DEFAULT NULL,
  `106` float DEFAULT NULL,
  `107` float DEFAULT NULL,
  `108` float DEFAULT NULL,
  `109` float DEFAULT NULL,
  `110` float DEFAULT NULL,
  `111` float DEFAULT NULL,
  `112` float DEFAULT NULL,
  `113` float DEFAULT NULL,
  `114` float DEFAULT NULL,
  `115` float DEFAULT NULL,
  `116` float DEFAULT NULL,
  `117` float NOT NULL,
  `118` float NOT NULL,
  `119` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `money` (`sheif`, `min`, `premium`, `gold`, `ref`, `clickSM`, `clickVM`, `clickSO`, `clickVO`, `clickSC`, `clickVC`, `clickS`, `clickV`, `1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `9`, `10`, `11`, `12`, `13`, `14`, `15`, `16`, `17`, `18`, `19`, `20`, `21`, `22`, `23`, `24`, `25`, `26`, `27`, `28`, `29`, `30`, `31`, `32`, `33`, `34`, `35`, `36`, `37`, `38`, `39`, `40`, `41`, `42`, `43`, `44`, `45`, `46`, `47`, `48`, `49`, `50`, `51`, `52`, `53`, `54`, `55`, `56`, `57`, `58`, `59`, `60`, `61`, `62`, `63`, `64`, `65`, `66`, `67`, `68`, `69`, `70`, `71`, `72`, `73`, `74`, `75`, `76`, `77`, `78`, `79`, `80`, `81`, `82`, `83`, `84`, `85`, `86`, `87`, `88`, `89`, `90`, `91`, `92`, `93`, `94`, `95`, `96`, `97`, `98`, `99`, `100`, `101`, `102`, `103`, `104`, `105`, `106`, `107`, `108`, `109`, `110`, `111`, `112`, `113`, `114`, `115`, `116`, `117`, `118`, `119`) VALUES (0,10,3,5,15,0,857,0,862,6,927,6,2646,400,400,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,100,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,350,250,350,350,250,250,250,250,250,250,250,250,250,230,250,250,200,200,300,250,230,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,300,300,300,10,10);





CREATE TABLE `news` (
  `id_new` int(11) NOT NULL AUTO_INCREMENT,
  `text` varchar(400) CHARACTER SET utf8 DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time NOT NULL,
  PRIMARY KEY (`id_new`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `randoms` (
  `usa` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `rand` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `sites` (
  `id_url` int(11) NOT NULL AUTO_INCREMENT,
  `id_zver` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `status` enum('activ','mod','ban','rumod') DEFAULT 'mod',
  `kol` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `tiketi` (
  `id_tiket` int(11) NOT NULL AUTO_INCREMENT,
  `id_zver` int(11) NOT NULL,
  `text` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `answer` varchar(1024) CHARACTER SET utf8 DEFAULT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id_tiket`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;











CREATE TABLE `trafick` (
  `id_zver` int(11) NOT NULL,
  `id_rek` int(11) NOT NULL,
  `id_url` int(11) NOT NULL,
  `usa` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `brauzer` varchar(255) NOT NULL,
  `ip` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `oper` int(255) DEFAULT NULL,
  `time` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;









CREATE TABLE `url` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) CHARACTER SET utf8 NOT NULL,
  `limit` int(50) NOT NULL,
  `1` int(1) NOT NULL DEFAULT '0',
  `2` int(1) NOT NULL DEFAULT '0',
  `3` int(1) NOT NULL DEFAULT '0',
  `4` int(1) NOT NULL DEFAULT '0',
  `5` int(1) NOT NULL DEFAULT '0',
  `6` int(1) NOT NULL DEFAULT '0',
  `7` int(1) NOT NULL DEFAULT '0',
  `8` int(1) NOT NULL DEFAULT '0',
  `9` int(1) NOT NULL DEFAULT '0',
  `10` int(1) NOT NULL DEFAULT '0',
  `11` int(1) NOT NULL DEFAULT '0',
  `12` int(1) NOT NULL DEFAULT '0',
  `13` int(1) NOT NULL DEFAULT '0',
  `14` int(1) NOT NULL DEFAULT '0',
  `15` int(1) NOT NULL DEFAULT '0',
  `16` int(1) NOT NULL DEFAULT '0',
  `17` int(1) NOT NULL DEFAULT '0',
  `18` int(1) NOT NULL DEFAULT '0',
  `19` int(1) NOT NULL DEFAULT '0',
  `20` int(1) NOT NULL DEFAULT '0',
  `21` int(1) NOT NULL DEFAULT '0',
  `22` int(1) NOT NULL DEFAULT '0',
  `23` int(1) NOT NULL DEFAULT '0',
  `24` int(1) NOT NULL DEFAULT '0',
  `25` int(1) NOT NULL DEFAULT '0',
  `26` int(1) NOT NULL DEFAULT '0',
  `27` int(1) NOT NULL DEFAULT '0',
  `28` int(1) NOT NULL DEFAULT '0',
  `29` int(1) NOT NULL DEFAULT '0',
  `30` int(1) NOT NULL DEFAULT '0',
  `31` int(1) NOT NULL DEFAULT '0',
  `32` int(1) NOT NULL DEFAULT '0',
  `33` int(1) NOT NULL DEFAULT '0',
  `34` int(1) NOT NULL DEFAULT '0',
  `35` int(1) NOT NULL DEFAULT '0',
  `36` int(1) NOT NULL DEFAULT '0',
  `37` int(1) NOT NULL DEFAULT '0',
  `38` int(1) NOT NULL DEFAULT '0',
  `39` int(1) NOT NULL DEFAULT '0',
  `40` int(1) NOT NULL DEFAULT '0',
  `41` int(1) NOT NULL DEFAULT '0',
  `42` int(1) NOT NULL DEFAULT '0',
  `43` int(1) NOT NULL DEFAULT '0',
  `44` int(1) NOT NULL DEFAULT '0',
  `45` int(1) NOT NULL DEFAULT '0',
  `46` int(1) NOT NULL DEFAULT '0',
  `47` int(1) NOT NULL DEFAULT '0',
  `48` int(1) NOT NULL DEFAULT '0',
  `49` int(1) NOT NULL DEFAULT '0',
  `50` int(1) NOT NULL DEFAULT '0',
  `51` int(1) NOT NULL DEFAULT '0',
  `52` int(1) NOT NULL DEFAULT '0',
  `53` int(1) NOT NULL DEFAULT '0',
  `54` int(1) NOT NULL DEFAULT '0',
  `55` int(1) NOT NULL DEFAULT '0',
  `56` int(1) NOT NULL DEFAULT '0',
  `57` int(1) NOT NULL DEFAULT '0',
  `58` int(1) NOT NULL DEFAULT '0',
  `59` int(1) NOT NULL DEFAULT '0',
  `60` int(1) NOT NULL DEFAULT '0',
  `61` int(1) NOT NULL DEFAULT '0',
  `62` int(1) NOT NULL DEFAULT '0',
  `63` int(1) NOT NULL DEFAULT '0',
  `64` int(1) NOT NULL DEFAULT '0',
  `65` int(1) NOT NULL DEFAULT '0',
  `66` int(1) NOT NULL DEFAULT '0',
  `67` int(1) NOT NULL DEFAULT '0',
  `68` int(1) NOT NULL DEFAULT '0',
  `69` int(1) NOT NULL DEFAULT '0',
  `70` int(1) NOT NULL DEFAULT '0',
  `71` int(1) NOT NULL DEFAULT '0',
  `72` int(1) NOT NULL DEFAULT '0',
  `73` int(1) NOT NULL DEFAULT '0',
  `74` int(1) NOT NULL DEFAULT '0',
  `75` int(1) NOT NULL DEFAULT '0',
  `76` int(1) NOT NULL DEFAULT '0',
  `77` int(1) NOT NULL DEFAULT '0',
  `78` int(1) NOT NULL DEFAULT '0',
  `79` int(1) NOT NULL DEFAULT '0',
  `80` int(1) NOT NULL DEFAULT '0',
  `81` int(1) NOT NULL DEFAULT '0',
  `82` int(1) NOT NULL DEFAULT '0',
  `83` int(1) NOT NULL DEFAULT '0',
  `84` int(1) NOT NULL DEFAULT '0',
  `85` int(1) NOT NULL DEFAULT '0',
  `86` int(1) NOT NULL DEFAULT '0',
  `87` int(1) NOT NULL DEFAULT '0',
  `88` int(1) NOT NULL DEFAULT '0',
  `89` int(1) NOT NULL DEFAULT '0',
  `90` int(1) NOT NULL DEFAULT '0',
  `91` int(1) NOT NULL DEFAULT '0',
  `92` int(1) NOT NULL DEFAULT '0',
  `93` int(1) NOT NULL DEFAULT '0',
  `94` int(1) NOT NULL DEFAULT '0',
  `95` int(1) NOT NULL DEFAULT '0',
  `96` int(1) NOT NULL DEFAULT '0',
  `97` int(1) NOT NULL DEFAULT '0',
  `98` int(1) NOT NULL DEFAULT '0',
  `99` int(1) NOT NULL DEFAULT '0',
  `100` int(1) NOT NULL DEFAULT '0',
  `101` int(1) NOT NULL DEFAULT '0',
  `102` int(1) NOT NULL DEFAULT '0',
  `103` int(1) NOT NULL DEFAULT '0',
  `104` int(1) NOT NULL DEFAULT '0',
  `105` int(1) NOT NULL DEFAULT '0',
  `106` int(1) NOT NULL DEFAULT '0',
  `107` int(1) NOT NULL DEFAULT '0',
  `108` int(1) NOT NULL DEFAULT '0',
  `109` int(1) NOT NULL DEFAULT '0',
  `110` int(1) NOT NULL DEFAULT '0',
  `111` int(1) NOT NULL DEFAULT '0',
  `112` int(1) NOT NULL DEFAULT '0',
  `113` int(1) NOT NULL DEFAULT '0',
  `114` int(1) NOT NULL DEFAULT '0',
  `115` int(1) NOT NULL DEFAULT '0',
  `116` int(1) NOT NULL DEFAULT '0',
  `117` int(1) NOT NULL DEFAULT '0',
  `118` int(1) NOT NULL DEFAULT '0',
  `119` int(1) NOT NULL DEFAULT '0',
  `lim2` int(10) NOT NULL,
  `info` varchar(40) CHARACTER SET utf8 NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;









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







DROP TABLE IF EXISTS `viplati`;

CREATE TABLE `viplati` (
  `id_vip` int(11) NOT NULL AUTO_INCREMENT,
  `id_zver` int(11) NOT NULL,
  `summa` float NOT NULL,
  `purse` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id_vip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `zveri` (
  `id_zver` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(18) CHARACTER SET utf8 NOT NULL,
  `pass` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `mail` varchar(255) CHARACTER SET ucs2 DEFAULT NULL,
  `icq` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `ua` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `ip` varchar(255) NOT NULL,
  `ses` varchar(255) NOT NULL,
  `timeses` int(11) NOT NULL,
  `balans` float NOT NULL,
  `clickS` int(11) NOT NULL,
  `clickV` int(11) NOT NULL,
  `monS` float NOT NULL,
  `monV` float NOT NULL,
  `datreg` datetime NOT NULL,
  `wmr` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `id_parent` int(11) NOT NULL,
  `status` enum('activ','ban') DEFAULT 'activ',
  `type` enum('user','premium','gold') DEFAULT 'user',
  PRIMARY KEY (`id_zver`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
