initialise repository

Signed-off-by: Amygdala Peanut-Almond <amygdala@almond.desloratadyna.net>

1 files changed, 7 insertions, 0 deletions

diff --git a/utils/initdb.js b/utils/initdb.js
new file mode 100644
index 0000000..471837e
--- /dev/null
+++ b/utils/initdb.js
@@ -0,0 +1,7 @@
+const SQLite = require("better-sqlite3");
+const database = SQLite("./database.db");
+
+database.prepare("CREATE TABLE amygdala_webhook(guildId TEXT PRIMARY KEY, webhookUrl TEXT);").run();
+database.prepare("CREATE TABLE amygdala_profile(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, timestamp INTEGER, userID TEXT, key TEXT, value TEXT);").run();
+database.close();
+