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