Advertisement
devepone

pdns

Oct 25th, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.43 KB | None | 0 0
  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.  
  22. DROP TABLE IF EXISTS `comments`;
  23. /*!40101 SET @saved_cs_client = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE 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.  
  43. LOCK TABLES `comments` WRITE;
  44. /*!40000 ALTER TABLE `comments` DISABLE KEYS */;
  45. /*!40000 ALTER TABLE `comments` ENABLE KEYS */;
  46. UNLOCK TABLES;
  47.  
  48. --
  49. -- Table structure for table `cryptokeys`
  50. --
  51.  
  52. DROP TABLE IF EXISTS `cryptokeys`;
  53. /*!40101 SET @saved_cs_client = @@character_set_client */;
  54. /*!40101 SET character_set_client = utf8 */;
  55. CREATE 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.  
  70. LOCK TABLES `cryptokeys` WRITE;
  71. /*!40000 ALTER TABLE `cryptokeys` DISABLE KEYS */;
  72. /*!40000 ALTER TABLE `cryptokeys` ENABLE KEYS */;
  73. UNLOCK TABLES;
  74.  
  75. --
  76. -- Table structure for table `domainmetadata`
  77. --
  78.  
  79. DROP TABLE IF EXISTS `domainmetadata`;
  80. /*!40101 SET @saved_cs_client = @@character_set_client */;
  81. /*!40101 SET character_set_client = utf8 */;
  82. CREATE 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.  
  96. LOCK TABLES `domainmetadata` WRITE;
  97. /*!40000 ALTER TABLE `domainmetadata` DISABLE KEYS */;
  98. /*!40000 ALTER TABLE `domainmetadata` ENABLE KEYS */;
  99. UNLOCK TABLES;
  100.  
  101. --
  102. -- Table structure for table `domains`
  103. --
  104.  
  105. DROP TABLE IF EXISTS `domains`;
  106. /*!40101 SET @saved_cs_client = @@character_set_client */;
  107. /*!40101 SET character_set_client = utf8 */;
  108. CREATE 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.  
  125. LOCK TABLES `domains` WRITE;
  126. /*!40000 ALTER TABLE `domains` DISABLE KEYS */;
  127. INSERT 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 */;
  129. UNLOCK TABLES;
  130.  
  131. --
  132. -- Table structure for table `records`
  133. --
  134.  
  135. DROP TABLE IF EXISTS `records`;
  136. /*!40101 SET @saved_cs_client = @@character_set_client */;
  137. /*!40101 SET character_set_client = utf8 */;
  138. CREATE 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.  
  161. LOCK TABLES `records` WRITE;
  162. /*!40000 ALTER TABLE `records` DISABLE KEYS */;
  163. INSERT 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 */;
  165. UNLOCK TABLES;
  166.  
  167. --
  168. -- Table structure for table `supermasters`
  169. --
  170.  
  171. DROP TABLE IF EXISTS `supermasters`;
  172. /*!40101 SET @saved_cs_client = @@character_set_client */;
  173. /*!40101 SET character_set_client = utf8 */;
  174. CREATE 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.  
  186. LOCK TABLES `supermasters` WRITE;
  187. /*!40000 ALTER TABLE `supermasters` DISABLE KEYS */;
  188. /*!40000 ALTER TABLE `supermasters` ENABLE KEYS */;
  189. UNLOCK TABLES;
  190.  
  191. --
  192. -- Table structure for table `tsigkeys`
  193. --
  194.  
  195. DROP TABLE IF EXISTS `tsigkeys`;
  196. /*!40101 SET @saved_cs_client = @@character_set_client */;
  197. /*!40101 SET character_set_client = utf8 */;
  198. CREATE 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.  
  212. LOCK TABLES `tsigkeys` WRITE;
  213. /*!40000 ALTER TABLE `tsigkeys` DISABLE KEYS */;
  214. /*!40000 ALTER TABLE `tsigkeys` ENABLE KEYS */;
  215. UNLOCK 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement