/[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 4 by dpavlin, Sat May 14 11:44:05 2005 UTC revision 11 by dpavlin, Sat May 14 18:20:50 2005 UTC
# Line 17  create table lists ( Line 17  create table lists (
17          primary key(id)          primary key(id)
18  );  );
19    
20    create index lists_name_ind on lists(name);
21    
22  create table user_list (  create table user_list (
23          user_id int not null references users(id) on update cascade on delete cascade,          user_id int not null references users(id) on update cascade on delete cascade,
24          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,
# Line 26  create table user_list ( Line 28  create table user_list (
28    
29  create table messages (  create table messages (
30          id      serial,          id      serial,
         from    text not null,  
31          message text not null,          message text not null,
32          date    timestamp not null default now(),          date    timestamp not null default now(),
33          primary key(id)          primary key(id)
34  );  );
35    
36  create table message_list (  create index messages_md5_ind on messages(md5);
37    
38    create table queue (
39          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,
40          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,
41          date    timestamp not null default now(),          date    timestamp not null default now(),
42            all_sent boolean default false,
43          primary key(message_id, list_id)          primary key(message_id, list_id)
44  );  );
45    
# Line 47  create table sent ( Line 51  create table sent (
51  );  );
52    
53  create table received (  create table received (
54          user_id not null references users(id) on update cascade on delete cascade,          id serial,
55            user_id int not null references users(id) on update cascade on delete cascade,
56          message text not null,          message text not null,
57          bounced boolean not null default false,          bounced boolean not null default false,
58          date    timestamp not null default now(),          date    timestamp not null default now(),
59            primary key (id)
60  );  );
61    
62    
Legend:
Removed from v.4  
changed lines
  Added in v.11
  ViewVC Help
Powered by ViewVC 1.1.26