From 70304b1903cc5b1accd9caea229e59901384203a Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Tue, 28 Mar 2023 01:29:08 +0900 Subject: Add `kakeibo.` prefix. --- revert/articles.sql | 7 ------- revert/articles_update_timestamp.sql | 12 ------------ revert/articles_update_timestamp@v1.0.0-alpha.3.sql | 7 ------- revert/items.sql | 10 ---------- revert/items@v1.0.0-alpha.1.sql | 7 ------- revert/items_update_timestamp.sql | 12 ------------ revert/items_update_timestamp@v1.0.0-alpha.3.sql | 7 ------- revert/kakeibo.articles.sql | 7 +++++++ revert/kakeibo.articles_update_timestamp.sql | 12 ++++++++++++ revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql | 7 +++++++ revert/kakeibo.items.sql | 10 ++++++++++ revert/kakeibo.items@v1.0.0-alpha.1.sql | 7 +++++++ revert/kakeibo.items_update_timestamp.sql | 12 ++++++++++++ revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql | 7 +++++++ revert/kakeibo.transaction_types.sql | 7 +++++++ revert/kakeibo.transactions.sql | 8 ++++++++ revert/kakeibo.transactions@v1.0.0-alpha.1.sql | 7 +++++++ revert/kakeibo.transactions@v1.0.0-alpha.2.sql | 8 ++++++++ revert/kakeibo.transactions_update_timestamp.sql | 12 ++++++++++++ .../kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql | 7 +++++++ revert/transaction_types.sql | 7 ------- revert/transactions.sql | 8 -------- revert/transactions@v1.0.0-alpha.1.sql | 7 ------- revert/transactions@v1.0.0-alpha.2.sql | 8 -------- revert/transactions_update_timestamp.sql | 12 ------------ revert/transactions_update_timestamp@v1.0.0-alpha.3.sql | 7 ------- 26 files changed, 111 insertions(+), 111 deletions(-) delete mode 100644 revert/articles.sql delete mode 100644 revert/articles_update_timestamp.sql delete mode 100644 revert/articles_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 revert/items.sql delete mode 100644 revert/items@v1.0.0-alpha.1.sql delete mode 100644 revert/items_update_timestamp.sql delete mode 100644 revert/items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 revert/kakeibo.articles.sql create mode 100644 revert/kakeibo.articles_update_timestamp.sql create mode 100644 revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 revert/kakeibo.items.sql create mode 100644 revert/kakeibo.items@v1.0.0-alpha.1.sql create mode 100644 revert/kakeibo.items_update_timestamp.sql create mode 100644 revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 revert/kakeibo.transaction_types.sql create mode 100644 revert/kakeibo.transactions.sql create mode 100644 revert/kakeibo.transactions@v1.0.0-alpha.1.sql create mode 100644 revert/kakeibo.transactions@v1.0.0-alpha.2.sql create mode 100644 revert/kakeibo.transactions_update_timestamp.sql create mode 100644 revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 revert/transaction_types.sql delete mode 100644 revert/transactions.sql delete mode 100644 revert/transactions@v1.0.0-alpha.1.sql delete mode 100644 revert/transactions@v1.0.0-alpha.2.sql delete mode 100644 revert/transactions_update_timestamp.sql delete mode 100644 revert/transactions_update_timestamp@v1.0.0-alpha.3.sql (limited to 'revert') diff --git a/revert/articles.sql b/revert/articles.sql deleted file mode 100644 index d5177d1..0000000 --- a/revert/articles.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:articles from pg - -BEGIN; - -DROP TABLE kakeibo.articles; - -COMMIT; diff --git a/revert/articles_update_timestamp.sql b/revert/articles_update_timestamp.sql deleted file mode 100644 index 56e4503..0000000 --- a/revert/articles_update_timestamp.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:articles_update_timestamp to pg --- requires: articles --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.articles - FOR EACH ROW - EXECUTE FUNCTION kakeibo.update_timestamp(); - -COMMIT; diff --git a/revert/articles_update_timestamp@v1.0.0-alpha.3.sql b/revert/articles_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index 3ce73d1..0000000 --- a/revert/articles_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:articles_update_timestamp from pg - -BEGIN; - -DROP TRIGGER update_timestamp ON kakeibo.articles; - -COMMIT; diff --git a/revert/items.sql b/revert/items.sql deleted file mode 100644 index c8cbcd5..0000000 --- a/revert/items.sql +++ /dev/null @@ -1,10 +0,0 @@ --- Deploy kakeibo:items to pg --- requires: schema --- requires: transactions - -BEGIN; - -ALTER TABLE kakeibo.items - DROP COLUMN article_id; - -COMMIT; diff --git a/revert/items@v1.0.0-alpha.1.sql b/revert/items@v1.0.0-alpha.1.sql deleted file mode 100644 index b36bf6b..0000000 --- a/revert/items@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:items from pg - -BEGIN; - -DROP TABLE kakeibo.items; - -COMMIT; diff --git a/revert/items_update_timestamp.sql b/revert/items_update_timestamp.sql deleted file mode 100644 index f9258b2..0000000 --- a/revert/items_update_timestamp.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:items_update_timestamp to pg --- requires: items --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.items - FOR EACH ROW - EXECUTE FUNCTION kakeibo.update_timestamp(); - -COMMIT; diff --git a/revert/items_update_timestamp@v1.0.0-alpha.3.sql b/revert/items_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index 52ce12f..0000000 --- a/revert/items_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:items_update_timestamp from pg - -BEGIN; - -DROP TRIGGER update_timestamp ON kakeibo.items; - -COMMIT; diff --git a/revert/kakeibo.articles.sql b/revert/kakeibo.articles.sql new file mode 100644 index 0000000..d5177d1 --- /dev/null +++ b/revert/kakeibo.articles.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:articles from pg + +BEGIN; + +DROP TABLE kakeibo.articles; + +COMMIT; diff --git a/revert/kakeibo.articles_update_timestamp.sql b/revert/kakeibo.articles_update_timestamp.sql new file mode 100644 index 0000000..56e4503 --- /dev/null +++ b/revert/kakeibo.articles_update_timestamp.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:articles_update_timestamp to pg +-- requires: articles +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.articles + FOR EACH ROW + EXECUTE FUNCTION kakeibo.update_timestamp(); + +COMMIT; diff --git a/revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql b/revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..3ce73d1 --- /dev/null +++ b/revert/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:articles_update_timestamp from pg + +BEGIN; + +DROP TRIGGER update_timestamp ON kakeibo.articles; + +COMMIT; diff --git a/revert/kakeibo.items.sql b/revert/kakeibo.items.sql new file mode 100644 index 0000000..c8cbcd5 --- /dev/null +++ b/revert/kakeibo.items.sql @@ -0,0 +1,10 @@ +-- Deploy kakeibo:items to pg +-- requires: schema +-- requires: transactions + +BEGIN; + +ALTER TABLE kakeibo.items + DROP COLUMN article_id; + +COMMIT; diff --git a/revert/kakeibo.items@v1.0.0-alpha.1.sql b/revert/kakeibo.items@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..b36bf6b --- /dev/null +++ b/revert/kakeibo.items@v1.0.0-alpha.1.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:items from pg + +BEGIN; + +DROP TABLE kakeibo.items; + +COMMIT; diff --git a/revert/kakeibo.items_update_timestamp.sql b/revert/kakeibo.items_update_timestamp.sql new file mode 100644 index 0000000..f9258b2 --- /dev/null +++ b/revert/kakeibo.items_update_timestamp.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:items_update_timestamp to pg +-- requires: items +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.items + FOR EACH ROW + EXECUTE FUNCTION kakeibo.update_timestamp(); + +COMMIT; diff --git a/revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql b/revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..52ce12f --- /dev/null +++ b/revert/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:items_update_timestamp from pg + +BEGIN; + +DROP TRIGGER update_timestamp ON kakeibo.items; + +COMMIT; diff --git a/revert/kakeibo.transaction_types.sql b/revert/kakeibo.transaction_types.sql new file mode 100644 index 0000000..48df263 --- /dev/null +++ b/revert/kakeibo.transaction_types.sql @@ -0,0 +1,7 @@ +-- 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 new file mode 100644 index 0000000..c424cc1 --- /dev/null +++ b/revert/kakeibo.transactions.sql @@ -0,0 +1,8 @@ +-- Revert kakeibo:transactions from pg + +BEGIN; + +ALTER TABLE kakeibo.transactions + DROP CONSTRAINT transactions_type_code_fkey; + +COMMIT; diff --git a/revert/kakeibo.transactions@v1.0.0-alpha.1.sql b/revert/kakeibo.transactions@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..835ff3d --- /dev/null +++ b/revert/kakeibo.transactions@v1.0.0-alpha.1.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:transactions from pg + +BEGIN; + +DROP TABLE kakeibo.transactions; + +COMMIT; diff --git a/revert/kakeibo.transactions@v1.0.0-alpha.2.sql b/revert/kakeibo.transactions@v1.0.0-alpha.2.sql new file mode 100644 index 0000000..d30390a --- /dev/null +++ b/revert/kakeibo.transactions@v1.0.0-alpha.2.sql @@ -0,0 +1,8 @@ +-- Revert kakeibo:transactions from pg + +BEGIN; + +ALTER TABLE kakeibo.transactions + DROP COLUMN article_id; + +COMMIT; diff --git a/revert/kakeibo.transactions_update_timestamp.sql b/revert/kakeibo.transactions_update_timestamp.sql new file mode 100644 index 0000000..23c126a --- /dev/null +++ b/revert/kakeibo.transactions_update_timestamp.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:transactions_update_timestamp to pg +-- requires: transactions +-- requires: update_timestamp + +BEGIN; + +CREATE OR REPLACE TRIGGER update_timestamp + BEFORE UPDATE ON kakeibo.transactions + FOR EACH ROW + EXECUTE FUNCTION kakeibo.update_timestamp(); + +COMMIT; diff --git a/revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql b/revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..c9bee8f --- /dev/null +++ b/revert/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql @@ -0,0 +1,7 @@ +-- Revert kakeibo:transactions_update_timestamp from pg + +BEGIN; + +DROP TRIGGER update_timestamp ON kakeibo.transactions; + +COMMIT; diff --git a/revert/transaction_types.sql b/revert/transaction_types.sql deleted file mode 100644 index 48df263..0000000 --- a/revert/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/transactions.sql b/revert/transactions.sql deleted file mode 100644 index c424cc1..0000000 --- a/revert/transactions.sql +++ /dev/null @@ -1,8 +0,0 @@ --- Revert kakeibo:transactions from pg - -BEGIN; - -ALTER TABLE kakeibo.transactions - DROP CONSTRAINT transactions_type_code_fkey; - -COMMIT; diff --git a/revert/transactions@v1.0.0-alpha.1.sql b/revert/transactions@v1.0.0-alpha.1.sql deleted file mode 100644 index 835ff3d..0000000 --- a/revert/transactions@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:transactions from pg - -BEGIN; - -DROP TABLE kakeibo.transactions; - -COMMIT; diff --git a/revert/transactions@v1.0.0-alpha.2.sql b/revert/transactions@v1.0.0-alpha.2.sql deleted file mode 100644 index d30390a..0000000 --- a/revert/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/revert/transactions_update_timestamp.sql b/revert/transactions_update_timestamp.sql deleted file mode 100644 index 23c126a..0000000 --- a/revert/transactions_update_timestamp.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:transactions_update_timestamp to pg --- requires: transactions --- requires: update_timestamp - -BEGIN; - -CREATE OR REPLACE TRIGGER update_timestamp - BEFORE UPDATE ON kakeibo.transactions - FOR EACH ROW - EXECUTE FUNCTION kakeibo.update_timestamp(); - -COMMIT; diff --git a/revert/transactions_update_timestamp@v1.0.0-alpha.3.sql b/revert/transactions_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index c9bee8f..0000000 --- a/revert/transactions_update_timestamp@v1.0.0-alpha.3.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Revert kakeibo:transactions_update_timestamp from pg - -BEGIN; - -DROP TRIGGER update_timestamp ON kakeibo.transactions; - -COMMIT; -- cgit v1.2.3