diff options
| author | CiaranG <ciaran@ciarang.com> | 2008-09-10 03:37:41 -0400 |
|---|---|---|
| committer | CiaranG <ciaran@ciarang.com> | 2008-09-10 03:37:41 -0400 |
| commit | c10ab14d13bb6800fbc379c90f79469ee50ce0f0 (patch) | |
| tree | ae9eefc61f29885617c06c36cbb0db9b5be2f7d7 | |
| parent | e322732bd31f42c8d863492c256222ded4a309de (diff) | |
PostgreSQL - reply.modified needs a default
darcs-hash:20080910073741-f6e2c-fe856e1acbc14f77e8ad6502cf5e16de768e0e5f.gz
| -rw-r--r-- | db/laconica_pg.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql index 8becea99c..315112b93 100644 --- a/db/laconica_pg.sql +++ b/db/laconica_pg.sql @@ -126,7 +126,7 @@ create table reply ( notice_id integer not null /* comment 'notice that is the reply' */ references notice (id) ,
profile_id integer not null /* comment 'profile replied to' */ references profile (id) ,
- modified timestamp not null /* comment 'date this record was modified' */,
+ modified timestamp not null default 'now' /* comment 'date this record was modified' */,
replied_id integer /* comment 'notice replied to (not used, see notice.reply_to)' */,
primary key (notice_id, profile_id)
|