1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
create table person (
person_id INTEGER PRIMARY KEY,
name varchar(20) not null,
age integer,
weight double(11,2),
iq int default '0',
is_rock_star tinyint default '1',
description text
);
create unique index u_name on person (name);
create table pet (
pet_id int,
person_id int,
name varchar(30),
age int,
check ( age < 100 ),
primary key (pet_id, person_id)
);
create trigger after insert on pet
begin
update pet set name=name;
end
;
create view person_pet as
select pr.person_id, pr.name as person_name, pt.name as pet_name
from person pr, pet pt
where person.person_id=pet.pet_id
;
|
