projects
/
dbsrgits/SQL-Translator.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
blame
|
history
|
raw
|
HEAD
[merge] Batch alter support for Pg and refactoring
[dbsrgits/SQL-Translator.git]
/
t
/
data
/
diff
/
create1.yml
1
---
2
schema:
3
procedures: {}
4
tables:
5
deleted:
6
constraints:
7
- fields: id
8
name: 'fk_fake'
9
reference_fields:
10
- fk_id
11
reference_table: fake
12
type: FOREIGN KEY
13
- fields:
14
- id
15
name: pk_id
16
type: UNIQUE
17
fields:
18
id:
19
data_type: int
20
default_value: ~
21
extra: {}
22
is_nullable: 1
23
is_primary_key: 0
24
is_unique: 0
25
name: id
26
order: 1
27
size:
28
- 11
29
indices: []
30
name: deleted
31
options: []
32
order: 3
33
employee:
34
constraints:
35
- deferrable: 1
36
expression: ''
37
fields:
38
- employee_id
39
match_type: ''
40
name: FK5302D47D93FE702E
41
on_delete: ''
42
on_update: ''
43
options: []
44
reference_fields:
45
- person_id
46
reference_table: person
47
type: FOREIGN KEY
48
- deferrable: 1
49
expression: ''
50
fields:
51
- position
52
- employee_id
53
match_type: ''
54
name: ''
55
on_delete: ''
56
on_update: ''
57
options: []
58
reference_fields: []
59
reference_table: ''
60
type: PRIMARY KEY
61
fields:
62
employee_id:
63
data_type: int
64
default_value: ~
65
extra: {}
66
is_nullable: 0
67
is_primary_key: 1
68
is_unique: 0
69
name: employee_id
70
order: 2
71
size:
72
- 11
73
job_title:
74
data_type: varchar
75
default_value: ~
76
extra: {}
77
is_nullable: 1
78
is_primary_key: 0
79
is_unique: 0
80
name: job_title
81
order: 3
82
size:
83
- 255
84
position:
85
data_type: varchar
86
default_value: ~
87
extra: {}
88
is_nullable: 0
89
is_primary_key: 1
90
is_unique: 0
91
name: position
92
order: 1
93
size:
94
- 50
95
indices: []
96
name: employee
97
options:
98
- ENGINE: InnoDB
99
order: 2
100
old_name:
101
name: old_name
102
fields:
103
pk:
104
data_type: int
105
default_value: ~
106
extra: {}
107
is_auto_increment: 1
108
is_nullable: 0
109
is_primary_key: 1
110
is_unique: 1
111
name: pk
112
order: 1
113
order: 4
114
person:
115
constraints:
116
- deferrable: 1
117
expression: ''
118
fields:
119
- person_id
120
match_type: ''
121
name: ''
122
on_delete: ''
123
on_update: ''
124
options: []
125
reference_fields: []
126
reference_table: ''
127
type: PRIMARY KEY
128
- deferrable: 1
129
expression: ''
130
fields:
131
- age
132
match_type: ''
133
name: UC_age_name
134
on_delete: ''
135
on_update: ''
136
options: []
137
reference_fields: []
138
reference_table: ''
139
type: UNIQUE
140
fields:
141
age:
142
data_type: int
143
default_value: ~
144
extra: {}
145
is_nullable: 1
146
is_primary_key: 0
147
is_unique: 1
148
name: age
149
order: 3
150
size:
151
- 11
152
description:
153
data_type: text
154
default_value: ~
155
extra: {}
156
is_nullable: 1
157
is_primary_key: 0
158
is_unique: 0
159
name: description
160
order: 6
161
size:
162
- 65535
163
iq:
164
data_type: tinyint
165
default_value: 0
166
extra: {}
167
is_nullable: 1
168
is_primary_key: 0
169
is_unique: 0
170
name: iq
171
order: 5
172
size:
173
- 4
174
name:
175
data_type: varchar
176
default_value: ~
177
extra: {}
178
is_nullable: 1
179
is_primary_key: 0
180
is_unique: 0
181
name: name
182
order: 2
183
size:
184
- 20
185
person_id:
186
data_type: int
187
default_value: ~
188
extra: {}
189
is_nullable: 0
190
is_primary_key: 1
191
is_unique: 0
192
name: person_id
193
order: 1
194
size:
195
- 11
196
weight:
197
data_type: double
198
default_value: ~
199
extra: {}
200
is_nullable: 1
201
is_primary_key: 0
202
is_unique: 0
203
name: weight
204
order: 4
205
size:
206
- 11
207
- 2
208
value:
209
data_type: double
210
default_value: 0
211
extra: {}
212
is_nullable: 1
213
is_primary_key: 0
214
is_unique: 0
215
name: value
216
order: 7
217
size:
218
- 8
219
- 2
220
indices:
221
- fields:
222
- name
223
name: u_name
224
options: []
225
type: UNIQUE
226
name: person
227
options:
228
- ENGINE: MyISAM
229
order: 1
230
triggers: {}
231
views: {}
232
translator:
233
add_drop_table: 0
234
filename: t/data/mysql/create.sql
235
no_comments: 0
236
parser_args:
237
db_password: ~
238
db_user: ~
239
dsn: ~
240
field_separator: ~
241
mysql_parser_version: ~
242
record_separator: ~
243
scan_fields: 1
244
trim_fields: 1
245
parser_type: SQL::Translator::Parser::MySQL
246
producer_args:
247
add_prefix: ~
248
add_truncate: ~
249
db_password: ~
250
db_user: ~
251
dsn: ~
252
imap_file: ~
253
imap_url: ~
254
indent: ~
255
newlines: ~
256
package_name: ~
257
prefix: ~
258
pretty: ~
259
skip: ~
260
skiplike: ~
261
title: ~
262
tt_conf: {}
263
tt_vars: {}
264
ttfile: ~
265
producer_type: SQL::Translator::Producer::YAML
266
show_warnings: 0
267
trace: 0
268
version: 0.0899_01