diff options
Diffstat (limited to 'migrations/003_create_posts_table.sql.sql')
| -rw-r--r-- | migrations/003_create_posts_table.sql.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/migrations/003_create_posts_table.sql.sql b/migrations/003_create_posts_table.sql.sql index 81dab8f..584b7b4 100644 --- a/migrations/003_create_posts_table.sql.sql +++ b/migrations/003_create_posts_table.sql.sql @@ -1,8 +1,9 @@ CREATE TABLE posts( id SERIAL NOT NULL PRIMARY KEY, title VARCHAR(100) NOT NULL, - description TEXT NOT NULL, + description TEXT, url VARCHAR(255) UNIQUE, + user_id INT NOT NULL REFERENCES users(id), created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); |
