[dbsrgits/SQL-Translator.git] / t / data / oracle / schema_diff_a.yaml

---
schema:
  procedures: {}
  tables:
    d_operator:
      constraints:
        - deferrable: 1
          expression: ''
          fields:
            - id_operator
          match_type: ''
          name: ''
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: PRIMARY KEY
      fields:
        id_operator:
          data_type: integer
          default_value: ~
          extra: {}
          is_auto_increment: 1
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: id_operator
          order: 58
          size:
            - 0
        name:
          data_type: varchar2
          default_value: ~
          extra: {}
          is_nullable: 0
          is_primary_key: 0
          is_unique: 0
          name: name
          order: 59
          size:
            - 10
        other:
          data_type: varchar2
          default_value: ~
          extra: {}
          is_nullable: 1
          is_primary_key: 0
          is_unique: 0
          name: other
          order: 60
          size:
            - 10
      name: d_operator
      order: 11
Commit	Line	Data
9556363f	1	---
	2	schema:
	3	procedures: {}
	4	tables:
	5	d_operator:
	6	constraints:
	7	- deferrable: 1
	8	expression: ''
	9	fields:
	10	- id_operator
	11	match_type: ''
	12	name: ''
	13	on_delete: ''
	14	on_update: ''
	15	options: []
	16	reference_fields: []
	17	reference_table: ''
	18	type: PRIMARY KEY
	19	fields:
	20	id_operator:
	21	data_type: integer
	22	default_value: ~
	23	extra: {}
	24	is_auto_increment: 1
	25	is_nullable: 0
	26	is_primary_key: 1
	27	is_unique: 0
	28	name: id_operator
	29	order: 58
	30	size:
	31	- 0
	32	name:
e19efc15	33	data_type: varchar2
9556363f	34	default_value: ~
	35	extra: {}
	36	is_nullable: 0
	37	is_primary_key: 0
	38	is_unique: 0
	39	name: name
	40	order: 59
	41	size:
e19efc15	42	- 10
d888d445	43	other:
e19efc15	44	data_type: varchar2
d888d445	45	default_value: ~
	46	extra: {}
	47	is_nullable: 1
	48	is_primary_key: 0
	49	is_unique: 0
	50	name: other
807290c3	51	order: 60
d888d445	52	size:
e19efc15	53	- 10
9556363f	54	name: d_operator
9556363f	55	order: 11