/[webpac2]/trunk/sql/schema.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/sql/schema.sql

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

revision 26 by dpavlin, Sat Jul 23 18:39:44 2005 UTC revision 27 by dpavlin, Sat Jul 23 19:21:07 2005 UTC
# Line 29  create table catalog_entry ( Line 29  create table catalog_entry (
29          primary key (catalog_id, entry_id)          primary key (catalog_id, entry_id)
30  );  );
31    
 -- Pg General Bits entries  
 create table entries_pgbits (  
         issue   int not null,                   -- unique index  
         primary key(id)  
 ) inherits (entries) ;  
   
32  -- Items for each Entry  -- Items for each Entry
33  create table items (  create table items (
34          id      serial,          id      serial,
# Line 71  create table entry_tag ( Line 65  create table entry_tag (
65          primary key (entry_id, tag_id)          primary key (entry_id, tag_id)
66  );  );
67    
68    -- Pg General Bits
69    create table entries_pgbits (
70            issue   int not null,                   -- unique index
71            primary key(id)
72    ) inherits (entries) ;
73    
74    create table items_pgbits (
75            mytitle text not null,
76            ititle  text not null,
77            ikey    text,
78            html    text,
79            contributors text,
80            primary key(id)
81    ) inherits (items) ;
82    
83    -- some views
84    
85    create view pgbits_articles as select
86            issue,
87            entries_pgbits.date as issue_date,
88            ititle,
89            mytitle,
90            items_pgbits.date as date
91    from items_pgbits
92    join entries_pgbits on entry_id = entries_pgbits.id ;
93    
Legend:
Removed from v.26  
changed lines
  Added in v.27
  ViewVC Help
Powered by ViewVC 1.1.26