diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/001_create_timestamp_trigger.sql | 2 | ||||
| -rw-r--r-- | migrations/002_create_users_table.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/migrations/001_create_timestamp_trigger.sql b/migrations/001_create_timestamp_trigger.sql index f181510..192a783 100644 --- a/migrations/001_create_timestamp_trigger.sql +++ b/migrations/001_create_timestamp_trigger.sql @@ -8,4 +8,4 @@ $$ LANGUAGE plpgsql; ---- create above / drop below ---- -DROP FUNCTION trigger_set_timestamp() +DROP FUNCTION trigger_set_timestamp(); diff --git a/migrations/002_create_users_table.sql b/migrations/002_create_users_table.sql index 3ac92b3..746dc23 100644 --- a/migrations/002_create_users_table.sql +++ b/migrations/002_create_users_table.sql @@ -2,7 +2,7 @@ CREATE TABLE users( id SERIAL NOT NULL PRIMARY KEY, username VARCHAR(50) UNIQUE NOT NULL, secret VARCHAR(255) NOT NULL, - email VARCHAR(255) UNIQUE NOT NULL, + email VARCHAR(255) UNIQUE, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); |