From 28e420d7f8ce5dc622c5e0e28a10654f48fcbca4 Mon Sep 17 00:00:00 2001 From: Alexander Kavon Date: Mon, 22 Jan 2024 17:22:38 -0500 Subject: add missing semicolon, update email field to optional --- migrations/001_create_timestamp_trigger.sql | 2 +- migrations/002_create_users_table.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'migrations') 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() ); -- cgit v1.2.3