-- MySQL dump 10.9 -- -- Host: localhost Database: db_nekt_1 -- ------------------------------------------------------ -- Server version 4.1.18-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `param` varchar(16) character set cp1251 NOT NULL default '', `value` varchar(32) character set cp1251 NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `config` -- /*!40000 ALTER TABLE `config` DISABLE KEYS */; LOCK TABLES `config` WRITE; INSERT INTO `config` VALUES ('lupdate','2006-04-13 03:00:02'),('quote','1'),('business','10'),('domains','0.25'),('views','10'),('reach','100'),('speed','1'),('templates','base'),('perlist','3'),('fullimit','5'),('email','test@test.ru'); UNLOCK TABLES; /*!40000 ALTER TABLE `config` ENABLE KEYS */; -- -- Table structure for table `general` -- DROP TABLE IF EXISTS `general`; CREATE TABLE `general` ( `host` varchar(64) NOT NULL default '', `ns` varchar(64) character set latin1 NOT NULL default '', `name` varchar(20) NOT NULL default '', `descr` tinytext NOT NULL, `link` varchar(64) character set latin1 NOT NULL default '', `date` date NOT NULL default '0000-00-00', `status` enum('waiting','active','disable') character set latin1 NOT NULL default 'waiting', `comment` tinytext NOT NULL, PRIMARY KEY (`host`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; -- -- Dumping data for table `general` -- /*!40000 ALTER TABLE `general` DISABLE KEYS */; LOCK TABLES `general` WRITE; INSERT INTO `general` VALUES ('peterhost.ru','ns1.peterhost.ru.','PeterHost','Услуги хостинга oт $4,2 и регистрация доменов в зонах .ru, .com, .org, .net.','peterhost.ru','0000-00-00','active',''),('megahoster.ru','ns1.megahoster.ru.','','','','0000-00-00','active','0'),('valuehost.ru','ns1.valuehost.ru.','Young Munster Rugby','News, club information, team profiles, fixtures, results and photo gallery.','','0000-00-00','active',''),('agava.net.ru','ns1.agava.net.ru.','','','agava.net.ru','0000-00-00','active',''),('masterhost.ru','ns.masterhost.ru.','Masterhost','Профессиональный хостинг. FTP-доступ, CGI, SSI, SSL, WAP, доступ к статистике.','masterhost.ru','0000-00-00','active',''),('zenon.net','','Zenon','Internet service provider offering dial-up connection and ermanent IP-connection, virtual servers support and collocation services. Details and price list.','zenon.net','0000-00-00','active',''),('infobox.org','ns1.infobox.org.','','','infobox.org','2006-03-30','active',''),('holm.ru','ns1.agava.net.ru.','Холм.Ру','Бесплатный хостинг от Agava.ru. PHP, CGI, Perl, MySQL, форумы и гостевые книги.','holm.ru','2006-03-31','waiting','Этот домен не участвует в рейтинге ввиду несоответствия тематике рейтинга.'),('mirohost.net','ns3.imena.com.ua.','MiroHost.net','Web-хостинг в Украине от $5 в месяц. 200 мБ, CGI, Perl, PHP, mySQL, FTP, Telnet, SSH. Регистрация доменов. Colocation.','mirohost.net','2006-03-31','active',''),('sweb.ru','ns1.spaceweb.ru.','SpaceWeb - профессио','Хостинг, регистрация доменов, аренда выделенных серверов.','sweb.ru','2006-04-04','active',''); UNLOCK TABLES; /*!40000 ALTER TABLE `general` ENABLE KEYS */; -- -- Table structure for table `history` -- DROP TABLE IF EXISTS `history`; CREATE TABLE `history` ( `date` date NOT NULL default '0000-00-00', `host` varchar(64) character set cp1251 NOT NULL default '', `place` smallint(5) unsigned NOT NULL default '0', `total` mediumint(8) unsigned NOT NULL default '0', `quote` smallint(5) unsigned NOT NULL default '0', `business` smallint(5) unsigned NOT NULL default '0', `domains` smallint(5) unsigned NOT NULL default '0', `views` float unsigned NOT NULL default '0', `reach` float unsigned NOT NULL default '0', PRIMARY KEY (`date`,`host`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `history` -- /*!40000 ALTER TABLE `history` DISABLE KEYS */; LOCK TABLES `history` WRITE; INSERT INTO `history` VALUES ('0000-00-00','peterhost.ru',3,12668,1900,533,6263,2.2,38.5),('0000-00-00','masterhost.ru',2,23902,2600,484,40680,4.1,64.5),('0000-00-00','megahoster.ru',7,7510,0,719,0,2,3),('2006-03-28','peterhost.ru',2,12554,1900,522,5628,2.7,40),('0000-00-00','valuehost.ru',5,12192,550,0,22824,3.6,59),('2006-03-27','peterhost.ru',2,12554,1900,522,5628,2.7,40),('2006-03-27','masterhost.ru',1,35297,2600,480,37518,1.8,185),('2006-03-27','megahoster.ru',3,7060,0,706,0,0,0),('2006-03-28','masterhost.ru',1,35297,2600,480,37518,1.8,185),('2006-03-28','megahoster.ru',4,7060,0,706,0,0,0),('2006-03-28','valuehost.ru',3,11011,550,0,22300,3.6,48.5),('2006-03-29','peterhost.ru',2,12410,1900,522,6018,3.6,37.5),('2006-03-29','masterhost.ru',1,38743,2600,480,39295,1.9,215),('2006-03-29','megahoster.ru',4,7070,0,707,0,0,0),('2006-03-29','valuehost.ru',3,10908,550,0,22672,4,46.5),('2006-03-30','masterhost.ru',1,39772,2600,480,39404,2.1,225),('0000-00-00','zenon.net',4,9016,0,0,0,1.6,90),('2006-03-30','megahoster.ru',5,7040,0,704,0,0,0),('2006-03-30','peterhost.ru',2,12452,1900,525,6033,4.4,37.5),('2006-03-30','valuehost.ru',3,11263,550,0,22679,4.3,50),('2006-03-30','zenon.net',4,7422,0,0,0,2.2,74),('0000-00-00','infobox.org',9,2000,0,0,8000,0,0),('2006-03-31','infobox.org',6,1962,0,0,7848,0,0),('2006-03-31','masterhost.ru',1,39335,2600,478,39738,2.1,220),('2006-03-31','megahoster.ru',5,7050,0,705,0,0,0),('2006-03-31','peterhost.ru',2,12063,1900,526,6038,4.3,33.5),('2006-03-31','valuehost.ru',3,11608,550,0,22672,4,53.5),('2006-03-31','zenon.net',4,7219,0,0,0,1.9,72),('2006-04-07','sweb.ru',7,5921,1100,0,9559,3.1,24),('0000-00-00','holm.ru',1,43597,23000,0,14319,1.6,180),('0000-00-00','mirohost.net',6,6155,2200,299,0,2.5,9.5),('2006-04-07','megahoster.ru',4,7370,0,716,0,1,2),('2006-04-01','holm.ru',2,39059,23000,0,14140,2.4,125),('2006-04-01','infobox.org',7,1970,0,0,7882,0,0),('2006-04-01','masterhost.ru',1,39396,2600,481,39859,2.1,220),('2006-04-01','megahoster.ru',5,7090,0,709,0,0,0),('2006-04-01','mirohost.net',6,5783,2200,295,0,3.3,6),('2006-04-01','peterhost.ru',2,12067,1900,526,6054,4.3,33.5),('2006-04-01','valuehost.ru',3,11614,550,0,22697,4,53.5),('2006-04-01','zenon.net',4,7219,0,0,0,1.9,72),('2006-04-07','masterhost.ru',1,37911,2600,482,39859,2.6,205),('2006-04-02','holm.ru',1,39057,23000,0,14140,2.2,125),('2006-04-02','infobox.org',7,1970,0,0,7882,0,0),('2006-04-02','masterhost.ru',1,37881,2600,479,39859,2.6,205),('2006-04-02','megahoster.ru',5,7060,0,706,0,0,0),('2006-04-02','mirohost.net',6,5744,2200,294,0,5.4,5.5),('2006-04-02','peterhost.ru',2,12395,1900,524,6054,4.2,37),('2006-04-02','valuehost.ru',3,11120,550,0,22697,4.6,48.5),('2006-04-02','zenon.net',4,7324,0,0,0,2.4,73),('2006-04-03','holm.ru',1,39057,23000,0,14140,2.2,125),('2006-04-03','infobox.org',7,1970,0,0,7882,0,0),('2006-04-03','masterhost.ru',1,37911,2600,482,39859,2.6,205),('2006-04-03','megahoster.ru',5,7100,0,710,0,0,0),('2006-04-03','mirohost.net',6,5764,2200,296,0,5.4,5.5),('2006-04-03','peterhost.ru',2,12435,1900,528,6054,4.2,37),('2006-04-03','valuehost.ru',3,11120,550,0,22697,4.6,48.5),('2006-04-03','zenon.net',4,7324,0,0,0,2.4,73),('2006-04-07','infobox.org',8,1991,0,0,7964,0,0),('2006-04-04','holm.ru',1,39057,23000,0,14140,2.2,125),('2006-04-04','infobox.org',7,1970,0,0,7882,0,0),('2006-04-04','masterhost.ru',1,37911,2600,482,39859,2.6,205),('2006-04-04','megahoster.ru',5,7100,0,710,0,0,0),('2006-04-04','mirohost.net',6,5764,2200,296,0,5.4,5.5),('2006-04-04','peterhost.ru',2,12435,1900,528,6054,4.2,37),('2006-04-04','valuehost.ru',3,11120,550,0,22697,4.6,48.5),('2006-04-04','zenon.net',4,7324,0,0,0,2.4,73),('0000-00-00','sweb.ru',0,7091,1100,0,9634,2.8,35.5),('2006-04-07','holm.ru',1,40095,23000,0,14287,2.3,135),('2006-04-05','holm.ru',1,39057,23000,0,14140,2.2,125),('2006-04-05','infobox.org',7,1970,0,0,7882,0,0),('2006-04-05','masterhost.ru',1,37911,2600,482,39859,2.6,205),('2006-04-05','megahoster.ru',5,7100,0,710,0,0,0),('2006-04-05','mirohost.net',6,5764,2200,296,0,5.4,5.5),('2006-04-05','peterhost.ru',2,12435,1900,528,6054,4.2,37),('2006-04-05','valuehost.ru',3,11120,550,0,22697,4.6,48.5),('2006-04-05','zenon.net',4,7324,0,0,0,2.4,73),('2006-04-06','holm.ru',1,39057,23000,0,14140,2.2,125),('2006-04-06','infobox.org',7,1970,0,0,7882,0,0),('2006-04-06','masterhost.ru',1,37911,2600,482,39859,2.6,205),('2006-04-06','megahoster.ru',5,7100,0,710,0,0,0),('2006-04-06','mirohost.net',6,5764,2200,296,0,5.4,5.5),('2006-04-06','peterhost.ru',2,12435,1900,528,6054,4.2,37),('2006-04-06','valuehost.ru',3,11120,550,0,22697,4.6,48.5),('2006-04-06','zenon.net',4,7324,0,0,0,2.4,73),('2006-04-07','mirohost.net',6,6405,2200,297,0,3.5,12),('2006-04-07','peterhost.ru',2,12435,1900,528,6054,4.2,37),('2006-04-07','valuehost.ru',3,11120,550,0,22697,4.6,48.5),('2006-04-07','zenon.net',5,6871,0,0,0,2.1,68.5),('2006-04-08','peterhost.ru',2,11785,1900,531,6233,1.7,30),('2006-04-08','megahoster.ru',4,7370,0,716,0,1,2),('2006-04-08','valuehost.ru',3,11485,550,0,22797,3.6,52),('2006-04-08','masterhost.ru',1,22837,2600,485,40533,5.4,52),('2006-04-08','zenon.net',5,6871,0,0,0,2.1,68.5),('2006-04-08','infobox.org',8,1991,0,0,7964,0,0),('2006-04-08','holm.ru',1,40095,23000,0,14287,2.3,135),('2006-04-08','mirohost.net',6,6405,2200,297,0,3.5,12),('2006-04-08','sweb.ru',7,5921,1100,0,9559,3.1,24),('2006-04-09','peterhost.ru',2,11765,1900,529,6233,1.7,30),('2006-04-09','megahoster.ru',4,7370,0,716,0,1,2),('2006-04-09','valuehost.ru',3,11485,550,0,22797,3.6,52),('2006-04-09','masterhost.ru',1,22837,2600,485,40533,5.4,52),('2006-04-09','zenon.net',5,6871,0,0,0,2.1,68.5),('2006-04-09','infobox.org',8,1991,0,0,7964,0,0),('2006-04-09','holm.ru',1,40095,23000,0,14287,2.3,135),('2006-04-09','mirohost.net',6,6405,2200,297,0,3.5,12),('2006-04-09','sweb.ru',7,5921,1100,0,9559,3.1,24),('2006-04-10','peterhost.ru',3,11815,1900,529,6223,1.9,30.5),('2006-04-10','megahoster.ru',5,7380,0,717,0,1,2),('2006-04-10','valuehost.ru',2,11995,550,0,22808,4.3,57),('2006-04-10','masterhost.ru',1,22995,2600,485,40578,5.1,53.5),('2006-04-10','zenon.net',4,8020,0,0,0,2,80),('2006-04-10','infobox.org',8,1989,0,0,7955,0,0),('2006-04-10','holm.ru',1,41590,23000,0,14273,2.2,150),('2006-04-10','mirohost.net',6,6395,2200,296,0,3.5,12),('2006-04-10','sweb.ru',7,6365,1100,0,9547,2.8,28.5),('2006-04-11','peterhost.ru',2,12596,1900,532,6220,2.1,38),('2006-04-11','megahoster.ru',5,7460,0,714,0,2,3),('2006-04-11','valuehost.ru',3,12094,550,0,22826,3.8,58),('2006-04-11','masterhost.ru',1,23456,2600,486,40566,5.5,58),('2006-04-11','zenon.net',4,8520,0,0,0,2,85),('2006-04-11','infobox.org',8,1988,0,0,7952,0,0),('2006-04-11','holm.ru',1,41586,23000,0,14271,1.8,150),('2006-04-11','mirohost.net',7,6592,2200,296,0,3.2,14),('2006-04-11','sweb.ru',6,6616,1100,0,9544,3,31),('2006-04-12','holm.ru',1,42597,23000,0,14318,1.7,160),('2006-04-12','infobox.org',8,1989,0,0,7957,0,0),('2006-04-12','masterhost.ru',1,23850,2600,486,40592,4.2,62),('2006-04-12','megahoster.ru',5,7460,0,714,0,2,3),('2006-04-12','mirohost.net',7,6612,2200,298,0,3.2,14),('2006-04-12','peterhost.ru',2,12652,1900,532,6245,2.1,38.5),('2006-04-12','sweb.ru',6,6829,1100,0,9584,3.3,33),('2006-04-12','valuehost.ru',3,11895,550,0,22824,3.9,56),('2006-04-12','zenon.net',4,9016,0,0,0,1.6,90),('2006-04-13','holm.ru',1,43597,23000,0,14319,1.7,170),('2006-04-13','infobox.org',9,2000,0,0,8000,0,0),('2006-04-13','masterhost.ru',2,23902,2600,484,40680,4.2,62.5),('2006-04-13','megahoster.ru',7,7510,0,719,0,2,3),('2006-04-13','mirohost.net',6,6155,2200,298,0,2.5,9.5),('2006-04-13','peterhost.ru',3,12668,1900,533,6263,2.2,38.5),('2006-04-13','sweb.ru',0,7091,1100,0,9634,3.3,35.5),('2006-04-13','valuehost.ru',5,12192,550,0,22824,3.6,59),('2006-04-13','zenon.net',4,9016,0,0,0,1.6,90); UNLOCK TABLES; /*!40000 ALTER TABLE `history` ENABLE KEYS */; -- -- Table structure for table `list` -- DROP TABLE IF EXISTS `list`; CREATE TABLE `list` ( `host` varchar(64) character set cp1251 NOT NULL default '', `place` smallint(5) unsigned NOT NULL default '0', `dplace` smallint(6) NOT NULL default '0', `total` mediumint(8) unsigned NOT NULL default '0', `dtotal` mediumint(9) NOT NULL default '0', `quote` smallint(5) unsigned NOT NULL default '0', `dquote` smallint(6) NOT NULL default '0', `business` smallint(5) unsigned NOT NULL default '0', `dbusiness` smallint(6) NOT NULL default '0', `domains` smallint(5) unsigned NOT NULL default '0', `ddomains` smallint(6) NOT NULL default '0', `views` float unsigned NOT NULL default '0', `dviews` float NOT NULL default '0', `reach` float unsigned NOT NULL default '0', `dreach` float NOT NULL default '0', PRIMARY KEY (`host`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `list` -- /*!40000 ALTER TABLE `list` DISABLE KEYS */; LOCK TABLES `list` WRITE; INSERT INTO `list` VALUES ('masterhost.ru',1,0,23850,394,2600,0,486,0,40592,26,4.2,-1.3,62,4),('peterhost.ru',2,0,12652,56,1900,0,532,0,6245,25,2.1,0,38.5,0.5),('valuehost.ru',3,0,11895,-199,550,0,0,0,22824,-2,3.9,0.1,56,-2),('zenon.net',4,0,9016,496,0,0,0,0,0,0,1.6,-0.4,90,5),('megahoster.ru',5,0,7460,0,0,0,714,0,0,0,2,0,3,0),('sweb.ru',6,0,6829,213,1100,0,0,0,9584,40,3.3,0.3,33,2),('mirohost.net',7,0,6612,20,2200,0,298,2,0,0,3.2,0,14,0),('infobox.org',8,0,1989,1,0,0,0,0,7957,5,0,0,0,0); UNLOCK TABLES; /*!40000 ALTER TABLE `list` ENABLE KEYS */; -- -- Table structure for table `todo` -- DROP TABLE IF EXISTS `todo`; CREATE TABLE `todo` ( `host` varchar(64) character set cp1251 NOT NULL default '', `param` enum('quote','business','domains','alexa','image') NOT NULL default 'quote', `tryes` tinyint(3) unsigned NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `host` (`host`,`param`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `todo` -- /*!40000 ALTER TABLE `todo` DISABLE KEYS */; LOCK TABLES `todo` WRITE; INSERT INTO `todo` VALUES ('peterhost.ru','quote',1,'2006-04-05 14:48:00'),('peterhost.ru','business',0,'2006-04-12 03:41:01'),('peterhost.ru','domains',0,'2006-04-12 07:08:01'),('peterhost.ru','alexa',0,'2006-04-12 03:43:02'),('megahoster.ru','quote',0,'0000-00-00 00:00:00'),('megahoster.ru','business',0,'2006-04-12 03:40:01'),('megahoster.ru','domains',0,'0000-00-00 00:00:00'),('megahoster.ru','alexa',0,'2006-04-11 03:45:04'),('valuehost.ru','quote',0,'2006-04-05 15:28:01'),('valuehost.ru','business',1,'0000-00-00 00:00:00'),('valuehost.ru','domains',0,'2006-04-12 07:07:01'),('valuehost.ru','alexa',0,'2006-04-12 03:32:03'),('masterhost.ru','quote',1,'2006-04-05 17:12:01'),('masterhost.ru','business',0,'2006-04-12 03:38:01'),('masterhost.ru','domains',1,'2006-04-12 07:01:02'),('masterhost.ru','alexa',1,'2006-04-13 03:47:05'),('infobox.org','business',1,'0000-00-00 00:00:00'),('infobox.org','quote',1,'0000-00-00 00:00:00'),('zenon.net','quote',1,'0000-00-00 00:00:00'),('zenon.net','business',1,'0000-00-00 00:00:00'),('zenon.net','domains',1,'0000-00-00 00:00:00'),('zenon.net','alexa',0,'2006-04-12 03:36:03'),('masterhost.ru','image',0,'2006-04-12 03:26:03'),('infobox.org','image',1,'2006-04-13 03:57:01'),('holm.ru','image',1,'2006-04-13 03:48:02'),('agava.net.ru','image',1,'2006-04-13 03:46:02'),('infobox.org','alexa',1,'0000-00-00 00:00:00'),('infobox.org','domains',1,'2006-04-12 07:06:01'),('sweb.ru','image',1,'2006-04-13 03:52:03'),('peterhost.ru','image',1,'2006-04-13 03:43:07'),('mirohost.net','image',1,'2006-04-13 03:51:01'),('megahoster.ru','image',1,'2006-04-13 03:50:03'),('holm.ru','quote',1,'2006-04-05 16:00:02'),('holm.ru','business',1,'0000-00-00 00:00:00'),('holm.ru','domains',1,'2006-04-12 07:23:02'),('holm.ru','alexa',1,'2006-04-13 03:35:08'),('mirohost.net','quote',1,'2006-04-05 15:44:01'),('mirohost.net','business',1,'2006-04-13 03:33:05'),('mirohost.net','domains',1,'0000-00-00 00:00:00'),('mirohost.net','alexa',1,'2006-04-13 03:31:08'),('sweb.ru','quote',1,'2006-04-05 15:08:00'),('sweb.ru','business',1,'0000-00-00 00:00:00'),('sweb.ru','domains',1,'2006-04-12 07:15:02'),('sweb.ru','alexa',1,'2006-04-13 03:03:06'),('valuehost.ru','image',1,'2006-04-13 03:01:01'),('zenon.net','image',1,'2006-04-13 03:02:02'); UNLOCK TABLES; /*!40000 ALTER TABLE `todo` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;