Remove trnasaction_types from history.

9 files changed, 4 insertions, 70 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;
diff --git a/revert/kakeibo.transaction_types.sql b/revert/kakeibo.transaction_types.sql
deleted file mode 100644
index 48df263..0000000
--- a/revert/kakeibo.transaction_types.sql
+++ /dev/null
@@ -1,7 +0,0 @@
--- Revert kakeibo:transaction_types from pg
-
-BEGIN;
-
-DROP TABLE kakeibo.transaction_types;
-
-COMMIT;
diff --git a/revert/kakeibo.transactions.sql b/revert/kakeibo.transactions.sql
index c424cc1..d30390a 100644
--- a/revert/kakeibo.transactions.sql
+++ b/revert/kakeibo.transactions.sql
@@ -3,6 +3,6 @@
 BEGIN;
 
 ALTER TABLE kakeibo.transactions
-  DROP CONSTRAINT transactions_type_code_fkey;
+  DROP COLUMN article_id;
 
 COMMIT;
diff --git a/revert/kakeibo.transactions@v1.0.0-alpha.2.sql b/revert/kakeibo.transactions@v1.0.0-alpha.2.sql
deleted file mode 100644
index d30390a..0000000
--- a/revert/kakeibo.transactions@v1.0.0-alpha.2.sql
+++ /dev/null
@@ -1,8 +0,0 @@
--- Revert kakeibo:transactions from pg
-
-BEGIN;
-
-ALTER TABLE kakeibo.transactions
-  DROP COLUMN article_id;
-
-COMMIT;
diff --git a/sqitch.plan b/sqitch.plan
index 3d51e33..2246756 100644
--- a/sqitch.plan
+++ b/sqitch.plan
@@ -15,9 +15,7 @@ kakeibo.transactions [kakeibo.transactions@v1.0.0-alpha.1 kakeibo.articles] 2023
 kakeibo.items [kakeibo.items@v1.0.0-alpha.1 kakeibo.articles] 2023-03-12T15:12:15Z Masaya Tojo <masaya@tojo.tokyo> # Add article_id column to items table.
 @v1.0.0-alpha.2 2023-03-12T15:18:49Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha.2.
 
-kakeibo.transaction_types [kakeibo] 2023-03-12T15:20:07Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage transaction type codes.
 kakeibo.articles_update_timestamp [kakeibo.articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to articles table.
-kakeibo.transactions [kakeibo.transactions@v1.0.0-alpha.2 kakeibo.articles] 2023-03-12T15:42:06Z Masaya Tojo <masaya@tojo.tokyo> # Add foreign key constraint to transactions table referencing types table.
 common 2023-03-27T15:01:06Z Masaya Tojo <masaya@tojo.tokyo> # Add common schema.
 update_timestamp [update_timestamp@v1.0.0-alpha.2] 2023-03-27T15:03:00Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp to common schema.
 @v1.0.0-alpha.3 2023-03-27T15:07:33Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha.3.
diff --git a/verify/kakeibo.transaction_types.sql b/verify/kakeibo.transaction_types.sql
deleted file mode 100644
index 49aa2f6..0000000
--- a/verify/kakeibo.transaction_types.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- Verify kakeibo:transaction_types on pg
-
-BEGIN;
-
-SELECT code,
-       name
-  FROM kakeibo.transaction_types
- WHERE FALSE;
-
-ROLLBACK;
diff --git a/verify/kakeibo.transactions@v1.0.0-alpha.2.sql b/verify/kakeibo.transactions@v1.0.0-alpha.2.sql
deleted file mode 100644
index 3f5b58f..0000000
--- a/verify/kakeibo.transactions@v1.0.0-alpha.2.sql
+++ /dev/null
@@ -1,15 +0,0 @@
--- Verify kakeibo:transactions on pg
-
-BEGIN;
-
-SELECT id,
-       type_code,
-       date,
-       note,
-       created_at,
-       updated_at,
-       article_id
-  FROM kakeibo.transactions
- WHERE FALSE;
-
-ROLLBACK;