View file katsql.sql

File size: 15.21Kb
DROP TABLE IF EXISTS `inet_ban`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_ban` (
  `id` int(10) NOT NULL auto_increment,
  `url` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_ban`
--

LOCK TABLES `inet_ban` WRITE;
/*!40000 ALTER TABLE `inet_ban` DISABLE KEYS */;
/*!40000 ALTER TABLE `inet_ban` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_category`
--

DROP TABLE IF EXISTS `inet_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_category` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `position` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_category`
--

LOCK TABLES `inet_category` WRITE;
/*!40000 ALTER TABLE `inet_category` DISABLE KEYS */;
INSERT INTO `inet_category` (`id`, `name`, `position`) VALUES (1,'Загрузки',1),(2,'Для взрослых',2),(3,'Халява',3),(4,'Общение',4),(5,'Сервисы',5),(6,'Порталы',6),(7,'Развлечения',7),(8,'Вап мастеру',8),(9,'Бизнес',9),(10,'Прочее',10);
/*!40000 ALTER TABLE `inet_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_config`
--

DROP TABLE IF EXISTS `inet_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_config` (
  `id` int(11) NOT NULL auto_increment,
  `lday` varchar(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_config`
--

LOCK TABLES `inet_config` WRITE;
/*!40000 ALTER TABLE `inet_config` DISABLE KEYS */;
INSERT INTO `inet_config` (`id`, `lday`) VALUES (1,'03');
/*!40000 ALTER TABLE `inet_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_diapozon`
--

DROP TABLE IF EXISTS `inet_diapozon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_diapozon` (
  `id` int(11) NOT NULL auto_increment,
  `operator` int(11) NOT NULL,
  `start` bigint(20) NOT NULL default '0',
  `finish` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_diapozon`
--

LOCK TABLES `inet_diapozon` WRITE;
/*!40000 ALTER TABLE `inet_diapozon` DISABLE KEYS */;
INSERT INTO `inet_diapozon` (`id`, `operator`, `start`, `finish`) VALUES (1,1,3274702592,3274702847),(2,2,1333559296,1333592063),(3,2,3560611840,3560612095),(4,2,3560613888,3560615935),(5,2,3560615936,3560620031),(6,2,3560612352,3560612863),(7,2,1333559296,1333575679),(8,2,1536278528,1536294911),(9,3,3582431104,3582434943),(10,4,1295286272,1295288319),(11,4,1358905344,1358905471),(12,4,1490444288,1490452479),(13,4,1490436096,1490444287),(14,4,1295288320,1295290367),(15,5,3588472832,3588489215),(16,5,3253698560,3253699071),(17,6,3588519936,3588520447),(18,6,1360163840,1360164351),(19,6,1360162816,1360166911),(20,6,1347599104,1347599359),(21,7,3273026560,3273027583),(22,7,1385632000,1385632255),(23,8,3648409600,3648410623),(24,8,3648408576,3648409599),(25,8,3648405504,3648406527),(26,8,3648411648,3648412671),(27,8,1505550336,1505551359),(28,8,1406984192,1406985215),(29,8,1433657344,1433657599),(30,8,3648412672,3648413695),(31,8,3648410624,3648411647),(32,9,1427948288,1427948543),(33,10,1388849152,1388850175),(34,11,1296711680,1296711935),(35,11,3557661440,3557661695),(36,12,3240705024,3240706047),(37,12,1360467968,1360470015),(38,12,1360465920,1360467967),(39,13,1402275840,1402276863),(40,13,1402278912,1402279935),(41,13,1402286080,1402287103),(42,13,1402273792,1402275839),(43,13,1346621440,1346622463),(44,13,3251233792,3251234815),(45,13,1402276115,1402276863),(46,13,1402284032,1402285055),(47,13,1402281984,1402283007),(48,13,1402287104,1402288127),(49,13,1402279936,1402280959),(50,13,1402277888,1402278911),(51,14,3650368512,3650368767),(52,15,1410459648,1410460159),(53,15,3641237504,3641241599),(54,15,3276428288,3276428543),(55,15,3258356736,3258357759),(56,15,3562834880,3562834943),(57,15,3579259392,3579265535),(58,15,1347674112,1347678207),(59,15,3579267072,3579267935),(60,15,1358906880,1358907135),(61,15,1476194816,1476195071),(62,15,1372794624,1372794879),(63,15,3642047744,3642047999),(64,15,3287259392,3287259647),(65,15,3579269120,3579273215),(66,15,3277188608,3277188863),(67,15,3645018112,3645019135),(68,15,1347126528,1347127167),(69,15,3281465344,3281465599),(70,15,1360933376,1360933887),(71,15,3647698432,3647698687),(72,15,3267023360,3267023488),(73,15,3645566976,3645569023),(74,15,1535627776,1535628031),(75,15,1410457600,1410459647),(76,15,1433788416,1433788671),(77,16,1389383040,1389383167),(78,17,1358122240,1358123007),(79,17,1358118912,1358119423),(80,18,1438682304,1438682335),(81,19,1509752832,1509756927),(82,19,3565250560,3565254655),(83,19,1536507904,1536516095),(84,19,1536516096,1536518143),(85,19,3578853376,3578854079),(86,19,1406738432,1406739967),(87,20,3266342656,3266342911),(88,21,1346736128,1346737151),(89,21,3260286336,3260286463),(90,21,1310210048,1310211071),(91,22,1509527552,1509528575),(92,23,1506762752,1506764799),(93,23,1506762752,1506763007),(94,23,1506763520,1506763647),(95,24,3580231936,3580232191),(96,24,1404203008,1404211199),(97,24,1404215296,1404219391),(98,24,1404874752,1404875775),(99,24,1404189184,1404189695),(100,24,1404829696,1404837887),(101,24,3580236800,3580237567),(102,24,3580235264,3580235775),(103,24,1518927872,1518944255),(104,24,1404837888,1404846079),(105,24,3580214272,3580214783),(106,24,1404227584,1404232191),(107,24,3580232448,3580233215),(108,24,3580239360,3580239871),(109,24,3580231680,3580231935),(110,25,1441366016,1441371903),(111,25,1401450496,1401450751),(112,25,1506570240,1506574335),(113,25,3571187712,3571191807),(114,25,3564676832,3564676863),(115,25,1494507776,1494508031),(116,25,3641816064,3641816319),(117,26,3651755008,3651756031);
/*!40000 ALTER TABLE `inet_diapozon` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_feedback`
--

DROP TABLE IF EXISTS `inet_feedback`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_feedback` (
  `id` int(11) NOT NULL auto_increment,
  `ot` int(11) default NULL,
  `komu` int(11) default NULL,
  `mes` text NOT NULL,
  `sdate` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_feedback`
--

LOCK TABLES `inet_feedback` WRITE;
/*!40000 ALTER TABLE `inet_feedback` DISABLE KEYS */;
/*!40000 ALTER TABLE `inet_feedback` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_in`
--

DROP TABLE IF EXISTS `inet_in`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_in` (
  `id` int(11) NOT NULL auto_increment,
  `id_site` int(11) NOT NULL,
  `date` date NOT NULL,
  `operator` int(11) NOT NULL default '0',
  `mobil` int(11) NOT NULL default '0',
  `agent` varchar(50) NOT NULL,
  `ip` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id_site` (`id_site`,`date`),
  KEY `operator` (`operator`,`mobil`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_in`
--

LOCK TABLES `inet_in` WRITE;
/*!40000 ALTER TABLE `inet_in` DISABLE KEYS */;
/*!40000 ALTER TABLE `inet_in` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_ip`
--

DROP TABLE IF EXISTS `inet_ip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_ip` (
  `id_site` int(11) NOT NULL,
  `ip` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_ip`
--

LOCK TABLES `inet_ip` WRITE;
/*!40000 ALTER TABLE `inet_ip` DISABLE KEYS */;
/*!40000 ALTER TABLE `inet_ip` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_mobil`
--

DROP TABLE IF EXISTS `inet_mobil`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_mobil` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_mobil`
--

LOCK TABLES `inet_mobil` WRITE;
/*!40000 ALTER TABLE `inet_mobil` DISABLE KEYS */;
INSERT INTO `inet_mobil` (`id`, `name`) VALUES (1,'Ericsson'),(2,'SonyEricsson'),(3,'Nokia'),(4,'Samsung'),(5,'Siemens'),(6,'Motorola'),(7,'LG'),(8,'Sharp'),(9,'Alcatel'),(10,'Panasonic'),(11,'Sagem'),(12,'Pantech'),(13,'NEC'),(14,'BenQ'),(15,'Opera Mini');
/*!40000 ALTER TABLE `inet_mobil` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_news`
--

DROP TABLE IF EXISTS `inet_news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_news` (
  `id` int(10) NOT NULL auto_increment,
  `date` datetime NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_news`
--

LOCK TABLES `inet_news` WRITE;
/*!40000 ALTER TABLE `inet_news` DISABLE KEYS */;
/*!40000 ALTER TABLE `inet_news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_online`
--

DROP TABLE IF EXISTS `inet_online`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_online` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(50) character set cp1251 NOT NULL,
  `ua` varchar(50) character set cp1251 NOT NULL,
  `lastdate` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_online`
--

LOCK TABLES `inet_online` WRITE;
/*!40000 ALTER TABLE `inet_online` DISABLE KEYS */;
INSERT INTO `inet_online` (`id`, `ip`, `ua`, `lastdate`) VALUES (1,'78.46.111.100','Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1;','2010-12-03 15:19:56');
/*!40000 ALTER TABLE `inet_online` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_operator`
--

DROP TABLE IF EXISTS `inet_operator`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_operator` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_operator`
--

LOCK TABLES `inet_operator` WRITE;
/*!40000 ALTER TABLE `inet_operator` DISABLE KEYS */;
INSERT INTO `inet_operator` (`id`, `name`) VALUES (1,'K\'cel'),(2,'life:)'),(3,'TambovGSM'),(4,'UMC'),(5,'WellCOM GSM'),(6,'Байкалвестком'),(7,'БашСЕЛ'),(8,'ВымпелКом'),(9,'Дальсвязь'),(10,'ИНДИГО'),(11,'КаР-Тел'),(12,'Киевстар'),(13,'МегаФон'),(14,'МОТИВ'),(15,'МТС'),(16,'Нижегородская сотовая связь (НСС)'),(17,'НТК'),(18,'Оренбург-GSM'),(19,'Скай Линк'),(20,'Скай Мобайл'),(21,'СМАРТС'),(22,'СТеК Джи Эс Эм'),(23,'ТАТИНКОМ-Т'),(24,'Теле2'),(25,'Уралсвязьинформ'),(26,'Цифровая экспансия');
/*!40000 ALTER TABLE `inet_operator` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_out`
--

DROP TABLE IF EXISTS `inet_out`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_out` (
  `id` int(11) NOT NULL auto_increment,
  `id_site` int(11) NOT NULL,
  `date` date NOT NULL,
  `operator` int(11) NOT NULL,
  `mobil` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id_site` (`id_site`,`date`,`operator`,`mobil`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_out`
--

LOCK TABLES `inet_out` WRITE;
/*!40000 ALTER TABLE `inet_out` DISABLE KEYS */;
/*!40000 ALTER TABLE `inet_out` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_payreq`
--

DROP TABLE IF EXISTS `inet_payreq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_payreq` (
  `id` int(11) NOT NULL auto_increment,
  `id_site` int(11) NOT NULL,
  `cost` float NOT NULL,
  `refcost` float NOT NULL default '0',
  `st` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_payreq`
--

LOCK TABLES `inet_payreq` WRITE;
/*!40000 ALTER TABLE `inet_payreq` DISABLE KEYS */;
/*!40000 ALTER TABLE `inet_payreq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_resultat`
--

DROP TABLE IF EXISTS `inet_resultat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_resultat` (
  `id` int(11) NOT NULL,
  `res` text NOT NULL,
  `coment` text NOT NULL,
  `sss` text NOT NULL,
  `ddd` text NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_resultat`
--

LOCK TABLES `inet_resultat` WRITE;
/*!40000 ALTER TABLE `inet_resultat` DISABLE KEYS */;
/*!40000 ALTER TABLE `inet_resultat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inet_sites`
--

DROP TABLE IF EXISTS `inet_sites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inet_sites` (
  `id` int(10) NOT NULL auto_increment,
  `pass` varchar(50) NOT NULL default '',
  `url` varchar(100) default NULL,
  `name` varchar(100) default NULL,
  `opis` text NOT NULL,
  `icq` text NOT NULL,
  `mob` text NOT NULL,
  `opss` text NOT NULL,
  `mail` varchar(100) default NULL,
  `img` varchar(100) NOT NULL,
  `category` int(10) NOT NULL default '0',
  `in` int(10) NOT NULL default '0',
  `out` int(10) NOT NULL default '0',
  `all_in` varchar(10) NOT NULL default '0',
  `all_out` varchar(10) NOT NULL default '0',
  `wm` varchar(50) default NULL,
  `pay` float NOT NULL default '0',
  `refpay` float NOT NULL default '0',
  `refid` int(11) default NULL,
  `resultat` varchar(4) NOT NULL default 'off',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inet_sites`