aboutsummaryrefslogtreecommitdiff
path: root/backend/migrations/2021-12-18-130837_bots/up.sql
diff options
context:
space:
mode:
authorIlion Beyst <ilion.beyst@gmail.com>2021-12-19 00:16:46 +0100
committerIlion Beyst <ilion.beyst@gmail.com>2021-12-19 00:16:46 +0100
commit52242b03f1af7f73e73592c2e5ee2bc54813a64d (patch)
tree1ecafcbebad7b6f8ae71670afbe2921c975196fa /backend/migrations/2021-12-18-130837_bots/up.sql
parent2dbb085008f68ed56675cf23ea6e1c89af632ea9 (diff)
downloadplanetwars.dev-52242b03f1af7f73e73592c2e5ee2bc54813a64d.tar.xz
planetwars.dev-52242b03f1af7f73e73592c2e5ee2bc54813a64d.zip
simple bot uploads
Diffstat (limited to 'backend/migrations/2021-12-18-130837_bots/up.sql')
-rw-r--r--backend/migrations/2021-12-18-130837_bots/up.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/backend/migrations/2021-12-18-130837_bots/up.sql b/backend/migrations/2021-12-18-130837_bots/up.sql
new file mode 100644
index 0000000..27f3582
--- /dev/null
+++ b/backend/migrations/2021-12-18-130837_bots/up.sql
@@ -0,0 +1,14 @@
+CREATE TABLE bots (
+ id serial PRIMARY KEY,
+ owner_id integer REFERENCES users(id) NOT NULL,
+ name text NOT NULL
+);
+
+CREATE UNIQUE INDEX bots_index ON bots(owner_id, name);
+
+CREATE TABLE code_bundles (
+ id serial PRIMARY KEY,
+ bot_id integer REFERENCES bots(id) NOT NULL,
+ path text NOT NULL,
+ created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
+); \ No newline at end of file