skhNUm0C

1DROP TABLE IF EXISTS domains;
2CREATE TABLE domains (
3    id INT auto_increment,
4    name VARCHAR(255) NOT NULL,
5    master VARCHAR(128) DEFAULT NULL,
6    last_check INT DEFAULT NULL,
7    type VARCHAR(6) NOT NULL,
8    notified_serial INT DEFAULT NULL,
9    account VARCHAR(40) DEFAULT NULL,
10    primary key (id)
11);
12
13DROP TABLE IF EXISTS records;
14CREATE TABLE records (
15    id INT auto_increment,
16    domain_id INT DEFAULT NULL,
17    name VARCHAR(255) DEFAULT NULL,
18    type VARCHAR(6) DEFAULT NULL,
19    content VARCHAR(255) DEFAULT NULL,
20    ttl INT DEFAULT NULL,
21    prio INT DEFAULT NULL,
22    change_date INT DEFAULT NULL,
23    primary key(id)
24);
25
26DROP TABLE IF EXISTS supermasters;
27CREATE TABLE supermasters (
28    ip VARCHAR(25) NOT NULL,
29    nameserver VARCHAR(255) NOT NULL,
30    account VARCHAR(40) DEFAULT NULL
31);