t/data/diff/pgsql/create2.yml

   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         nickname:
 217           data_type: varchar
 218           default_value: ~
 219           extra: {}
 220           is_nullable: 0
 221           is_primary_key: 0
 222           is_unique: 0
 223           name: nickname
 224           order: 8
 225           size:
 226             - 24
 227       indices:
 228         - fields:
 229             - name
 230           name: unique_name
 231           options: []
 232           type: UNIQUE
 233       name: person
 234       order: 1
 235   triggers: {}
 236   views: {}
 237 translator:
 238   add_drop_table: 0
 239   filename: t/data/pgsql/create2.sql
 240   no_comments: 0
 241   parser_args:
 242     db_password: ~
 243     db_user: ~
 244     dsn: ~
 245     field_separator: ~
 246     mysql_parser_version: ~
 247     record_separator: ~
 248     scan_fields: 1
 249     trim_fields: 1
 250   parser_type: SQL::Translator::Parser::PostgreSQL
 251   producer_args:
 252     add_prefix: ~
 253     add_truncate: ~
 254     db_password: ~
 255     db_user: ~
 256     dsn: ~
 257     imap_file: ~
 258     imap_url: ~
 259     indent: ~
 260     newlines: ~
 261     package_name: ~
 262     prefix: ~
 263     pretty: ~
 264     skip: ~
 265     skiplike: ~
 266     title: ~
 267     tt_conf: {}
 268     tt_vars: {}
 269     ttfile: ~
 270   producer_type: SQL::Translator::Producer::YAML
 271   show_warnings: 0
 272   trace: 0
 273   version: 0.0899_01