X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fdata%2Fdiff%2Fcreate1.yml;h=b0f147763b28f1a95f42b770919964c51b518a0a;hb=3ab19c1b31fa1fef8284a271afd282736242dd8f;hp=8e08999412f67c16317db43eec4a5a11359627c1;hpb=4d4385499fa84e31f78abe4cacf517e4a11c7b8f;p=dbsrgits%2FSQL-Translator.git diff --git a/t/data/diff/create1.yml b/t/data/diff/create1.yml index 8e08999..b0f1477 100644 --- 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 @@ -191,6 +205,18 @@ schema: size: - 11 - 2 + value: + data_type: double + default_value: 0 + extra: {} + is_nullable: 1 + is_primary_key: 0 + is_unique: 0 + name: value + order: 7 + size: + - 8 + - 2 indices: - fields: - name