Commit | Line | Data |
24e769f2 |
1 | create table person ( |
99fa843e |
2 | -- field comment 1 |
3 | -- field comment 2 |
03d12def |
4 | person_id INTEGER PRIMARY KEY AUTOINCREMENT, |
5 | 'name' varchar(20) not null, |
6 | 'age' integer, |
24e769f2 |
7 | weight double(11,2), |
8 | iq tinyint default '0', |
51df59ae |
9 | description text |
24e769f2 |
10 | ); |
11 | |
12 | create unique index u_name on person (name); |
13 | |
14 | create table pet ( |
03d12def |
15 | "pet_id" int, |
16 | "person_id" int references person (person_id), |
17 | "name" varchar(30), |
18 | "age" int, |
24e769f2 |
19 | check ( age < 100 ), |
20 | primary key (pet_id, person_id) |
21 | ); |
22 | |
da2f5992 |
23 | create trigger pet_trig after insert on pet |
24e769f2 |
24 | begin |
2661d702 |
25 | update pet set name=name; |
24e769f2 |
26 | end |
2661d702 |
27 | ; |
24e769f2 |
28 | |
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 |
33 | ; |