/[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 27 by dpavlin, Sat Jul 23 19:21:07 2005 UTC revision 36 by dpavlin, Tue Aug 2 00:42:29 2005 UTC
# Line 34  create table items ( Line 34  create table items (
34          id      serial,          id      serial,
35          title   text,          title   text,
36          entry_id int references entries(id),          entry_id int references entries(id),
   
37          i_type  text not null,          i_type  text not null,
38          date timestamp not null default now(),          date timestamp not null default now(),
39          primary key(id)          primary key(id)
# Line 84  create table items_pgbits ( Line 83  create table items_pgbits (
83    
84  create view pgbits_articles as select  create view pgbits_articles as select
85          issue,          issue,
86          entries_pgbits.date as issue_date,          date(entries_pgbits.date) as issue_date,
87          ititle,          ititle,
88          mytitle,          mytitle,
89          items_pgbits.date as date          date(items_pgbits.date) as date
90  from items_pgbits  from items_pgbits
91  join entries_pgbits on entry_id = entries_pgbits.id ;  join entries_pgbits on entry_id = entries_pgbits.id ;
92    
Legend:
Removed from v.27  
changed lines
  Added in v.36
  ViewVC Help
Powered by ViewVC 1.1.26