· 7 years ago · Oct 25, 2018, 01:56 PM
1-- MySQL dump 10.14 Distrib 5.5.60-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: powerdns
4-- ------------------------------------------------------
5-- Server version 5.5.60-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 AUTO_INCREMENT=25 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 */;
127INSERT INTO `domains` VALUES (1,'mario200.ie',NULL,NULL,'NATIVE',NULL,NULL),(2,'mario201.ie',NULL,NULL,'NATIVE',NULL,NULL),(3,'mario108.ie',NULL,NULL,'NATIVE',NULL,NULL),(4,'mario109.ie',NULL,NULL,'NATIVE',NULL,NULL),(5,'navyaa5.ie',NULL,NULL,'NATIVE',NULL,NULL),(6,'navyaa6.ie',NULL,NULL,'NATIVE',NULL,NULL),(7,'navyaa7.ie',NULL,NULL,'NATIVE',NULL,NULL),(8,'navyaa8.ie',NULL,NULL,'NATIVE',NULL,NULL),(9,'navyaa9.ie',NULL,NULL,'NATIVE',NULL,NULL),(10,'navyaa10.ie',NULL,NULL,'NATIVE',NULL,NULL),(11,'navyaa11.ie',NULL,NULL,'NATIVE',NULL,NULL),(12,'navyaa12.ie',NULL,NULL,'NATIVE',NULL,NULL),(13,'navyaa13.ie',NULL,NULL,'NATIVE',NULL,NULL),(14,'navyaa14.ie',NULL,NULL,'NATIVE',NULL,NULL),(15,'navyaa15.ie',NULL,NULL,'NATIVE',NULL,NULL),(16,'navyaa16.ie',NULL,NULL,'NATIVE',NULL,NULL),(17,'navyaa17.ie',NULL,NULL,'NATIVE',NULL,NULL),(18,'navyaa18.ie',NULL,NULL,'NATIVE',NULL,NULL),(19,'navyaa19.ie',NULL,NULL,'NATIVE',NULL,NULL),(20,'navyaa20.ie',NULL,NULL,'NATIVE',NULL,NULL),(21,'iedr.ie',NULL,NULL,'NATIVE',NULL,NULL),(22,'mario.ie',NULL,NULL,'NATIVE',NULL,NULL),(23,'example0005.ie',NULL,NULL,'NATIVE',NULL,NULL),(24,'xn--0-ufa491h.ie',NULL,NULL,'NATIVE',NULL,NULL);
128/*!40000 ALTER TABLE `domains` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `records`
133--
134
135DROP TABLE IF EXISTS `records`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `records` (
139 `id` bigint(20) NOT NULL AUTO_INCREMENT,
140 `domain_id` int(11) DEFAULT NULL,
141 `name` varchar(255) DEFAULT NULL,
142 `type` varchar(10) DEFAULT NULL,
143 `content` varchar(64000) DEFAULT NULL,
144 `ttl` int(11) DEFAULT NULL,
145 `prio` int(11) DEFAULT NULL,
146 `change_date` int(11) DEFAULT NULL,
147 `disabled` tinyint(1) DEFAULT '0',
148 `ordername` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
149 `auth` tinyint(1) DEFAULT '1',
150 PRIMARY KEY (`id`),
151 KEY `nametype_index` (`name`,`type`),
152 KEY `domain_id` (`domain_id`),
153 KEY `ordername` (`ordername`)
154) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;
155/*!40101 SET character_set_client = @saved_cs_client */;
156
157--
158-- Dumping data for table `records`
159--
160
161LOCK TABLES `records` WRITE;
162/*!40000 ALTER TABLE `records` DISABLE KEYS */;
163INSERT INTO `records` VALUES (1,1,'mario200.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(2,1,'mario200.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(3,1,'mario200.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(4,2,'mario201.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(5,2,'mario201.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(6,2,'mario201.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(7,3,'mario108.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(8,3,'mario108.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(9,3,'mario108.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(10,4,'mario109.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(11,4,'mario109.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(12,4,'mario109.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(13,5,'navyaa5.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(14,5,'navyaa5.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(15,5,'navyaa5.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(16,6,'navyaa6.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(17,6,'navyaa6.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(18,6,'navyaa6.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(19,7,'navyaa7.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(20,7,'navyaa7.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(21,7,'navyaa7.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(22,8,'navyaa8.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(23,8,'navyaa8.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(24,8,'navyaa8.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(25,9,'navyaa9.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(26,9,'navyaa9.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(27,9,'navyaa9.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(28,10,'navyaa10.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(29,10,'navyaa10.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(30,10,'navyaa10.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(31,11,'navyaa11.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(32,11,'navyaa11.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(33,11,'navyaa11.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(34,21,'navyaa12.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(35,21,'navyaa12.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(36,21,'navyaa12.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(37,13,'navyaa13.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(38,13,'navyaa13.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(39,13,'navyaa13.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(40,14,'navyaa14.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(41,14,'navyaa14.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(42,14,'navyaa14.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(43,15,'navyaa15.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(44,15,'navyaa15.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(45,15,'navyaa15.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(46,16,'navyaa16.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(47,16,'navyaa16.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(48,16,'navyaa16.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(49,17,'navyaa17.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(50,17,'navyaa17.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(51,17,'navyaa17.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(52,18,'navyaa18.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(53,18,'navyaa18.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(54,18,'navyaa18.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(55,19,'navyaa19.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(56,19,'navyaa19.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(57,19,'navyaa19.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(58,20,'navyaa20.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018021001',86400,NULL,NULL,0,NULL,1),(59,20,'navyaa20.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(60,20,'navyaa20.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(61,5,'example0005.ie','A','10.0.0.21',120,NULL,NULL,0,NULL,1),(62,5,'ns1.example0005.ie','A','10.0.0.21',120,NULL,NULL,0,NULL,1),(63,5,'ns2.example0005.ie','A','10.0.0.21',120,NULL,NULL,0,NULL,1),(64,21,'iedr-node-1','A','10.0.0.8',86400,NULL,NULL,0,NULL,1),(65,21,'iedr-node-2','A','10.0.0.10',86400,NULL,NULL,0,NULL,1),(66,21,'iedr-node-3','A','10.0.0.6',86400,NULL,NULL,0,NULL,1),(67,21,'iedr-node-4','A','10.0.0.13',86400,NULL,NULL,0,NULL,1),(68,21,'iedr-node-5','A','10.0.0.4',86400,NULL,NULL,0,NULL,1),(69,21,'iedr-node-nfs','A','10.0.0.5',86400,NULL,NULL,0,NULL,1),(70,21,'iedr-node-smb','A','10.0.0.15',86400,NULL,NULL,0,NULL,1),(71,21,'iedr-node-db-1','A','10.0.0.7',86400,NULL,NULL,0,NULL,1),(72,21,'iedr-node-db-2','A','10.0.0.12',86400,NULL,NULL,0,NULL,1),(73,21,'iedr-node-proxy','A','10.0.0.22',86400,NULL,NULL,0,NULL,1),(74,21,'iedr-node-glue','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(75,22,'mario.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018081001',86400,NULL,NULL,0,NULL,1),(76,22,'mario.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(77,22,'mario.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(78,23,'example0005.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018081001',86400,NULL,NULL,0,NULL,1),(79,23,'example0005.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(80,23,'example0005.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(81,23,'ns1.example0005.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(82,23,'ns2.example0005.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(83,23,'ns3.example0005.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(84,23,'ns4.example0005.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(85,23,'ns5.example0005.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(86,23,'ns6.example0005.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(87,23,'ns7.example0005.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(88,23,'example0005.ie','NS','ns3.example0005.ie',86400,NULL,NULL,0,NULL,1),(89,23,'example0005.ie','NS','ns4.example0005.ie',86400,NULL,NULL,0,NULL,1),(90,23,'example0005.ie','NS','ns5.example0005.ie',86400,NULL,NULL,0,NULL,1),(91,23,'example0005.ie','NS','ns6.example0005.ie',86400,NULL,NULL,0,NULL,1),(92,23,'example0005.ie','NS','ns7.example0005.ie',86400,NULL,NULL,0,NULL,1),(93,24,'xn--0-ufa491h.ie','SOA','ns1.example0005.ie billy.iedr.ie 2018081001',86400,NULL,NULL,0,NULL,1),(94,24,'xn--0-ufa491h.ie','NS','ns1.example0005.ie',86400,NULL,NULL,0,NULL,1),(95,24,'xn--0-ufa491h.ie','NS','ns2.example0005.ie',86400,NULL,NULL,0,NULL,1),(96,23,'xn--0-ufa491h.ie','NS','ns1.xn--0-ufa491h.ie',86400,NULL,NULL,0,NULL,1),(97,23,'xn--0-ufa491h.ie','NS','ns2.xn--0-ufa491h.ie',86400,NULL,NULL,0,NULL,1),(98,23,'xn--0-ufa491h.ie','NS','ns3.xn--0-ufa491h.ie',86400,NULL,NULL,0,NULL,1),(99,23,'xn--0-ufa491h.ie','NS','ns4.xn--0-ufa491h.ie',86400,NULL,NULL,0,NULL,1),(100,23,'xn--0-ufa491h.ie','NS','ns5.xn--0-ufa491h.ie',86400,NULL,NULL,0,NULL,1),(101,23,'xn--0-ufa491h.ie','NS','ns6.xn--0-ufa491h.ie',86400,NULL,NULL,0,NULL,1),(102,23,'xn--0-ufa491h.ie','NS','ns7.xn--0-ufa491h.ie',86400,NULL,NULL,0,NULL,1),(103,23,'ns1.xn--0-ufa491h.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(104,23,'ns2.xn--0-ufa491h.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(105,23,'ns3.xn--0-ufa491h.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(106,23,'ns4.xn--0-ufa491h.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(107,23,'ns5.xn--0-ufa491h.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(108,23,'ns6.xn--0-ufa491h.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1),(109,23,'ns7.xn--0-ufa491h.ie','A','10.0.0.21',86400,NULL,NULL,0,NULL,1);
164/*!40000 ALTER TABLE `records` ENABLE KEYS */;
165UNLOCK TABLES;
166
167--
168-- Table structure for table `supermasters`
169--
170
171DROP TABLE IF EXISTS `supermasters`;
172/*!40101 SET @saved_cs_client = @@character_set_client */;
173/*!40101 SET character_set_client = utf8 */;
174CREATE TABLE `supermasters` (
175 `ip` varchar(64) NOT NULL,
176 `nameserver` varchar(255) NOT NULL,
177 `account` varchar(40) CHARACTER SET utf8 NOT NULL,
178 PRIMARY KEY (`ip`,`nameserver`)
179) ENGINE=InnoDB DEFAULT CHARSET=latin1;
180/*!40101 SET character_set_client = @saved_cs_client */;
181
182--
183-- Dumping data for table `supermasters`
184--
185
186LOCK TABLES `supermasters` WRITE;
187/*!40000 ALTER TABLE `supermasters` DISABLE KEYS */;
188/*!40000 ALTER TABLE `supermasters` ENABLE KEYS */;
189UNLOCK TABLES;
190
191--
192-- Table structure for table `tsigkeys`
193--
194
195DROP TABLE IF EXISTS `tsigkeys`;
196/*!40101 SET @saved_cs_client = @@character_set_client */;
197/*!40101 SET character_set_client = utf8 */;
198CREATE TABLE `tsigkeys` (
199 `id` int(11) NOT NULL AUTO_INCREMENT,
200 `name` varchar(255) DEFAULT NULL,
201 `algorithm` varchar(50) DEFAULT NULL,
202 `secret` varchar(255) DEFAULT NULL,
203 PRIMARY KEY (`id`),
204 UNIQUE KEY `namealgoindex` (`name`,`algorithm`)
205) ENGINE=InnoDB DEFAULT CHARSET=latin1;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Dumping data for table `tsigkeys`
210--
211
212LOCK TABLES `tsigkeys` WRITE;
213/*!40000 ALTER TABLE `tsigkeys` DISABLE KEYS */;
214/*!40000 ALTER TABLE `tsigkeys` ENABLE KEYS */;
215UNLOCK TABLES;
216/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
217
218/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
219/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
220/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
221/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
222/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
223/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
224/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
225
226-- Dump completed on 2018-10-25 14:51:04