Changeset 369 for trunk/dns.sql

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

File:

• trunk/dns.sql (modified) (1 diff)

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);