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

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

revision 17 by dpavlin, Sun May 15 16:32:36 2005 UTC revision 18 by dpavlin, Sun May 15 17:01:19 2005 UTC
# Line 12  create table users ( Line 12  create table users (
12  create table lists (  create table lists (
13          id      serial,          id      serial,
14          name    text not null,          name    text not null,
15          email   text not null,          email   text default '',
16          bounce_limit int not null default 3,          bounce_limit int not null default 3,
17          date    timestamp not null default now(),          date    timestamp not null default now(),
18          primary key(id)          primary key(id)
# Line 34  create table messages ( Line 34  create table messages (
34          primary key(id)          primary key(id)
35  );  );
36    
 create index messages_md5_ind on messages(md5);  
   
37  create table queue (  create table queue (
38          message_id int not null references messages(id) on update cascade on delete cascade,          message_id int not null references messages(id) on update cascade on delete cascade,
39          list_id int not null references lists(id) on update cascade on delete cascade,          list_id int not null references lists(id) on update cascade on delete cascade,
Legend:
Removed from v.17  
changed lines
  Added in v.18
  ViewVC Help
Powered by ViewVC 1.1.26