projects / GitHub / Stricted / Domain-Control-Panel.git / blame
| Commit | Line | Data |
|---|---|---|
| 2aa91ff2 S |
1 | CREATE TABLE IF NOT EXISTS dns_soa ( |
| 2 | id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 3 | origin VARCHAR(255) NOT NULL, | |
| 4 | ns VARCHAR(255) NOT NULL, | |
| 5 | mbox VARCHAR(255) NOT NULL, | |
| 6 | serial INT(10) NOT NULL DEFAULT '1', | |
| 7 | refresh INT(10) NOT NULL DEFAULT '28800', | |
| 8 | retry INT(10) NOT NULL DEFAULT '7200', | |
| 9 | expire INT(10) NOT NULL DEFAULT '604800', | |
| 10 | minimum INT(10) NOT NULL DEFAULT '86400', | |
| 11 | ttl INT(10) NOT NULL DEFAULT '86400', | |
| 12 | active boolean NOT NULL DEFAULT 1, | |
| 13 | UNIQUE KEY origin (origin) | |
| 14 | ) ENGINE=InnoDB; | |
| 15 | ||
| 16 | CREATE TABLE IF NOT EXISTS dns_rr ( | |
| 17 | id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 18 | zone INT(10) NOT NULL, | |
| 19 | name VARCHAR(255) NOT NULL, | |
| 20 | data VARCHAR(255) NOT NULL, | |
| 21 | aux INT(10) NOT NULL, | |
| 22 | ttl INT(10) NOT NULL DEFAULT '86400', | |
| 23 | type enum('A','AAAA','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT', 'DNSKEY', 'TLSA', 'DS') DEFAULT NULL, | |
| 24 | active boolean NOT NULL DEFAULT 1, | |
| 25 | UNIQUE KEY dns_rr (zone, name, type, data) | |
| 26 | ) ENGINE=InnoDB; | |
| 27 | ||
| 28 | CREATE TABLE IF NOT EXISTS dns_sec ( | |
| 29 | id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 30 | zone INT(10) NOT NULL, | |
| 31 | type enum('ZSK','KSK') DEFAULT NULL, | |
| 32 | algo VARCHAR(255) NOT NULL, | |
| 33 | public TEXT, | |
| 34 | private TEXT, | |
| 35 | dsset TEXT, | |
| 36 | active boolean NOT NULL DEFAULT 1 | |
| 37 | ) ENGINE=InnoDB; | |
| 38 | ||
| 39 | CREATE TABLE IF NOT EXISTS dns_user ( | |
| 40 | userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 41 | username VARCHAR(255) NOT NULL, | |
| 42 | email VARCHAR(255) NOT NULL, | |
| 43 | password VARCHAR(255) NOT NULL, | |
| 44 | reseller INT(10) NOT NULL DEFAULT '0', | |
| 45 | status INT(10) NOT NULL DEFAULT '0', | |
| 46 | UNIQUE KEY dns_user (username, email, password) | |
| 47 | ) ENGINE=InnoDB; | |
| 48 | ||
| 49 | CREATE TABLE IF NOT EXISTS dns_soa_to_user ( | |
| 50 | id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 51 | userID INT(10) NOT NULL, | |
| 52 | soaID INT(10) NOT NULL, | |
| 53 | UNIQUE KEY dns_soa_to_user (userID, soaID) | |
| 54 | ) ENGINE=InnoDB; | |
| 55 | ||
| 56 | CREATE TABLE IF NOT EXISTS dns_options ( | |
| 57 | optionID int(255) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 58 | `option` varchar(255) DEFAULT NULL, | |
| 59 | `value` varchar(255) DEFAULT NULL, | |
| 60 | UNIQUE KEY dns_options (`option`, `value`) | |
| 61 | ) ENGINE=InnoDB; | |
| 62 | ||
| 63 | CREATE TABLE IF NOT EXISTS dns_api ( | |
| 64 | id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 65 | userID INT(10) NOT NULL, | |
| 66 | apiKey VARCHAR(255) NOT NULL | |
| 67 | ) ENGINE=InnoDB; | |
| 68 | ||
| 69 | ALTER TABLE dns_api ADD FOREIGN KEY (userID) REFERENCES dns_user (userID) ON DELETE CASCADE; | |
| 70 | ALTER TABLE dns_sec ADD FOREIGN KEY (zone) REFERENCES dns_soa (id) ON DELETE CASCADE; | |
| 71 | ALTER TABLE dns_rr ADD FOREIGN KEY (zone) REFERENCES dns_soa (id) ON DELETE CASCADE; | |
| 72 | ALTER TABLE dns_soa_to_user ADD FOREIGN KEY (userID) REFERENCES dns_user (userID) ON DELETE CASCADE; | |
| 73 | ALTER TABLE dns_soa_to_user ADD FOREIGN KEY (soaID) REFERENCES dns_soa (id) ON DELETE CASCADE; | |
| 74 | ||
| 75 | INSERT INTO dns_options VALUES (1, 'dns_api_key', 'aa'); | |
| 76 | INSERT INTO dns_options VALUES (4, 'dns_soa_minimum_ttl', '60'); | |
| 77 | INSERT INTO dns_options VALUES (3, 'enable_debug_mode', '1'); | |
| 78 | INSERT INTO dns_options VALUES (2, 'offline', '0'); | |
| 79 | ||
| 80 | INSERT INTO `dns_user` VALUES (1, 'admin', 'example@example.net', '$2a$08$XfcfTGc1LlmOHWUt/2sfNeFLEwqESy6wmrIIJMyQS1j5pwembqiae', '0', '2'); |