add missing semicolon, update email field to optional

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()
 );