t/data/diff/pgsql/create1.yml

   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       order: 2
  98     old_name:
  99       name: old_name
 100       fields:
 101         pk:
 102           data_type: int
 103           default_value: ~
 104           extra: {}
 105           is_auto_increment: 1
 106           is_nullable: 0
 107           is_primary_key: 1
 108           is_unique: 1
 109           name: pk
 110           order: 1
 111       order: 4
 112     person:
 113       constraints:
 114         - deferrable: 1
 115           expression: ''
 116           fields:
 117             - person_id
 118           match_type: ''
 119           name: ''
 120           on_delete: ''
 121           on_update: ''
 122           options: []
 123           reference_fields: []
 124           reference_table: ''
 125           type: PRIMARY KEY
 126         - deferrable: 1
 127           expression: ''
 128           fields:
 129             - age
 130           match_type: ''
 131           name: UC_age_name
 132           on_delete: ''
 133           on_update: ''
 134           options: []
 135           reference_fields: []
 136           reference_table: ''
 137           type: UNIQUE
 138       fields:
 139         age:
 140           data_type: int
 141           default_value: ~
 142           extra: {}
 143           is_nullable: 1
 144           is_primary_key: 0
 145           is_unique: 1
 146           name: age
 147           order: 3
 148           size:
 149             - 11
 150         description:
 151           data_type: text
 152           default_value: ~
 153           extra: {}
 154           is_nullable: 1
 155           is_primary_key: 0
 156           is_unique: 0
 157           name: description
 158           order: 6
 159           size:
 160             - 65535
 161         iq:
 162           data_type: smallint
 163           default_value: 0
 164           is_nullable: 1
 165           is_primary_key: 0
 166           is_unique: 0
 167           name: iq
 168           order: 5
 169           size:
 170             - 4
 171         name:
 172           data_type: varchar
 173           default_value: ~
 174           extra: {}
 175           is_nullable: 1
 176           is_primary_key: 0
 177           is_unique: 0
 178           name: name
 179           order: 2
 180           size:
 181             - 20
 182         person_id:
 183           data_type: int
 184           default_value: ~
 185           extra: {}
 186           is_nullable: 0
 187           is_primary_key: 1
 188           is_unique: 0
 189           name: person_id
 190           order: 1
 191           size:
 192             - 11
 193         weight:
 194           data_type: numeric
 195           default_value: ~
 196           extra: {}
 197           is_nullable: 1
 198           is_primary_key: 0
 199           is_unique: 0
 200           name: weight
 201           order: 4
 202           size:
 203             - 11
 204             - 2
 205       indices:
 206         - fields:
 207             - name
 208           name: u_name
 209           options: []
 210           type: UNIQUE
 211       name: person
 212       order: 1
 213   triggers: {}
 214   views: {}
 215 translator:
 216   add_drop_table: 0
 217   filename: t/data/pgsql/create.sql
 218   no_comments: 0
 219   parser_args:
 220     db_password: ~
 221     db_user: ~
 222     dsn: ~
 223     field_separator: ~
 224     mysql_parser_version: ~
 225     record_separator: ~
 226     scan_fields: 1
 227     trim_fields: 1
 228   parser_type: SQL::Translator::Parser::PostgreSQL
 229   producer_args:
 230     add_prefix: ~
 231     add_truncate: ~
 232     db_password: ~
 233     db_user: ~
 234     dsn: ~
 235     imap_file: ~
 236     imap_url: ~
 237     indent: ~
 238     newlines: ~
 239     package_name: ~
 240     prefix: ~
 241     pretty: ~
 242     skip: ~
 243     skiplike: ~
 244     title: ~
 245     tt_conf: {}
 246     tt_vars: {}
 247     ttfile: ~
 248   producer_type: SQL::Translator::Producer::YAML
 249   show_warnings: 0
 250   trace: 0
 251   version: 0.0899_01