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