/[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 36 by dpavlin, Tue May 17 17:49:14 2005 UTC revision 45 by dpavlin, Wed May 18 13:12:54 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 default '',          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 70  create index received_user_id_int on rec Line 70  create index received_user_id_int on rec
70  create index received_list_id_int on received(list_id);  create index received_list_id_int on received(list_id);
71    
72    
73  insert into users (email, full_name) values ('dpavlin@rot13.org', 'DbP');  insert into users (email, name) values ('dpavlin@rot13.org', 'DbP');
74  insert into users (email, full_name) values ('dpavlin@gmail.com', 'DbP');  insert into users (email, name) values ('dpavlin@gmail.com', 'DbP');
75  insert into users (email, full_name) values ('xxx_doesnt_exist_xxx@gmail.com', 'fake');  insert into users (email, name) values ('xxx_doesnt_exist_xxx@gmail.com', 'fake');
76    
77  insert into lists (name, email) values ('Just me','my-alter-ego@rot13.org');  insert into lists (name, email) values ('Just me','my-alter-ego@rot13.org');
78  insert into lists (name, email) values ('All users','announce@example.com');  insert into lists (name, email) values ('All users','announce@example.com');
Legend:
Removed from v.36  
changed lines
  Added in v.45
  ViewVC Help
Powered by ViewVC 1.1.26