[vhffs-dev] [498] Oops ;)

[subversion@xxxxxxxxx]

Revision: 498
Author:   gradator
Date:     2007-02-28 12:46:44 +0000 (Wed, 28 Feb 2007)

Log Message:
-----------
Oops ;)

Modified Paths:
--------------
    branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql


Modified: branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql
===================================================================
--- branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql	2007-02-24 21:26:56 UTC (rev 497)
+++ branches/vhffs_4.1/vhffs-backend/src/pgsql/initdb.sql	2007-02-28 12:46:44 UTC (rev 498)
@@ -128,7 +128,7 @@
 	expire INTEGER NOT NULL DEFAULT 604800,
 	minimum INTEGER NOT NULL DEFAULT 86400,
 	ttl INTEGER NOT NULL DEFAULT 86400,
-	CONSTRAINT vhffs_dns_pkey4 PRIMARY KEY (id)
+	CONSTRAINT vhffs_dns_pkey4 PRIMARY KEY (dns_id)
 ) WITH OIDS;
 
 CREATE TABLE vhffs_dns_rr (
@@ -324,7 +324,7 @@
 ALTER TABLE vhffs_dns ADD CONSTRAINT fk_vhffs_dns_vhffs_groups FOREIGN KEY (owner_gid) REFERENCES vhffs_groups(gid);
 ALTER TABLE vhffs_dns ADD CONSTRAINT fk_vhffs_dns_vhffs_object FOREIGN KEY (object_id) REFERENCES vhffs_object(object_id) ON DELETE CASCADE;
 
-ALTER TABLE vhffs_dns_rr ADD CONSTRAINT fk_vhffs_dns_rr_vhffs_dns FOREIGN KEY (zone) REFERENCES vhffs_dns(id) ON DELETE CASCADE;
+ALTER TABLE vhffs_dns_rr ADD CONSTRAINT fk_vhffs_dns_rr_vhffs_dns FOREIGN KEY (zone) REFERENCES vhffs_dns(dns_id) ON DELETE CASCADE;
 ALTER TABLE vhffs_dns_rr ADD CONSTRAINT fk_vhffs_dns_rr_chk_type CHECK (type='A' OR type='AAAA' OR type='CNAME' OR type='HINFO' OR type='MX' OR type='NS' OR type='PTR' OR type='RP' OR type='SRV' OR type='TXT');
 
 ALTER TABLE vhffs_httpd ADD CONSTRAINT fk_vhffs_httpd_vhffs_users FOREIGN KEY (owner_uid) REFERENCES vhffs_users(uid);