Commit | Line | Data |
4d438549 |
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 |
46bf5655 |
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 |
4d438549 |
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 |