/[pgestraier]/trunk/data/trivia.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/data/trivia.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 83 by dpavlin, Wed Jan 17 22:30:14 2007 UTC revision 84 by dpavlin, Thu Jan 18 11:02:57 2007 UTC
# Line 12  create table trivias ( Line 12  create table trivias (
12          primary key(id)          primary key(id)
13  );  );
14    
15    create index trivias_film_id on trivias(film_id) ;
16    
17  create table quotes (  create table quotes (
18          id serial,          id serial,
19          trivia_id int references trivias(id),          trivia_id int references trivias(id),
# Line 19  create table quotes ( Line 21  create table quotes (
21          primary key(id)          primary key(id)
22  );  );
23    
24    create index quotes_trivia_id on quotes(trivia_id) ;
25    

Legend:
Removed from v.83  
changed lines
  Added in v.84

  ViewVC Help
Powered by ViewVC 1.1.26