From 0a8e2a6e5dc7d75017f81d90ce1eb904280f1cba Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Mon, 27 Mar 2023 03:44:51 +0900 Subject: Rename `schema` to `kakeibo`. --- deploy/kakeibo.sql | 7 +++++++ deploy/schema.sql | 7 ------- revert/kakeibo.sql | 7 +++++++ revert/schema.sql | 7 ------- sqitch.conf | 2 +- sqitch.plan | 20 ++++++++++---------- verify/kakeibo.sql | 7 +++++++ verify/schema.sql | 7 ------- 8 files changed, 32 insertions(+), 32 deletions(-) create mode 100644 deploy/kakeibo.sql delete mode 100644 deploy/schema.sql create mode 100644 revert/kakeibo.sql delete mode 100644 revert/schema.sql create mode 100644 verify/kakeibo.sql delete mode 100644 verify/schema.sql diff --git a/deploy/kakeibo.sql b/deploy/kakeibo.sql new file mode 100644 index 0000000..fdd6de2 --- /dev/null +++ b/deploy/kakeibo.sql @@ -0,0 +1,7 @@ +-- Deploy kakeibo:schema to pg + +BEGIN; + +CREATE SCHEMA kakeibo; + +COMMIT; diff --git a/deploy/schema.sql b/deploy/schema.sql deleted file mode 100644 index fdd6de2..0000000 --- a/deploy/schema.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Deploy kakeibo:schema to pg - -BEGIN; - -CREATE SCHEMA kakeibo; - -COMMIT; diff --git a/revert/kakeibo.sql b/revert/kakeibo.sql new file mode 100644 index 0000000..d51dc03 --- /dev/null +++ b/revert/kakeibo.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:schema from pg + +BEGIN; + +DROP SCHEMA kakeibo; + +COMMIT; diff --git a/revert/schema.sql b/revert/schema.sql deleted file mode 100644 index d51dc03..0000000 --- a/revert/schema.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:schema from pg - -BEGIN; - -DROP SCHEMA kakeibo; - -COMMIT; 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 # Add schema for use in kakeibo. -transactions [schema] 2023-03-11T16:50:25Z Masaya Tojo # Add table for tracking transactions. -items [schema transactions] 2023-03-12T04:48:30Z Masaya Tojo # Add table for tracking items. -insert_transaction [schema transactions] 2023-03-12T07:06:15Z Masaya Tojo # Add function to create new transaction. -insert_item [schema items] 2023-03-12T07:25:23Z Masaya Tojo # Add function to add new item. -delete_item [schema items] 2023-03-12T08:14:34Z Masaya Tojo # Add function to delete item. -delete_transaction [schema transactions] 2023-03-12T08:40:47Z Masaya Tojo # Add function to delete transaction. -update_timestamp [schema] 2023-03-12T13:57:49Z Masaya Tojo # Add function to update timestamp. +kakeibo 2023-03-11T15:56:41Z Masaya Tojo # Add schema for use in kakeibo. +transactions [kakeibo] 2023-03-11T16:50:25Z Masaya Tojo # Add table for tracking transactions. +items [kakeibo transactions] 2023-03-12T04:48:30Z Masaya Tojo # Add table for tracking items. +insert_transaction [kakeibo transactions] 2023-03-12T07:06:15Z Masaya Tojo # Add function to create new transaction. +insert_item [kakeibo items] 2023-03-12T07:25:23Z Masaya Tojo # Add function to add new item. +delete_item [kakeibo items] 2023-03-12T08:14:34Z Masaya Tojo # Add function to delete item. +delete_transaction [kakeibo transactions] 2023-03-12T08:40:47Z Masaya Tojo # Add function to delete transaction. +update_timestamp [kakeibo] 2023-03-12T13:57:49Z Masaya Tojo # Add function to update timestamp. transactions_update_timestamp [transactions update_timestamp] 2023-03-12T14:10:42Z Masaya Tojo # Add update_timestamp trigger to transactions table. items_update_timestamp [items update_timestamp] 2023-03-12T14:14:13Z Masaya Tojo # Add update_timestamp trigger to items table. @v1.0.0-alpha.1 2023-03-12T14:21:52Z Masaya Tojo # Tag v1.0.0-alpha.1. -articles [schema] 2023-03-12T14:43:06Z Masaya Tojo # Add table to manage articles. +articles [kakeibo] 2023-03-12T14:43:06Z Masaya Tojo # Add table to manage articles. transactions [transactions@v1.0.0-alpha.1 articles] 2023-03-12T15:06:03Z Masaya Tojo # Add article_id column to transactions table. items [items@v1.0.0-alpha.1 articles] 2023-03-12T15:12:15Z Masaya Tojo # Add article_id column to items table. @v1.0.0-alpha.2 2023-03-12T15:18:49Z Masaya Tojo # Tag v1.0.0-alpha.2. -transaction_types [schema] 2023-03-12T15:20:07Z Masaya Tojo # Add table to manage transaction type codes. +transaction_types [kakeibo] 2023-03-12T15:20:07Z Masaya Tojo # Add table to manage transaction type codes. articles_update_timestamp [articles update_timestamp] 2023-03-12T15:38:43Z Masaya Tojo # Add update_timestamp trigger to articles table. transactions [transactions@v1.0.0-alpha.2 articles] 2023-03-12T15:42:06Z Masaya Tojo # Add foreign key constraint to transactions table referencing types table. diff --git a/verify/kakeibo.sql b/verify/kakeibo.sql new file mode 100644 index 0000000..661fd8a --- /dev/null +++ b/verify/kakeibo.sql @@ -0,0 +1,7 @@ +-- Verify kakeibo:schema on pg + +BEGIN; + +SELECT pg_catalog.has_schema_privilege('kakeibo', 'usage'); + +ROLLBACK; diff --git a/verify/schema.sql b/verify/schema.sql deleted file mode 100644 index 661fd8a..0000000 --- a/verify/schema.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Verify kakeibo:schema on pg - -BEGIN; - -SELECT pg_catalog.has_schema_privilege('kakeibo', 'usage'); - -ROLLBACK; -- cgit v1.2.3