]>
Commit | Line | Data |
---|---|---|
476b248c SS |
1 | create table domains ( |
2 | id INTEGER PRIMARY KEY, | |
3 | name VARCHAR(255) NOT NULL COLLATE NOCASE, | |
4 | master VARCHAR(128) DEFAULT NULL, | |
5 | last_check INTEGER DEFAULT NULL, | |
6 | type VARCHAR(6) NOT NULL, | |
7 | notified_serial INTEGER DEFAULT NULL, | |
8 | account VARCHAR(40) DEFAULT NULL | |
9 | ); | |
10 | ||
11 | CREATE UNIQUE INDEX name_index ON domains(name); | |
12 | ||
13 | CREATE TABLE records ( | |
14 | id INTEGER PRIMARY KEY, | |
15 | domain_id INTEGER DEFAULT NULL, | |
16 | name VARCHAR(255) DEFAULT NULL, | |
17 | type VARCHAR(10) DEFAULT NULL, | |
18 | content VARCHAR(65535) DEFAULT NULL, | |
19 | ttl INTEGER DEFAULT NULL, | |
20 | prio INTEGER DEFAULT NULL, | |
21 | change_date INTEGER DEFAULT NULL, | |
22 | ordername VARCHAR(255), | |
23 | auth BOOL | |
24 | ); | |
25 | ||
26 | CREATE INDEX rec_name_index ON records(name); | |
27 | CREATE INDEX nametype_index ON records(name,type); | |
28 | CREATE INDEX domain_id ON records(domain_id); | |
29 | CREATE INDEX orderindex ON records(ordername); | |
30 | ||
31 | create table supermasters ( | |
32 | ip VARCHAR(25) NOT NULL, | |
33 | nameserver VARCHAR(255) NOT NULL COLLATE NOCASE, | |
34 | account VARCHAR(40) DEFAULT NULL | |
35 | ); | |
36 | ||
37 | create table domainmetadata ( | |
38 | id INTEGER PRIMARY KEY, | |
39 | domain_id INT NOT NULL, | |
40 | kind VARCHAR(16) COLLATE NOCASE, | |
41 | content TEXT | |
42 | ); | |
43 | ||
44 | create index domainmetaidindex on domainmetadata(domain_id); | |
45 | ||
46 | create table cryptokeys ( | |
47 | id INTEGER PRIMARY KEY, | |
48 | domain_id INT NOT NULL, | |
49 | flags INT NOT NULL, | |
50 | active BOOL, | |
51 | content TEXT | |
52 | ); | |
53 | ||
54 | create index domainidindex on cryptokeys(domain_id); | |
55 | ||
56 | create table tsigkeys ( | |
57 | id INTEGER PRIMARY KEY, | |
58 | name VARCHAR(255) COLLATE NOCASE, | |
59 | algorithm VARCHAR(50) COLLATE NOCASE, | |
60 | secret VARCHAR(255) | |
61 | ); | |
62 | ||
63 | create unique index namealgoindex on tsigkeys(name, algorithm); |