Changeset 369 for trunk

Timestamp:

07/27/12 14:01:37 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Fix up a minor SQL issue - missing an FK constraint on revzones.group_id

Location:

trunk

Files:

• dns-1.0-1.2.sql (modified) (1 diff)
• dns.sql (modified) (1 diff)

trunk/dns-1.0-1.2.sql

@@ -41 +41 @@
 );
 CREATE INDEX rev_status_index ON revzones (status);
+
+ALTER TABLE ONLY revzones
+    ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);
 
 ALTER TABLE log ADD COLUMN rdns_id INTEGER;

trunk/dns.sql

@@ -292 +292 @@
     ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);
 
+ALTER TABLE ONLY revzones
+    ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);
+
 ALTER TABLE ONLY default_records
     ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);