Changeset 369 for trunk


Ignore:
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:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/dns-1.0-1.2.sql

    r368 r369  
    4141);
    4242CREATE INDEX rev_status_index ON revzones (status);
     43
     44ALTER TABLE ONLY revzones
     45    ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);
    4346
    4447ALTER TABLE log ADD COLUMN rdns_id INTEGER;
  • trunk/dns.sql

    r366 r369  
    292292    ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);
    293293
     294ALTER TABLE ONLY revzones
     295    ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);
     296
    294297ALTER TABLE ONLY default_records
    295298    ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id);
Note: See TracChangeset for help on using the changeset viewer.