diff options
| author | CiaranG <ciaran@ciarang.com> | 2009-05-08 08:14:50 +0100 |
|---|---|---|
| committer | CiaranG <ciaran@ciarang.com> | 2009-05-08 08:14:50 +0100 |
| commit | 9a8095079dc602c7f2b74e48237445d682844de6 (patch) | |
| tree | ed3bb22712fbbfd290e99788371745fadb7dc1b2 | |
| parent | 11e0db8c2cec18337fd960ccda055dd14d89f9d7 (diff) | |
PostgreSQL - added dirty dates to Foreign_link - see 3e7b1e69e3e97ac007465376b62084f10bcf97ca
| -rw-r--r-- | db/laconica_pg.sql | 2 |
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' */,
|