4 person_id INTEGER PRIMARY KEY AUTOINCREMENT,
5 'name' varchar(20) not null,
8 iq tinyint default '0',
12 create unique index u_name on person (name);
16 "person_id" int references person (person_id),
20 primary key (pet_id, person_id)
23 create trigger pet_trig after insert on pet
25 update pet set name=name;
29 create view person_pet as
30 select pr.person_id, pr.name as person_name, pt.name as pet_name
31 from person pr, pet pt
32 where person.person_id=pet.pet_id