n0kfHui1

1-- MySQL dump 10.14  Distrib 5.5.56-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost    Database: powerdns
4-- ------------------------------------------------------
5-- Server version       5.5.56-MariaDB
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `comments`
20--
21
22DROP TABLE IF EXISTS `comments`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `comments` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `domain_id` int(11) NOT NULL,
28  `name` varchar(255) NOT NULL,
29  `type` varchar(10) NOT NULL,
30  `modified_at` int(11) NOT NULL,
31  `account` varchar(40) CHARACTER SET utf8 DEFAULT NULL,
32  `comment` text CHARACTER SET utf8 NOT NULL,
33  PRIMARY KEY (`id`),
34  KEY `comments_name_type_idx` (`name`,`type`),
35  KEY `comments_order_idx` (`domain_id`,`modified_at`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `comments`
41--
42
43LOCK TABLES `comments` WRITE;
44/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
45/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `cryptokeys`
50--
51
52DROP TABLE IF EXISTS `cryptokeys`;
53/*!40101 SET @saved_cs_client     = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `cryptokeys` (
56  `id` int(11) NOT NULL AUTO_INCREMENT,
57  `domain_id` int(11) NOT NULL,
58  `flags` int(11) NOT NULL,
59  `active` tinyint(1) DEFAULT NULL,
60  `content` text,
61  PRIMARY KEY (`id`),
62  KEY `domainidindex` (`domain_id`)
63) ENGINE=InnoDB DEFAULT CHARSET=latin1;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `cryptokeys`
68--
69
70LOCK TABLES `cryptokeys` WRITE;
71/*!40000 ALTER TABLE `cryptokeys` DISABLE KEYS */;
72/*!40000 ALTER TABLE `cryptokeys` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `domainmetadata`
77--
78
79DROP TABLE IF EXISTS `domainmetadata`;
80/*!40101 SET @saved_cs_client     = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `domainmetadata` (
83  `id` int(11) NOT NULL AUTO_INCREMENT,
84  `domain_id` int(11) NOT NULL,
85  `kind` varchar(32) DEFAULT NULL,
86  `content` text,
87  PRIMARY KEY (`id`),
88  KEY `domainmetadata_idx` (`domain_id`,`kind`)
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Dumping data for table `domainmetadata`
94--
95
96LOCK TABLES `domainmetadata` WRITE;
97/*!40000 ALTER TABLE `domainmetadata` DISABLE KEYS */;
98/*!40000 ALTER TABLE `domainmetadata` ENABLE KEYS */;
99UNLOCK TABLES;
100
101--
102-- Table structure for table `domains`
103--
104
105DROP TABLE IF EXISTS `domains`;
106/*!40101 SET @saved_cs_client     = @@character_set_client */;
107/*!40101 SET character_set_client = utf8 */;
108CREATE TABLE `domains` (
109  `id` int(11) NOT NULL AUTO_INCREMENT,
110  `name` varchar(255) NOT NULL,
111  `master` varchar(128) DEFAULT NULL,
112  `last_check` int(11) DEFAULT NULL,
113  `type` varchar(6) NOT NULL,
114  `notified_serial` int(10) unsigned DEFAULT NULL,
115  `account` varchar(40) CHARACTER SET utf8 DEFAULT NULL,
116  PRIMARY KEY (`id`),
117  UNIQUE KEY `name_index` (`name`)
118) ENGINE=InnoDB DEFAULT CHARSET=latin1;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `domains`
123--
124
125LOCK TABLES `domains` WRITE;
126/*!40000 ALTER TABLE `domains` DISABLE KEYS */;
127/*!40000 ALTER TABLE `domains` ENABLE KEYS */;
128UNLOCK TABLES;
129
130--
131-- Table structure for table `records`
132--
133
134DROP TABLE IF EXISTS `records`;
135/*!40101 SET @saved_cs_client     = @@character_set_client */;
136/*!40101 SET character_set_client = utf8 */;
137CREATE TABLE `records` (
138  `id` bigint(20) NOT NULL AUTO_INCREMENT,
139  `domain_id` int(11) DEFAULT NULL,
140  `name` varchar(255) DEFAULT NULL,
141  `type` varchar(10) DEFAULT NULL,
142  `content` varchar(64000) DEFAULT NULL,
143  `ttl` int(11) DEFAULT NULL,
144  `prio` int(11) DEFAULT NULL,
145  `change_date` int(11) DEFAULT NULL,
146  `disabled` tinyint(1) DEFAULT '0',
147  `ordername` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
148  `auth` tinyint(1) DEFAULT '1',
149  PRIMARY KEY (`id`),
150  KEY `nametype_index` (`name`,`type`),
151  KEY `domain_id` (`domain_id`),
152  KEY `ordername` (`ordername`)
153) ENGINE=InnoDB DEFAULT CHARSET=latin1;
154/*!40101 SET character_set_client = @saved_cs_client */;
155
156--
157-- Dumping data for table `records`
158--
159
160LOCK TABLES `records` WRITE;
161/*!40000 ALTER TABLE `records` DISABLE KEYS */;
162/*!40000 ALTER TABLE `records` ENABLE KEYS */;
163UNLOCK TABLES;
164
165--
166-- Table structure for table `supermasters`
167--
168
169DROP TABLE IF EXISTS `supermasters`;
170/*!40101 SET @saved_cs_client     = @@character_set_client */;
171/*!40101 SET character_set_client = utf8 */;
172CREATE TABLE `supermasters` (
173  `ip` varchar(64) NOT NULL,
174  `nameserver` varchar(255) NOT NULL,
175  `account` varchar(40) CHARACTER SET utf8 NOT NULL,
176  PRIMARY KEY (`ip`,`nameserver`)
177) ENGINE=InnoDB DEFAULT CHARSET=latin1;
178/*!40101 SET character_set_client = @saved_cs_client */;
179
180--
181-- Dumping data for table `supermasters`
182--
183
184LOCK TABLES `supermasters` WRITE;
185/*!40000 ALTER TABLE `supermasters` DISABLE KEYS */;
186/*!40000 ALTER TABLE `supermasters` ENABLE KEYS */;
187UNLOCK TABLES;
188
189--
190-- Table structure for table `tsigkeys`
191--
192
193DROP TABLE IF EXISTS `tsigkeys`;
194/*!40101 SET @saved_cs_client     = @@character_set_client */;
195/*!40101 SET character_set_client = utf8 */;
196CREATE TABLE `tsigkeys` (
197  `id` int(11) NOT NULL AUTO_INCREMENT,
198  `name` varchar(255) DEFAULT NULL,
199  `algorithm` varchar(50) DEFAULT NULL,
200  `secret` varchar(255) DEFAULT NULL,
201  PRIMARY KEY (`id`),
202  UNIQUE KEY `namealgoindex` (`name`,`algorithm`)
203) ENGINE=InnoDB DEFAULT CHARSET=latin1;
204/*!40101 SET character_set_client = @saved_cs_client */;
205
206--
207-- Dumping data for table `tsigkeys`
208--
209
210LOCK TABLES `tsigkeys` WRITE;
211/*!40000 ALTER TABLE `tsigkeys` DISABLE KEYS */;
212/*!40000 ALTER TABLE `tsigkeys` ENABLE KEYS */;
213UNLOCK TABLES;
214/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
215
216/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
217/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
218/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
219/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
220/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
221/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
222/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
223
224-- Dump completed on 2018-07-16  8:28:17