summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorilotterytea <iltsu@alright.party>2025-08-15 16:42:12 +0500
committerilotterytea <iltsu@alright.party>2025-08-15 16:42:12 +0500
commite971d763cb649a51d26f75e8764ffbcb2d9d7a2b (patch)
tree06082fe36f352547f1eb19971d3fe6be046b34f2
parent23a29bb00552f2251c964192d92d3b2fe7336d9e (diff)
feat: user table
-rw-r--r--database.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/database.sql b/database.sql
new file mode 100644
index 0000000..27962fa
--- /dev/null
+++ b/database.sql
@@ -0,0 +1,6 @@
+CREATE TABLE IF NOT EXISTS users (
+ id BIGINT PRIMARY KEY,
+ username TEXT NOT NULL UNIQUE,
+ `password` TEXT NOT NULL,
+ joined_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
+); \ No newline at end of file