diff options
Diffstat (limited to 'backend')
| -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 ); |