Skip to content

Commit 29027e2

Browse files
rkorytkowskirkorytkowski
committedJun 17, 2013
Revert "TRUNK-3915 Resolved and successfully tested."
This reverts commit cebb56d.
·
2.7.31.11.0-alpha
1 parent 5daf803 commit 29027e2

File tree

1 file changed

+57
-55
lines changed

1 file changed

+57
-55
lines changed
 

‎api/src/main/resources/liquibase-schema-only.xml

+57-55
Original file line numberDiff line numberDiff line change
@@ -29,7 +29,7 @@
2929
<column name="void_reason" type="varchar(255)"/>
3030
<column name="changed_by" type="int"/>
3131
<column name="date_changed" type="DATETIME"/>
32-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
32+
<column name="uuid" type="char(38)" />
3333
</createTable>
3434
<modifySql dbms="mssql">
3535
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -77,7 +77,7 @@
7777
<column name="retired_by" type="int"/>
7878
<column name="date_retired" type="DATETIME"/>
7979
<column name="retire_reason" type="varchar(255)"/>
80-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
80+
<column name="uuid" type="char(38)" />
8181
</createTable>
8282
<modifySql dbms="mssql">
8383
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -100,7 +100,7 @@
100100
<constraints nullable="false"/>
101101
</column>
102102
<column name="sort_weight" type="double precision"></column>
103-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
103+
<column name="uuid" type="char(38)" />
104104
</createTable>
105105
<modifySql dbms="mssql">
106106
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -129,7 +129,7 @@
129129
<column name="retired_by" type="int"/>
130130
<column name="date_retired" type="DATETIME"/>
131131
<column name="retire_reason" type="varchar(255)"/>
132-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
132+
<column name="uuid" type="char(38)" />
133133
</createTable>
134134
<modifySql dbms="mssql">
135135
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -159,7 +159,7 @@
159159
<column name="retired_by" type="int"/>
160160
<column name="date_retired" type="DATETIME"/>
161161
<column name="retire_reason" type="varchar(255)"/>
162-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
162+
<column name="uuid" type="char(38)" />
163163
</createTable>
164164
<modifySql dbms="mssql">
165165
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -187,7 +187,7 @@
187187
</column>
188188
<column name="changed_by" type="int"/>
189189
<column name="date_changed" type="DATETIME"/>
190-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
190+
<column name="uuid" type="char(38)" />
191191
</createTable>
192192
<modifySql dbms="mssql">
193193
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -215,7 +215,7 @@
215215
</column>
216216
<column name="changed_by" type="int"/>
217217
<column name="date_changed" type="DATETIME"/>
218-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
218+
<column name="uuid" type="char(38)" />
219219
</createTable>
220220
<modifySql dbms="mssql">
221221
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -247,7 +247,7 @@
247247
<column name="voided_by" type="int"/>
248248
<column name="date_voided" type="DATETIME"/>
249249
<column name="void_reason" type="varchar(255)"/>
250-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
250+
<column name="uuid" type="char(38)" />
251251
</createTable>
252252
<modifySql dbms="mssql">
253253
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -276,7 +276,7 @@
276276
<column name="voided_by" type="int"/>
277277
<column name="date_voided" type="DATETIME"/>
278278
<column name="void_reason" type="varchar(255)"/>
279-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
279+
<column name="uuid" type="char(38)" />
280280
</createTable>
281281
<modifySql dbms="mssql">
282282
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -337,7 +337,7 @@
337337
<column defaultValue="" name="locale" type="varchar(50)">
338338
<constraints nullable="false"/>
339339
</column>
340-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
340+
<column name="uuid" type="char(38)" />
341341
</createTable>
342342
<modifySql dbms="mssql">
343343
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -371,7 +371,7 @@
371371
<column name="date_created" type="DATETIME">
372372
<constraints nullable="false"/>
373373
</column>
374-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
374+
<column name="uuid" type="char(38)" />
375375
</createTable>
376376
<modifySql dbms="mssql">
377377
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -414,7 +414,7 @@
414414
<column name="retired_by" type="int"/>
415415
<column name="date_retired" type="DATETIME"/>
416416
<column name="retire_reason" type="varchar(255)"/>
417-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
417+
<column name="uuid" type="char(38)" />
418418
</createTable>
419419
<modifySql dbms="mssql">
420420
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -428,7 +428,7 @@
428428
<column defaultValueNumeric="0" name="concept_id" type="int"/>
429429
<column defaultValueNumeric="0" name="program_workflow_id" type="int"/>
430430
<column defaultValueNumeric="0" name="program_workflow_state_id" type="int"/>
431-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
431+
<column name="uuid" type="char(38)" />
432432
</createTable>
433433
<modifySql dbms="mssql">
434434
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -486,7 +486,7 @@
486486
<column name="retired_by" type="int"/>
487487
<column name="date_retired" type="DATETIME"/>
488488
<column name="retire_reason" type="varchar(255)"/>
489-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
489+
<column name="uuid" type="char(38)" />
490490
</createTable>
491491
<modifySql dbms="mssql">
492492
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -555,7 +555,7 @@
555555
<column name="changed_by" type="int"/>
556556
<column name="date_changed" type="DATETIME"/>
557557
<column name="visit_id" type="int"/>
558-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
558+
<column name="uuid" type="char(38)" />
559559
</createTable>
560560
<modifySql dbms="mssql">
561561
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -584,7 +584,7 @@
584584
<column name="retired_by" type="int"/>
585585
<column name="date_retired" type="DATETIME"/>
586586
<column name="retire_reason" type="varchar(255)"/>
587-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
587+
<column name="uuid" type="char(38)" />
588588
<column name="edit_privilege" type="varchar(255)">
589589
<constraints nullable="true"/>
590590
</column>
@@ -627,7 +627,7 @@
627627
<column name="retired_by" type="int"/>
628628
<column name="date_retired" type="DATETIME"/>
629629
<column name="retire_reason" type="varchar(255)"/>
630-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
630+
<column name="uuid" type="char(38)" />
631631
</createTable>
632632
<modifySql dbms="mssql">
633633
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -647,7 +647,7 @@
647647
<column name="date_created" type="DATETIME">
648648
<constraints nullable="false"/>
649649
</column>
650-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
650+
<column name="uuid" type="char(38)" />
651651
</createTable>
652652
<modifySql dbms="mssql">
653653
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -669,7 +669,7 @@
669669
<column name="date_created" type="DATETIME">
670670
<constraints nullable="false"/>
671671
</column>
672-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
672+
<column name="uuid" type="char(38)" />
673673
</createTable>
674674
<modifySql dbms="mssql">
675675
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -708,7 +708,7 @@
708708
<column name="retired_by" type="int"/>
709709
<column name="date_retired" type="DATETIME"/>
710710
<column name="retired_reason" type="varchar(255)"/>
711-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
711+
<column name="uuid" type="char(38)" />
712712
</createTable>
713713
<modifySql dbms="mssql">
714714
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -743,7 +743,7 @@
743743
<constraints nullable="false"/>
744744
</column>
745745
<column name="sort_weight" type="real"/>
746-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
746+
<column name="uuid" type="char(38)" />
747747
</createTable>
748748
<modifySql dbms="mssql">
749749
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -756,7 +756,7 @@
756756
</column>
757757
<column name="property_value" type="text"/>
758758
<column name="description" type="text"/>
759-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
759+
<column name="uuid" type="char(38)" />
760760
</createTable>
761761
<modifySql dbms="mssql">
762762
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -778,7 +778,7 @@
778778
<constraints nullable="false"/>
779779
</column>
780780
<column name="message_state" type="int" defaultValueNumeric="2" remarks="2=processed, 4=deleted"/>
781-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
781+
<column name="uuid" type="char(38)" />
782782
</createTable>
783783
<modifySql dbms="mssql">
784784
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -803,6 +803,7 @@
803803
<column name="date_created" type="DATETIME">
804804
<constraints nullable="false"/>
805805
</column>
806+
<column name="uuid" type="char(38)" />
806807
</createTable>
807808
<modifySql dbms="mssql">
808809
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -826,7 +827,8 @@
826827
<column name="date_processed" type="DATETIME"/>
827828
<column name="error_msg" type="text"/>
828829
<column name="date_created" type="DATETIME"/>
829-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
830+
<column name="uuid" type="char(38)" />
831+
</createTable>
830832
<modifySql dbms="mssql">
831833
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
832834
</modifySql>
@@ -846,7 +848,7 @@
846848
<column name="date_created" type="DATETIME">
847849
<constraints nullable="false"/>
848850
</column>
849-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
851+
<column name="uuid" type="char(38)" />
850852
</createTable>
851853
<modifySql dbms="mssql">
852854
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -887,7 +889,7 @@
887889
<column name="date_retired" type="DATETIME"/>
888890
<column name="retire_reason" type="varchar(255)"/>
889891
<column name="parent_location" type="int"/>
890-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
892+
<column name="uuid" type="char(38)" />
891893
</createTable>
892894
<modifySql dbms="mssql">
893895
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -915,7 +917,7 @@
915917
</column>
916918
<column name="changed_by" type="int"/>
917919
<column name="date_changed" type="DATETIME"/>
918-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
920+
<column name="uuid" type="char(38)" />
919921
</createTable>
920922
<modifySql dbms="mssql">
921923
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -944,7 +946,7 @@
944946
</column>
945947
<column name="changed_by" type="int"/>
946948
<column name="date_changed" type="DATETIME"/>
947-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
949+
<column name="uuid" type="char(38)" />
948950
</createTable>
949951
<modifySql dbms="mssql">
950952
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -962,7 +964,7 @@
962964
<constraints nullable="false"/>
963965
</column>
964966
<column name="date_changed" type="timestamp"/>
965-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
967+
<column name="uuid" type="char(38)" />
966968
</createTable>
967969
<modifySql dbms="mssql">
968970
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -979,7 +981,7 @@
979981
<column name="sender" type="varchar(255)"/>
980982
<column name="recipients" type="varchar(512)"/>
981983
<column defaultValueNumeric="0" name="ordinal" type="int"/>
982-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
984+
<column name="uuid" type="char(38)" />
983985
</createTable>
984986
<modifySql dbms="mssql">
985987
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1027,7 +1029,7 @@
10271029
<column name="voided_by" type="int"/>
10281030
<column name="date_voided" type="DATETIME"/>
10291031
<column name="void_reason" type="varchar(255)"/>
1030-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1032+
<column name="uuid" type="char(38)" />
10311033
</createTable>
10321034
<modifySql dbms="mssql">
10331035
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1056,7 +1058,7 @@
10561058
<column name="retired_by" type="int"/>
10571059
<column name="date_retired" type="DATETIME"/>
10581060
<column name="retire_reason" type="varchar(255)"/>
1059-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1061+
<column name="uuid" type="char(38)" />
10601062
</createTable>
10611063
<modifySql dbms="mssql">
10621064
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1101,7 +1103,7 @@
11011103
<constraints nullable="false"/>
11021104
</column>
11031105
<column name="accession_number" type="varchar(255)"/>
1104-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1106+
<column name="uuid" type="char(38)" />
11051107
</createTable>
11061108
<modifySql dbms="mssql">
11071109
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1161,7 +1163,7 @@
11611163
<column name="voided_by" type="int"/>
11621164
<column name="date_voided" type="DATETIME"/>
11631165
<column name="void_reason" type="varchar(255)"/>
1164-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1166+
<column name="uuid" type="char(38)" />
11651167
</createTable>
11661168
<modifySql dbms="mssql">
11671169
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1202,7 +1204,7 @@
12021204
<column name="retired_by" type="int"/>
12031205
<column name="date_retired" type="DATETIME"/>
12041206
<column name="retire_reason" type="varchar(255)"/>
1205-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1207+
<column name="uuid" type="char(38)" />
12061208
</createTable>
12071209
<modifySql dbms="mssql">
12081210
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1237,7 +1239,7 @@
12371239
<column name="voided_by" type="int"/>
12381240
<column name="date_voided" type="DATETIME"/>
12391241
<column name="void_reason" type="varchar(255)"/>
1240-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1242+
<column name="uuid" type="char(38)" />
12411243
</createTable>
12421244
<modifySql dbms="mssql">
12431245
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1270,7 +1272,7 @@
12701272
<column name="voided_by" type="int"/>
12711273
<column name="date_voided" type="DATETIME"/>
12721274
<column name="void_reason" type="varchar(255)"/>
1273-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1275+
<column name="uuid" type="char(38)" />
12741276
</createTable>
12751277
<modifySql dbms="mssql">
12761278
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1305,7 +1307,7 @@
13051307
<column name="voided_by" type="int"/>
13061308
<column name="date_voided" type="DATETIME"/>
13071309
<column name="void_reason" type="varchar(255)"/>
1308-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1310+
<column name="uuid" type="char(38)" />
13091311
</createTable>
13101312
<modifySql dbms="mssql">
13111313
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1349,7 +1351,7 @@
13491351
<column name="address6" type="varchar(255)"/>
13501352
<column name="date_changed" type="DATETIME"/>
13511353
<column name="changed_by" type="int"/>
1352-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1354+
<column name="uuid" type="char(38)" />
13531355
</createTable>
13541356
<modifySql dbms="mssql">
13551357
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1383,7 +1385,7 @@
13831385
<column name="voided_by" type="int"/>
13841386
<column name="date_voided" type="DATETIME"/>
13851387
<column name="void_reason" type="varchar(255)"/>
1386-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1388+
<column name="uuid" type="char(38)" />
13871389
</createTable>
13881390
<modifySql dbms="mssql">
13891391
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1421,7 +1423,7 @@
14211423
<column name="retire_reason" type="varchar(255)"/>
14221424
<column name="edit_privilege" type="varchar(255)"/>
14231425
<column name="sort_weight" type="double precision"/>
1424-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1426+
<column name="uuid" type="char(38)" />
14251427
</createTable>
14261428
<modifySql dbms="mssql">
14271429
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1460,7 +1462,7 @@
14601462
<column name="void_reason" type="varchar(255)"/>
14611463
<column name="changed_by" type="int"/>
14621464
<column name="date_changed" type="DATETIME"/>
1463-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1465+
<column name="uuid" type="char(38)" />
14641466
</createTable>
14651467
<modifySql dbms="mssql">
14661468
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1474,7 +1476,7 @@
14741476
<column defaultValue="" name="description" type="varchar(250)">
14751477
<constraints nullable="false"/>
14761478
</column>
1477-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1479+
<column name="uuid" type="char(38)" />
14781480
</createTable>
14791481
<modifySql dbms="mssql">
14801482
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1504,7 +1506,7 @@
15041506
<constraints nullable="false"/>
15051507
</column>
15061508
<column name="description" type="varchar(500)"/>
1507-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1509+
<column name="uuid" type="char(38)" />
15081510
</createTable>
15091511
<modifySql dbms="mssql">
15101512
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1532,7 +1534,7 @@
15321534
</column>
15331535
<column name="changed_by" type="int"/>
15341536
<column name="date_changed" type="DATETIME"/>
1535-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1537+
<column name="uuid" type="char(38)" />
15361538
</createTable>
15371539
<modifySql dbms="mssql">
15381540
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1566,7 +1568,7 @@
15661568
</column>
15671569
<column name="changed_by" type="int"/>
15681570
<column name="date_changed" type="DATETIME"/>
1569-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1571+
<column name="uuid" type="char(38)" />
15701572
</createTable>
15711573
<modifySql dbms="mssql">
15721574
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1602,7 +1604,7 @@
16021604
<column name="voided_by" type="int"/>
16031605
<column name="date_voided" type="DATETIME"/>
16041606
<column name="void_reason" type="varchar(255)"/>
1605-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1607+
<column name="uuid" type="char(38)" />
16061608
</createTable>
16071609
<modifySql dbms="mssql">
16081610
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1640,7 +1642,7 @@
16401642
<column name="retired_by" type="int"/>
16411643
<column name="date_retired" type="DATETIME"/>
16421644
<column name="retire_reason" type="varchar(255)"/>
1643-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1645+
<column name="uuid" type="char(38)" />
16441646
</createTable>
16451647
<modifySql dbms="mssql">
16461648
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1676,7 +1678,7 @@
16761678
<column name="voided_by" type="int"/>
16771679
<column name="date_voided" type="DATETIME"/>
16781680
<column name="void_reason" type="varchar(255)"/>
1679-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1681+
<column name="uuid" type="char(38)" />
16801682
</createTable>
16811683
<modifySql dbms="mssql">
16821684
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1696,7 +1698,7 @@
16961698
<column name="xml_data" type="text">
16971699
<constraints nullable="false"/>
16981700
</column>
1699-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1701+
<column name="uuid" type="char(38)" />
17001702
</createTable>
17011703
<modifySql dbms="mssql">
17021704
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1710,7 +1712,7 @@
17101712
<column defaultValue="" name="description" type="varchar(255)">
17111713
<constraints nullable="false"/>
17121714
</column>
1713-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1715+
<column name="uuid" type="char(38)" />
17141716
</createTable>
17151717
<modifySql dbms="mssql">
17161718
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1764,7 +1766,7 @@
17641766
<column name="last_execution_time" type="DATETIME">
17651767
<constraints nullable="true"/>
17661768
</column>
1767-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1769+
<column name="uuid" type="char(38)" />
17681770
</createTable>
17691771
<modifySql dbms="mssql">
17701772
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1835,7 +1837,7 @@
18351837
<column name="retired_by" type="int"/>
18361838
<column name="date_retired" type="DATETIME"/>
18371839
<column name="retire_reason" type="varchar(255)" defaultValue="null"/>
1838-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1840+
<column name="uuid" type="char(38)"/>
18391841
</createTable>
18401842
<modifySql dbms="mssql">
18411843
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1870,7 +1872,7 @@
18701872
<column name="retired_by" type="int" />
18711873
<column name="date_retired" type="datetime" />
18721874
<column name="retire_reason" type="varchar(255)" defaultValue="null"/>
1873-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1875+
<column name="uuid" type="char(38)" />
18741876
</createTable>
18751877
<modifySql dbms="mssql">
18761878
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1921,7 +1923,7 @@
19211923
<column name="date_retired" type="DATETIME"/>
19221924
<column name="retired_by" type="int"/>
19231925
<column name="retire_reason" type="varchar(1000)"/>
1924-
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
1926+
<column name="uuid" type="char(38)" />
19251927
</createTable>
19261928
<modifySql dbms="mssql">
19271929
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />

0 commit comments

Comments
 (0)
Please sign in to comment.