Changeset 369 for trunk/dns-1.0-1.2.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-1.0-1.2.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;