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,
        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,
        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 (
 ) ENGINE=InnoDB;
 
 CREATE TABLE IF NOT EXISTS dns_sec (


@@ -79,12 +78,34 @@ CREATE TABLE IF NOT EXISTS dns_session (
        sessionData TEXT
 ) ENGINE=InnoDB;
 
        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_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');
 
 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 (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');
 
 
 INSERT INTO `dns_user` VALUES (1, 'admin', 'example@example.net', '$2a$08$XfcfTGc1LlmOHWUt/2sfNeFLEwqESy6wmrIIJMyQS1j5pwembqiae', '0', '2');