Parent Directory | Revision Log
added indexes
1 | create table films ( |
2 | id serial, |
3 | title text not null, |
4 | year int, |
5 | primary key(id) |
6 | ); |
7 | |
8 | create table trivias ( |
9 | id serial, |
10 | film_id int references films(id), |
11 | trivia text not null, |
12 | primary key(id) |
13 | ); |
14 | |
15 | create index trivias_film_id on trivias(film_id) ; |
16 | |
17 | create table quotes ( |
18 | id serial, |
19 | trivia_id int references trivias(id), |
20 | quote text not null, |
21 | primary key(id) |
22 | ); |
23 | |
24 | create index quotes_trivia_id on quotes(trivia_id) ; |
25 |
ViewVC Help | |
Powered by ViewVC 1.1.26 |