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

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

revision 11 by dpavlin, Sat May 14 18:20:50 2005 UTC revision 33 by dpavlin, Tue May 17 11:09:08 2005 UTC
# Line 1  Line 1 
1  create table users (  create table users (
2          id      serial,          id      serial,
3          email   text not null,          email   text not null,
4          full_name text not null,          full_name text default '',
5          date    timestamp not null default now(),          date    timestamp not null default now(),
6          active  boolean not null default true,          active  boolean not null default true,
7          bounce_count int not null default 0,          bounce_count int not null default 0,
# Line 9  create table users ( Line 9  create table users (
9          primary key(id)          primary key(id)
10  );  );
11    
12    create unique index users_email_ind on users(email);
13    
14  create table lists (  create table lists (
15          id      serial,          id      serial,
16          name    text not null,          name    text not null,
17            email   text not null,
18          bounce_limit int not null default 3,          bounce_limit int not null default 3,
19          date    timestamp not null default now(),          date    timestamp not null default now(),
20          primary key(id)          primary key(id)
21  );  );
22    
23  create index lists_name_ind on lists(name);  create unique index lists_name_ind on lists(name);
24    create unique index lists_email_ind on lists(email);
25    
26  create table user_list (  create table user_list (
27          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,
# Line 33  create table messages ( Line 37  create table messages (
37          primary key(id)          primary key(id)
38  );  );
39    
 create index messages_md5_ind on messages(md5);  
   
40  create table queue (  create table queue (
41          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,
42          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 64  insert into users (email, full_name) val Line 66  insert into users (email, full_name) val
66  insert into users (email, full_name) values ('dpavlin@gmail.com', 'DbP');  insert into users (email, full_name) values ('dpavlin@gmail.com', 'DbP');
67  insert into users (email, full_name) values ('xxx_doesnt_exist_xxx@gmail.com', 'fake');  insert into users (email, full_name) values ('xxx_doesnt_exist_xxx@gmail.com', 'fake');
68    
69  insert into lists (name) values ('Just me');  insert into lists (name, email) values ('Just me','my-alter-ego@rot13.org');
70  insert into lists (name) values ('All users');  insert into lists (name, email) values ('All users','announce@example.com');
71    
72  insert into user_list (user_id, list_id) select users.id,1 from users limit 1;  insert into user_list (user_id, list_id) select users.id,1 from users limit 1;
73  insert into user_list (user_id, list_id) select users.id,2 from users;  insert into user_list (user_id, list_id) select users.id,2 from users;
Legend:
Removed from v.11  
changed lines
  Added in v.33
  ViewVC Help
Powered by ViewVC 1.1.26