diff options
Diffstat (limited to 'migrations/20240321225523_init.up.sql')
-rw-r--r-- | migrations/20240321225523_init.up.sql | 15 |
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 -); |