From 5d970eeaf179f425c2c1577aad149a07056e2430 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Sun, 28 Jul 2024 03:19:20 +0900 Subject: chore: format schema.sql --- backend/schema.sql | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) (limited to 'backend/schema.sql') diff --git a/backend/schema.sql b/backend/schema.sql index 5a70eeb..6696242 100644 --- a/backend/schema.sql +++ b/backend/schema.sql @@ -1,23 +1,23 @@ CREATE TABLE users ( - user_id SERIAL PRIMARY KEY, - username VARCHAR(64) NOT NULL UNIQUE, + user_id SERIAL PRIMARY KEY, + username VARCHAR(64) NOT NULL UNIQUE, display_name VARCHAR(64) NOT NULL, - icon_path VARCHAR(255), - is_admin BOOLEAN NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT NOW() + icon_path VARCHAR(255), + is_admin BOOLEAN NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT NOW() ); CREATE TABLE user_auths ( - user_auth_id SERIAL PRIMARY KEY, - user_id INT NOT NULL, - auth_type VARCHAR(16) NOT NULL, + user_auth_id SERIAL PRIMARY KEY, + user_id INT NOT NULL, + auth_type VARCHAR(16) NOT NULL, password_hash VARCHAR(256), CONSTRAINT fk_user_id FOREIGN KEY(user_id) REFERENCES users(user_id) ); CREATE TABLE games ( - game_id SERIAL PRIMARY KEY, - type VARCHAR(255) NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT NOW(), - state VARCHAR(255) NOT NULL + game_id SERIAL PRIMARY KEY, + type VARCHAR(255) NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + state VARCHAR(255) NOT NULL ); -- cgit v1.2.3-70-g09d2