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