[dbsrgits/SQL-Translator.git] / t / data / diff / pgsql / create1.yml

---
schema:
  procedures: {}
  tables:
    deleted:
      constraints:
        - fields: id
          name: 'fk_fake'
          reference_fields:
            - fk_id
          reference_table: fake
          type: FOREIGN KEY
        - fields:
            - id
          name: pk_id
          type: UNIQUE
      fields:
        id:
          data_type: int
          default_value: ~
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: id
          order: 10
          size:
            - 11
      indices: []
      name: deleted
      options: []
      order: 3
    employee:
      constraints:
        - deferrable: 1
          expression: ''
          fields:
            - employee_id
          match_type: ''
          name: FK5302D47D93FE702E
          on_delete: ''
          on_update: ''
          options: []
          reference_fields:
            - person_id
          reference_table: person
          type: FOREIGN KEY
        - deferrable: 1
          expression: ''
          fields:
            - position
            - employee_id
          match_type: ''
          name: ''
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: PRIMARY KEY
      fields:
        employee_id:
          data_type: int
          default_value: ~
          extra: {}
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: employee_id
          order: 8
          size:
            - 11
        job_title:
          data_type: varchar
          default_value: ~
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: job_title
          order: 9
          size:
            - 255
        position:
          data_type: varchar
          default_value: ~
          extra: {}
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: position
          order: 7
          size:
            - 50
      indices: []
      name: employee
      order: 2
    old_name:
      name: old_name
      fields:
        pk:
          data_type: int
          default_value: ~
          extra: {}
          is_auto_increment: 1
          is_nullable: 0
          is_primary_key: 1
          is_unique: 1
          name: pk
          order: 1
      order: 4
    person:
      constraints:
        - deferrable: 1
          expression: ''
          fields:
            - person_id
          match_type: ''
          name: ''
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: PRIMARY KEY
        - deferrable: 1
          expression: ''
          fields:
            - age
          match_type: ''
          name: UC_age_name
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: UNIQUE
      fields:
        age:
          data_type: int
          default_value: ~
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 1
          name: age
          order: 3
          size:
            - 11
        description:
          data_type: text
          default_value: ~
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: description
          order: 6
          size:
            - 65535
        iq:
          data_type: smallint
          default_value: 0
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: iq
          order: 5
          size:
            - 4
        name:
          data_type: varchar
          default_value: ~
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: name
          order: 2
          size:
            - 20
        person_id:
          data_type: int
          default_value: ~
          extra: {}
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: person_id
          order: 1
          size:
            - 11
        weight:
          data_type: numeric
          default_value: ~
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: weight
          order: 4
          size:
            - 11
            - 2
        nickname:
          data_type: varchar
          default_value: ~
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: nickname
          order: 8
          size:
            - 20
      indices:
        - fields:
            - name
          name: u_name
          options: []
          type: UNIQUE
      name: person
      order: 1
  triggers: {}
  views: {}
translator:
  add_drop_table: 0
  filename: t/data/pgsql/create.sql
  no_comments: 0
  parser_args:
    db_password: ~
    db_user: ~
    dsn: ~
    field_separator: ~
    mysql_parser_version: ~
    record_separator: ~
    scan_fields: 1
    trim_fields: 1
  parser_type: SQL::Translator::Parser::PostgreSQL
  producer_args:
    add_prefix: ~
    add_truncate: ~
    db_password: ~
    db_user: ~
    dsn: ~
    imap_file: ~
    imap_url: ~
    indent: ~
    newlines: ~
    package_name: ~
    prefix: ~
    pretty: ~
    skip: ~
    skiplike: ~
    title: ~
    tt_conf: {}
    tt_vars: {}
    ttfile: ~
  producer_type: SQL::Translator::Producer::YAML
  show_warnings: 0
  trace: 0
  version: 0.0899_01
Commit	Line	Data
3406fd5b	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
8953d9e7	205	nickname:
	206	data_type: varchar
	207	default_value: ~
	208	extra: {}
	209	is_nullable: 1
	210	is_primary_key: 0
	211	is_unique: 0
	212	name: nickname
	213	order: 8
	214	size:
	215	- 20
3406fd5b	216	indices:
	217	- fields:
	218	- name
	219	name: u_name
	220	options: []
	221	type: UNIQUE
	222	name: person
	223	order: 1
	224	triggers: {}
	225	views: {}
	226	translator:
	227	add_drop_table: 0
	228	filename: t/data/pgsql/create.sql
	229	no_comments: 0
	230	parser_args:
	231	db_password: ~
	232	db_user: ~
	233	dsn: ~
	234	field_separator: ~
	235	mysql_parser_version: ~
	236	record_separator: ~
	237	scan_fields: 1
	238	trim_fields: 1
	239	parser_type: SQL::Translator::Parser::PostgreSQL
	240	producer_args:
	241	add_prefix: ~
	242	add_truncate: ~
	243	db_password: ~
	244	db_user: ~
	245	dsn: ~
	246	imap_file: ~
	247	imap_url: ~
	248	indent: ~
	249	newlines: ~
	250	package_name: ~
	251	prefix: ~
	252	pretty: ~
	253	skip: ~
	254	skiplike: ~
	255	title: ~
	256	tt_conf: {}
	257	tt_vars: {}
	258	ttfile: ~
	259	producer_type: SQL::Translator::Producer::YAML
	260	show_warnings: 0
	261	trace: 0
	262	version: 0.0899_01