aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/schema.sql
diff options
context:
space:
mode:
authornsfisis <nsfisis@gmail.com>2024-07-28 03:19:20 +0900
committernsfisis <nsfisis@gmail.com>2024-07-28 03:19:26 +0900
commit5d970eeaf179f425c2c1577aad149a07056e2430 (patch)
treebc7637a449bcbf2d0aeac18d27491e9f6ef7ab69 /backend/schema.sql
parent569eb3753db04c2ceca8d005b3e1cef15cfe8eb7 (diff)
downloadphperkaigi-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.sql24
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
);