Project

General

Profile

Revision 6a5088e0

ID6a5088e00d435c3a91b54f0de95fa5ddac595a33
Parent ae214cb5
Child 8c760302

Added by Andreas Müller over 8 years ago

URIs->CLOBs

View differences:

cdmlib-persistence/src/test/resources/dbscripts/001-cdm.h2.sql
694 694
    LSID_REVISION VARCHAR(255),
695 695
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
696 696
    TITLECACHE VARCHAR(255),
697
    URI VARCHAR(255),
697
    URI CLOB,
698 698
    ISO639_1 VARCHAR(2),
699 699
    RANKCLASS INTEGER,
700 700
    ISTECHNICAL BOOLEAN,
......
744 744
    LSID_REVISION VARCHAR(255),
745 745
    PROTECTEDTITLECACHE BOOLEAN,
746 746
    TITLECACHE VARCHAR(255),
747
    URI VARCHAR(255),
747
    URI CLOB,
748 748
    CREATEDBY_ID INTEGER,
749 749
    UPDATEDBY_ID INTEGER,
750 750
    KINDOF_ID INTEGER,
......
1503 1503
    LSID_REVISION VARCHAR(255),
1504 1504
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
1505 1505
    TITLECACHE VARCHAR(255),
1506
    URI VARCHAR(255),
1506
    URI CLOB,
1507 1507
    DESCRIPTIONSEPARATED BOOLEAN NOT NULL,
1508 1508
    CREATEDBY_ID INTEGER,
1509 1509
    UPDATEDBY_ID INTEGER,
......
1524 1524
    LSID_REVISION VARCHAR(255),
1525 1525
    PROTECTEDTITLECACHE BOOLEAN,
1526 1526
    TITLECACHE VARCHAR(255),
1527
    URI VARCHAR(255),
1527
    URI CLOB,
1528 1528
    DESCRIPTIONSEPARATED BOOLEAN,
1529 1529
    CREATEDBY_ID INTEGER,
1530 1530
    UPDATEDBY_ID INTEGER,
......
1721 1721
    UUID VARCHAR(36),
1722 1722
    UPDATED TIMESTAMP,
1723 1723
    ACCESSIONNUMBER VARCHAR(255),
1724
    URI VARCHAR(255),
1724
    URI CLOB,
1725 1725
    CREATEDBY_ID INTEGER,
1726 1726
    UPDATEDBY_ID INTEGER
1727 1727
);
......
1734 1734
    UUID VARCHAR(36),
1735 1735
    UPDATED TIMESTAMP,
1736 1736
    ACCESSIONNUMBER VARCHAR(255),
1737
    URI VARCHAR(255),
1737
    URI CLOB,
1738 1738
    CREATEDBY_ID INTEGER,
1739 1739
    UPDATEDBY_ID INTEGER
1740 1740
);
......
2125 2125
    UUID VARCHAR(36),
2126 2126
    UPDATED TIMESTAMP,
2127 2127
    SIZE INTEGER,
2128
    URI VARCHAR(255),
2128
    URI CLOB,
2129 2129
    DURATION INTEGER,
2130 2130
    HEIGHT INTEGER,
2131 2131
    WIDTH INTEGER,
......
2144 2144
    UUID VARCHAR(36),
2145 2145
    UPDATED TIMESTAMP,
2146 2146
    SIZE INTEGER,
2147
    URI VARCHAR(255),
2147
    URI CLOB,
2148 2148
    CREATEDBY_ID INTEGER,
2149 2149
    UPDATEDBY_ID INTEGER,
2150 2150
    REPRESENTATION_ID INTEGER,
......
2806 2806
    SERIESPART VARCHAR(255),
2807 2807
    TITLE CLOB,
2808 2808
    REFTYPE INTEGER,
2809
    URI VARCHAR(255),
2809
    URI CLOB, VARCHAR(255),
2810 2810
    VOLUME VARCHAR(255),
2811 2811
    CREATEDBY_ID INTEGER,
2812 2812
    UPDATEDBY_ID INTEGER,
......
2852 2852
    SERIESPART VARCHAR(255),
2853 2853
    TITLE CLOB,
2854 2854
    REFTYPE INTEGER,
2855
    URI VARCHAR(255),
2855
    URI CLOB,
2856 2856
    VOLUME VARCHAR(255),
2857 2857
    CREATEDBY_ID INTEGER,
2858 2858
    UPDATEDBY_ID INTEGER,
......
3019 3019
    UPDATED TIMESTAMP,
3020 3020
    TEXT CLOB,
3021 3021
    ABBREVIATEDTEXT VARCHAR(255),
3022
    URI VARCHAR(255),
3022
    URI CLOB,
3023 3023
    CREATEDBY_ID INTEGER,
3024 3024
    UPDATEDBY_ID INTEGER,
3025 3025
    LANGUAGE_ID INTEGER,
......
3036 3036
    UPDATED TIMESTAMP,
3037 3037
    TEXT CLOB,
3038 3038
    ABBREVIATEDTEXT VARCHAR(255),
3039
    URI VARCHAR(255),
3039
    URI CLOB,
3040 3040
    CREATEDBY_ID INTEGER,
3041 3041
    UPDATEDBY_ID INTEGER,
3042 3042
    LANGUAGE_ID INTEGER,
......
4048 4048
    LSID_REVISION VARCHAR(255),
4049 4049
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
4050 4050
    TITLECACHE VARCHAR(255),
4051
    URI VARCHAR(255),
4052
    TERMSOURCEURI VARCHAR(255),
4051
    URI CLOB,
4052
    TERMSOURCEURI CLOB,
4053 4053
    CREATEDBY_ID INTEGER,
4054 4054
    UPDATEDBY_ID INTEGER
4055 4055
);
......
4070 4070
    LSID_REVISION VARCHAR(255),
4071 4071
    PROTECTEDTITLECACHE BOOLEAN,
4072 4072
    TITLECACHE VARCHAR(255),
4073
    URI VARCHAR(255),
4074
    TERMSOURCEURI VARCHAR(255),
4073
    URI CLOB,
4074
    TERMSOURCEURI CLOB,
4075 4075
    CREATEDBY_ID INTEGER,
4076 4076
    UPDATEDBY_ID INTEGER
4077 4077
);

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)