Honor supplied field order when adding fields to a table object
[dbsrgits/SQL-Translator.git] / t / data / oracle / schema_diff_b.yaml
1 ---
2 schema:
3   procedures: {}
4   tables:
5     d_operator:
6       constraints:
7         - deferrable: 1
8           expression: ''
9           fields:
10             - id_operator
11           match_type: ''
12           name: ''
13           on_delete: ''
14           on_update: ''
15           options: []
16           reference_fields: []
17           reference_table: ''
18           type: PRIMARY KEY
19       fields:
20         id_operator:
21           data_type: integer
22           default_value: ~
23           extra: {}
24           is_auto_increment: 1
25           is_nullable: 0
26           is_primary_key: 1
27           is_unique: 0
28           name: id_operator
29           order: 58
30           size:
31             - 0
32         name:
33           data_type: nvarchar2
34           default_value: ~
35           extra: {}
36           is_nullable: 0
37           is_primary_key: 0
38           is_unique: 0
39           name: name
40           order: 59
41           size:
42             - 10
43         other:
44           data_type: nvarchar2
45           default_value: ~
46           extra: {}
47           is_nullable: 0
48           is_primary_key: 0
49           is_unique: 0
50           name: other
51           order: 60
52           size:
53             - 10
54       name: d_operator
55       order: 11