Honor supplied field order when adding fields to a table object

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

diff --git a/t/data/diff/create1.yml b/t/data/diff/create1.yml
index 8e08999..4cddd5c 100644 (file)
--- a/t/data/diff/create1.yml
+++ b/t/data/diff/create1.yml
@@ -23,7 +23,7 @@ schema:
           is_primary_key: 0
           is_unique: 0
           name: id
-          order: 10
+          order: 1
           size:
             - 11
       indices: []
@@ -67,7 +67,7 @@ schema:
           is_primary_key: 1
           is_unique: 0
           name: employee_id
-          order: 8
+          order: 2
           size:
             - 11
         job_title:
@@ -78,7 +78,7 @@ schema:
           is_primary_key: 0
           is_unique: 0
           name: job_title
-          order: 9
+          order: 3
           size:
             - 255
         position:
@@ -89,7 +89,7 @@ schema:
           is_primary_key: 1
           is_unique: 0
           name: position
-          order: 7
+          order: 1
           size:
             - 50
       indices: []
@@ -97,6 +97,20 @@ schema:
       options:
         - ENGINE: InnoDB
       order: 2
+    old_name:
+      name: 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
+      order: 4
     person:
       constraints:
         - deferrable: 1