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