aboutsummaryrefslogtreecommitdiff
path: root/revert/items.sql
diff options
context:
space:
mode:
Diffstat (limited to 'revert/items.sql')
-rw-r--r--revert/items.sql7
1 files changed, 5 insertions, 2 deletions
diff --git a/revert/items.sql b/revert/items.sql
index b36bf6b..c8cbcd5 100644
--- a/revert/items.sql
+++ b/revert/items.sql
@@ -1,7 +1,10 @@
--- Revert kakeibo:items from pg
+-- Deploy kakeibo:items to pg
+-- requires: schema
+-- requires: transactions
BEGIN;
-DROP TABLE kakeibo.items;
+ALTER TABLE kakeibo.items
+ DROP COLUMN article_id;
COMMIT;