| 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 |
projects / dbsrgits/SQL-Translator-2.0-ish.git / blame