fix diff for altering two things per column - add ; at the end

[dbsrgits/SQL-Translator.git] / t / data / diff / create2.yml

diff --git a/t/data/diff/create2.yml b/t/data/diff/create2.yml
index ccdb6e6..693c20a 100644 (file)
--- a/t/data/diff/create2.yml
+++ b/t/data/diff/create2.yml
@@ -13,7 +13,7 @@ schema:
           is_primary_key: 0
           is_unique: 0
           name: id
-          order: 10
+          order: 1
           size:
             - 11
       indices: []
@@ -53,11 +53,11 @@ schema:
           data_type: int
           default_value: ~
           extra: {}
-          is_nullable: 0
+          is_nullable: 1
           is_primary_key: 1
           is_unique: 0
           name: employee_id
-          order: 9
+          order: 2
           size:
             - 11
         position:
@@ -68,7 +68,7 @@ schema:
           is_primary_key: 1
           is_unique: 0
           name: position
-          order: 8
+          order: 1
           size:
             - 50
       indices: []
@@ -76,6 +76,26 @@ schema:
       options:
         - ENGINE: InnoDB
       order: 2
+    new_name:
+      name: new_name
+      extra:
+        renamed_from: old_name
+      fields:
+        pk:
+          data_type: int
+          default_value: ~
+          extra: {}
+          is_auto_increment: 1
+          is_nullable: 0
+          is_primary_key: 1
+          is_unique: 1
+          name: pk
+          order: 1
+        other:
+          data_type: int
+          name: new_field
+          order: 2
+      order: 4
     person:
       constraints:
         - deferrable: 1