summaryrefslogtreecommitdiff
path: root/db/laconica_pg.sql
diff options
context:
space:
mode:
authorCiaranG <ciaran@ciarang.com>2009-05-08 08:14:50 +0100
committerCiaranG <ciaran@ciarang.com>2009-05-08 08:14:50 +0100
commit9a8095079dc602c7f2b74e48237445d682844de6 (patch)
treeed3bb22712fbbfd290e99788371745fadb7dc1b2 /db/laconica_pg.sql
parent11e0db8c2cec18337fd960ccda055dd14d89f9d7 (diff)
PostgreSQL - added dirty dates to Foreign_link - see 3e7b1e69e3e97ac007465376b62084f10bcf97ca
Diffstat (limited to 'db/laconica_pg.sql')
-rw-r--r--db/laconica_pg.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index f879d7936..a27a616f2 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -291,6 +291,8 @@ create table foreign_link (
noticesync int not null default 1 /* comment 'notice synchronisation, bit 1 = sync outgoing, bit 2 = sync incoming, bit 3 = filter local replies' */,
friendsync int not null default 2 /* comment 'friend synchronisation, bit 1 = sync outgoing, bit 2 = sync incoming */,
profilesync int not null default 1 /* comment 'profile synchronization, bit 1 = sync outgoing, bit 2 = sync incoming' */,
+ last_noticesync timestamp default null /* comment 'last time notices were imported' */,
+ last_friendsync timestamp default null /* comment 'last time friends were imported' */,
created timestamp not null default CURRENT_TIMESTAMP /* comment 'date this record was created' */,
modified timestamp /* comment 'date this record was modified' */,