aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-03-27 03:44:51 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-27 03:46:58 +0900
commit0a8e2a6e5dc7d75017f81d90ce1eb904280f1cba (patch)
treed4c3951b4c33825ae72c0a619ddc7c8e9bdfaac6
parent1bf0d0539222c01bfd2fed9f4b147a3c125d6895 (diff)
Rename `schema` to `kakeibo`.
-rw-r--r--deploy/kakeibo.sql (renamed from deploy/schema.sql)0
-rw-r--r--revert/kakeibo.sql (renamed from revert/schema.sql)0
-rw-r--r--sqitch.conf2
-rw-r--r--sqitch.plan20
-rw-r--r--verify/kakeibo.sql (renamed from verify/schema.sql)0
5 files changed, 11 insertions, 11 deletions
diff --git a/deploy/schema.sql b/deploy/kakeibo.sql
index fdd6de2..fdd6de2 100644
--- a/deploy/schema.sql
+++ b/deploy/kakeibo.sql
diff --git a/revert/schema.sql b/revert/kakeibo.sql
index d51dc03..d51dc03 100644
--- a/revert/schema.sql
+++ b/revert/kakeibo.sql
diff --git a/sqitch.conf b/sqitch.conf
index 0f69cac..90f2c11 100644
--- a/sqitch.conf
+++ b/sqitch.conf
@@ -3,7 +3,7 @@
# plan_file = sqitch.plan
# top_dir = .
[target "life_archive_test"]
- uri = db:pg://db.private.tojo.tokyo/life_test
+ uri = db:pg://db.private.tojo.tokyo/life_archive_test
[engine "pg"]
target = life_archive_test
[deploy]
diff --git a/sqitch.plan b/sqitch.plan
index 30ccec8..4e5968c 100644
--- a/sqitch.plan
+++ b/sqitch.plan
@@ -2,23 +2,23 @@
%project=life-archive
%uri=https://git.tojo.tokyo/life-archive.git
-schema 2023-03-11T15:56:41Z Masaya Tojo <masaya@tojo.tokyo> # Add schema for use in kakeibo.
-transactions [schema] 2023-03-11T16:50:25Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking transactions.
-items [schema transactions] 2023-03-12T04:48:30Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking items.
-insert_transaction [schema transactions] 2023-03-12T07:06:15Z Masaya Tojo <masaya@tojo.tokyo> # Add function to create new transaction.
-insert_item [schema items] 2023-03-12T07:25:23Z Masaya Tojo <masaya@tojo.tokyo> # Add function to add new item.
-delete_item [schema items] 2023-03-12T08:14:34Z Masaya Tojo <masaya@tojo.tokyo> # Add function to delete item.
-delete_transaction [schema transactions] 2023-03-12T08:40:47Z Masaya Tojo <masaya@tojo.tokyo> # Add function to delete transaction.
-update_timestamp [schema] 2023-03-12T13:57:49Z Masaya Tojo <masaya@tojo.tokyo> # Add function to update timestamp.
+kakeibo 2023-03-11T15:56:41Z Masaya Tojo <masaya@tojo.tokyo> # Add schema for use in kakeibo.
+transactions [kakeibo] 2023-03-11T16:50:25Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking transactions.
+items [kakeibo transactions] 2023-03-12T04:48:30Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking items.
+insert_transaction [kakeibo transactions] 2023-03-12T07:06:15Z Masaya Tojo <masaya@tojo.tokyo> # Add function to create new transaction.
+insert_item [kakeibo items] 2023-03-12T07:25:23Z Masaya Tojo <masaya@tojo.tokyo> # Add function to add new item.
+delete_item [kakeibo items] 2023-03-12T08:14:34Z Masaya Tojo <masaya@tojo.tokyo> # Add function to delete item.
+delete_transaction [kakeibo transactions] 2023-03-12T08:40:47Z Masaya Tojo <masaya@tojo.tokyo> # Add function to delete transaction.
+update_timestamp [kakeibo] 2023-03-12T13:57:49Z Masaya Tojo <masaya@tojo.tokyo> # Add function to update timestamp.
transactions_update_timestamp [transactions update_timestamp] 2023-03-12T14:10:42Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to transactions table.
items_update_timestamp [items update_timestamp] 2023-03-12T14:14:13Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to items table.
@v1.0.0-alpha.1 2023-03-12T14:21:52Z Masaya Tojo <masaya@tojo.tokyo> # Tag v1.0.0-alpha.1.
-articles [schema] 2023-03-12T14:43:06Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage articles.
+articles [kakeibo] 2023-03-12T14:43:06Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage articles.
transactions [transactions@v1.0.0-alpha.1 articles] 2023-03-12T15:06:03Z Masaya Tojo <masaya@tojo.tokyo> # Add article_id column to transactions table.
items [items@v1.0.0-alpha.1 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.
-transaction_types [schema] 2023-03-12T15:20:07Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage transaction type codes.
+transaction_types [kakeibo] 2023-03-12T15:20:07Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage transaction type codes.
articles_update_timestamp [articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to articles table.
transactions [transactions@v1.0.0-alpha.2 articles] 2023-03-12T15:42:06Z Masaya Tojo <masaya@tojo.tokyo> # Add foreign key constraint to transactions table referencing types table.
diff --git a/verify/schema.sql b/verify/kakeibo.sql
index 661fd8a..661fd8a 100644
--- a/verify/schema.sql
+++ b/verify/kakeibo.sql