diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-28 03:19:20 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-28 03:19:26 +0900 |
| commit | 5d970eeaf179f425c2c1577aad149a07056e2430 (patch) | |
| tree | bc7637a449bcbf2d0aeac18d27491e9f6ef7ab69 /backend/schema.sql | |
| parent | 569eb3753db04c2ceca8d005b3e1cef15cfe8eb7 (diff) | |
| download | phperkaigi-2025-albatross-5d970eeaf179f425c2c1577aad149a07056e2430.tar.gz phperkaigi-2025-albatross-5d970eeaf179f425c2c1577aad149a07056e2430.tar.zst phperkaigi-2025-albatross-5d970eeaf179f425c2c1577aad149a07056e2430.zip | |
chore: format schema.sql
Diffstat (limited to 'backend/schema.sql')
| -rw-r--r-- | backend/schema.sql | 24 |
1 files changed, 12 insertions, 12 deletions
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 ); |
