Changeset 1514

Timestamp:

12/09/06 14:58:44 (14 years ago)

Author:

aharwood

Message:

Corrected syntax

File:

• TI07-MOLES/trunk/RDBMS/Postgres/basicbuildscripts/inst_level_0/inst_level_1/inst_level_2/inst_level_3/inst_level_4/tbl_metadata_record_coverages_box.sql (modified) (1 diff)

TI07-MOLES/trunk/RDBMS/Postgres/basicbuildscripts/inst_level_0/inst_level_1/inst_level_2/inst_level_3/inst_level_4/tbl_metadata_record_coverages_box.sql

@@ -12 +12 @@
      FOREIGN KEY (fld_data_provider_local_id, fld_data_provider_id) 
      REFERENCES ndgb.tbl_metadata_records (fld_data_provider_local_id, fld_data_provider_id) 
-     ON UPDATE RESTRICT ON DELETE RESTRICT
+     ON UPDATE RESTRICT ON DELETE RESTRICT,
   CONSTRAINT fk_metadata_record_coverages_box_general_terms 
     FOREIGN KEY (fld_term_namespace, fld_term_id) 
     REFERENCES ndgb.tbl_general_terms (fld_term_namespace, fld_term_id) 
     ON UPDATE RESTRICT ON DELETE RESTRICT
-) 
+) INHERITS (ndgb.tbl_metadata_record_coverages)
   WITHOUT OIDS;