Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: openmrs/openmrs-core
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: 97464e2a89c0
Choose a base ref
...
head repository: openmrs/openmrs-core
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: 5daf80389931
Choose a head ref
  • 2 commits
  • 1 file changed
  • 2 contributors

Commits on Jun 16, 2013

  1. TRUNK-3915 Resolved and successfully tested.

    @ArcTanSusan
    ArcTanSusan committed Jun 16, 2013
    Copy the full SHA
    cebb56d View commit details

Commits on Jun 17, 2013

  1. Merge pull request #344 from onceuponatimeforever/TRUNK-3915 

    TRUNK-3915 Resolved and successfully tested.
    @rkorytkowski
    rkorytkowski committed Jun 17, 2013
    Copy the full SHA
    5daf803 View commit details
Showing with 55 additions and 57 deletions.
  1. +55 −57 api/src/main/resources/liquibase-schema-only.xml
112 changes: 55 additions & 57 deletions api/src/main/resources/liquibase-schema-only.xml
View file
Original file line number Diff line number Diff line change
@@ -29,7 +29,7 @@
<column name="void_reason" type="varchar(255)"/>
<column name="changed_by" type="int"/>
<column name="date_changed" type="DATETIME"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -77,7 +77,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -100,7 +100,7 @@
<constraints nullable="false"/>
</column>
<column name="sort_weight" type="double precision"></column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -129,7 +129,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -159,7 +159,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -187,7 +187,7 @@
</column>
<column name="changed_by" type="int"/>
<column name="date_changed" type="DATETIME"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -215,7 +215,7 @@
</column>
<column name="changed_by" type="int"/>
<column name="date_changed" type="DATETIME"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -247,7 +247,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -276,7 +276,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -337,7 +337,7 @@
<column defaultValue="" name="locale" type="varchar(50)">
<constraints nullable="false"/>
</column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -371,7 +371,7 @@
<column name="date_created" type="DATETIME">
<constraints nullable="false"/>
</column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -414,7 +414,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -428,7 +428,7 @@
<column defaultValueNumeric="0" name="concept_id" type="int"/>
<column defaultValueNumeric="0" name="program_workflow_id" type="int"/>
<column defaultValueNumeric="0" name="program_workflow_state_id" type="int"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -486,7 +486,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -555,7 +555,7 @@
<column name="changed_by" type="int"/>
<column name="date_changed" type="DATETIME"/>
<column name="visit_id" type="int"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -584,7 +584,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
<column name="edit_privilege" type="varchar(255)">
<constraints nullable="true"/>
</column>
@@ -627,7 +627,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -647,7 +647,7 @@
<column name="date_created" type="DATETIME">
<constraints nullable="false"/>
</column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -669,7 +669,7 @@
<column name="date_created" type="DATETIME">
<constraints nullable="false"/>
</column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -708,7 +708,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retired_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -743,7 +743,7 @@
<constraints nullable="false"/>
</column>
<column name="sort_weight" type="real"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -756,7 +756,7 @@
</column>
<column name="property_value" type="text"/>
<column name="description" type="text"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -778,7 +778,7 @@
<constraints nullable="false"/>
</column>
<column name="message_state" type="int" defaultValueNumeric="2" remarks="2=processed, 4=deleted"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -803,7 +803,6 @@
<column name="date_created" type="DATETIME">
<constraints nullable="false"/>
</column>
<column name="uuid" type="char(38)" />
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -827,8 +826,7 @@
<column name="date_processed" type="DATETIME"/>
<column name="error_msg" type="text"/>
<column name="date_created" type="DATETIME"/>
<column name="uuid" type="char(38)" />
</createTable>
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
</modifySql>
@@ -848,7 +846,7 @@
<column name="date_created" type="DATETIME">
<constraints nullable="false"/>
</column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -889,7 +887,7 @@
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="parent_location" type="int"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -917,7 +915,7 @@
</column>
<column name="changed_by" type="int"/>
<column name="date_changed" type="DATETIME"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -946,7 +944,7 @@
</column>
<column name="changed_by" type="int"/>
<column name="date_changed" type="DATETIME"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -964,7 +962,7 @@
<constraints nullable="false"/>
</column>
<column name="date_changed" type="timestamp"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -981,7 +979,7 @@
<column name="sender" type="varchar(255)"/>
<column name="recipients" type="varchar(512)"/>
<column defaultValueNumeric="0" name="ordinal" type="int"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1029,7 +1027,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1058,7 +1056,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1103,7 +1101,7 @@
<constraints nullable="false"/>
</column>
<column name="accession_number" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1163,7 +1161,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1204,7 +1202,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1239,7 +1237,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1272,7 +1270,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1307,7 +1305,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1351,7 +1349,7 @@
<column name="address6" type="varchar(255)"/>
<column name="date_changed" type="DATETIME"/>
<column name="changed_by" type="int"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1385,7 +1383,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1423,7 +1421,7 @@
<column name="retire_reason" type="varchar(255)"/>
<column name="edit_privilege" type="varchar(255)"/>
<column name="sort_weight" type="double precision"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1462,7 +1460,7 @@
<column name="void_reason" type="varchar(255)"/>
<column name="changed_by" type="int"/>
<column name="date_changed" type="DATETIME"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1476,7 +1474,7 @@
<column defaultValue="" name="description" type="varchar(250)">
<constraints nullable="false"/>
</column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1506,7 +1504,7 @@
<constraints nullable="false"/>
</column>
<column name="description" type="varchar(500)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1534,7 +1532,7 @@
</column>
<column name="changed_by" type="int"/>
<column name="date_changed" type="DATETIME"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1568,7 +1566,7 @@
</column>
<column name="changed_by" type="int"/>
<column name="date_changed" type="DATETIME"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1604,7 +1602,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1642,7 +1640,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1678,7 +1676,7 @@
<column name="voided_by" type="int"/>
<column name="date_voided" type="DATETIME"/>
<column name="void_reason" type="varchar(255)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1698,7 +1696,7 @@
<column name="xml_data" type="text">
<constraints nullable="false"/>
</column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1712,7 +1710,7 @@
<column defaultValue="" name="description" type="varchar(255)">
<constraints nullable="false"/>
</column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1766,7 +1764,7 @@
<column name="last_execution_time" type="DATETIME">
<constraints nullable="true"/>
</column>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1837,7 +1835,7 @@
<column name="retired_by" type="int"/>
<column name="date_retired" type="DATETIME"/>
<column name="retire_reason" type="varchar(255)" defaultValue="null"/>
<column name="uuid" type="char(38)"/>
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1872,7 +1870,7 @@
<column name="retired_by" type="int" />
<column name="date_retired" type="datetime" />
<column name="retire_reason" type="varchar(255)" defaultValue="null"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />
@@ -1923,7 +1921,7 @@
<column name="date_retired" type="DATETIME"/>
<column name="retired_by" type="int"/>
<column name="retire_reason" type="varchar(1000)"/>
<column name="uuid" type="char(38)" />
<column name="uuid" type="char(38)"><constraints nullable="false"/></column>
</createTable>
<modifySql dbms="mssql">
<replace replace="CHAR(38)" with="UNIQUEIDENTIFIER NOT NULL DEFAULT NEWSEQUENTIALID()" />