procedures: {}
tables:
person:
- comments: ''
constraints:
- deferrable: 1
expression: ''
type: UNIQUE
fields:
age:
- comments: ''
data_type: integer
default_value: ~
extra: {}
size:
- 0
description:
- comments: ''
data_type: text
default_value: ~
extra: {}
size:
- 0
iq:
- comments: ''
data_type: tinyint
default_value: 0
extra: {}
size:
- 0
name:
- comments: ''
data_type: varchar
default_value: ~
extra: {}
size:
- 20
person_id:
- comments: ''
data_type: INTEGER
default_value: ~
extra: {}
size:
- 0
weight:
- comments: ''
data_type: double
default_value: ~
extra: {}
options: []
order: 1
pet:
- comments: ''
constraints:
- deferrable: 1
expression: ''
- fields: ''
+ fields: []
match_type: ''
name: ''
on_delete: ''
type: PRIMARY KEY
fields:
age:
- comments: ''
data_type: int
default_value: ~
extra: {}
size:
- 0
name:
- comments: ''
data_type: varchar
default_value: ~
extra: {}
size:
- 30
person_id:
- comments: ''
data_type: int
default_value: ~
extra: {}
size:
- 0
pet_id:
- comments: ''
data_type: int
default_value: ~
extra: {}
options: []
order: 2
triggers:
- after:
+ pet_trig:
action:
for_each: ~
steps:
- - update name=name
+ - update pet set name=name
when: ~
database_event: insert
fields: ~
- name: after
- on_table: ~
+ name: pet_trig
+ on_table: pet
order: 1
- perform_action_when: ~
+ perform_action_when: after
views:
person_pet:
fields: ''
parser => 'SQLite',
producer => 'YAML',
data => $data,
+# debug => 1,
+# trace => 1,
);
my $out;