]>
Commit | Line | Data |
---|---|---|
76e1255a KM |
1 | BEGIN TRANSACTION; |
2 | CREATE TEMPORARY TABLE records_backup ( | |
3 | id INTEGER PRIMARY KEY, | |
4 | domain_id INTEGER DEFAULT NULL, | |
5 | name VARCHAR(255) DEFAULT NULL, | |
6 | type VARCHAR(10) DEFAULT NULL, | |
7 | content VARCHAR(65535) DEFAULT NULL, | |
8 | ttl INTEGER DEFAULT NULL, | |
9 | prio INTEGER DEFAULT NULL, | |
10 | disabled BOOLEAN DEFAULT 0, | |
11 | ordername VARCHAR(255), | |
12 | auth BOOL DEFAULT 1 | |
13 | ); | |
14 | ||
15 | INSERT INTO records_backup SELECT id,domain_id,name,type,content,ttl,prio,disabled,ordername,auth FROM records; | |
16 | DROP TABLE records; | |
17 | ||
18 | CREATE TABLE records ( | |
19 | id INTEGER PRIMARY KEY, | |
20 | domain_id INTEGER DEFAULT NULL, | |
21 | name VARCHAR(255) DEFAULT NULL, | |
22 | type VARCHAR(10) DEFAULT NULL, | |
23 | content VARCHAR(65535) DEFAULT NULL, | |
24 | ttl INTEGER DEFAULT NULL, | |
25 | prio INTEGER DEFAULT NULL, | |
26 | disabled BOOLEAN DEFAULT 0, | |
27 | ordername VARCHAR(255), | |
28 | auth BOOL DEFAULT 1, | |
29 | FOREIGN KEY(domain_id) REFERENCES domains(id) ON DELETE CASCADE ON UPDATE CASCADE | |
30 | ); | |
31 | ||
32 | CREATE INDEX rec_name_index ON records(name); | |
33 | CREATE INDEX nametype_index ON records(name,type); | |
34 | CREATE INDEX domain_id ON records(domain_id); | |
35 | CREATE INDEX orderindex ON records(ordername); | |
36 | ||
37 | INSERT INTO records SELECT id,domain_id,name,type,content,ttl,prio,disabled,ordername,auth FROM records_backup; | |
38 | DROP TABLE records_backup; | |
39 | COMMIT; |