add sqldef and sqlc

1 files changed, 23 insertions, 0 deletions

diff --git a/backend/schema.sql b/backend/schema.sql
new file mode 100644
index 0000000..6a2db2d
--- /dev/null
+++ b/backend/schema.sql
@@ -0,0 +1,23 @@
+CREATE TABLE users (
+    user_id SERIAL PRIMARY KEY,
+    username VARCHAR(64) NOT NULL UNIQUE,
+    display_username VARCHAR(64) NOT NULL,
+    icon_url 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,
+    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
+);