Commit | Line | Data |
ecc14773 |
1 | --- |
2 | schema: |
3 | procedures: |
4 | foo_proc: |
5 | comments: Go Sox! |
6 | extra: |
7 | bar: baz |
8 | foo: bar |
9 | hello: world |
10 | name: foo_proc |
11 | order: 1 |
12 | owner: Nomar |
13 | parameters: |
14 | - foo |
15 | - bar |
16 | sql: select foo from bar |
17 | tables: |
18 | Another: |
19 | constraints: |
20 | - deferrable: 1 |
21 | expression: '' |
22 | fields: |
23 | - id |
24 | match_type: '' |
25 | name: '' |
26 | on_delete: '' |
27 | on_update: '' |
28 | options: [] |
29 | reference_fields: [] |
30 | reference_table: '' |
31 | type: PRIMARY KEY |
32 | extra: |
33 | bar: baz |
34 | foo: bar |
35 | hello: world |
36 | mysql_table_type: InnoDB |
37 | fields: |
38 | id: |
39 | data_type: int |
40 | default_value: ~ |
41 | is_auto_increment: 1 |
42 | is_nullable: 0 |
43 | is_primary_key: 1 |
44 | is_unique: 0 |
45 | name: id |
46 | order: 1 |
47 | size: |
48 | - 10 |
49 | indices: [] |
50 | name: Another |
51 | options: [] |
52 | order: 2 |
53 | Basic: |
54 | constraints: |
55 | - deferrable: 1 |
56 | expression: '' |
57 | extra: |
58 | bar: baz |
59 | foo: bar |
60 | hello: world |
61 | fields: |
62 | - id |
63 | match_type: '' |
64 | name: '' |
65 | on_delete: '' |
66 | on_update: '' |
67 | options: [] |
68 | reference_fields: [] |
69 | reference_table: '' |
70 | type: PRIMARY KEY |
71 | - deferrable: 1 |
72 | expression: '' |
73 | fields: |
74 | - email |
75 | match_type: '' |
76 | name: emailuniqueindex |
77 | on_delete: '' |
78 | on_update: '' |
79 | options: [] |
80 | reference_fields: [] |
81 | reference_table: '' |
82 | type: UNIQUE |
83 | - deferrable: 1 |
84 | expression: '' |
85 | fields: |
86 | - another_id |
87 | match_type: '' |
88 | name: '' |
89 | on_delete: '' |
90 | on_update: '' |
91 | options: [] |
92 | reference_fields: |
93 | - id |
94 | reference_table: Another |
95 | type: FOREIGN KEY |
96 | extra: |
97 | bar: baz |
98 | foo: bar |
99 | hello: world |
100 | mysql_table_type: InnoDB |
101 | fields: |
102 | another_id: |
103 | data_type: int |
104 | default_value: 2 |
105 | is_nullable: 1 |
106 | is_primary_key: 0 |
107 | is_unique: 0 |
108 | name: another_id |
109 | order: 8 |
110 | size: |
111 | - 10 |
112 | description: |
113 | data_type: text |
114 | default_value: '' |
115 | is_nullable: 1 |
116 | is_primary_key: 0 |
117 | is_unique: 0 |
118 | name: description |
119 | order: 3 |
120 | size: |
121 | - 0 |
122 | email: |
123 | data_type: varchar |
124 | default_value: ~ |
125 | extra: |
126 | bar: baz |
127 | foo: bar |
128 | hello: world |
129 | is_nullable: 1 |
130 | is_primary_key: 0 |
131 | is_unique: 1 |
132 | name: email |
133 | order: 4 |
134 | size: |
135 | - 500 |
136 | emptytagdef: |
137 | comments: Hello emptytagdef |
138 | data_type: varchar |
139 | default_value: '' |
140 | is_nullable: 1 |
141 | is_primary_key: 0 |
142 | is_unique: 0 |
143 | name: emptytagdef |
144 | order: 7 |
145 | size: |
146 | - 0 |
147 | explicitemptystring: |
148 | data_type: varchar |
149 | default_value: '' |
150 | is_nullable: 1 |
151 | is_primary_key: 0 |
152 | is_unique: 0 |
153 | name: explicitemptystring |
154 | order: 6 |
155 | size: |
156 | - 0 |
157 | explicitnulldef: |
158 | data_type: varchar |
159 | default_value: ~ |
160 | is_nullable: 1 |
161 | is_primary_key: 0 |
162 | is_unique: 0 |
163 | name: explicitnulldef |
164 | order: 5 |
165 | size: |
166 | - 0 |
167 | id: |
168 | data_type: int |
169 | default_value: ~ |
170 | extra: |
171 | ZEROFILL: 1 |
172 | is_auto_increment: 1 |
173 | is_nullable: 0 |
174 | is_primary_key: 1 |
175 | is_unique: 0 |
176 | name: id |
177 | order: 1 |
178 | size: |
179 | - 10 |
180 | timest: |
181 | data_type: timestamp |
182 | default_value: ~ |
183 | is_nullable: 1 |
184 | is_primary_key: 0 |
185 | is_unique: 0 |
186 | name: timest |
187 | order: 9 |
188 | size: |
189 | - 0 |
190 | title: |
191 | data_type: varchar |
192 | default_value: hello |
193 | is_nullable: 0 |
194 | is_primary_key: 0 |
195 | is_unique: 0 |
196 | name: title |
197 | order: 2 |
198 | size: |
199 | - 100 |
200 | indices: |
201 | - extra: |
202 | bar: baz |
203 | foo: bar |
204 | hello: world |
205 | fields: |
206 | - title |
207 | name: titleindex |
208 | options: [] |
209 | type: NORMAL |
210 | name: Basic |
211 | options: [] |
212 | order: 1 |
213 | triggers: |
214 | bar_trigger: |
215 | action: update modified2=timestamp(); |
216 | database_events: |
217 | - insert |
218 | - update |
219 | extra: |
220 | hello: aliens |
221 | fields: ~ |
222 | name: bar_trigger |
223 | on_table: Basic |
224 | order: 2 |
225 | perform_action_when: before |
226 | foo_trigger: |
227 | action: update modified=timestamp(); |
228 | database_events: |
229 | - insert |
230 | extra: |
231 | bar: baz |
232 | foo: bar |
233 | hello: world |
234 | fields: ~ |
235 | name: foo_trigger |
236 | on_table: Basic |
237 | order: 1 |
238 | perform_action_when: after |
239 | views: |
240 | email_list: |
241 | extra: |
242 | bar: baz |
243 | foo: bar |
244 | hello: world |
245 | fields: |
246 | - email |
247 | name: email_list |
248 | order: 1 |
249 | sql: SELECT email FROM Basic WHERE (email IS NOT NULL) |
250 | translator: |
251 | add_drop_table: 0 |
252 | filename: t/data/roundtrip.xml |
253 | no_comments: 0 |
254 | parser_args: {} |
255 | parser_type: SQL::Translator::Parser::XML |
256 | producer_args: {} |
257 | producer_type: SQL::Translator::Producer::YAML |
258 | show_warnings: 0 |
259 | trace: 0 |
260 | version: 0.09007 |