summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEric Helgeson <erichelgeson@gmail.com>2009-07-28 20:21:01 -0500
committerEvan Prodromou <evan@controlyourself.ca>2009-08-04 06:05:04 -0400
commitdc5d0cc4f102cb3ce0d734ab25638e65b774a6e9 (patch)
tree37cb6353c93b5c2a43edef192e92f94babb53348
parenta321651a13f531a0222e90ec4483f0db3e2d31d8 (diff)
Splitting br3nda's merge 97db6e17b3f76e9a6acf87ddbad47ba54e9b1a3b
Adding deleted_notice to pg.sql
-rw-r--r--db/laconica_pg.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index ad34720a2..b5626d3f4 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -529,6 +529,17 @@ create table session (
create index session_modified_idx on session (modified);
+create table deleted_notice (
+
+ id integer primary key /* comment 'identity of notice'*/ ,
+ profile_id integer /* not null comment 'author of the notice'*/,
+ uri varchar(255) unique /* comment 'universally unique identifier, usually a tag URI'*/,
+ created timestamp not null /* comment 'date the notice record was created'*/ ,
+ deleted timestamp not null DEFAULT CURRENT_TIMESTAMP /* comment 'date the notice record was created'*/
+);
+
+CREATE index deleted_notice_profile_id_idx on deleted_notice (profile_id);
+
/* Textsearch stuff */