fix last commit

[GitHub/Stricted/Domain-Control-Panel.git] / database.sql

diff --git a/database.sql b/database.sql
index 55c17b795b7aea04451ddc7456c200b29ad2bd94..0a7b67a75503987d09d2da7f437df314e67c37b1 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -17,12 +17,11 @@ CREATE TABLE IF NOT EXISTS dns_rr (
        id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
        zone INT(10) NOT NULL,
        name VARCHAR(255) NOT NULL,
-       data VARCHAR(255) NOT NULL,
+       data TEXT,
        aux INT(10) NOT NULL,
        ttl INT(10) NOT NULL DEFAULT '86400',
        type enum('A', 'AAAA', 'CNAME', 'MX', 'PTR', 'SRV', 'TXT', 'TLSA', 'NS', 'DS') DEFAULT NULL,
-       active boolean NOT NULL DEFAULT 1,
-       UNIQUE KEY dns_rr (zone, name, type, data)
+       active boolean NOT NULL DEFAULT 1
 ) ENGINE=InnoDB;
 
 CREATE TABLE IF NOT EXISTS dns_sec (
@@ -79,12 +78,34 @@ CREATE TABLE IF NOT EXISTS dns_session (
        sessionData TEXT
 ) ENGINE=InnoDB;
 
+CREATE TABLE IF NOT EXISTS dns_permissions (
+       permissionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
+       permission VARCHAR(255) NOT NULL
+) ENGINE=InnoDB;
+
+CREATE TABLE IF NOT EXISTS dns_permissions_to_user (
+       id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
+       userID INT(10) NOT NULL,
+       permissionID INT(10) NOT NULL
+) ENGINE=InnoDB;
+
+CREATE TABLE IF NOT EXISTS dns_language (
+       id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
+       languageID INT(10) NOT NULL,
+       languageItem VARCHAR(255) NOT NULL,
+       languageValue VARCHAR(255) NOT NULL
+) ENGINE=InnoDB;
+
+
+
 ALTER TABLE dns_api ADD FOREIGN KEY (userID) REFERENCES dns_user (userID) ON DELETE CASCADE;
 ALTER TABLE dns_sec ADD FOREIGN KEY (zone) REFERENCES dns_soa (id) ON DELETE CASCADE;
 ALTER TABLE dns_rr ADD FOREIGN KEY (zone) REFERENCES dns_soa (id) ON DELETE CASCADE;
 ALTER TABLE dns_soa_to_user ADD FOREIGN KEY (userID) REFERENCES dns_user (userID) ON DELETE CASCADE;
 ALTER TABLE dns_soa_to_user ADD FOREIGN KEY (soaID) REFERENCES dns_soa (id) ON DELETE CASCADE;
 ALTER TABLE dns_template ADD FOREIGN KEY (userID) REFERENCES dns_user (userID) ON DELETE CASCADE;
+ALTER TABLE dns_permissions_to_user ADD FOREIGN KEY (userID) REFERENCES dns_user (userID) ON DELETE CASCADE;
+ALTER TABLE dns_permissions_to_user ADD FOREIGN KEY (permissionID) REFERENCES dns_permissions (permissionID) ON DELETE CASCADE;
 
 INSERT INTO dns_options VALUES (1, 'dns_api_key', '0E2372C5-E5A3-424B-82E5-75AD723A9447');
 INSERT INTO dns_options VALUES (2, 'offline', '0');
@@ -98,6 +119,7 @@ INSERT INTO dns_options VALUES (9, 'dns_soa_retry', '7200');
 INSERT INTO dns_options VALUES (10, 'dns_soa_expire', '604800');
 INSERT INTO dns_options VALUES (11, 'dns_soa_minimum_ttl', '60');
 INSERT INTO dns_options VALUES (12, 'enable_dnssec', '1');
+INSERT INTO dns_options VALUES (13, 'cache_source_type', 'disk');
 
 
 INSERT INTO `dns_user` VALUES (1, 'admin', 'example@example.net', '$2a$08$XfcfTGc1LlmOHWUt/2sfNeFLEwqESy6wmrIIJMyQS1j5pwembqiae', '0', '2');