Commit | Line | Data |
3406fd5b |
1 | --- |
2 | schema: |
3 | procedures: {} |
4 | tables: |
5 | added: |
6 | constraints: [] |
7 | fields: |
8 | id: |
9 | data_type: int |
10 | default_value: ~ |
11 | extra: {} |
12 | is_nullable: 1 |
13 | is_primary_key: 0 |
14 | is_unique: 0 |
15 | name: id |
16 | order: 10 |
17 | size: |
18 | - 11 |
19 | indices: [] |
20 | name: added |
21 | options: [] |
22 | order: 3 |
23 | employee: |
24 | constraints: |
25 | - deferrable: 1 |
26 | expression: '' |
27 | fields: |
28 | - employee_id |
29 | match_type: '' |
30 | name: FK5302D47D93FE702E_diff |
31 | on_delete: '' |
32 | on_update: '' |
33 | options: [] |
34 | reference_fields: |
35 | - person_id |
36 | reference_table: person |
37 | type: FOREIGN KEY |
38 | - deferrable: 1 |
39 | expression: '' |
40 | fields: |
41 | - employee_id |
42 | - position |
43 | match_type: '' |
44 | name: '' |
45 | on_delete: '' |
46 | on_update: '' |
47 | options: [] |
48 | reference_fields: [] |
49 | reference_table: '' |
50 | type: PRIMARY KEY |
51 | fields: |
52 | employee_id: |
53 | data_type: int |
54 | default_value: ~ |
55 | extra: {} |
56 | is_nullable: 1 |
57 | is_primary_key: 1 |
58 | is_unique: 0 |
59 | name: employee_id |
60 | order: 9 |
61 | size: |
62 | - 11 |
63 | position: |
64 | data_type: varchar |
65 | default_value: ~ |
66 | extra: {} |
67 | is_nullable: 0 |
68 | is_primary_key: 1 |
69 | is_unique: 0 |
70 | name: position |
71 | order: 8 |
72 | size: |
73 | - 50 |
74 | indices: [] |
75 | name: employee |
76 | order: 2 |
77 | new_name: |
78 | name: new_name |
79 | extra: |
80 | renamed_from: old_name |
81 | fields: |
82 | pk: |
83 | data_type: int |
84 | default_value: ~ |
85 | extra: {} |
86 | is_auto_increment: 1 |
87 | is_nullable: 0 |
88 | is_primary_key: 1 |
89 | is_unique: 1 |
90 | name: pk |
91 | order: 1 |
92 | other: |
93 | data_type: int |
94 | name: new_field |
95 | order: 2 |
96 | order: 4 |
97 | person: |
98 | constraints: |
99 | - deferrable: 1 |
100 | expression: '' |
101 | fields: |
102 | - person_id |
103 | match_type: '' |
104 | name: '' |
105 | on_delete: '' |
106 | on_update: '' |
107 | options: [] |
108 | reference_fields: [] |
109 | reference_table: '' |
110 | type: PRIMARY KEY |
111 | - deferrable: 1 |
112 | expression: '' |
113 | fields: |
114 | - person_id |
115 | match_type: '' |
116 | name: UC_person_id |
117 | on_delete: '' |
118 | on_update: '' |
119 | options: [] |
120 | reference_fields: [] |
121 | reference_table: '' |
122 | type: UNIQUE |
123 | - deferrable: 1 |
124 | expression: '' |
125 | fields: |
126 | - age |
127 | - name |
128 | match_type: '' |
129 | name: UC_age_name |
130 | on_delete: '' |
131 | on_update: '' |
132 | options: [] |
133 | reference_fields: [] |
134 | reference_table: '' |
135 | type: UNIQUE |
136 | fields: |
137 | age: |
138 | data_type: int |
139 | default_value: 18 |
140 | extra: {} |
141 | is_nullable: 1 |
142 | is_primary_key: 0 |
143 | is_unique: 1 |
144 | name: age |
145 | order: 3 |
146 | size: |
147 | - 11 |
148 | iq: |
149 | data_type: int |
150 | default_value: 0 |
151 | is_nullable: 1 |
152 | is_primary_key: 0 |
153 | is_unique: 0 |
154 | name: iq |
155 | order: 5 |
156 | size: |
157 | - 11 |
158 | is_rock_star: |
159 | data_type: smallint |
160 | default_value: 1 |
161 | extra: {} |
162 | is_nullable: 1 |
163 | is_primary_key: 0 |
164 | is_unique: 0 |
165 | name: is_rock_star |
166 | order: 6 |
167 | size: |
168 | - 4 |
169 | name: |
170 | data_type: varchar |
171 | default_value: ~ |
172 | extra: {} |
173 | is_nullable: 0 |
174 | is_primary_key: 0 |
175 | is_unique: 1 |
176 | name: name |
177 | order: 2 |
178 | size: |
179 | - 20 |
180 | person_id: |
181 | data_type: int |
182 | default_value: ~ |
183 | extra: {} |
184 | is_auto_increment: 1 |
185 | is_nullable: 0 |
186 | is_primary_key: 1 |
187 | is_unique: 1 |
188 | name: person_id |
189 | order: 1 |
190 | size: |
191 | - 11 |
192 | physical_description: |
193 | data_type: text |
194 | default_value: ~ |
195 | extra: |
196 | renamed_from: 'description' |
197 | is_nullable: 1 |
198 | is_primary_key: 0 |
199 | is_unique: 0 |
200 | name: physical_description |
201 | order: 7 |
202 | size: |
203 | - 65535 |
204 | weight: |
205 | data_type: numeric |
206 | default_value: ~ |
207 | extra: {} |
208 | is_nullable: 1 |
209 | is_primary_key: 0 |
210 | is_unique: 0 |
211 | name: weight |
212 | order: 4 |
213 | size: |
214 | - 11 |
215 | - 2 |
216 | indices: |
217 | - fields: |
218 | - name |
219 | name: unique_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/create2.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 |