projects
/
dbsrgits/SQL-Translator.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
blame
|
history
|
raw
|
HEAD
Fix ignored option to script/sqlt-diagram (RT#5992)
[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
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
indices:
209
- fields:
210
- name
211
name: u_name
212
options: []
213
type: UNIQUE
214
name: person
215
options:
216
- ENGINE: MyISAM
217
order: 1
218
triggers: {}
219
views: {}
220
translator:
221
add_drop_table: 0
222
filename: t/data/mysql/create.sql
223
no_comments: 0
224
parser_args:
225
db_password: ~
226
db_user: ~
227
dsn: ~
228
field_separator: ~
229
mysql_parser_version: ~
230
record_separator: ~
231
scan_fields: 1
232
trim_fields: 1
233
parser_type: SQL::Translator::Parser::MySQL
234
producer_args:
235
add_prefix: ~
236
add_truncate: ~
237
db_password: ~
238
db_user: ~
239
dsn: ~
240
imap_file: ~
241
imap_url: ~
242
indent: ~
243
newlines: ~
244
package_name: ~
245
prefix: ~
246
pretty: ~
247
skip: ~
248
skiplike: ~
249
title: ~
250
tt_conf: {}
251
tt_vars: {}
252
ttfile: ~
253
producer_type: SQL::Translator::Producer::YAML
254
show_warnings: 0
255
trace: 0
256
version: 0.0899_01