From 3edf5d60f54bfd0cd2c818e5fb1ca133e324325d Mon Sep 17 00:00:00 2001
From: Ilion Beyst <ilion.beyst@gmail.com>
Date: Thu, 30 Dec 2021 11:45:59 +0100
Subject: rename to planetwars-server

---
 .../migrations/2021-12-18-130837_bots/down.sql             |  3 +++
 planetwars-server/migrations/2021-12-18-130837_bots/up.sql | 14 ++++++++++++++
 2 files changed, 17 insertions(+)
 create mode 100644 planetwars-server/migrations/2021-12-18-130837_bots/down.sql
 create mode 100644 planetwars-server/migrations/2021-12-18-130837_bots/up.sql

(limited to 'planetwars-server/migrations/2021-12-18-130837_bots')

diff --git a/planetwars-server/migrations/2021-12-18-130837_bots/down.sql b/planetwars-server/migrations/2021-12-18-130837_bots/down.sql
new file mode 100644
index 0000000..3d14604
--- /dev/null
+++ b/planetwars-server/migrations/2021-12-18-130837_bots/down.sql
@@ -0,0 +1,3 @@
+DROP TABLE code_bundles;
+DROP INDEX bots_index;
+DROP TABLE bots;
\ No newline at end of file
diff --git a/planetwars-server/migrations/2021-12-18-130837_bots/up.sql b/planetwars-server/migrations/2021-12-18-130837_bots/up.sql
new file mode 100644
index 0000000..27f3582
--- /dev/null
+++ b/planetwars-server/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
-- 
cgit v1.2.3