Skip to content

Commit e0a7c2b

Browse files
ArcTanSusanrkorytkowski
ArcTanSusan
authored and
rkorytkowski
committedJun 17, 2013
TRUNK-3915 Resolved and successfully tested.
(cherry picked from commit cebb56d)
·
latest1.9.4
1 parent e76fc6b commit e0a7c2b

File tree

1 file changed

+56
-57
lines changed

1 file changed

+56
-57
lines changed
 

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

+56-57
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)" />
32+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
80+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
103+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
132+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
162+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
190+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
218+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
250+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
279+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
340+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
374+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
417+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
431+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
489+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
558+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
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)" />
587+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
588588
</createTable>
589589
<modifySql dbms="mssql">
590590
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -621,7 +621,7 @@
621621
<column name="retired_by" type="int"/>
622622
<column name="date_retired" type="DATETIME"/>
623623
<column name="retire_reason" type="varchar(255)"/>
624-
<column name="uuid" type="char(38)" />
624+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
625625
</createTable>
626626
<modifySql dbms="mssql">
627627
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -641,7 +641,7 @@
641641
<column name="date_created" type="DATETIME">
642642
<constraints nullable="false"/>
643643
</column>
644-
<column name="uuid" type="char(38)" />
644+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
645645
</createTable>
646646
<modifySql dbms="mssql">
647647
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -663,7 +663,7 @@
663663
<column name="date_created" type="DATETIME">
664664
<constraints nullable="false"/>
665665
</column>
666-
<column name="uuid" type="char(38)" />
666+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
667667
</createTable>
668668
<modifySql dbms="mssql">
669669
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -702,7 +702,7 @@
702702
<column name="retired_by" type="int"/>
703703
<column name="date_retired" type="DATETIME"/>
704704
<column name="retired_reason" type="varchar(255)"/>
705-
<column name="uuid" type="char(38)" />
705+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
706706
</createTable>
707707
<modifySql dbms="mssql">
708708
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -737,7 +737,7 @@
737737
<constraints nullable="false"/>
738738
</column>
739739
<column name="sort_weight" type="real"/>
740-
<column name="uuid" type="char(38)" />
740+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
741741
</createTable>
742742
<modifySql dbms="mssql">
743743
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -750,7 +750,7 @@
750750
</column>
751751
<column name="property_value" type="text"/>
752752
<column name="description" type="text"/>
753-
<column name="uuid" type="char(38)" />
753+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
754754
</createTable>
755755
<modifySql dbms="mssql">
756756
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -772,7 +772,7 @@
772772
<constraints nullable="false"/>
773773
</column>
774774
<column name="message_state" type="int" defaultValueNumeric="2" remarks="2=processed, 4=deleted"/>
775-
<column name="uuid" type="char(38)" />
775+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
776776
</createTable>
777777
<modifySql dbms="mssql">
778778
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -797,7 +797,7 @@
797797
<column name="date_created" type="DATETIME">
798798
<constraints nullable="false"/>
799799
</column>
800-
<column name="uuid" type="char(38)" />
800+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
801801
</createTable>
802802
<modifySql dbms="mssql">
803803
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -821,8 +821,7 @@
821821
<column name="date_processed" type="DATETIME"/>
822822
<column name="error_msg" type="text"/>
823823
<column name="date_created" type="DATETIME"/>
824-
<column name="uuid" type="char(38)" />
825-
</createTable>
824+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
826825
<modifySql dbms="mssql">
827826
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
828827
</modifySql>
@@ -842,7 +841,7 @@
842841
<column name="date_created" type="DATETIME">
843842
<constraints nullable="false"/>
844843
</column>
845-
<column name="uuid" type="char(38)" />
844+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
846845
</createTable>
847846
<modifySql dbms="mssql">
848847
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -883,7 +882,7 @@
883882
<column name="date_retired" type="DATETIME"/>
884883
<column name="retire_reason" type="varchar(255)"/>
885884
<column name="parent_location" type="int"/>
886-
<column name="uuid" type="char(38)" />
885+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
887886
</createTable>
888887
<modifySql dbms="mssql">
889888
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -911,7 +910,7 @@
911910
</column>
912911
<column name="changed_by" type="int"/>
913912
<column name="date_changed" type="DATETIME"/>
914-
<column name="uuid" type="char(38)" />
913+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
915914
</createTable>
916915
<modifySql dbms="mssql">
917916
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -940,7 +939,7 @@
940939
</column>
941940
<column name="changed_by" type="int"/>
942941
<column name="date_changed" type="DATETIME"/>
943-
<column name="uuid" type="char(38)" />
942+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
944943
</createTable>
945944
<modifySql dbms="mssql">
946945
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -958,7 +957,7 @@
958957
<constraints nullable="false"/>
959958
</column>
960959
<column name="date_changed" type="timestamp"/>
961-
<column name="uuid" type="char(38)" />
960+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
962961
</createTable>
963962
<modifySql dbms="mssql">
964963
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -975,7 +974,7 @@
975974
<column name="sender" type="varchar(255)"/>
976975
<column name="recipients" type="varchar(512)"/>
977976
<column defaultValueNumeric="0" name="ordinal" type="int"/>
978-
<column name="uuid" type="char(38)" />
977+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
979978
</createTable>
980979
<modifySql dbms="mssql">
981980
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1023,7 +1022,7 @@
10231022
<column name="voided_by" type="int"/>
10241023
<column name="date_voided" type="DATETIME"/>
10251024
<column name="void_reason" type="varchar(255)"/>
1026-
<column name="uuid" type="char(38)" />
1025+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
10271026
</createTable>
10281027
<modifySql dbms="mssql">
10291028
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1052,7 +1051,7 @@
10521051
<column name="retired_by" type="int"/>
10531052
<column name="date_retired" type="DATETIME"/>
10541053
<column name="retire_reason" type="varchar(255)"/>
1055-
<column name="uuid" type="char(38)" />
1054+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
10561055
</createTable>
10571056
<modifySql dbms="mssql">
10581057
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1097,7 +1096,7 @@
10971096
<constraints nullable="false"/>
10981097
</column>
10991098
<column name="accession_number" type="varchar(255)"/>
1100-
<column name="uuid" type="char(38)" />
1099+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
11011100
</createTable>
11021101
<modifySql dbms="mssql">
11031102
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1157,7 +1156,7 @@
11571156
<column name="voided_by" type="int"/>
11581157
<column name="date_voided" type="DATETIME"/>
11591158
<column name="void_reason" type="varchar(255)"/>
1160-
<column name="uuid" type="char(38)" />
1159+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
11611160
</createTable>
11621161
<modifySql dbms="mssql">
11631162
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1198,7 +1197,7 @@
11981197
<column name="retired_by" type="int"/>
11991198
<column name="date_retired" type="DATETIME"/>
12001199
<column name="retire_reason" type="varchar(255)"/>
1201-
<column name="uuid" type="char(38)" />
1200+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
12021201
</createTable>
12031202
<modifySql dbms="mssql">
12041203
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1233,7 +1232,7 @@
12331232
<column name="voided_by" type="int"/>
12341233
<column name="date_voided" type="DATETIME"/>
12351234
<column name="void_reason" type="varchar(255)"/>
1236-
<column name="uuid" type="char(38)" />
1235+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
12371236
</createTable>
12381237
<modifySql dbms="mssql">
12391238
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1266,7 +1265,7 @@
12661265
<column name="voided_by" type="int"/>
12671266
<column name="date_voided" type="DATETIME"/>
12681267
<column name="void_reason" type="varchar(255)"/>
1269-
<column name="uuid" type="char(38)" />
1268+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
12701269
</createTable>
12711270
<modifySql dbms="mssql">
12721271
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1301,7 +1300,7 @@
13011300
<column name="voided_by" type="int"/>
13021301
<column name="date_voided" type="DATETIME"/>
13031302
<column name="void_reason" type="varchar(255)"/>
1304-
<column name="uuid" type="char(38)" />
1303+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
13051304
</createTable>
13061305
<modifySql dbms="mssql">
13071306
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1345,7 +1344,7 @@
13451344
<column name="address6" type="varchar(255)"/>
13461345
<column name="date_changed" type="DATETIME"/>
13471346
<column name="changed_by" type="int"/>
1348-
<column name="uuid" type="char(38)" />
1347+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
13491348
</createTable>
13501349
<modifySql dbms="mssql">
13511350
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1379,7 +1378,7 @@
13791378
<column name="voided_by" type="int"/>
13801379
<column name="date_voided" type="DATETIME"/>
13811380
<column name="void_reason" type="varchar(255)"/>
1382-
<column name="uuid" type="char(38)" />
1381+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
13831382
</createTable>
13841383
<modifySql dbms="mssql">
13851384
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1417,7 +1416,7 @@
14171416
<column name="retire_reason" type="varchar(255)"/>
14181417
<column name="edit_privilege" type="varchar(50)"/>
14191418
<column name="sort_weight" type="double precision"/>
1420-
<column name="uuid" type="char(38)" />
1419+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
14211420
</createTable>
14221421
<modifySql dbms="mssql">
14231422
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1456,7 +1455,7 @@
14561455
<column name="void_reason" type="varchar(255)"/>
14571456
<column name="changed_by" type="int"/>
14581457
<column name="date_changed" type="DATETIME"/>
1459-
<column name="uuid" type="char(38)" />
1458+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
14601459
</createTable>
14611460
<modifySql dbms="mssql">
14621461
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1470,7 +1469,7 @@
14701469
<column defaultValue="" name="description" type="varchar(250)">
14711470
<constraints nullable="false"/>
14721471
</column>
1473-
<column name="uuid" type="char(38)" />
1472+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
14741473
</createTable>
14751474
<modifySql dbms="mssql">
14761475
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1500,7 +1499,7 @@
15001499
<constraints nullable="false"/>
15011500
</column>
15021501
<column name="description" type="varchar(500)"/>
1503-
<column name="uuid" type="char(38)" />
1502+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
15041503
</createTable>
15051504
<modifySql dbms="mssql">
15061505
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1528,7 +1527,7 @@
15281527
</column>
15291528
<column name="changed_by" type="int"/>
15301529
<column name="date_changed" type="DATETIME"/>
1531-
<column name="uuid" type="char(38)" />
1530+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
15321531
</createTable>
15331532
<modifySql dbms="mssql">
15341533
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1562,7 +1561,7 @@
15621561
</column>
15631562
<column name="changed_by" type="int"/>
15641563
<column name="date_changed" type="DATETIME"/>
1565-
<column name="uuid" type="char(38)" />
1564+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
15661565
</createTable>
15671566
<modifySql dbms="mssql">
15681567
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1598,7 +1597,7 @@
15981597
<column name="voided_by" type="int"/>
15991598
<column name="date_voided" type="DATETIME"/>
16001599
<column name="void_reason" type="varchar(255)"/>
1601-
<column name="uuid" type="char(38)" />
1600+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
16021601
</createTable>
16031602
<modifySql dbms="mssql">
16041603
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1636,7 +1635,7 @@
16361635
<column name="retired_by" type="int"/>
16371636
<column name="date_retired" type="DATETIME"/>
16381637
<column name="retire_reason" type="varchar(255)"/>
1639-
<column name="uuid" type="char(38)" />
1638+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
16401639
</createTable>
16411640
<modifySql dbms="mssql">
16421641
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1672,7 +1671,7 @@
16721671
<column name="voided_by" type="int"/>
16731672
<column name="date_voided" type="DATETIME"/>
16741673
<column name="void_reason" type="varchar(255)"/>
1675-
<column name="uuid" type="char(38)" />
1674+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
16761675
</createTable>
16771676
<modifySql dbms="mssql">
16781677
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1692,7 +1691,7 @@
16921691
<column name="xml_data" type="text">
16931692
<constraints nullable="false"/>
16941693
</column>
1695-
<column name="uuid" type="char(38)" />
1694+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
16961695
</createTable>
16971696
<modifySql dbms="mssql">
16981697
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1706,7 +1705,7 @@
17061705
<column defaultValue="" name="description" type="varchar(255)">
17071706
<constraints nullable="false"/>
17081707
</column>
1709-
<column name="uuid" type="char(38)" />
1708+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
17101709
</createTable>
17111710
<modifySql dbms="mssql">
17121711
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1760,7 +1759,7 @@
17601759
<column name="last_execution_time" type="DATETIME">
17611760
<constraints nullable="true"/>
17621761
</column>
1763-
<column name="uuid" type="char(38)" />
1762+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
17641763
</createTable>
17651764
<modifySql dbms="mssql">
17661765
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1831,7 +1830,7 @@
18311830
<column name="retired_by" type="int"/>
18321831
<column name="date_retired" type="DATETIME"/>
18331832
<column name="retire_reason" type="varchar(255)" defaultValue="null"/>
1834-
<column name="uuid" type="char(38)"/>
1833+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
18351834
</createTable>
18361835
<modifySql dbms="mssql">
18371836
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1866,7 +1865,7 @@
18661865
<column name="retired_by" type="int" />
18671866
<column name="date_retired" type="datetime" />
18681867
<column name="retire_reason" type="varchar(255)" defaultValue="null"/>
1869-
<column name="uuid" type="char(38)" />
1868+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
18701869
</createTable>
18711870
<modifySql dbms="mssql">
18721871
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1917,7 +1916,7 @@
19171916
<column name="date_retired" type="DATETIME"/>
19181917
<column name="retired_by" type="int"/>
19191918
<column name="retire_reason" type="varchar(1000)"/>
1920-
<column name="uuid" type="char(38)" />
1919+
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
19211920
</createTable>
19221921
<modifySql dbms="mssql">
19231922
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />

0 commit comments

Comments
 (0)
Please sign in to comment.