From c4d0cb1bbf084e2f16f78f6b85f06db87e12608b Mon Sep 17 00:00:00 2001 From: Bert Hubert Date: Sun, 16 Mar 2008 16:32:24 +0000 Subject: [PATCH] remove files on request of Norbert git-svn-id: svn://svn.powerdns.com/pdns/trunk/pdns@1162 d19b8d6e-7fed-0310-83ef-9ca221ded41b --- modules/opendbxbackend/tables-mysql.sql | 57 ------------------------ modules/opendbxbackend/tables-pgsql.sql | 57 ------------------------ modules/opendbxbackend/tables-sqlite.sql | 51 --------------------- 3 files changed, 165 deletions(-) delete mode 100644 modules/opendbxbackend/tables-mysql.sql delete mode 100644 modules/opendbxbackend/tables-pgsql.sql delete mode 100644 modules/opendbxbackend/tables-sqlite.sql diff --git a/modules/opendbxbackend/tables-mysql.sql b/modules/opendbxbackend/tables-mysql.sql deleted file mode 100644 index c57d45c1d..000000000 --- a/modules/opendbxbackend/tables-mysql.sql +++ /dev/null @@ -1,57 +0,0 @@ -SET SESSION sql_mode='ANSI'; - -CREATE TABLE "domains" ( - "id" INTEGER NOT NULL AUTO_INCREMENT, - "name" VARCHAR(255) NOT NULL, - "type" VARCHAR(6) NOT NULL, - "master" VARCHAR(40) NOT NULL DEFAULT '', - "account" VARCHAR(40) NOT NULL DEFAULT '', - "notified_serial" INTEGER DEFAULT NULL, - "last_check" INTEGER DEFAULT NULL, - "status" CHAR(1) NOT NULL DEFAULT 'A', -CONSTRAINT "pk_domains_id" - PRIMARY KEY ("id"), -CONSTRAINT "unq_domains_name" - UNIQUE ("name") -) type=InnoDB; - -CREATE INDEX "idx_domains_status_type" ON "domains" ("status","type"); - - - -CREATE TABLE "records" ( - "id" INTEGER NOT NULL AUTO_INCREMENT, - "domain_id" INTEGER NOT NULL, - "name" VARCHAR(255) NOT NULL, - "type" VARCHAR(6) NOT NULL, - "ttl" INTEGER DEFAULT NULL, - "prio" INTEGER DEFAULT NULL, - "content" VARCHAR(255) NOT NULL, - "change_date" INTEGER DEFAULT NULL, -CONSTRAINT "pk_records_id" - PRIMARY KEY ("id"), -CONSTRAINT "fk_records_domainid" - FOREIGN KEY ("domain_id") - REFERENCES "domains" ("id") - ON UPDATE CASCADE - ON DELETE CASCADE -) type=InnoDB; - -CREATE INDEX "idx_records_name_type" ON "records" ("name","type"); -CREATE INDEX "idx_records_type" ON "records" ("type"); - - - -CREATE TABLE "supermasters" ( - "ip" VARCHAR(40) NOT NULL, - "nameserver" VARCHAR(255) NOT NULL, - "account" VARCHAR(40) NOT NULL DEFAULT '' -); - -CREATE INDEX "idx_smip_smns" ON "supermasters" ("ip","nameserver"); - - - -GRANT SELECT ON "supermasters" TO "powerdns"; -GRANT ALL ON "domains" TO "powerdns"; -GRANT ALL ON "records" TO "powerdns"; diff --git a/modules/opendbxbackend/tables-pgsql.sql b/modules/opendbxbackend/tables-pgsql.sql deleted file mode 100644 index 5d8afcb70..000000000 --- a/modules/opendbxbackend/tables-pgsql.sql +++ /dev/null @@ -1,57 +0,0 @@ -CREATE TABLE "domains" ( - "id" SERIAL NOT NULL, - "name" VARCHAR(255) NOT NULL, - "type" VARCHAR(6) NOT NULL, - "master" VARCHAR(40) NOT NULL DEFAULT '', - "account" VARCHAR(40) NOT NULL DEFAULT '', - "notified_serial" INTEGER DEFAULT NULL, - "last_check" INTEGER DEFAULT NULL, - "status" CHAR(1) NOT NULL DEFAULT 'A', -CONSTRAINT "pk_domains_id" - PRIMARY KEY ("id"), -CONSTRAINT "unq_domains_name" - UNIQUE ("name") -); - -CREATE INDEX "idx_domains_status_type" ON "domains" ("status","type"); - - - -CREATE TABLE "records" ( - "id" SERIAL NOT NULL, - "domain_id" INTEGER NOT NULL, - "name" VARCHAR(255) NOT NULL, - "type" VARCHAR(6) NOT NULL, - "ttl" INTEGER DEFAULT NULL, - "prio" INTEGER DEFAULT NULL, - "content" VARCHAR(255) NOT NULL, - "change_date" INTEGER DEFAULT NULL, -CONSTRAINT "pk_records_id" - PRIMARY KEY ("id"), -CONSTRAINT "fk_records_domainid" - FOREIGN KEY ("domain_id") - REFERENCES domains ("id") - ON UPDATE CASCADE - ON DELETE CASCADE -); - -CREATE INDEX "idx_records_name_type" ON "records" ("name","type"); -CREATE INDEX "idx_records_type" ON "records" ("type"); - - - -CREATE TABLE "supermasters" ( - "ip" VARCHAR(40) NOT NULL, - "nameserver" VARCHAR(255) NOT NULL, - "account" VARCHAR(40) NOT NULL DEFAULT '' -); - -CREATE INDEX "idx_smaster_ip_ns" ON "supermasters" ("ip","nameserver"); - - - -GRANT SELECT ON "supermasters" TO "powerdns"; -GRANT ALL ON "domains" TO "powerdns"; -GRANT ALL ON "domains_id_seq" TO "powerdns"; -GRANT ALL ON "records" TO "powerdns"; -GRANT ALL ON "records_id_seq" TO "powerdns"; diff --git a/modules/opendbxbackend/tables-sqlite.sql b/modules/opendbxbackend/tables-sqlite.sql deleted file mode 100644 index 0491ac280..000000000 --- a/modules/opendbxbackend/tables-sqlite.sql +++ /dev/null @@ -1,51 +0,0 @@ -CREATE TABLE "domains" ( - "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - "name" VARCHAR(255) NOT NULL, - "type" VARCHAR(6) NOT NULL, - "master" VARCHAR(40) NOT NULL DEFAULT '', - "account" VARCHAR(40) NOT NULL DEFAULT '', - "notified_serial" INTEGER DEFAULT NULL, - "last_check" INTEGER DEFAULT NULL, - "status" CHAR(1) NOT NULL DEFAULT 'A', -CONSTRAINT "unq_domains_name" - UNIQUE ("name") -); - -CREATE INDEX "idx_domains_status_type" ON "domains" ("status","type"); - - - -CREATE TABLE "records" ( - "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - "domain_id" INTEGER NOT NULL, - "name" VARCHAR(255) NOT NULL, - "type" VARCHAR(6) NOT NULL, - "ttl" INTEGER DEFAULT NULL, - "prio" INTEGER DEFAULT NULL, - "content" VARCHAR(255) NOT NULL, - "change_date" INTEGER DEFAULT NULL, -CONSTRAINT "fk_records_domainid" - FOREIGN KEY ("domain_id") - REFERENCES "domains" ("id") - ON UPDATE CASCADE - ON DELETE CASCADE -); - -CREATE INDEX "idx_records_name_type" ON "records" ("name","type"); -CREATE INDEX "idx_records_type" ON "records" ("type"); - - - -CREATE TABLE "supermasters" ( - "ip" VARCHAR(40) NOT NULL, - "nameserver" VARCHAR(255) NOT NULL, - "account" VARCHAR(40) NOT NULL DEFAULT '' -); - -CREATE INDEX "idx_smip_smns" ON "supermasters" ("ip","nameserver"); - - - -GRANT SELECT ON "supermasters" TO "powerdns"; -GRANT ALL ON "domains" TO "powerdns"; -GRANT ALL ON "records" TO "powerdns"; -- 2.40.0