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