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

---
schema:
  procedures: {}
  tables:
    added:
      constraints: []
      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: added
      options: []
      order: 3
    employee:
      constraints:
        - deferrable: 1
          expression: ''
          fields:
            - employee_id
          match_type: ''
          name: FK5302D47D93FE702E_diff
          on_delete: ''
          on_update: ''
          options: []
          reference_fields:
            - person_id
          reference_table: person
          type: FOREIGN KEY
        - deferrable: 1
          expression: ''
          fields:
            - employee_id
            - position
          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: 1
          is_primary_key: 1
          is_unique: 0
          name: employee_id
          order: 9
          size:
            - 11
        position:
          data_type: varchar
          default_value: ~
          extra: {}
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: position
          order: 8
          size:
            - 50
      indices: []
      name: employee
      order: 2
    new_name:
      name: new_name
      extra:
        renamed_from: 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
        other:
          data_type: int
          name: new_field
          order: 2
      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:
            - person_id
          match_type: ''
          name: UC_person_id
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: UNIQUE
        - deferrable: 1
          expression: ''
          fields:
            - age
            - name
          match_type: ''
          name: UC_age_name
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: UNIQUE
      fields:
        age:
          data_type: int
          default_value: 18
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 1
          name: age
          order: 3
          size:
            - 11
        iq:
          data_type: int
          default_value: 0
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: iq
          order: 5
          size:
            - 11
        is_rock_star:
          data_type: smallint
          default_value: 1
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: is_rock_star
          order: 6
          size:
            - 4
        name:
          data_type: varchar
          default_value: ~
          extra: {}
          is_nullable: 0
          is_primary_key: 0
          is_unique: 1
          name: name
          order: 2
          size:
            - 20
        person_id:
          data_type: int
          default_value: ~
          extra: {}
          is_auto_increment: 1
          is_nullable: 0
          is_primary_key: 1
          is_unique: 1
          name: person_id
          order: 1
          size:
            - 11
        physical_description:
          data_type: text
          default_value: ~
          extra:
            renamed_from: 'description'
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: physical_description
          order: 7
          size:
            - 65535
        weight:
          data_type: numeric
          default_value: ~
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: weight
          order: 4
          size:
            - 11
            - 2
      indices:
        - fields:
            - name
          name: unique_name
          options: []
          type: UNIQUE
      name: person
      order: 1
  triggers: {}
  views: {}
translator:
  add_drop_table: 0
  filename: t/data/pgsql/create2.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	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	indices:
217	- fields:
218	- name
219	name: unique_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/create2.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