|
From: <chr...@us...> - 2018-08-24 00:42:50
|
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 '',
|