diff options
author | cvs2svn <cvs2svn@FreeBSD.org> | 2005-04-20 06:16:18 +0000 |
---|---|---|
committer | cvs2svn <cvs2svn@FreeBSD.org> | 2005-04-20 06:16:18 +0000 |
commit | 8673c7ec800a8bcc6da14c506081a3cb76e2b8ea (patch) | |
tree | ad3f495c08f0cc331b6958d319f699d021175c19 /dns/powerdns-devel/files/pdns_sqlite.sql | |
parent | 0d9507efb9d902ba8e7fafa90edd7893d2f8db19 (diff) | |
download | ports-release/5.4.0.tar.gz ports-release/5.4.0.zip |
Diffstat (limited to 'dns/powerdns-devel/files/pdns_sqlite.sql')
-rw-r--r-- | dns/powerdns-devel/files/pdns_sqlite.sql | 33 |
1 files changed, 0 insertions, 33 deletions
diff --git a/dns/powerdns-devel/files/pdns_sqlite.sql b/dns/powerdns-devel/files/pdns_sqlite.sql deleted file mode 100644 index f0f831fb2977..000000000000 --- a/dns/powerdns-devel/files/pdns_sqlite.sql +++ /dev/null @@ -1,33 +0,0 @@ -create table domains ( - id INTEGER PRIMARY KEY, - name VARCHAR(255) NOT NULL, - master VARCHAR(20) DEFAULT NULL, - last_check INTEGER DEFAULT NULL, - type VARCHAR(6) NOT NULL, - notified_serial INTEGER DEFAULT NULL, - account VARCHAR(40) DEFAULT NULL -); - -CREATE UNIQUE INDEX name_index ON domains(name); - -CREATE TABLE records ( - id INTEGER PRIMARY KEY, - domain_id INTEGER DEFAULT NULL, - name VARCHAR(255) DEFAULT NULL, - type VARCHAR(6) DEFAULT NULL, - content VARCHAR(255) DEFAULT NULL, - ttl INTEGER DEFAULT NULL, - prio INTEGER DEFAULT NULL, - change_date INTEGER DEFAULT NULL -); - -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 -); - |