Remove trnasaction_types from history.

3 files changed, 3 insertions, 27 deletions

diff --git a/deploy/kakeibo.transaction_types.sql b/deploy/kakeibo.transaction_types.sql
deleted file mode 100644
index cf07925..0000000
--- a/deploy/kakeibo.transaction_types.sql
+++ /dev/null
@@ -1,12 +0,0 @@
--- Deploy kakeibo:transaction_types to pg
--- requires: schema
-
-BEGIN;
-
-CREATE TABLE kakeibo.transaction_types (
-  code INTEGER PRIMARY KEY,
-  name TEXT NOT NULL
-);
-INSERT INTO kakeibo.transaction_types VALUES (0, 'outgo'),  (1, 'income');
-
-COMMIT;
diff --git a/deploy/kakeibo.transactions.sql b/deploy/kakeibo.transactions.sql
index 3a4585a..0572a23 100644
--- a/deploy/kakeibo.transactions.sql
+++ b/deploy/kakeibo.transactions.sql
@@ -5,8 +5,8 @@
 BEGIN;
 
 ALTER TABLE kakeibo.transactions
-  ADD CONSTRAINT transactions_type_code_fkey
-  FOREIGN KEY (type_code)
-  REFERENCES kakeibo.transaction_types (code);
+  ADD COLUMN article_id INTEGER,
+  ADD CONSTRAINT transactions_article_id_fkey
+  FOREIGN KEY (article_id) REFERENCES kakeibo.articles (id);
 
 COMMIT;
diff --git a/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql b/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql
deleted file mode 100644
index 0572a23..0000000
--- a/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql
+++ /dev/null
@@ -1,12 +0,0 @@
--- Deploy kakeibo:transactions to pg
--- requires: schema
--- requires: articles
-
-BEGIN;
-
-ALTER TABLE kakeibo.transactions
-  ADD COLUMN article_id INTEGER,
-  ADD CONSTRAINT transactions_article_id_fkey
-  FOREIGN KEY (article_id) REFERENCES kakeibo.articles (id);
-
-COMMIT;