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 |
24 | update name=name; |
25 | end |
26 | |
27 | create view person_pet as |
28 | select pr.person_id, pr.name as person_name, pt.name as pet_name |
29 | from person pr, pet pt |
30 | where person.person_id=pet.pet_id |
31 | ; |