diff options
author | cvs2svn <cvs2svn@FreeBSD.org> | 2005-01-21 15:36:45 +0000 |
---|---|---|
committer | cvs2svn <cvs2svn@FreeBSD.org> | 2005-01-21 15:36:45 +0000 |
commit | 7011c19a8c96a2f8fb7c04d61cb28cdc507584a6 (patch) | |
tree | 22c0efaf2b6bb5b461389f9bac9542c7e3a5909a /dns/powerdns-devel/files/pdns_mysql.sql | |
parent | Now buildable on 4.x, still broken on >= 5.x. (diff) |
This commit was manufactured by cvs2svn to create tag 'RELEASE_4_11_0'.release/4.11.0
Diffstat (limited to 'dns/powerdns-devel/files/pdns_mysql.sql')
-rw-r--r-- | dns/powerdns-devel/files/pdns_mysql.sql | 38 |
1 files changed, 0 insertions, 38 deletions
diff --git a/dns/powerdns-devel/files/pdns_mysql.sql b/dns/powerdns-devel/files/pdns_mysql.sql deleted file mode 100644 index 278c5d56c61c..000000000000 --- a/dns/powerdns-devel/files/pdns_mysql.sql +++ /dev/null @@ -1,38 +0,0 @@ -create table domains ( - id INT auto_increment, - name VARCHAR(255) NOT NULL, - master VARCHAR(20) DEFAULT NULL, - last_check INT DEFAULT NULL, - type VARCHAR(6) NOT NULL, - notified_serial INT DEFAULT NULL, - account VARCHAR(40) DEFAULT NULL, - primary key (id) -)type=InnoDB; - -CREATE UNIQUE INDEX name_index ON domains(name); - -CREATE TABLE records ( - id INT auto_increment, - domain_id INT DEFAULT NULL, - name VARCHAR(255) DEFAULT NULL, - type VARCHAR(6) DEFAULT NULL, - content VARCHAR(255) DEFAULT NULL, - ttl INT DEFAULT NULL, - prio INT DEFAULT NULL, - change_date INT DEFAULT NULL, - primary key(id) -)type=InnoDB; - -CREATE INDEX rec_name_index ON records(name); -CREATE INDEX nametype_index ON records(name,type); -CREATE INDEX domain_id ON records(domain_id); - -create table supermasters ( - ip VARCHAR(25) NOT NULL, - nameserver VARCHAR(255) NOT NULL, - account VARCHAR(40) DEFAULT NULL -); - -GRANT SELECT ON supermasters TO pdns; -GRANT ALL ON domains TO pdns; -GRANT ALL ON records TO pdns; |