[Xoops-svn] SF.net SVN: xoops-svn:[13387] *.xoops.org (Subdomain APIs & Sites)/ zones.xoops.org/install/sql

[<chr...@us...>]

Revision: 13387
          http://sourceforge.net/p/xoops/svn/13387
Author:   chronolabscoop
Date:     2018-08-24 00:42:45 +0000 (Fri, 24 Aug 2018)
Log Message:
-----------
Fixing PDNS Database Structure!

Modified Paths:
--------------
    *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.domains.sql
    *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.peers.sql
    *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.records.sql
    *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.supermasters.sql
    *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.users.sql

Added Paths:
-----------
    *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.comments.sql
    *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.cryptokeys.sql
    *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.domainmetadata.sql
    *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.tsigkeys.sql

Added: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.comments.sql
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.comments.sql	                        (rev 0)
+++ *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.comments.sql	2018-08-24 00:42:45 UTC (rev 13387)
@@ -0,0 +1,16 @@
+DROP TABLE `comments`;
+
+CREATE TABLE `comments` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `domain_id` int(11) NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `type` varchar(10) NOT NULL,
+ `modified_at` int(11) NOT NULL,
+ `account` varchar(40) CHARACTER SET utf8 NOT NULL,
+ `comment` text CHARACTER SET utf8 NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `comments_domain_id_idx` (`domain_id`),
+ KEY `comments_name_type_idx` (`name`,`type`),
+ KEY `comments_order_idx` (`domain_id`,`modified_at`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+


Property changes on: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.comments.sql
___________________________________________________________________
Added: svn:executable
## -0,0 +1 ##
+*
\ No newline at end of property
Added: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.cryptokeys.sql
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.cryptokeys.sql	                        (rev 0)
+++ *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.cryptokeys.sql	2018-08-24 00:42:45 UTC (rev 13387)
@@ -0,0 +1,12 @@
+DROP TABLE `cryptokeys`;
+
+CREATE TABLE `cryptokeys` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `domain_id` int(11) NOT NULL,
+ `flags` int(11) NOT NULL,
+ `active` tinyint(1) DEFAULT NULL,
+ `content` text,
+ PRIMARY KEY (`id`),
+ KEY `domainidindex` (`domain_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+


Property changes on: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.cryptokeys.sql
___________________________________________________________________
Added: svn:executable
## -0,0 +1 ##
+*
\ No newline at end of property
Added: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.domainmetadata.sql
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.domainmetadata.sql	                        (rev 0)
+++ *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.domainmetadata.sql	2018-08-24 00:42:45 UTC (rev 13387)
@@ -0,0 +1,11 @@
+DROP TABLE `domainmetadata`;
+
+CREATE TABLE `domainmetadata` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `domain_id` int(11) NOT NULL,
+ `kind` varchar(32) DEFAULT NULL,
+ `content` text,
+ PRIMARY KEY (`id`),
+ KEY `domainmetadata_idx` (`domain_id`,`kind`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+


Property changes on: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.domainmetadata.sql
___________________________________________________________________
Added: svn:executable
## -0,0 +1 ##
+*
\ No newline at end of property
Modified: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.domains.sql
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.domains.sql	2018-07-31 17:31:30 UTC (rev 13386)
+++ *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.domains.sql	2018-08-24 00:42:45 UTC (rev 13387)
@@ -1,3 +1,5 @@
+DROP TABLE `domains`;
+
 CREATE TABLE `domains` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `name` varchar(255) NOT NULL,

Modified: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.peers.sql
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.peers.sql	2018-07-31 17:31:30 UTC (rev 13386)
+++ *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.peers.sql	2018-08-24 00:42:45 UTC (rev 13387)
@@ -1,3 +1,5 @@
+DROP TABLE `peers`;
+
 CREATE TABLE `peers` (
   `pid` mediumint(32) unsigned NOT NULL AUTO_INCREMENT,
   `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',

Modified: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.records.sql
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.records.sql	2018-07-31 17:31:30 UTC (rev 13386)
+++ *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.records.sql	2018-08-24 00:42:45 UTC (rev 13387)
@@ -1,3 +1,5 @@
+DROP TABLE `records`;
+
 CREATE TABLE `records` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `domain_id` int(11) DEFAULT NULL,
@@ -7,10 +9,13 @@
   `ttl` int(11) DEFAULT NULL,
   `prio` int(11) DEFAULT NULL,
   `change_date` int(11) DEFAULT NULL,
+  `disabled` tinyint(1) DEFAULT 0,
+  `ordername` varchar(255) DEFAULT '',
+  `auth` tinyint(1) DEFAULT 0,
   PRIMARY KEY (`id`),
-  KEY `rec_name_index` (`name`),
-  KEY `nametype_index` (`name`,`type`),
-  KEY `domain_id` (`domain_id`),
-  KEY `search` (`domain_id`,`name`,`type`,`prio`,`ttl`)
+  KEY `rec_name_index` (`disabled`,`name`),
+  KEY `nametype_index` (`disabled`,`name`,`type`),
+  KEY `domain_id` (`domain_id`,`type`),
+  KEY `search` (`disabled`,`ordername`,`domain_id`,`name`,`type`,`prio`,`ttl`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 

Modified: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.supermasters.sql
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.supermasters.sql	2018-07-31 17:31:30 UTC (rev 13386)
+++ *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.supermasters.sql	2018-08-24 00:42:45 UTC (rev 13387)
@@ -1,3 +1,5 @@
+DROP TABLE `supermasters`;
+
 CREATE TABLE `supermasters` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `ip` varchar(128) NOT NULL,

Added: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.tsigkeys.sql
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.tsigkeys.sql	                        (rev 0)
+++ *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.tsigkeys.sql	2018-08-24 00:42:45 UTC (rev 13387)
@@ -0,0 +1,11 @@
+DROP TABLE `tsigkeys`;
+
+CREATE TABLE `tsigkeys` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) DEFAULT NULL,
+ `algorithm` varchar(50) DEFAULT NULL,
+ `secret` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `namealgoindex` (`name`,`algorithm`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+


Property changes on: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.tsigkeys.sql
___________________________________________________________________
Added: svn:executable
## -0,0 +1 ##
+*
\ No newline at end of property
Modified: *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.users.sql
===================================================================
--- *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.users.sql	2018-07-31 17:31:30 UTC (rev 13386)
+++ *.xoops.org (Subdomain APIs & Sites)/zones.xoops.org/install/sql/noprefix.users.sql	2018-08-24 00:42:45 UTC (rev 13387)
@@ -1,3 +1,5 @@
+DROP TABLE `users`;
+
 CREATE TABLE `users` (
   `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   `name` varchar(60) NOT NULL DEFAULT '',