diff options
Diffstat (limited to 'backend/migrations/2021-12-18-130837_bots')
-rw-r--r-- | backend/migrations/2021-12-18-130837_bots/down.sql | 3 | ||||
-rw-r--r-- | backend/migrations/2021-12-18-130837_bots/up.sql | 14 |
2 files changed, 0 insertions, 17 deletions
diff --git a/backend/migrations/2021-12-18-130837_bots/down.sql b/backend/migrations/2021-12-18-130837_bots/down.sql deleted file mode 100644 index 3d14604..0000000 --- a/backend/migrations/2021-12-18-130837_bots/down.sql +++ /dev/null @@ -1,3 +0,0 @@ -DROP TABLE code_bundles; -DROP INDEX bots_index; -DROP TABLE bots;
\ No newline at end of file diff --git a/backend/migrations/2021-12-18-130837_bots/up.sql b/backend/migrations/2021-12-18-130837_bots/up.sql deleted file mode 100644 index 27f3582..0000000 --- a/backend/migrations/2021-12-18-130837_bots/up.sql +++ /dev/null @@ -1,14 +0,0 @@ -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 |