diff options
| -rw-r--r-- | postgres/init.sql | 11 | 
1 files changed, 7 insertions, 4 deletions
diff --git a/postgres/init.sql b/postgres/init.sql index 75a9154c..40538492 100644 --- a/postgres/init.sql +++ b/postgres/init.sql @@ -16,18 +16,21 @@ INSERT INTO users VALUES (  CREATE TABLE messages (      id varchar,      author_id varchar references users(id), -    primary key(id), -    is_deleted boolean +    is_deleted boolean, +    created_at timestamp, +    primary key(id)  );  INSERT INTO messages VALUES(      0,      0, -    false +    false, +    now()  );  INSERT INTO messages VALUES(      1,      0, -    false +    false, +    now() + INTERVAL '10 minutes'  );  |