aboutsummaryrefslogtreecommitdiff
path: root/due_moe_schema.sql
diff options
context:
space:
mode:
authorFuwn <[email protected]>2023-10-26 15:41:57 -0700
committerFuwn <[email protected]>2023-10-26 15:41:57 -0700
commit9bac3b6b6a9103841a3456436c65af66549a83da (patch)
tree4273c0ebe5567109daf8b7a4d2c92d51694677cf /due_moe_schema.sql
parentfix(feeds): html encode title (diff)
parentfeat: move back to bun (diff)
downloaddue.moe-9bac3b6b6a9103841a3456436c65af66549a83da.tar.xz
due.moe-9bac3b6b6a9103841a3456436c65af66549a83da.zip
merge: branch 'badges'
Diffstat (limited to 'due_moe_schema.sql')
-rw-r--r--due_moe_schema.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/due_moe_schema.sql b/due_moe_schema.sql
new file mode 100644
index 00000000..9fdb098c
--- /dev/null
+++ b/due_moe_schema.sql
@@ -0,0 +1,8 @@
+CREATE TABLE user_badges (
+ id integer primary key,
+ user_id integer not null,
+ post text(1000) not null,
+ image text(1000) not null,
+ description text(1000) default null,
+ time timestamp default current_timestamp
+);