Project

General

Profile

Revision cd3908b7

IDcd3908b741aeb1b75ccd3ce17cd50e912178cf8a
Parent 4349acec
Child 94ff3012

Added by Andreas Müller over 8 years ago

update tests for rename states to stateData #2923

View differences:

cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
1315 1315
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD;
1316 1316
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(
1317 1317
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1318
    STATES_ID INTEGER NOT NULL
1318
    STATEDATA_ID INTEGER NOT NULL
1319 1319
);
1320 1320
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA;
1321 1321
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(
1322 1322
    REV INTEGER NOT NULL,
1323 1323
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1324
    STATES_ID INTEGER NOT NULL,
1324
    STATEDATA_ID INTEGER NOT NULL,
1325 1325
    REVTYPE TINYINT
1326 1326
);
1327 1327
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD;
......
4731 4731
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_48 PRIMARY KEY(ID, REV);
4732 4732
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BB PRIMARY KEY(COLLECTION_ID, EXTENSIONS_ID);
4733 4733
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B3 PRIMARY KEY(REV, FEATURENODE_ID, INAPPLICABLEIF_ID);
4734
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATES_ID);
4734
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID);
4735 4735
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_B1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);
4736 4736
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_B6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);
4737 4737
ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_B7 PRIMARY KEY(POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);
......
5240 5240
ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5241 5241
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5242 5242
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
5243
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATES_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5243
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5244 5244
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5245 5245
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5246 5246
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
cdmlib-io/src/test/resources/dbscripts/001-cdm.h2.sql
1315 1315
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD;
1316 1316
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(
1317 1317
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1318
    STATES_ID INTEGER NOT NULL
1318
    STATEDATA_ID INTEGER NOT NULL
1319 1319
);
1320 1320
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA;
1321 1321
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(
1322 1322
    REV INTEGER NOT NULL,
1323 1323
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1324
    STATES_ID INTEGER NOT NULL,
1324
    STATEDATA_ID INTEGER NOT NULL,
1325 1325
    REVTYPE TINYINT
1326 1326
);
1327 1327
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD;
......
4731 4731
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_48 PRIMARY KEY(ID, REV);
4732 4732
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BB PRIMARY KEY(COLLECTION_ID, EXTENSIONS_ID);
4733 4733
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B3 PRIMARY KEY(REV, FEATURENODE_ID, INAPPLICABLEIF_ID);
4734
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATES_ID);
4734
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID);
4735 4735
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_B1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);
4736 4736
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_B6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);
4737 4737
ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_B7 PRIMARY KEY(POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);
......
5240 5240
ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5241 5241
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5242 5242
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
5243
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATES_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5243
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5244 5244
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5245 5245
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5246 5246
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
cdmlib-persistence/src/test/resources/dbscripts/001-cdm.h2.sql
1315 1315
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD;
1316 1316
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(
1317 1317
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1318
    STATES_ID INTEGER NOT NULL
1318
    STATEDATA_ID INTEGER NOT NULL
1319 1319
);
1320 1320
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA;
1321 1321
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(
1322 1322
    REV INTEGER NOT NULL,
1323 1323
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1324
    STATES_ID INTEGER NOT NULL,
1324
    STATEDATA_ID INTEGER NOT NULL,
1325 1325
    REVTYPE TINYINT
1326 1326
);
1327 1327
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD;
......
4731 4731
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_48 PRIMARY KEY(ID, REV);
4732 4732
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BB PRIMARY KEY(COLLECTION_ID, EXTENSIONS_ID);
4733 4733
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B3 PRIMARY KEY(REV, FEATURENODE_ID, INAPPLICABLEIF_ID);
4734
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATES_ID);
4734
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID);
4735 4735
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_B1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);
4736 4736
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_B6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);
4737 4737
ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_B7 PRIMARY KEY(POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);
......
5240 5240
ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5241 5241
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5242 5242
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
5243
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATES_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5243
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5244 5244
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5245 5245
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5246 5246
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
cdmlib-persistence/src/test/resources/eu/etaxonomy/cdm/persistence/dao/hibernate/dataset.dtd
1346 1346
<!ELEMENT DESCRIPTIONELEMENTBASE_STATEDATA EMPTY>
1347 1347
<!ATTLIST DESCRIPTIONELEMENTBASE_STATEDATA
1348 1348
    DESCRIPTIONELEMENTBASE_ID CDATA #IMPLIED
1349
    STATES_ID CDATA #IMPLIED
1349
    STATEDATA_ID CDATA #IMPLIED
1350 1350
>
1351 1351

  
1352 1352
<!ELEMENT DESCRIPTIONELEMENTBASE_STATEDATA_AUD EMPTY>
1353 1353
<!ATTLIST DESCRIPTIONELEMENTBASE_STATEDATA_AUD
1354 1354
    REV CDATA #REQUIRED
1355 1355
    DESCRIPTIONELEMENTBASE_ID CDATA #REQUIRED
1356
    STATES_ID CDATA #REQUIRED
1356
    STATEDATA_ID CDATA #REQUIRED
1357 1357
    REVTYPE CDATA #IMPLIED
1358 1358
>
1359 1359

  
cdmlib-persistence/src/test/resources/eu/etaxonomy/cdm/persistence/dao/hibernate/description/DescriptionElementDaoHibernateImplTest.testSaveCategoricalData-result.xml
1 1
<?xml version='1.0' encoding='UTF-8'?>
2 2
<dataset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../dataset.xsd">
3 3
  <DESCRIPTIONELEMENTBASE DTYPE="CategoricalData" UUID="5c3f2340-f675-4d50-af96-89a2a12993b8" ORDERRELEVANT="false" FEATURE_ID="936"/>
4
  <DESCRIPTIONELEMENTBASE_STATEDATA DESCRIPTIONELEMENTBASE_ID="1000 " STATES_ID="1001"/>
4
  <DESCRIPTIONELEMENTBASE_STATEDATA DESCRIPTIONELEMENTBASE_ID="1000 " STATEDATA_ID="1001"/>
5 5
  <STATEDATA_DEFINEDTERMBASE/>
6 6
  <STATEDATA UUID="04b9190d-d4ab-4c3a-8dec-8293dc820ddc"/>
7 7
  <STATEDATA_LANGUAGESTRING STATEDATA_ID="1002" MODIFYINGTEXT_ID="406"/>
cdmlib-services/src/test/resources/dbscripts/001-cdm.h2.sql
1315 1315
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD;
1316 1316
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(
1317 1317
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1318
    STATES_ID INTEGER NOT NULL
1318
    STATEDATA_ID INTEGER NOT NULL
1319 1319
);
1320 1320
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA;
1321 1321
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(
1322 1322
    REV INTEGER NOT NULL,
1323 1323
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1324
    STATES_ID INTEGER NOT NULL,
1324
    STATEDATA_ID INTEGER NOT NULL,
1325 1325
    REVTYPE TINYINT
1326 1326
);
1327 1327
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD;
......
4731 4731
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_48 PRIMARY KEY(ID, REV);
4732 4732
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BB PRIMARY KEY(COLLECTION_ID, EXTENSIONS_ID);
4733 4733
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B3 PRIMARY KEY(REV, FEATURENODE_ID, INAPPLICABLEIF_ID);
4734
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATES_ID);
4734
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID);
4735 4735
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_B1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);
4736 4736
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_B6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);
4737 4737
ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_B7 PRIMARY KEY(POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);
......
5240 5240
ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5241 5241
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5242 5242
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
5243
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATES_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5243
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5244 5244
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5245 5245
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5246 5246
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)