| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181 |
- -- phpMyAdmin SQL Dump
- -- version 4.2.4
- -- http://www.phpmyadmin.net
- --
- -- Хост: localhost:3306
- -- Время создания: Апр 20 2015 г., 05:04
- -- Версия сервера: 5.6.19
- -- Версия PHP: 5.4.29
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!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 */;
- --
- -- База данных: `pwhoisd`
- --
- -- --------------------------------------------------------
- --
- -- Структура таблицы `contact_pir`
- --
- CREATE TABLE IF NOT EXISTS `contact_pir` (
- `ID` varchar(64) NOT NULL,
- `Name` varchar(2048) NOT NULL,
- `Organization` varchar(2048) NOT NULL,
- `Street` text NOT NULL,
- `City` varchar(2048) NOT NULL,
- `StateProvince` varchar(2048) NOT NULL,
- `PostalCode` varchar(256) NOT NULL,
- `Country` varchar(256) NOT NULL,
- `Phone` varchar(256) NOT NULL,
- `PhoneExt` varchar(256) NOT NULL,
- `Fax` varchar(256) NOT NULL,
- `FaxExt` varchar(256) NOT NULL,
- `Email` varchar(256) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Дамп данных таблицы `contact_pir`
- --
- INSERT INTO `contact_pir` (`ID`, `Name`, `Organization`, `Street`, `City`, `StateProvince`, `PostalCode`, `Country`, `Phone`, `PhoneExt`, `Fax`, `FaxExt`, `Email`) VALUES
- ('DI_10634473', 'Domain Coordination Centre', 'OOO Informacionnye Seti', '1a Pugacheva St.\r\nNOTE: For spam or abuse issues\r\nNOTE: send requests to abuse@hsdn.org', 'Saratov', 'Saratovskaya oblast', '410004', 'RU', '+7.8452220456', '', '', '', 'domains@hsdn.org'),
- ('GODA-02131674', 'Registration Private', 'Domains By Proxy, LLC', ' DomainsByProxy.com\r\n 14747 N Northsight Blvd Suite 111, PMB 309', 'Scottsdale', 'Arizona', '85260', 'US', '+1.4806242599', '', ' +1.4806242598', '', 'PIR.ORG@domainsbyproxy.com');
- -- --------------------------------------------------------
- --
- -- Структура таблицы `domain_pir`
- --
- CREATE TABLE IF NOT EXISTS `domain_pir` (
- `DomainName` varchar(256) NOT NULL,
- `DomainID` varchar(64) NOT NULL,
- `CreationDate` timestamp NULL DEFAULT NULL,
- `UpdatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `RegistryExpiryDate` timestamp NULL DEFAULT NULL,
- `TrademarkName` varchar(256) DEFAULT NULL,
- `TrademarkDate` varchar(256) DEFAULT NULL,
- `TrademarkCountry` varchar(256) DEFAULT NULL,
- `TrademarkNumber` varchar(256) DEFAULT NULL,
- `SponsoringRegistrar` varchar(256) NOT NULL,
- `SponsoringRegistrarIANAID` varchar(256) NOT NULL,
- `WHOISServer` varchar(256) NOT NULL,
- `ReferralURL` varchar(256) NOT NULL,
- `DomainStatus` text NOT NULL,
- `RegistrantID` varchar(256) DEFAULT NULL,
- `AdminID` varchar(256) DEFAULT NULL,
- `TechID` varchar(256) DEFAULT NULL,
- `BillingID` varchar(256) DEFAULT NULL,
- `NameServer1` varchar(256) NOT NULL,
- `NameServer2` varchar(256) NOT NULL,
- `NameServer3` varchar(256) NOT NULL,
- `NameServer4` varchar(256) NOT NULL,
- `NameServer5` varchar(256) NOT NULL,
- `NameServer6` varchar(256) NOT NULL,
- `NameServer7` varchar(256) NOT NULL,
- `NameServer8` varchar(256) NOT NULL,
- `NameServer9` varchar(256) NOT NULL,
- `NameServer10` varchar(256) NOT NULL,
- `NameServer11` varchar(256) NOT NULL,
- `NameServer12` varchar(256) NOT NULL,
- `NameServer13` varchar(256) NOT NULL,
- `DNSSEC` varchar(256) NOT NULL DEFAULT 'Unsigned',
- `DSCreated1` timestamp NULL DEFAULT NULL,
- `DSKeyTag1` varchar(256) DEFAULT NULL,
- `Algorithm1` varchar(256) DEFAULT NULL,
- `DigestType1` varchar(256) DEFAULT NULL,
- `Digest1` varchar(256) DEFAULT NULL,
- `DSMaximumSignatureLife1` varchar(256) DEFAULT NULL,
- `DSCreated2` timestamp NULL DEFAULT NULL,
- `DSKeyTag2` varchar(256) DEFAULT NULL,
- `Algorithm2` varchar(256) DEFAULT NULL,
- `DigestType2` varchar(256) DEFAULT NULL,
- `Digest2` varchar(256) DEFAULT NULL,
- `DSMaximumSignatureLife2` varchar(256) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Дамп данных таблицы `domain_pir`
- --
- INSERT INTO `domain_pir` (`DomainName`, `DomainID`, `CreationDate`, `UpdatedDate`, `RegistryExpiryDate`, `TrademarkName`, `TrademarkDate`, `TrademarkCountry`, `TrademarkNumber`, `SponsoringRegistrar`, `SponsoringRegistrarIANAID`, `WHOISServer`, `ReferralURL`, `DomainStatus`, `RegistrantID`, `AdminID`, `TechID`, `BillingID`, `NameServer1`, `NameServer2`, `NameServer3`, `NameServer4`, `NameServer5`, `NameServer6`, `NameServer7`, `NameServer8`, `NameServer9`, `NameServer10`, `NameServer11`, `NameServer12`, `NameServer13`, `DNSSEC`, `DSCreated1`, `DSKeyTag1`, `Algorithm1`, `DigestType1`, `Digest1`, `DSMaximumSignatureLife1`, `DSCreated2`, `DSKeyTag2`, `Algorithm2`, `DigestType2`, `Digest2`, `DSMaximumSignatureLife2`) VALUES
- ('HSDN.ORG', 'D119032872-LROR', '2006-03-23 10:21:15', '2015-03-11 20:07:03', '2016-03-23 10:21:15', NULL, NULL, NULL, NULL, 'PDR Ltd. d/b/a PublicDomainRegistry.com (R27-LROR)', '303', '', '', 'ok -- http://www.icann.org/epp#ok', 'DI_10634473', 'DI_10634473', 'DI_10634473', NULL, 'NS1.HSDN.ORG', 'NS2.HSDN.ORG', 'NS3.HSDN.ORG', 'NS4.HSDN.ORG', '', '', '', '', '', '', '', '', '', 'Unsigned', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
- ('PIR.ORG', 'D96207-LROR', '1996-02-18 02:00:00', '2015-02-19 22:41:55', '2016-02-19 02:00:00', NULL, NULL, NULL, NULL, 'GoDaddy.com, LLC (R91-LROR)', '146', '', '', 'serverDeleteProhibited -- http://www.icann.org/epp#serverDeleteProhibited\r\nserverTransferProhibited -- http://www.icann.org/epp#serverTransferProhibited\r\nserverUpdateProhibited -- http://www.icann.org/epp#serverUpdateProhibited', 'GODA-02131674', 'GODA-02131674', 'GODA-02131674', NULL, 'NS1.AMS1.AFILIAS-NST.INFO', 'NS1.MIA1.AFILIAS-NST.INFO', 'NS1.SEA1.AFILIAS-NST.INFO', 'NS1.YYZ1.AFILIAS-NST.INFO', '', '', '', '', '', '', '', '', '', 'signedDelegation', '2010-03-26 13:52:50', '54135', '5', '1', '225F055ACB65C8B60AD18B3640062E8C23A5FD89', '1814400 seconds', NULL, NULL, NULL, NULL, NULL, NULL);
- -- --------------------------------------------------------
- --
- -- Структура таблицы `domain_ripn`
- --
- CREATE TABLE IF NOT EXISTS `domain_ripn` (
- `id` int(11) NOT NULL,
- `domain` varchar(256) NOT NULL,
- `nserver1` varchar(256) NOT NULL,
- `nserver2` varchar(256) NOT NULL,
- `nserver3` varchar(256) NOT NULL,
- `nserver4` varchar(256) NOT NULL,
- `state` varchar(256) NOT NULL,
- `person` varchar(256) NOT NULL DEFAULT 'Private person',
- `org` varchar(256) NOT NULL,
- `registrar` varchar(256) NOT NULL,
- `admin_contact` varchar(256) NOT NULL,
- `descr` text NOT NULL,
- `created` timestamp NOT NULL DEFAULT 0,
- `paid_till` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `free_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `source` varchar(256) NOT NULL,
- `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
- --
- -- Дамп данных таблицы `domain_ripn`
- --
- INSERT INTO `domain_ripn` (`id`, `domain`, `nserver1`, `nserver2`, `nserver3`, `nserver4`, `state`, `person`, `org`, `registrar`, `admin_contact`, `descr`, `created`, `paid_till`, `free_date`, `source`, `updated`) VALUES
- (1, 'YA.RU', 'ns1.yandex.ru.', 'ns2.yandex.ru.', '', '', 'REGISTERED, DELEGATED, VERIFIED', '', 'YANDEX, LLC.', 'RU-CENTER-RU', 'https://www.nic.ru/whois', '', '1999-07-11 20:00:00', '2015-04-15 04:36:24', '2015-04-15 04:36:24', 'RIPN', '2015-04-20 02:00:50'),
- (2, 'HSDN.RU', 'ns1.hsdn.org.', 'ns2.hsdn.org.', 'ns3.hsdn.org.', 'ns4.hsdn.org.', 'REGISTERED, DELEGATED, VERIFIED', '', 'OOO "Informacionnye Seti"', 'NAUNET-RU', 'domains@hsdn.org', 'NOTE: For spam or abuse issues\r\nNOTE: send requests to abuse@hsdn.org', '2009-02-04 21:00:00', '2016-02-04 21:00:00', '2016-03-06 21:00:00', 'TCI', '2015-04-20 02:01:51');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `contact_pir`
- --
- ALTER TABLE `contact_pir`
- ADD PRIMARY KEY (`ID`);
- --
- -- Indexes for table `domain_pir`
- --
- ALTER TABLE `domain_pir`
- ADD PRIMARY KEY (`DomainID`), ADD KEY `DomainName` (`DomainName`(255));
- --
- -- Indexes for table `domain_ripn`
- --
- ALTER TABLE `domain_ripn`
- ADD PRIMARY KEY (`id`), ADD KEY `updated` (`updated`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `domain_ripn`
- --
- ALTER TABLE `domain_ripn`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
- /*!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 */;
|