projects
/
dbsrgits/SQL-Translator.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
blame
|
history
|
raw
|
HEAD
Fix test
[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: 10
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: 8
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: 9
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: 7
93
size:
94
- 50
95
indices: []
96
name: employee
97
options:
98
- ENGINE: InnoDB
99
order: 2
100
person:
101
constraints:
102
- deferrable: 1
103
expression: ''
104
fields:
105
- person_id
106
match_type: ''
107
name: ''
108
on_delete: ''
109
on_update: ''
110
options: []
111
reference_fields: []
112
reference_table: ''
113
type: PRIMARY KEY
114
- deferrable: 1
115
expression: ''
116
fields:
117
- age
118
match_type: ''
119
name: UC_age_name
120
on_delete: ''
121
on_update: ''
122
options: []
123
reference_fields: []
124
reference_table: ''
125
type: UNIQUE
126
fields:
127
age:
128
data_type: int
129
default_value: ~
130
extra: {}
131
is_nullable: 1
132
is_primary_key: 0
133
is_unique: 1
134
name: age
135
order: 3
136
size:
137
- 11
138
description:
139
data_type: text
140
default_value: ~
141
extra: {}
142
is_nullable: 1
143
is_primary_key: 0
144
is_unique: 0
145
name: description
146
order: 6
147
size:
148
- 65535
149
iq:
150
data_type: tinyint
151
default_value: 0
152
extra: {}
153
is_nullable: 1
154
is_primary_key: 0
155
is_unique: 0
156
name: iq
157
order: 5
158
size:
159
- 4
160
name:
161
data_type: varchar
162
default_value: ~
163
extra: {}
164
is_nullable: 1
165
is_primary_key: 0
166
is_unique: 0
167
name: name
168
order: 2
169
size:
170
- 20
171
person_id:
172
data_type: int
173
default_value: ~
174
extra: {}
175
is_nullable: 0
176
is_primary_key: 1
177
is_unique: 0
178
name: person_id
179
order: 1
180
size:
181
- 11
182
weight:
183
data_type: double
184
default_value: ~
185
extra: {}
186
is_nullable: 1
187
is_primary_key: 0
188
is_unique: 0
189
name: weight
190
order: 4
191
size:
192
- 11
193
- 2
194
indices:
195
- fields:
196
- name
197
name: u_name
198
options: []
199
type: UNIQUE
200
name: person
201
options:
202
- ENGINE: MyISAM
203
order: 1
204
triggers: {}
205
views: {}
206
translator:
207
add_drop_table: 0
208
filename: t/data/mysql/create.sql
209
no_comments: 0
210
parser_args:
211
db_password: ~
212
db_user: ~
213
dsn: ~
214
field_separator: ~
215
mysql_parser_version: ~
216
record_separator: ~
217
scan_fields: 1
218
trim_fields: 1
219
parser_type: SQL::Translator::Parser::MySQL
220
producer_args:
221
add_prefix: ~
222
add_truncate: ~
223
db_password: ~
224
db_user: ~
225
dsn: ~
226
imap_file: ~
227
imap_url: ~
228
indent: ~
229
newlines: ~
230
package_name: ~
231
prefix: ~
232
pretty: ~
233
skip: ~
234
skiplike: ~
235
title: ~
236
tt_conf: {}
237
tt_vars: {}
238
ttfile: ~
239
producer_type: SQL::Translator::Producer::YAML
240
show_warnings: 0
241
trace: 0
242
version: 0.0899_01