-
Notifications
You must be signed in to change notification settings - Fork 1
/
mysql-database.sql
27 lines (26 loc) · 949 Bytes
/
mysql-database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
CREATE TABLE `domains` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` varchar(128) NOT NULL DEFAULT '',
`ttl` int(11) NOT NULL DEFAULT '3600',
`class` varchar(8) NOT NULL DEFAULT 'IN',
`zonemaster` varchar(128) NOT NULL DEFAULT '',
`adminmailbox` varchar(128) NOT NULL DEFAULT '',
`serial` int(11) NOT NULL DEFAULT '0',
`refresh` int(11) NOT NULL DEFAULT '10800',
`retry` int(11) NOT NULL DEFAULT '3600',
`expire` int(11) NOT NULL DEFAULT '1209600',
`negative` int(11) NOT NULL DEFAULT '7200',
PRIMARY KEY (`id`),
UNIQUE KEY `domain` (`domain`)
);
CREATE TABLE `records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` int(11) NOT NULL DEFAULT '0',
`zone` varchar(128) NOT NULL DEFAULT '',
`ttl` int(11) NOT NULL DEFAULT '3600',
`class` varchar(8) NOT NULL DEFAULT 'IN',
`type` varchar(8) NOT NULL DEFAULT '',
`address` varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `domain` (`domain`)
);