aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-03-28 01:29:08 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-03-28 01:29:08 +0900
commit70304b1903cc5b1accd9caea229e59901384203a (patch)
tree0068f30d93a328799898a6773828032fe7e1c843
parent37db03353a121d039a98af49aa034fb2d8f6e6ea (diff)
Add `kakeibo.` prefix.
-rw-r--r--deploy/kakeibo.articles.sql (renamed from deploy/articles.sql)0
-rw-r--r--deploy/kakeibo.articles_update_timestamp.sql (renamed from deploy/articles_update_timestamp.sql)0
-rw-r--r--deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql (renamed from deploy/articles_update_timestamp@v1.0.0-alpha.3.sql)0
-rw-r--r--deploy/kakeibo.items.sql (renamed from deploy/items.sql)0
-rw-r--r--deploy/kakeibo.items@v1.0.0-alpha.1.sql (renamed from deploy/items@v1.0.0-alpha.1.sql)0
-rw-r--r--deploy/kakeibo.items_update_timestamp.sql (renamed from deploy/items_update_timestamp.sql)0
-rw-r--r--deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql (renamed from deploy/items_update_timestamp@v1.0.0-alpha.3.sql)0
-rw-r--r--deploy/kakeibo.transaction_types.sql (renamed from deploy/transaction_types.sql)0
-rw-r--r--deploy/kakeibo.transactions.sql (renamed from deploy/transactions.sql)0
-rw-r--r--deploy/kakeibo.transactions@v1.0.0-alpha.1.sql (renamed from deploy/transactions@v1.0.0-alpha.1.sql)0
-rw-r--r--deploy/kakeibo.transactions@v1.0.0-alpha.2.sql (renamed from deploy/transactions@v1.0.0-alpha.2.sql)0
-rw-r--r--deploy/kakeibo.transactions_update_timestamp.sql (renamed from deploy/transactions_update_timestamp.sql)0
-rw-r--r--deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql (renamed from deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql)0
-rw-r--r--revert/kakeibo.articles.sql (renamed from revert/articles.sql)0
-rw-r--r--revert/kakeibo.articles_update_timestamp.sql (renamed from revert/articles_update_timestamp.sql)0
-rw-r--r--revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql (renamed from revert/articles_update_timestamp@v1.0.0-alpha.3.sql)0
-rw-r--r--revert/kakeibo.items.sql (renamed from revert/items.sql)0
-rw-r--r--revert/kakeibo.items@v1.0.0-alpha.1.sql (renamed from revert/items@v1.0.0-alpha.1.sql)0
-rw-r--r--revert/kakeibo.items_update_timestamp.sql (renamed from revert/items_update_timestamp.sql)0
-rw-r--r--revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql (renamed from revert/items_update_timestamp@v1.0.0-alpha.3.sql)0
-rw-r--r--revert/kakeibo.transaction_types.sql (renamed from revert/transaction_types.sql)0
-rw-r--r--revert/kakeibo.transactions.sql (renamed from revert/transactions.sql)0
-rw-r--r--revert/kakeibo.transactions@v1.0.0-alpha.1.sql (renamed from revert/transactions@v1.0.0-alpha.1.sql)0
-rw-r--r--revert/kakeibo.transactions@v1.0.0-alpha.2.sql (renamed from revert/transactions@v1.0.0-alpha.2.sql)0
-rw-r--r--revert/kakeibo.transactions_update_timestamp.sql (renamed from revert/transactions_update_timestamp.sql)0
-rw-r--r--revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql (renamed from revert/transactions_update_timestamp@v1.0.0-alpha.3.sql)0
-rw-r--r--sqitch.plan26
-rw-r--r--verify/kakeibo.articles.sql (renamed from verify/articles.sql)0
-rw-r--r--verify/kakeibo.articles_update_timestamp.sql (renamed from verify/articles_update_timestamp.sql)0
-rw-r--r--verify/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql (renamed from verify/articles_update_timestamp@v1.0.0-alpha.3.sql)0
-rw-r--r--verify/kakeibo.items.sql (renamed from verify/items.sql)0
-rw-r--r--verify/kakeibo.items@v1.0.0-alpha.1.sql (renamed from verify/items@v1.0.0-alpha.1.sql)0
-rw-r--r--verify/kakeibo.items_update_timestamp.sql (renamed from verify/items_update_timestamp.sql)0
-rw-r--r--verify/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql (renamed from verify/items_update_timestamp@v1.0.0-alpha.3.sql)0
-rw-r--r--verify/kakeibo.transaction_types.sql (renamed from verify/transaction_types.sql)0
-rw-r--r--verify/kakeibo.transactions.sql (renamed from verify/transactions.sql)0
-rw-r--r--verify/kakeibo.transactions@v1.0.0-alpha.1.sql (renamed from verify/transactions@v1.0.0-alpha.1.sql)0
-rw-r--r--verify/kakeibo.transactions@v1.0.0-alpha.2.sql (renamed from verify/transactions@v1.0.0-alpha.2.sql)0
-rw-r--r--verify/kakeibo.transactions_update_timestamp.sql (renamed from verify/transactions_update_timestamp.sql)0
-rw-r--r--verify/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql (renamed from verify/transactions_update_timestamp@v1.0.0-alpha.3.sql)0
40 files changed, 13 insertions, 13 deletions
diff --git a/deploy/articles.sql b/deploy/kakeibo.articles.sql
index 08fcb5e..08fcb5e 100644
--- a/deploy/articles.sql
+++ b/deploy/kakeibo.articles.sql
diff --git a/deploy/articles_update_timestamp.sql b/deploy/kakeibo.articles_update_timestamp.sql
index 239d80a..239d80a 100644
--- a/deploy/articles_update_timestamp.sql
+++ b/deploy/kakeibo.articles_update_timestamp.sql
diff --git a/deploy/articles_update_timestamp@v1.0.0-alpha.3.sql b/deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql
index 56e4503..56e4503 100644
--- a/deploy/articles_update_timestamp@v1.0.0-alpha.3.sql
+++ b/deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql
diff --git a/deploy/items.sql b/deploy/kakeibo.items.sql
index d95fbf5..d95fbf5 100644
--- a/deploy/items.sql
+++ b/deploy/kakeibo.items.sql
diff --git a/deploy/items@v1.0.0-alpha.1.sql b/deploy/kakeibo.items@v1.0.0-alpha.1.sql
index 0a43f8b..0a43f8b 100644
--- a/deploy/items@v1.0.0-alpha.1.sql
+++ b/deploy/kakeibo.items@v1.0.0-alpha.1.sql
diff --git a/deploy/items_update_timestamp.sql b/deploy/kakeibo.items_update_timestamp.sql
index d389f8f..d389f8f 100644
--- a/deploy/items_update_timestamp.sql
+++ b/deploy/kakeibo.items_update_timestamp.sql
diff --git a/deploy/items_update_timestamp@v1.0.0-alpha.3.sql b/deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql
index f9258b2..f9258b2 100644
--- a/deploy/items_update_timestamp@v1.0.0-alpha.3.sql
+++ b/deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql
diff --git a/deploy/transaction_types.sql b/deploy/kakeibo.transaction_types.sql
index cf07925..cf07925 100644
--- a/deploy/transaction_types.sql
+++ b/deploy/kakeibo.transaction_types.sql
diff --git a/deploy/transactions.sql b/deploy/kakeibo.transactions.sql
index 3a4585a..3a4585a 100644
--- a/deploy/transactions.sql
+++ b/deploy/kakeibo.transactions.sql
diff --git a/deploy/transactions@v1.0.0-alpha.1.sql b/deploy/kakeibo.transactions@v1.0.0-alpha.1.sql
index e37b276..e37b276 100644
--- a/deploy/transactions@v1.0.0-alpha.1.sql
+++ b/deploy/kakeibo.transactions@v1.0.0-alpha.1.sql
diff --git a/deploy/transactions@v1.0.0-alpha.2.sql b/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql
index 0572a23..0572a23 100644
--- a/deploy/transactions@v1.0.0-alpha.2.sql
+++ b/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql
diff --git a/deploy/transactions_update_timestamp.sql b/deploy/kakeibo.transactions_update_timestamp.sql
index 74ccee5..74ccee5 100644
--- a/deploy/transactions_update_timestamp.sql
+++ b/deploy/kakeibo.transactions_update_timestamp.sql
diff --git a/deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql b/deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql
index 23c126a..23c126a 100644
--- a/deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql
+++ b/deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql
diff --git a/revert/articles.sql b/revert/kakeibo.articles.sql
index d5177d1..d5177d1 100644
--- a/revert/articles.sql
+++ b/revert/kakeibo.articles.sql
diff --git a/revert/articles_update_timestamp.sql b/revert/kakeibo.articles_update_timestamp.sql
index 56e4503..56e4503 100644
--- a/revert/articles_update_timestamp.sql
+++ b/revert/kakeibo.articles_update_timestamp.sql
diff --git a/revert/articles_update_timestamp@v1.0.0-alpha.3.sql b/revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql
index 3ce73d1..3ce73d1 100644
--- a/revert/articles_update_timestamp@v1.0.0-alpha.3.sql
+++ b/revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql
diff --git a/revert/items.sql b/revert/kakeibo.items.sql
index c8cbcd5..c8cbcd5 100644
--- a/revert/items.sql
+++ b/revert/kakeibo.items.sql
diff --git a/revert/items@v1.0.0-alpha.1.sql b/revert/kakeibo.items@v1.0.0-alpha.1.sql
index b36bf6b..b36bf6b 100644
--- a/revert/items@v1.0.0-alpha.1.sql
+++ b/revert/kakeibo.items@v1.0.0-alpha.1.sql
diff --git a/revert/items_update_timestamp.sql b/revert/kakeibo.items_update_timestamp.sql
index f9258b2..f9258b2 100644
--- a/revert/items_update_timestamp.sql
+++ b/revert/kakeibo.items_update_timestamp.sql
diff --git a/revert/items_update_timestamp@v1.0.0-alpha.3.sql b/revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql
index 52ce12f..52ce12f 100644
--- a/revert/items_update_timestamp@v1.0.0-alpha.3.sql
+++ b/revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql
diff --git a/revert/transaction_types.sql b/revert/kakeibo.transaction_types.sql
index 48df263..48df263 100644
--- a/revert/transaction_types.sql
+++ b/revert/kakeibo.transaction_types.sql
diff --git a/revert/transactions.sql b/revert/kakeibo.transactions.sql
index c424cc1..c424cc1 100644
--- a/revert/transactions.sql
+++ b/revert/kakeibo.transactions.sql
diff --git a/revert/transactions@v1.0.0-alpha.1.sql b/revert/kakeibo.transactions@v1.0.0-alpha.1.sql
index 835ff3d..835ff3d 100644
--- a/revert/transactions@v1.0.0-alpha.1.sql
+++ b/revert/kakeibo.transactions@v1.0.0-alpha.1.sql
diff --git a/revert/transactions@v1.0.0-alpha.2.sql b/revert/kakeibo.transactions@v1.0.0-alpha.2.sql
index d30390a..d30390a 100644
--- a/revert/transactions@v1.0.0-alpha.2.sql
+++ b/revert/kakeibo.transactions@v1.0.0-alpha.2.sql
diff --git a/revert/transactions_update_timestamp.sql b/revert/kakeibo.transactions_update_timestamp.sql
index 23c126a..23c126a 100644
--- a/revert/transactions_update_timestamp.sql
+++ b/revert/kakeibo.transactions_update_timestamp.sql
diff --git a/revert/transactions_update_timestamp@v1.0.0-alpha.3.sql b/revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql
index c9bee8f..c9bee8f 100644
--- a/revert/transactions_update_timestamp@v1.0.0-alpha.3.sql
+++ b/revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql
diff --git a/sqitch.plan b/sqitch.plan
index 2ef8efd..3d51e33 100644
--- a/sqitch.plan
+++ b/sqitch.plan
@@ -3,27 +3,27 @@
%uri=https://git.tojo.tokyo/life-archive.git
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.
+kakeibo.transactions [kakeibo] 2023-03-11T16:50:25Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking transactions.
+kakeibo.items [kakeibo kakeibo.transactions] 2023-03-12T04:48:30Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking items.
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.
+kakeibo.transactions_update_timestamp [kakeibo.transactions update_timestamp] 2023-03-12T14:10:42Z Masaya Tojo <masaya@tojo.tokyo> # Add update_timestamp trigger to transactions table.
+kakeibo.items_update_timestamp [kakeibo.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 [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.
+kakeibo.articles [kakeibo] 2023-03-12T14:43:06Z Masaya Tojo <masaya@tojo.tokyo> # Add table to manage articles.
+kakeibo.transactions [kakeibo.transactions@v1.0.0-alpha.1 kakeibo.articles] 2023-03-12T15:06:03Z Masaya Tojo <masaya@tojo.tokyo> # Add article_id column to transactions table.
+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.
-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.
+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.
-articles_update_timestamp [articles_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:26Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
-items_update_timestamp [items_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:41Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
-transactions_update_timestamp [transactions_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:53Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
+kakeibo.articles_update_timestamp [kakeibo.articles_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:26Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
+kakeibo.items_update_timestamp [kakeibo.items_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:41Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
+kakeibo.transactions_update_timestamp [kakeibo.transactions_update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:11:53Z Masaya Tojo <masaya@tojo.tokyo> # Change kakeibo.update_timestamp to common.update_timestamp.
update_timestamp [update_timestamp@v1.0.0-alpha.3] 2023-03-27T15:18:34Z Masaya Tojo <masaya@tojo.tokyo> # Drop kakeibo.update_timestamp.
photo 2023-03-27T15:39:16Z Masaya Tojo <masaya@tojo.tokyo> # Add photo schema.
photo.photos [photo] 2023-03-27T16:00:51Z Masaya Tojo <masaya@tojo.tokyo> # Add table for tracking photos.
diff --git a/verify/articles.sql b/verify/kakeibo.articles.sql
index 355d20f..355d20f 100644
--- a/verify/articles.sql
+++ b/verify/kakeibo.articles.sql
diff --git a/verify/articles_update_timestamp.sql b/verify/kakeibo.articles_update_timestamp.sql
index f1952b3..f1952b3 100644
--- a/verify/articles_update_timestamp.sql
+++ b/verify/kakeibo.articles_update_timestamp.sql
diff --git a/verify/articles_update_timestamp@v1.0.0-alpha.3.sql b/verify/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql
index f1952b3..f1952b3 100644
--- a/verify/articles_update_timestamp@v1.0.0-alpha.3.sql
+++ b/verify/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql
diff --git a/verify/items.sql b/verify/kakeibo.items.sql
index 22a4ee3..22a4ee3 100644
--- a/verify/items.sql
+++ b/verify/kakeibo.items.sql
diff --git a/verify/items@v1.0.0-alpha.1.sql b/verify/kakeibo.items@v1.0.0-alpha.1.sql
index 9a561cf..9a561cf 100644
--- a/verify/items@v1.0.0-alpha.1.sql
+++ b/verify/kakeibo.items@v1.0.0-alpha.1.sql
diff --git a/verify/items_update_timestamp.sql b/verify/kakeibo.items_update_timestamp.sql
index c7fe432..c7fe432 100644
--- a/verify/items_update_timestamp.sql
+++ b/verify/kakeibo.items_update_timestamp.sql
diff --git a/verify/items_update_timestamp@v1.0.0-alpha.3.sql b/verify/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql
index c7fe432..c7fe432 100644
--- a/verify/items_update_timestamp@v1.0.0-alpha.3.sql
+++ b/verify/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql
diff --git a/verify/transaction_types.sql b/verify/kakeibo.transaction_types.sql
index 49aa2f6..49aa2f6 100644
--- a/verify/transaction_types.sql
+++ b/verify/kakeibo.transaction_types.sql
diff --git a/verify/transactions.sql b/verify/kakeibo.transactions.sql
index 3f5b58f..3f5b58f 100644
--- a/verify/transactions.sql
+++ b/verify/kakeibo.transactions.sql
diff --git a/verify/transactions@v1.0.0-alpha.1.sql b/verify/kakeibo.transactions@v1.0.0-alpha.1.sql
index 0cc1b2d..0cc1b2d 100644
--- a/verify/transactions@v1.0.0-alpha.1.sql
+++ b/verify/kakeibo.transactions@v1.0.0-alpha.1.sql
diff --git a/verify/transactions@v1.0.0-alpha.2.sql b/verify/kakeibo.transactions@v1.0.0-alpha.2.sql
index 3f5b58f..3f5b58f 100644
--- a/verify/transactions@v1.0.0-alpha.2.sql
+++ b/verify/kakeibo.transactions@v1.0.0-alpha.2.sql
diff --git a/verify/transactions_update_timestamp.sql b/verify/kakeibo.transactions_update_timestamp.sql
index 50f348e..50f348e 100644
--- a/verify/transactions_update_timestamp.sql
+++ b/verify/kakeibo.transactions_update_timestamp.sql
diff --git a/verify/transactions_update_timestamp@v1.0.0-alpha.3.sql b/verify/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql
index 50f348e..50f348e 100644
--- a/verify/transactions_update_timestamp@v1.0.0-alpha.3.sql
+++ b/verify/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql