aboutsummaryrefslogtreecommitdiff
path: root/src/lib/userBadgesDatabase.ts
diff options
context:
space:
mode:
authorFuwn <[email protected]>2023-10-24 19:11:21 -0700
committerFuwn <[email protected]>2023-10-24 19:11:21 -0700
commit7051fd67e98be0166d4f093f111dfa5dfa28bc0a (patch)
tree61395da21f35395a88950428990f21ca9c12d261 /src/lib/userBadgesDatabase.ts
parentfeat: badge wall (diff)
parentchore(git): ignore data folder (diff)
downloaddue.moe-7051fd67e98be0166d4f093f111dfa5dfa28bc0a.tar.xz
due.moe-7051fd67e98be0166d4f093f111dfa5dfa28bc0a.zip
merge: main into badges
Diffstat (limited to 'src/lib/userBadgesDatabase.ts')
-rw-r--r--src/lib/userBadgesDatabase.ts8
1 files changed, 4 insertions, 4 deletions
diff --git a/src/lib/userBadgesDatabase.ts b/src/lib/userBadgesDatabase.ts
index c129770e..78655cd3 100644
--- a/src/lib/userBadgesDatabase.ts
+++ b/src/lib/userBadgesDatabase.ts
@@ -8,16 +8,16 @@ export interface Badge {
id?: number;
}
-const database = new Database('./due_moe.sqlite3', {
+const database = new Database('./data/due_moe.sqlite3', {
verbose: dev ? console.log : undefined
});
database.exec(`create table if not exists user_badges (
id integer primary key,
user_id integer not null,
- post text not null,
- image text not null,
- description text default null,
+ post text(1000) not null,
+ image text(1000) not null,
+ description text(1000) default null,
time timestamp default current_timestamp
)`);