Project

General

Profile

« Previous | Next » 

Revision 85ae680a

Added by Andreas Müller over 12 years ago

synchronize dlls and dtds for tests

View differences:

cdmlib-ext/src/test/resources/dbscripts/001_cdm.ddl
1

  
2
    create table Address (
1
	create table Address (
3 2
        id integer not null,
4 3
        created timestamp,
5
        uuid varchar(255),
4
        uuid varchar(36),
6 5
        updated timestamp,
7 6
        locality varchar(255),
8 7
        location_errorradius integer,
......
16 15
        updatedby_id integer,
17 16
        country_id integer,
18 17
        location_referencesystem_id integer,
19
        primary key (id)
18
        primary key (id),
19
        unique (uuid)
20 20
    );
21 21

  
22 22
    create table Address_AUD (
......
24 24
        REV integer not null,
25 25
        revtype tinyint,
26 26
        created timestamp,
27
        uuid varchar(255),
27
        uuid varchar(36),
28 28
        updated timestamp,
29 29
        locality varchar(255),
30 30
        location_errorradius integer,
......
45 45
        DTYPE varchar(31) not null,
46 46
        id integer not null,
47 47
        created timestamp,
48
        uuid varchar(255),
48
        uuid varchar(36),
49 49
        updated timestamp,
50 50
        lsid_authority varchar(255),
51 51
        lsid_lsid varchar(255),
......
60 60
        firstname varchar(255),
61 61
        lastname varchar(255),
62 62
        lifespan_end varchar(255),
63
        lifespan_freetext varchar(255),
63 64
        lifespan_start varchar(255),
64
        lifespan_freetext varchar(30),
65 65
        prefix varchar(255),
66 66
        suffix varchar(255),
67 67
        protectednomenclaturaltitlecache bit,
68 68
        createdby_id integer,
69 69
        updatedby_id integer,
70 70
        ispartof_id integer,
71
        primary key (id)
71
        primary key (id),
72
        unique (uuid)
72 73
    );
73 74

  
74 75
    create table AgentBase_AUD (
......
77 78
        REV integer not null,
78 79
        revtype tinyint,
79 80
        created timestamp,
80
        uuid varchar(255),
81
        uuid varchar(36),
81 82
        updated timestamp,
82 83
        lsid_authority varchar(255),
83 84
        lsid_lsid varchar(255),
......
92 93
        name varchar(255),
93 94
        ispartof_id integer,
94 95
        nomenclaturaltitle varchar(255),
95
        protectednomenclaturaltitlecache bit,
96 96
        firstname varchar(255),
97 97
        lastname varchar(255),
98 98
        lifespan_end varchar(255),
99
        lifespan_freetext varchar(255),
99 100
        lifespan_start varchar(255),
100
        lifespan_freetext varchar(30),
101 101
        prefix varchar(255),
102 102
        suffix varchar(255),
103
        protectednomenclaturaltitlecache bit,
103 104
        primary key (id, REV)
104 105
    );
105 106

  
......
309 310
    create table Annotation (
310 311
        id integer not null,
311 312
        created timestamp,
312
        uuid varchar(255),
313
        uuid varchar(36),
313 314
        updated timestamp,
314 315
        text longvarchar,
315 316
        annotatedObj_type varchar(255),
......
320 321
        language_id integer,
321 322
        annotationtype_id integer,
322 323
        commentator_id integer,
323
        primary key (id)
324
        primary key (id),
325
        unique (uuid)
324 326
    );
325 327

  
326 328
    create table Annotation_AUD (
......
328 330
        REV integer not null,
329 331
        revtype tinyint,
330 332
        created timestamp,
331
        uuid varchar(255),
333
        uuid varchar(36),
332 334
        updated timestamp,
333 335
        text longvarchar,
334 336
        linkbackurl varbinary(255),
......
381 383
    create table CDM_VIEW (
382 384
        id integer not null,
383 385
        created timestamp,
384
        uuid varchar(255),
386
        uuid varchar(36),
385 387
        description varchar(255),
386 388
        name varchar(255),
387 389
        createdby_id integer,
388 390
        reference_id integer,
389
        primary key (id)
391
        primary key (id),
392
        unique (uuid)
390 393
    );
391 394

  
392 395
    create table CDM_VIEW_CDM_VIEW (
......
396 399
        unique (superviews_id)
397 400
    );
398 401
    
399
        create table Classification (
402
    
403
    create table Classification (
400 404
        id integer not null,
401 405
        created timestamp,
402
        uuid varchar(255),
406
        uuid varchar(36),
403 407
        updated timestamp,
404 408
        lsid_authority varchar(255),
405 409
        lsid_lsid varchar(255),
......
413 417
        updatedby_id integer,
414 418
        name_id integer,
415 419
        reference_id integer,
416
        primary key (id)
420
        primary key (id),
421
        unique (uuid)
417 422
    );
418 423

  
419 424
    create table Classification_AUD (
......
421 426
        REV integer not null,
422 427
        revtype tinyint,
423 428
        created timestamp,
424
        uuid varchar(255),
429
        uuid varchar(36),
425 430
        updated timestamp,
426 431
        lsid_authority varchar(255),
427 432
        lsid_lsid varchar(255),
......
545 550
        primary key (REV, Classification_id, rootnodes_id)
546 551
    );
547 552

  
553

  
548 554
    create table Collection (
549 555
        id integer not null,
550 556
        created timestamp,
551
        uuid varchar(255),
557
        uuid varchar(36),
552 558
        updated timestamp,
553 559
        lsid_authority varchar(255),
554 560
        lsid_lsid varchar(255),
......
565 571
        updatedby_id integer,
566 572
        institute_id integer,
567 573
        supercollection_id integer,
568
        primary key (id)
574
        primary key (id),
575
        unique (uuid)
569 576
    );
570 577

  
571 578
    create table Collection_AUD (
......
573 580
        REV integer not null,
574 581
        revtype tinyint,
575 582
        created timestamp,
576
        uuid varchar(255),
583
        uuid varchar(36),
577 584
        updated timestamp,
578 585
        lsid_authority varchar(255),
579 586
        lsid_lsid varchar(255),
......
702 709
    create table Credit (
703 710
        id integer not null,
704 711
        created timestamp,
705
        uuid varchar(255),
712
        uuid varchar(36),
706 713
        updated timestamp,
707 714
        text longvarchar,
708 715
        abbreviatedtext varchar(255),
......
710 717
        updatedby_id integer,
711 718
        language_id integer,
712 719
        agent_id integer,
713
        primary key (id)
720
        primary key (id),
721
        unique (uuid)
714 722
    );
715 723

  
716 724
    create table Credit_AUD (
......
718 726
        REV integer not null,
719 727
        revtype tinyint,
720 728
        created timestamp,
721
        uuid varchar(255),
729
        uuid varchar(36),
722 730
        updated timestamp,
723 731
        text longvarchar,
724 732
        abbreviatedtext varchar(255),
......
763 771
        DTYPE varchar(31) not null,
764 772
        id integer not null,
765 773
        created timestamp,
766
		protectedtitlecache bit not null,
767
        titleCache varchar(255),
768
        uuid varchar(255),
774
        uuid varchar(36),
769 775
        updated timestamp,
776
        lsid_authority varchar(255),
777
        lsid_lsid varchar(255),
778
        lsid_namespace varchar(255),
779
        lsid_object varchar(255),
780
        lsid_revision varchar(255),
781
        protectedtitlecache bit not null,
782
        titleCache varchar(255),
770 783
        uri varchar(255),
771
        orderindex integer,
772 784
        iso639_1 varchar(2),
773 785
        iso639_2 varchar(3),
786
        istechnical bit,
787
        orderindex integer,
774 788
        symmetrical bit,
775 789
        transitive bit,
776 790
        defaultcolor varchar(255),
......
785 799
        pointapproximation_latitude double,
786 800
        pointapproximation_longitude double,
787 801
        validperiod_end varchar(255),
802
        validperiod_freetext varchar(255),
788 803
        validperiod_start varchar(255),
789
        validperiod_freetext varchar(30),
790 804
        iso3166_a2 varchar(2),
791
		isTechnical bit,
792
		createdby_id integer,
805
        createdby_id integer,
793 806
        updatedby_id integer,
794 807
        kindof_id integer,
795 808
        partof_id integer,
......
798 811
        pointapproximation_referencesystem_id integer,
799 812
        shape_id integer,
800 813
        type_id integer,
801
		lsid_authority varchar(255),
802
        lsid_lsid varchar(255),
803
        lsid_namespace varchar(255),
804
        lsid_object varchar(255),
805
        lsid_revision varchar(255),
806
        primary key (id)
814
        primary key (id),
815
        unique (uuid)
807 816
    );
808 817

  
809 818
    create table DefinedTermBase_AUD (
......
812 821
        REV integer not null,
813 822
        revtype tinyint,
814 823
        created timestamp,
815
		protectedtitlecache bit not null,
816
        titleCache varchar(255),
817
        uuid varchar(255),
824
        uuid varchar(36),
818 825
        updated timestamp,
826
        lsid_authority varchar(255),
827
        lsid_lsid varchar(255),
828
        lsid_namespace varchar(255),
829
        lsid_object varchar(255),
830
        lsid_revision varchar(255),
831
        protectedtitlecache bit,
832
        titleCache varchar(255),
819 833
        uri varchar(255),
820 834
        createdby_id integer,
821 835
        updatedby_id integer,
822 836
        kindof_id integer,
823 837
        partof_id integer,
824 838
        vocabulary_id integer,
839
        istechnical bit,
825 840
        orderindex integer,
826 841
        iso639_1 varchar(2),
827 842
        iso639_2 varchar(3),
828
        supportscategoricaldata bit,
829
        supportscommontaxonname bit,
830
        supportsdistribution bit,
831
        supportsindividualassociation bit,
832
        supportsquantitativedata bit,
833
        supportstaxoninteraction bit,
834
        supportstextdata bit,
835
        defaultcolor varchar(255),
843
        symmetrical bit,
844
        transitive bit,
836 845
        pointapproximation_errorradius integer,
837 846
        pointapproximation_latitude double,
838 847
        pointapproximation_longitude double,
839 848
        validperiod_end varchar(255),
849
        validperiod_freetext varchar(255),
840 850
        validperiod_start varchar(255),
841
        validperiod_freetext varchar(30),
842 851
        level_id integer,
843 852
        pointapproximation_referencesystem_id integer,
844 853
        shape_id integer,
845 854
        type_id integer,
846 855
        iso3166_a2 varchar(2),
847
		isTechnical bit,
848
		symmetrical bit,
849
        transitive bit,
850
		lsid_authority varchar(255),
851
        lsid_lsid varchar(255),
852
        lsid_namespace varchar(255),
853
        lsid_object varchar(255),
854
        lsid_revision varchar(255),
856
        defaultcolor varchar(255),
857
        supportscategoricaldata bit,
858
        supportscommontaxonname bit,
859
        supportsdistribution bit,
860
        supportsindividualassociation bit,
861
        supportsquantitativedata bit,
862
        supportstaxoninteraction bit,
863
        supportstextdata bit,
855 864
        primary key (id, REV)
856 865
    );
857 866

  
867
    create table DefinedTermBase_Annotation (
868
        DefinedTermBase_id integer not null,
869
        annotations_id integer not null,
870
        primary key (DefinedTermBase_id, annotations_id),
871
        unique (annotations_id)
872
    );
873

  
874
    create table DefinedTermBase_Annotation_AUD (
875
        REV integer not null,
876
        DefinedTermBase_id integer not null,
877
        annotations_id integer not null,
878
        revtype tinyint,
879
        primary key (REV, DefinedTermBase_id, annotations_id)
880
    );
881

  
858 882
    create table DefinedTermBase_Continent (
859 883
        DefinedTermBase_id integer not null,
860 884
        continents_id integer not null,
......
869 893
        primary key (REV, DefinedTermBase_id, continents_id)
870 894
    );
871 895

  
872
    create table DefinedTermBase_Annotation(
896
    create table DefinedTermBase_Credit (
873 897
        DefinedTermBase_id integer not null,
874
        annotations_id integer not null,
875
        primary key (DefinedTermBase_id, annotations_id)
898
        credits_id integer not null,
899
        sortIndex integer not null,
900
        primary key (DefinedTermBase_id, sortIndex),
901
        unique (credits_id)
876 902
    );
877 903

  
878
    create table DefinedTermBase_Annotation_AUD (
904
    create table DefinedTermBase_Credit_AUD (
879 905
        REV integer not null,
880 906
        DefinedTermBase_id integer not null,
881
        annotations_id integer not null,
907
        credits_id integer not null,
908
        sortIndex integer not null,
882 909
        revtype tinyint,
883
        primary key (REV, DefinedTermBase_id, annotations_id)
910
        primary key (REV, DefinedTermBase_id, credits_id, sortIndex)
884 911
    );
885 912

  
886 913
    create table DefinedTermBase_Extension (
887 914
        DefinedTermBase_id integer not null,
888 915
        extensions_id integer not null,
889
        primary key (DefinedTermBase_id, extensions_id)
916
        primary key (DefinedTermBase_id, extensions_id),
917
        unique (extensions_id)
890 918
    );
891 919

  
892 920
    create table DefinedTermBase_Extension_AUD (
......
897 925
        primary key (REV, DefinedTermBase_id, extensions_id)
898 926
    );
899 927

  
900
	create table DefinedTermBase_Marker(
928
    create table DefinedTermBase_Marker (
901 929
        DefinedTermBase_id integer not null,
902 930
        markers_id integer not null,
903
        primary key (DefinedTermBase_id, markers_id)
931
        primary key (DefinedTermBase_id, markers_id),
932
        unique (markers_id)
904 933
    );
905 934

  
906 935
    create table DefinedTermBase_Marker_AUD (
......
940 969
        primary key (REV, DefinedTermBase_id, media_id)
941 970
    );
942 971

  
943
	create table DefinedTermBase_OriginalSourceBase(
944
	    DefinedTermBase_id integer not null,
972
    create table DefinedTermBase_OriginalSourceBase (
973
        DefinedTermBase_id integer not null,
945 974
        sources_id integer not null,
946 975
        primary key (DefinedTermBase_id, sources_id),
947 976
        unique (sources_id)
......
988 1017
    create table DefinedTermBase_Rights (
989 1018
        DefinedTermBase_id integer not null,
990 1019
        rights_id integer not null,
991
        primary key (DefinedTermBase_id, rights_id)
1020
        primary key (DefinedTermBase_id, rights_id),
1021
        unique (rights_id)
992 1022
    );
993 1023

  
994 1024
    create table DefinedTermBase_Rights_AUD (
......
1045 1075
    create table DerivationEvent (
1046 1076
        id integer not null,
1047 1077
        created timestamp,
1048
        uuid varchar(255),
1078
        uuid varchar(36),
1049 1079
        updated timestamp,
1050 1080
        description varchar(255),
1051 1081
        timeperiod_end varchar(255),
1082
        timeperiod_freetext varchar(255),
1052 1083
        timeperiod_start varchar(255),
1053
        timeperiod_freetext varchar(30),
1054 1084
        createdby_id integer,
1055 1085
        updatedby_id integer,
1056 1086
        actor_id integer,
1057 1087
        type_id integer,
1058
        primary key (id)
1088
        primary key (id),
1089
        unique (uuid)
1059 1090
    );
1060 1091

  
1061 1092
    create table DerivationEvent_AUD (
......
1063 1094
        REV integer not null,
1064 1095
        revtype tinyint,
1065 1096
        created timestamp,
1066
        uuid varchar(255),
1097
        uuid varchar(36),
1067 1098
        updated timestamp,
1068 1099
        description varchar(255),
1069 1100
        timeperiod_end varchar(255),
1101
        timeperiod_freetext varchar(255),
1070 1102
        timeperiod_start varchar(255),
1071
        timeperiod_freetext varchar(30),
1072 1103
        createdby_id integer,
1073 1104
        updatedby_id integer,
1074 1105
        actor_id integer,
......
1110 1141
        DTYPE varchar(31) not null,
1111 1142
        id integer not null,
1112 1143
        created timestamp,
1113
        uuid varchar(255),
1144
        uuid varchar(36),
1114 1145
        updated timestamp,
1115 1146
        lsid_authority varchar(255),
1116 1147
        lsid_lsid varchar(255),
......
1123 1154
        createdby_id integer,
1124 1155
        updatedby_id integer,
1125 1156
        taxon_id integer,
1126
        taxonName_id integer,
1127
        primary key (id)
1157
        taxonname_id integer,
1158
        primary key (id),
1159
        unique (uuid)
1128 1160
    );
1129 1161

  
1130 1162
    create table DescriptionBase_AUD (
......
1133 1165
        REV integer not null,
1134 1166
        revtype tinyint,
1135 1167
        created timestamp,
1136
        uuid varchar(255),
1168
        uuid varchar(36),
1137 1169
        updated timestamp,
1138 1170
        lsid_authority varchar(255),
1139 1171
        lsid_lsid varchar(255),
......
1146 1178
        createdby_id integer,
1147 1179
        updatedby_id integer,
1148 1180
        taxon_id integer,
1149
        taxonName_id integer,
1181
        taxonname_id integer,
1150 1182
        primary key (id, REV)
1151 1183
    );
1152 1184

  
......
1316 1348
        DTYPE varchar(31) not null,
1317 1349
        id integer not null,
1318 1350
        created timestamp,
1319
        uuid varchar(255),
1351
        uuid varchar(36),
1320 1352
        updated timestamp,
1321
        citationmicroreference varchar(255),
1322
        originalnamestring varchar(255),
1323 1353
        orderrelevant bit,
1324 1354
        name varchar(255),
1325 1355
        createdby_id integer,
1326 1356
        updatedby_id integer,
1327
        citation_id integer,
1328 1357
        feature_id integer,
1329 1358
        indescription_id integer,
1330
        nameusedinreference_id integer,
1331 1359
        language_id integer,
1332 1360
        area_id integer,
1333 1361
        status_id integer,
......
1335 1363
        unit_id integer,
1336 1364
        taxon2_id integer,
1337 1365
        format_id integer,
1338
        primary key (id)
1366
        primary key (id),
1367
        unique (uuid)
1339 1368
    );
1340 1369

  
1341 1370
    create table DescriptionElementBase_AUD (
......
1344 1373
        REV integer not null,
1345 1374
        revtype tinyint,
1346 1375
        created timestamp,
1347
        uuid varchar(255),
1376
        uuid varchar(36),
1348 1377
        updated timestamp,
1349
        citationmicroreference varchar(255),
1350
        originalnamestring varchar(255),
1351 1378
        createdby_id integer,
1352 1379
        updatedby_id integer,
1353
        citation_id integer,
1354 1380
        feature_id integer,
1355 1381
        indescription_id integer,
1356
        nameusedinreference_id integer,
1357
        format_id integer,
1358
        taxon2_id integer,
1359
        unit_id integer,
1360
        associatedspecimenorobservation_id integer,
1361 1382
        orderrelevant bit,
1383
        associatedspecimenorobservation_id integer,
1362 1384
        name varchar(255),
1363 1385
        language_id integer,
1386
        taxon2_id integer,
1364 1387
        area_id integer,
1365 1388
        status_id integer,
1389
        unit_id integer,
1390
        format_id integer,
1366 1391
        primary key (id, REV)
1367 1392
    );
1368 1393

  
......
1417 1442
        DescriptionElementBase_id integer not null,
1418 1443
        media_id integer not null,
1419 1444
        sortIndex integer not null,
1420
        primary key (DescriptionElementBase_id, media_id)
1445
        primary key (DescriptionElementBase_id, sortIndex)
1421 1446
    );
1422 1447

  
1423 1448
    create table DescriptionElementBase_Media_AUD (
......
1426 1451
        media_id integer not null,
1427 1452
        sortIndex integer not null,
1428 1453
        revtype tinyint,
1429
        primary key (REV, DescriptionElementBase_id, media_id)
1454
        primary key (REV, DescriptionElementBase_id, media_id, sortIndex)
1430 1455
    );
1431 1456

  
1432 1457
    create table DescriptionElementBase_Modifier (
......
1506 1531
    create table DeterminationEvent (
1507 1532
        id integer not null,
1508 1533
        created timestamp,
1509
        uuid varchar(255),
1534
        uuid varchar(36),
1510 1535
        updated timestamp,
1511 1536
        description varchar(255),
1512 1537
        timeperiod_end varchar(255),
1538
        timeperiod_freetext varchar(255),
1513 1539
        timeperiod_start varchar(255),
1514
        timeperiod_freetext varchar(30),
1515 1540
        preferredflag bit not null,
1516 1541
        createdby_id integer,
1517 1542
        updatedby_id integer,
......
1519 1544
        identifiedunit_id integer,
1520 1545
        modifier_id integer,
1521 1546
        taxon_id integer,
1522
        primary key (id)
1547
        primary key (id),
1548
        unique (uuid)
1523 1549
    );
1524 1550

  
1525 1551
    create table DeterminationEvent_AUD (
......
1527 1553
        REV integer not null,
1528 1554
        revtype tinyint,
1529 1555
        created timestamp,
1530
        uuid varchar(255),
1556
        uuid varchar(36),
1531 1557
        updated timestamp,
1532 1558
        description varchar(255),
1533 1559
        timeperiod_end varchar(255),
1560
        timeperiod_freetext varchar(255),
1534 1561
        timeperiod_start varchar(255),
1535
        timeperiod_freetext varchar(30),
1536 1562
        preferredflag bit,
1537 1563
        createdby_id integer,
1538 1564
        updatedby_id integer,
......
1590 1616
    create table Extension (
1591 1617
        id integer not null,
1592 1618
        created timestamp,
1593
        uuid varchar(255),
1619
        uuid varchar(36),
1594 1620
        updated timestamp,
1595 1621
        extendedObj_type varchar(255),
1596 1622
        extendedObj_id integer not null,
1597
        value varchar(255),
1623
        value longvarchar,
1598 1624
        createdby_id integer,
1599 1625
        updatedby_id integer,
1600 1626
        type_id integer,
1601
        primary key (id)
1627
        primary key (id),
1628
        unique (uuid)
1602 1629
    );
1603 1630

  
1604 1631
    create table Extension_AUD (
......
1606 1633
        REV integer not null,
1607 1634
        revtype tinyint,
1608 1635
        created timestamp,
1609
        uuid varchar(255),
1636
        uuid varchar(36),
1610 1637
        updated timestamp,
1611
        value varchar(255),
1638
        value longvarchar,
1612 1639
        createdby_id integer,
1613 1640
        updatedby_id integer,
1614 1641
        type_id integer,
......
1618 1645
    create table FeatureNode (
1619 1646
        id integer not null,
1620 1647
        created timestamp,
1621
        uuid varchar(255),
1648
        uuid varchar(36),
1622 1649
        updated timestamp,
1623 1650
        createdby_id integer,
1624 1651
        updatedby_id integer,
1625 1652
        featureTree_id integer not null,
1626 1653
        feature_id integer,
1627 1654
        parent_id integer,
1628
	primary key (id)
1655
        primary key (id),
1656
        unique (uuid)
1629 1657
    );
1630 1658

  
1631 1659
    create table FeatureNode_AUD (
......
1633 1661
        REV integer not null,
1634 1662
        revtype tinyint,
1635 1663
        created timestamp,
1636
        uuid varchar(255),
1664
        uuid varchar(36),
1637 1665
        updated timestamp,
1638 1666
        createdby_id integer,
1639 1667
        updatedby_id integer,
1640
        featureTree_id integer not null,
1668
       	featureTree_id integer not null,
1641 1669
        feature_id integer,
1642 1670
        parent_id integer,
1643 1671
        primary key (id, REV)
1644 1672
    );
1645 1673

  
1646
    create table FeatureNode_DefinedTermBase_OnlyApplicable (
1674
    create table FeatureNode_DefinedTermBase_InapplicableIf (
1647 1675
        FeatureNode_id integer not null,
1648
        OnlyApplicable_id integer not null,
1649
        primary key (FeatureNode_id, OnlyApplicable_id)
1676
        inapplicableif_id integer not null,
1677
        primary key (FeatureNode_id, inapplicableif_id)
1650 1678
    );
1651 1679

  
1652
    create table FeatureNode_DefinedTermBase_OnlyApplicable_AUD (
1680
    create table FeatureNode_DefinedTermBase_InapplicableIf_AUD (
1653 1681
        REV integer not null,
1654 1682
        FeatureNode_id integer not null,
1655
        OnlyApplicable_id integer not null,
1683
        inapplicableif_id integer not null,
1656 1684
        revtype tinyint,
1657
        primary key (REV, FeatureNode_id, OnlyApplicable_id)
1685
        primary key (REV, FeatureNode_id, inapplicableif_id)
1658 1686
    );
1659 1687

  
1660
    create table FeatureNode_DefinedTermBase_InapplicableIf (
1688
    create table FeatureNode_DefinedTermBase_OnlyApplicable (
1661 1689
        FeatureNode_id integer not null,
1662
        InapplicableIf_id integer not null,
1663
        primary key (FeatureNode_id, InapplicableIf_id)
1690
        onlyapplicableif_id integer not null,
1691
        primary key (FeatureNode_id, onlyapplicableif_id)
1664 1692
    );
1665 1693

  
1666
    create table FeatureNode_DefinedTermBase_InapplicableIf_AUD (
1694
    create table FeatureNode_DefinedTermBase_OnlyApplicable_AUD (
1667 1695
        REV integer not null,
1668 1696
        FeatureNode_id integer not null,
1669
        InapplicableIf_id integer not null,
1697
        onlyapplicableif_id integer not null,
1670 1698
        revtype tinyint,
1671
        primary key (REV, FeatureNode_id, InapplicableIf_id)
1699
        primary key (REV, FeatureNode_id, onlyapplicableif_id)
1672 1700
    );
1673 1701

  
1674 1702
    create table FeatureTree (
1675 1703
        id integer not null,
1676 1704
        created timestamp,
1677
        uuid varchar(255),
1705
        uuid varchar(36),
1678 1706
        updated timestamp,
1707
        lsid_authority varchar(255),
1708
        lsid_lsid varchar(255),
1709
        lsid_namespace varchar(255),
1710
        lsid_object varchar(255),
1711
        lsid_revision varchar(255),
1712
        protectedtitlecache bit not null,
1713
        titleCache varchar(255),
1679 1714
        uri varchar(255),
1680 1715
        descriptionseparated bit not null,
1681 1716
        createdby_id integer,
1682 1717
        updatedby_id integer,
1683 1718
        root_id integer,
1684
        primary key (id)
1719
        primary key (id),
1720
        unique (uuid)
1685 1721
    );
1686 1722

  
1687 1723
    create table FeatureTree_AUD (
1724
        DTYPE varchar(31) not null,
1688 1725
        id integer not null,
1689 1726
        REV integer not null,
1690 1727
        revtype tinyint,
1691 1728
        created timestamp,
1692
        uuid varchar(255),
1729
        uuid varchar(36),
1693 1730
        updated timestamp,
1731
        lsid_authority varchar(255),
1732
        lsid_lsid varchar(255),
1733
        lsid_namespace varchar(255),
1734
        lsid_object varchar(255),
1735
        lsid_revision varchar(255),
1736
        protectedtitlecache bit,
1737
        titleCache varchar(255),
1694 1738
        uri varchar(255),
1695 1739
        descriptionseparated bit,
1696 1740
        createdby_id integer,
......
1699 1743
        primary key (id, REV)
1700 1744
    );
1701 1745

  
1702
    create table FeatureTree_Representation (
1746
    create table FeatureTree_Annotation (
1703 1747
        FeatureTree_id integer not null,
1704
        representations_id integer not null,
1705
        primary key (FeatureTree_id, representations_id),
1706
        unique (representations_id)
1748
        annotations_id integer not null,
1749
        primary key (FeatureTree_id, annotations_id),
1750
        unique (annotations_id)
1707 1751
    );
1708 1752

  
1709
    create table FeatureTree_Representation_AUD (
1753
    create table FeatureTree_Annotation_AUD (
1710 1754
        REV integer not null,
1711 1755
        FeatureTree_id integer not null,
1712
        representations_id integer not null,
1756
        annotations_id integer not null,
1713 1757
        revtype tinyint,
1714
        primary key (REV, FeatureTree_id, representations_id)
1758
        primary key (REV, FeatureTree_id, annotations_id)
1715 1759
    );
1716 1760

  
1717
    create table GatheringEvent (
1718
        id integer not null,
1719
        created timestamp,
1720
        uuid varchar(255),
1721
        updated timestamp,
1722
        description varchar(255),
1723
        timeperiod_end varchar(255),
1724
        timeperiod_start varchar(255),
1725
        timeperiod_freetext varchar(30),
1726
        absoluteelevation integer,
1727
        absoluteelevationerror integer,
1728
        collectingmethod varchar(255),
1729
        distancetoground integer,
1730
        distancetowatersurface integer,
1731
        exactlocation_errorradius integer,
1732
        exactlocation_latitude double,
1733
        exactlocation_longitude double,
1734
        createdby_id integer,
1735
        updatedby_id integer,
1736
        country_id integer,
1737
        actor_id integer,
1738
        exactlocation_referencesystem_id integer,
1739
        locality_id integer,
1740
        primary key (id)
1761
    create table FeatureTree_Credit (
1762
        FeatureTree_id integer not null,
1763
        credits_id integer not null,
1764
        sortIndex integer not null,
1765
        primary key (FeatureTree_id, sortIndex),
1766
        unique (credits_id)
1741 1767
    );
1742 1768

  
1743
    create table GatheringEvent_AUD (
1744
        id integer not null,
1769
    create table FeatureTree_Credit_AUD (
1745 1770
        REV integer not null,
1771
        FeatureTree_id integer not null,
1772
        credits_id integer not null,
1773
        sortIndex integer not null,
1746 1774
        revtype tinyint,
1747
        created timestamp,
1748
        uuid varchar(255),
1749
        updated timestamp,
1750
        description varchar(255),
1751
        timeperiod_end varchar(255),
1752
        timeperiod_start varchar(255),
1753
        timeperiod_freetext varchar(30),
1754
        absoluteelevation integer,
1755
        absoluteelevationerror integer,
1756
        collectingmethod varchar(255),
1757
        distancetoground integer,
1758
        distancetowatersurface integer,
1759
        exactlocation_errorradius integer,
1775
        primary key (REV, FeatureTree_id, credits_id, sortIndex)
1776
    );
1777

  
1778
    create table FeatureTree_Extension (
1779
        FeatureTree_id integer not null,
1780
        extensions_id integer not null,
1781
        primary key (FeatureTree_id, extensions_id),
1782
        unique (extensions_id)
1783
    );
1784

  
1785
    create table FeatureTree_Extension_AUD (
1786
        REV integer not null,
1787
        FeatureTree_id integer not null,
1788
        extensions_id integer not null,
1789
        revtype tinyint,
1790
        primary key (REV, FeatureTree_id, extensions_id)
1791
    );
1792

  
1793
    create table FeatureTree_Marker (
1794
        FeatureTree_id integer not null,
1795
        markers_id integer not null,
1796
        primary key (FeatureTree_id, markers_id),
1797
        unique (markers_id)
1798
    );
1799

  
1800
    create table FeatureTree_Marker_AUD (
1801
        REV integer not null,
1802
        FeatureTree_id integer not null,
1803
        markers_id integer not null,
1804
        revtype tinyint,
1805
        primary key (REV, FeatureTree_id, markers_id)
1806
    );
1807

  
1808
    create table FeatureTree_OriginalSourceBase (
1809
        FeatureTree_id integer not null,
1810
        sources_id integer not null,
1811
        primary key (FeatureTree_id, sources_id),
1812
        unique (sources_id)
1813
    );
1814

  
1815
    create table FeatureTree_OriginalSourceBase_AUD (
1816
        REV integer not null,
1817
        FeatureTree_id integer not null,
1818
        sources_id integer not null,
1819
        revtype tinyint,
1820
        primary key (REV, FeatureTree_id, sources_id)
1821
    );
1822

  
1823
    create table FeatureTree_Representation (
1824
        FeatureTree_id integer not null,
1825
        representations_id integer not null,
1826
        primary key (FeatureTree_id, representations_id),
1827
        unique (representations_id)
1828
    );
1829

  
1830
    create table FeatureTree_Representation_AUD (
1831
        REV integer not null,
1832
        FeatureTree_id integer not null,
1833
        representations_id integer not null,
1834
        revtype tinyint,
1835
        primary key (REV, FeatureTree_id, representations_id)
1836
    );
1837

  
1838
    create table FeatureTree_Rights (
1839
        FeatureTree_id integer not null,
1840
        rights_id integer not null,
1841
        primary key (FeatureTree_id, rights_id),
1842
        unique (rights_id)
1843
    );
1844

  
1845
    create table FeatureTree_Rights_AUD (
1846
        REV integer not null,
1847
        FeatureTree_id integer not null,
1848
        rights_id integer not null,
1849
        revtype tinyint,
1850
        primary key (REV, FeatureTree_id, rights_id)
1851
    );
1852

  
1853
    create table FeatureTree_TaxonBase (
1854
        FeatureTree_id integer not null,
1855
        coveredtaxa_id integer not null,
1856
        primary key (FeatureTree_id, coveredtaxa_id)
1857
    );
1858

  
1859
    create table FeatureTree_TaxonBase_AUD (
1860
        REV integer not null,
1861
        FeatureTree_id integer not null,
1862
        coveredtaxa_id integer not null,
1863
        revtype tinyint,
1864
        primary key (REV, FeatureTree_id, coveredtaxa_id)
1865
    );
1866

  
1867
    create table GatheringEvent (
1868
        id integer not null,
1869
        created timestamp,
1870
        uuid varchar(36),
1871
        updated timestamp,
1872
        description varchar(255),
1873
        timeperiod_end varchar(255),
1874
        timeperiod_freetext varchar(255),
1875
        timeperiod_start varchar(255),
1876
        absoluteelevation integer,
1877
        absoluteelevationerror integer,
1878
        collectingmethod varchar(255),
1879
        distancetoground integer,
1880
        distancetowatersurface integer,
1881
        exactlocation_errorradius integer,
1882
        exactlocation_latitude double,
1883
        exactlocation_longitude double,
1884
        createdby_id integer,
1885
        updatedby_id integer,
1886
        country_id integer,
1887
        actor_id integer,
1888
        exactlocation_referencesystem_id integer,
1889
        locality_id integer,
1890
        primary key (id),
1891
        unique (uuid)
1892
    );
1893

  
1894
    create table GatheringEvent_AUD (
1895
        id integer not null,
1896
        REV integer not null,
1897
        revtype tinyint,
1898
        created timestamp,
1899
        uuid varchar(36),
1900
        updated timestamp,
1901
        description varchar(255),
1902
        timeperiod_end varchar(255),
1903
        timeperiod_freetext varchar(255),
1904
        timeperiod_start varchar(255),
1905
        absoluteelevation integer,
1906
        absoluteelevationerror integer,
1907
        collectingmethod varchar(255),
1908
        distancetoground integer,
1909
        distancetowatersurface integer,
1910
        exactlocation_errorradius integer,
1760 1911
        exactlocation_latitude double,
1761 1912
        exactlocation_longitude double,
1762 1913
        createdby_id integer,
......
1815 1966
    create table GenBankAccession (
1816 1967
        id integer not null,
1817 1968
        created timestamp,
1818
        uuid varchar(255),
1969
        uuid varchar(36),
1819 1970
        updated timestamp,
1820 1971
        accessionnumber varchar(255),
1821 1972
        uri varchar(255),
1822 1973
        createdby_id integer,
1823 1974
        updatedby_id integer,
1824
        primary key (id)
1975
        primary key (id),
1976
        unique (uuid)
1825 1977
    );
1826 1978

  
1827 1979
    create table GenBankAccession_AUD (
......
1829 1981
        REV integer not null,
1830 1982
        revtype tinyint,
1831 1983
        created timestamp,
1832
        uuid varchar(255),
1984
        uuid varchar(36),
1833 1985
        updated timestamp,
1834 1986
        accessionnumber varchar(255),
1835 1987
        uri varchar(255),
......
1841 1993
    create table GrantedAuthorityImpl (
1842 1994
        id integer not null,
1843 1995
        created timestamp,
1844
        uuid varchar(255),
1996
        uuid varchar(36),
1845 1997
        authority varchar(255),
1846 1998
        createdby_id integer,
1847 1999
        primary key (id),
1848
        unique (authority)
2000
        unique (uuid, authority)
1849 2001
    );
1850 2002
	
1851 2003
	create table hibernate_sequences (
......
1857 2009
    create table HomotypicalGroup (
1858 2010
        id integer not null,
1859 2011
        created timestamp,
1860
        uuid varchar(255),
2012
        uuid varchar(36),
1861 2013
        updated timestamp,
1862 2014
        createdby_id integer,
1863 2015
        updatedby_id integer,
1864
        primary key (id)
2016
        primary key (id),
2017
        unique (uuid)
1865 2018
    );
1866 2019

  
1867 2020
    create table HomotypicalGroup_AUD (
......
1869 2022
        REV integer not null,
1870 2023
        revtype tinyint,
1871 2024
        created timestamp,
1872
        uuid varchar(255),
2025
        uuid varchar(36),
1873 2026
        updated timestamp,
1874 2027
        createdby_id integer,
1875 2028
        updatedby_id integer,
......
1909 2062
    create table HybridRelationship (
1910 2063
        id integer not null,
1911 2064
        created timestamp,
1912
        uuid varchar(255),
2065
        uuid varchar(36),
1913 2066
        updated timestamp,
1914 2067
        citationmicroreference varchar(255),
1915 2068
        originalnamestring varchar(255),
......
1921 2074
        relatedfrom_id integer,
1922 2075
        relatedto_id integer,
1923 2076
        type_id integer,
1924
        primary key (id)
2077
        primary key (id),
2078
        unique (uuid)
1925 2079
    );
1926 2080

  
1927 2081
    create table HybridRelationship_AUD (
......
1929 2083
        REV integer not null,
1930 2084
        revtype tinyint,
1931 2085
        created timestamp,
1932
        uuid varchar(255),
2086
        uuid varchar(36),
1933 2087
        updated timestamp,
1934 2088
        citationmicroreference varchar(255),
1935 2089
        originalnamestring varchar(255),
......
1994 2148
    create table InstitutionalMembership (
1995 2149
        id integer not null,
1996 2150
        created timestamp,
1997
        uuid varchar(255),
2151
        uuid varchar(36),
1998 2152
        updated timestamp,
1999 2153
        department varchar(255),
2000 2154
        period_end varchar(255),
2155
        period_freetext varchar(255),
2001 2156
        period_start varchar(255),
2002
        period_freetext varchar(30),
2003 2157
        role varchar(255),
2004 2158
        createdby_id integer,
2005 2159
        updatedby_id integer,
2006 2160
        institute_id integer,
2007 2161
        person_id integer,
2008
        primary key (id)
2162
        primary key (id),
2163
        unique (uuid)
2009 2164
    );
2010 2165

  
2011 2166
    create table InstitutionalMembership_AUD (
......
2013 2168
        REV integer not null,
2014 2169
        revtype tinyint,
2015 2170
        created timestamp,
2016
        uuid varchar(255),
2171
        uuid varchar(36),
2017 2172
        updated timestamp,
2018 2173
        department varchar(255),
2019 2174
        period_end varchar(255),
2175
        period_freetext varchar(255),
2020 2176
        period_start varchar(255),
2021
        period_freetext varchar(30),
2022 2177
        role varchar(255),
2023 2178
        createdby_id integer,
2024 2179
        updatedby_id integer,
......
2026 2181
        person_id integer,
2027 2182
        primary key (id, REV)
2028 2183
    );
2029
    
2030
              
2184
           
2031 2185
    create table KeyStatement (
2032 2186
        id integer not null,
2033 2187
        created timestamp,
......
2068 2222
        primary key (REV, keyStatement_id, label_id, label_mapkey_id)
2069 2223
    );
2070 2224

  
2071

  
2072 2225
    create table LSIDAuthority (
2073 2226
        id integer not null,
2074 2227
        created timestamp,
2075
        uuid varchar(255),
2228
        uuid varchar(36),
2076 2229
        authority varchar(255),
2077 2230
        authoritywsdl longvarchar,
2078 2231
        port integer not null,
......
2080 2233
        url varchar(255),
2081 2234
        createdby_id integer,
2082 2235
        primary key (id),
2083
        unique (authority)
2236
        unique (uuid, authority)
2084 2237
    );
2085 2238

  
2086 2239
    create table LSIDAuthority_namespaces (
......
2093 2246
    create table LanguageString (
2094 2247
        id integer not null,
2095 2248
        created timestamp,
2096
        uuid varchar(255),
2249
        uuid varchar(36),
2097 2250
        updated timestamp,
2098 2251
        text longvarchar,
2099 2252
        createdby_id integer,
2100 2253
        updatedby_id integer,
2101 2254
        language_id integer,
2102
        primary key (id)
2255
        primary key (id),
2256
        unique (uuid)
2103 2257
    );
2104 2258

  
2105 2259
    create table LanguageString_AUD (
......
2107 2261
        REV integer not null,
2108 2262
        revtype tinyint,
2109 2263
        created timestamp,
2110
        uuid varchar(255),
2264
        uuid varchar(36),
2111 2265
        updated timestamp,
2112 2266
        text longvarchar,
2113 2267
        createdby_id integer,
......
2149 2303
    create table Locus (
2150 2304
        id integer not null,
2151 2305
        created timestamp,
2152
        uuid varchar(255),
2306
        uuid varchar(36),
2153 2307
        updated timestamp,
2154 2308
        description varchar(255),
2155 2309
        name varchar(255),
2156 2310
        createdby_id integer,
2157 2311
        updatedby_id integer,
2158
        primary key (id)
2312
        primary key (id),
2313
        unique (uuid)
2159 2314
    );
2160 2315

  
2161 2316
    create table Locus_AUD (
......
2163 2318
        REV integer not null,
2164 2319
        revtype tinyint,
2165 2320
        created timestamp,
2166
        uuid varchar(255),
2321
        uuid varchar(36),
2167 2322
        updated timestamp,
2168 2323
        description varchar(255),
2169 2324
        name varchar(255),
......
2175 2330
    create table Marker (
2176 2331
        id integer not null,
2177 2332
        created timestamp,
2178
        uuid varchar(255),
2333
        uuid varchar(36),
2179 2334
        updated timestamp,
2180 2335
        flag bit not null,
2181 2336
        markedObj_type varchar(255),
......
2183 2338
        createdby_id integer,
2184 2339
        updatedby_id integer,
2185 2340
        markertype_id integer,
2186
        primary key (id)
2341
        primary key (id),
2342
        unique (uuid)
2187 2343
    );
2188 2344

  
2189 2345
    create table Marker_AUD (
......
2191 2347
        REV integer not null,
2192 2348
        revtype tinyint,
2193 2349
        created timestamp,
2194
        uuid varchar(255),
2350
        uuid varchar(36),
2195 2351
        updated timestamp,
2196 2352
        flag bit,
2197
		createdby_id integer,
2353
        createdby_id integer,
2198 2354
        updatedby_id integer,
2199 2355
        markertype_id integer,
2200 2356
        primary key (id, REV)
......
2204 2360
        DTYPE varchar(31) not null,
2205 2361
        id integer not null,
2206 2362
        created timestamp,
2207
        uuid varchar(255),
2363
        uuid varchar(36),
2208 2364
        updated timestamp,
2209
        mediacreated date,
2210
        citationmicroreference varchar(255),
2211
        createdby_id integer,
2212
        updatedby_id integer,
2213
        artist_id integer,
2214
        citation_id integer,
2215
		lsid_authority varchar(255),
2365
        lsid_authority varchar(255),
2216 2366
        lsid_lsid varchar(255),
2217 2367
        lsid_namespace varchar(255),
2218 2368
        lsid_object varchar(255),
2219 2369
        lsid_revision varchar(255),
2220 2370
        protectedtitlecache bit not null,
2221 2371
        titleCache varchar(255),
2222
        primary key (id)
2223
    );
2224

  
2225
	create table Media_AUD (
2226
        DTYPE varchar(31) not null,
2227
        REV integer not null,
2228
        revtype tinyint,
2229
        id integer not null,
2230
        created timestamp,
2231
        uuid varchar(36),
2232
        updated timestamp,
2233 2372
        mediacreated timestamp,
2234 2373
        citationmicroreference varchar(255),
2235 2374
        createdby_id integer,
2236 2375
        updatedby_id integer,
2237 2376
        artist_id integer,
2238 2377
        citation_id integer,
2239
        lsid_authority varchar(255),
2240
        lsid_lsid varchar(255),
2241
        lsid_namespace varchar(255),
2242
        lsid_object varchar(255),
2243
        lsid_revision varchar(255),
2244
        protectedtitlecache bit not null,
2245
        titleCache varchar(255),
2246 2378
        primary key (id),
2247 2379
        unique (uuid)
2248 2380
    );
2249 2381

  
2250
    create table MediaKey_CoveredTaxon (
2251
        mediaKey_id integer not null,
2252
        coveredTaxon_id integer not null,
2253
        primary key (mediaKey_id, coveredTaxon_id)
2254
    );
2255

  
2256
    create table MediaKey_CoveredTaxon_AUD (
2257
        REV integer not null,
2258
        mediaKey_id integer not null,
2259
        coveredTaxon_id integer not null,
2260
        revtype tinyint,
2261
        primary key (REV, mediaKey_id, coveredTaxon_id)
2262
    );
2263

  
2264 2382
    create table MediaKey_NamedArea (
2265
        media_id integer not null,
2266
        geographicalScope_id integer not null,
2267
        primary key (media_id, geographicalScope_id)
2383
        Media_id integer not null,
2384
        geographicalscope_id integer not null,
2385
        primary key (Media_id, geographicalscope_id)
2268 2386
    );
2269 2387

  
2270 2388
    create table MediaKey_NamedArea_AUD (
2271 2389
        REV integer not null,
2272
        media_id integer not null,
2273
        geographicalScope_id integer not null,
2390
        Media_id integer not null,
2391
        geographicalscope_id integer not null,
2274 2392
        revtype tinyint,
2275
        primary key (REV, media_id, geographicalScope_id)
2393
        primary key (REV, Media_id, geographicalscope_id)
2276 2394
    );
2277 2395

  
2278
	create table MediaKey_Scope (
2279
        MediaKey_id integer not null,
2280
        scopes_id integer not null,
2281
        primary key (MediaKey_id, scopes_id)
2396
    create table MediaKey_Scope (
2397
        Media_id integer not null,
2398
        scoperestrictions_id integer not null,
2399
        primary key (Media_id, scoperestrictions_id)
2282 2400
    );
2283 2401

  
2284 2402
    create table MediaKey_Scope_AUD (
2285 2403
        REV integer not null,
2286
        MediaKey_id integer not null,
2287
        scopes_id integer not null,
2404
        Media_id integer not null,
2405
        scoperestrictions_id integer not null,
2288 2406
        revtype tinyint,
2289
        primary key (REV, MediaKey_id, scopes_id)
2407
        primary key (REV, Media_id, scoperestrictions_id)
2290 2408
    );
2291 2409

  
2292 2410
    create table MediaKey_Taxon (
......
2306 2424
    create table MediaRepresentation (
2307 2425
        id integer not null,
2308 2426
        created timestamp,
2309
        uuid varchar(255),
2427
        uuid varchar(36),
2310 2428
        updated timestamp,
2311 2429
        mimetype varchar(255),
2312 2430
        suffix varchar(255),
2313 2431
        createdby_id integer,
2314 2432
        updatedby_id integer,
2315 2433
        media_id integer,
2316
        primary key (id)
2434
        primary key (id),
2435
        unique (uuid)
2317 2436
    );
2318 2437

  
2319 2438
    create table MediaRepresentationPart (
2320 2439
        DTYPE varchar(31) not null,
2321 2440
        id integer not null,
2322 2441
        created timestamp,
2323
        uuid varchar(255),
2442
        uuid varchar(36),
2324 2443
        updated timestamp,
2325 2444
        size integer,
2326 2445
        uri varchar(255),
......
2331 2450
        updatedby_id integer,
2332 2451
        representation_id integer not null,
2333 2452
        sortIndex integer,
2334
        primary key (id)
2453
        primary key (id),
2454
        unique (uuid)
2335 2455
    );
2336 2456

  
2337 2457
    create table MediaRepresentationPart_AUD (
......
2340 2460
        REV integer not null,
2341 2461
        revtype tinyint,
2342 2462
        created timestamp,
2343
        uuid varchar(255),
2463
        uuid varchar(36),
2344 2464
        updated timestamp,
2345 2465
        size integer,
2346 2466
        uri varchar(255),
......
2358 2478
        REV integer not null,
2359 2479
        revtype tinyint,
2360 2480
        created timestamp,
2361
        uuid varchar(255),
2481
        uuid varchar(36),
2362 2482
        updated timestamp,
2363 2483
        mimetype varchar(255),
2364 2484
        suffix varchar(255),
......
2377 2497
        primary key (REV, representation_id, id, sortIndex)
2378 2498
    );
2379 2499

  
2500
    create table Media_AUD (
2501
        DTYPE varchar(31) not null,
2502
        id integer not null,
2503
        REV integer not null,
2504
        revtype tinyint,
2505
        created timestamp,
2506
        uuid varchar(36),
2507
        updated timestamp,
2508
        lsid_authority varchar(255),
2509
        lsid_lsid varchar(255),
2510
        lsid_namespace varchar(255),
2511
        lsid_object varchar(255),
2512
        lsid_revision varchar(255),
2513
        protectedtitlecache bit,
2514
        titleCache varchar(255),
2515
        mediacreated timestamp,
2516
        createdby_id integer,
2517
        updatedby_id integer,
2518
        artist_id integer,
2519
        citationmicroreference varchar(255),
2520
        citation_id integer,
2521
        primary key (id, REV)
2522
    );
2523

  
2380 2524
    create table Media_Annotation (
2381 2525
        Media_id integer not null,
2382 2526
        annotations_id integer not null,
......
2392 2536
        primary key (REV, Media_id, annotations_id)
2393 2537
    );
2394 2538

  
2395
    create table Media_DefinedTermBase (
2539
    create table Media_Credit (
2396 2540
        Media_id integer not null,
2397
        geoscopes_id integer not null,
2398
        primary key (Media_id, geoscopes_id)
2541
        credits_id integer not null,
2542
        sortIndex integer not null,
2543
        primary key (Media_id, sortIndex),
2544
        unique (credits_id)
2399 2545
    );
2400 2546

  
2401
    create table Media_DefinedTermBase_AUD (
2547
    create table Media_Credit_AUD (
2402 2548
        REV integer not null,
2403 2549
        Media_id integer not null,
2404
        geoscopes_id integer not null,
2550
        credits_id integer not null,
2551
        sortIndex integer not null,
2405 2552
        revtype tinyint,
2406
        primary key (REV, Media_id, geoscopes_id)
2553
        primary key (REV, Media_id, credits_id, sortIndex)
2407 2554
    );
2408 2555

  
2409 2556
    create table Media_Description (
......
2423 2570
        primary key (REV, Media_id, description_id, description_mapkey_id)
2424 2571
    );
2425 2572

  
2426
    create table Media_LanguageString (
2573
    create table Media_Extension (
2427 2574
        Media_id integer not null,
2428
        title_id integer not null,
2429
        title_mapkey_id integer not null,
2430
        primary key (Media_id, title_mapkey_id),
2431
        unique (title_id)
2575
        extensions_id integer not null,
2576
        primary key (Media_id, extensions_id),
2577
        unique (extensions_id)
2432 2578
    );
2433 2579

  
2434
    create table Media_LanguageString_AUD (
2580
    create table Media_Extension_AUD (
2581
        REV integer not null,
2582
        Media_id integer not null,
2583
        extensions_id integer not null,
2584
        revtype tinyint,
2585
        primary key (REV, Media_id, extensions_id)
2586
    );
2587

  
2588
    create table Media_LanguageString (
2589
        Media_id integer not null,
2590
        title_id integer not null,
2591
        title_mapkey_id integer not null,
2592
        primary key (Media_id, title_mapkey_id),
2593
        unique (title_id)
2594
    );
2595

  
2596
    create table Media_LanguageString_AUD (
2435 2597
        REV integer not null,
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff