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/002_create_users_table.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'migrations/002_create_users_table.sql') 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