summaryrefslogtreecommitdiffstats
path: root/migrations/20240321225523_init.up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20240321225523_init.up.sql')
-rw-r--r--migrations/20240321225523_init.up.sql15
1 files changed, 0 insertions, 15 deletions
diff --git a/migrations/20240321225523_init.up.sql b/migrations/20240321225523_init.up.sql
deleted file mode 100644
index ca86893..0000000
--- a/migrations/20240321225523_init.up.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
-
-CREATE TABLE users (
- uuid UUID NOT NULL PRIMARY KEY DEFAULT (uuid_generate_v4()),
- name VARCHAR(100) NOT NULL,
- email VARCHAR(255) NOT NULL UNIQUE,
- session_epoch TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
- created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
- updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
-);
-
-CREATE TABLE credentials (
- uuid UUID NOT NULL PRIMARY KEY,
- password_hash VARCHAR(100) NOT NULL
-);