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. --- deploy/articles.sql | 14 -------------- deploy/articles_update_timestamp.sql | 12 ------------ deploy/articles_update_timestamp@v1.0.0-alpha.3.sql | 12 ------------ deploy/items.sql | 13 ------------- deploy/items@v1.0.0-alpha.1.sql | 18 ------------------ deploy/items_update_timestamp.sql | 12 ------------ deploy/items_update_timestamp@v1.0.0-alpha.3.sql | 12 ------------ deploy/kakeibo.articles.sql | 14 ++++++++++++++ deploy/kakeibo.articles_update_timestamp.sql | 12 ++++++++++++ ...akeibo.articles_update_timestamp@v1.0.0-alpha.3.sql | 12 ++++++++++++ deploy/kakeibo.items.sql | 13 +++++++++++++ deploy/kakeibo.items@v1.0.0-alpha.1.sql | 18 ++++++++++++++++++ deploy/kakeibo.items_update_timestamp.sql | 12 ++++++++++++ .../kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql | 12 ++++++++++++ deploy/kakeibo.transaction_types.sql | 12 ++++++++++++ deploy/kakeibo.transactions.sql | 12 ++++++++++++ deploy/kakeibo.transactions@v1.0.0-alpha.1.sql | 15 +++++++++++++++ deploy/kakeibo.transactions@v1.0.0-alpha.2.sql | 12 ++++++++++++ deploy/kakeibo.transactions_update_timestamp.sql | 12 ++++++++++++ ...bo.transactions_update_timestamp@v1.0.0-alpha.3.sql | 12 ++++++++++++ deploy/transaction_types.sql | 12 ------------ deploy/transactions.sql | 12 ------------ deploy/transactions@v1.0.0-alpha.1.sql | 15 --------------- deploy/transactions@v1.0.0-alpha.2.sql | 12 ------------ deploy/transactions_update_timestamp.sql | 12 ------------ .../transactions_update_timestamp@v1.0.0-alpha.3.sql | 12 ------------ 26 files changed, 168 insertions(+), 168 deletions(-) delete mode 100644 deploy/articles.sql delete mode 100644 deploy/articles_update_timestamp.sql delete mode 100644 deploy/articles_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 deploy/items.sql delete mode 100644 deploy/items@v1.0.0-alpha.1.sql delete mode 100644 deploy/items_update_timestamp.sql delete mode 100644 deploy/items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 deploy/kakeibo.articles.sql create mode 100644 deploy/kakeibo.articles_update_timestamp.sql create mode 100644 deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 deploy/kakeibo.items.sql create mode 100644 deploy/kakeibo.items@v1.0.0-alpha.1.sql create mode 100644 deploy/kakeibo.items_update_timestamp.sql create mode 100644 deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql create mode 100644 deploy/kakeibo.transaction_types.sql create mode 100644 deploy/kakeibo.transactions.sql create mode 100644 deploy/kakeibo.transactions@v1.0.0-alpha.1.sql create mode 100644 deploy/kakeibo.transactions@v1.0.0-alpha.2.sql create mode 100644 deploy/kakeibo.transactions_update_timestamp.sql create mode 100644 deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql delete mode 100644 deploy/transaction_types.sql delete mode 100644 deploy/transactions.sql delete mode 100644 deploy/transactions@v1.0.0-alpha.1.sql delete mode 100644 deploy/transactions@v1.0.0-alpha.2.sql delete mode 100644 deploy/transactions_update_timestamp.sql delete mode 100644 deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql (limited to 'deploy') diff --git a/deploy/articles.sql b/deploy/articles.sql deleted file mode 100644 index 08fcb5e..0000000 --- a/deploy/articles.sql +++ /dev/null @@ -1,14 +0,0 @@ --- Deploy kakeibo:articles to pg --- requires: schema - -BEGIN; - -CREATE TABLE kakeibo.articles ( - id SERIAL PRIMARY KEY, - location TEXT UNIQUE, - title TEXT NOT NULL, - created_at TIMESTAMP NOT NULL DEFAULT NOW(), - updated_at TIMESTAMP NOT NULL DEFAULT NOW() -); - -COMMIT; diff --git a/deploy/articles_update_timestamp.sql b/deploy/articles_update_timestamp.sql deleted file mode 100644 index 239d80a..0000000 --- a/deploy/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 common.update_timestamp(); - -COMMIT; diff --git a/deploy/articles_update_timestamp@v1.0.0-alpha.3.sql b/deploy/articles_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index 56e4503..0000000 --- a/deploy/articles_update_timestamp@v1.0.0-alpha.3.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/deploy/items.sql b/deploy/items.sql deleted file mode 100644 index d95fbf5..0000000 --- a/deploy/items.sql +++ /dev/null @@ -1,13 +0,0 @@ --- Deploy kakeibo:items to pg --- requires: schema --- requires: transactions --- requires: articles - -BEGIN; - -ALTER TABLE kakeibo.items - ADD COLUMN article_id INTEGER, - ADD CONSTRAINT transactions_article_id_fkey - FOREIGN KEY (article_id) REFERENCES kakeibo.articles (id); - -COMMIT; diff --git a/deploy/items@v1.0.0-alpha.1.sql b/deploy/items@v1.0.0-alpha.1.sql deleted file mode 100644 index 0a43f8b..0000000 --- a/deploy/items@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,18 +0,0 @@ --- Deploy kakeibo:items to pg --- requires: schema --- requires: transactions - -BEGIN; - -CREATE TABLE kakeibo.items ( - id SERIAL PRIMARY KEY, - transaction_id INTEGER NOT NULL REFERENCES kakeibo.transactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT, - category TEXT NOT NULL, - subcategory TEXT CHECK (note <> ''), - amount INTEGER NOT NULL CHECK (amount > 0), - note TEXT CHECK (note <> '') , - created_at TIMESTAMP NOT NULL DEFAULT NOW(), - updated_at TIMESTAMP NOT NULL DEFAULT NOW() -); - -COMMIT; diff --git a/deploy/items_update_timestamp.sql b/deploy/items_update_timestamp.sql deleted file mode 100644 index d389f8f..0000000 --- a/deploy/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 common.update_timestamp(); - -COMMIT; diff --git a/deploy/items_update_timestamp@v1.0.0-alpha.3.sql b/deploy/items_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index f9258b2..0000000 --- a/deploy/items_update_timestamp@v1.0.0-alpha.3.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/deploy/kakeibo.articles.sql b/deploy/kakeibo.articles.sql new file mode 100644 index 0000000..08fcb5e --- /dev/null +++ b/deploy/kakeibo.articles.sql @@ -0,0 +1,14 @@ +-- Deploy kakeibo:articles to pg +-- requires: schema + +BEGIN; + +CREATE TABLE kakeibo.articles ( + id SERIAL PRIMARY KEY, + location TEXT UNIQUE, + title TEXT NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP NOT NULL DEFAULT NOW() +); + +COMMIT; diff --git a/deploy/kakeibo.articles_update_timestamp.sql b/deploy/kakeibo.articles_update_timestamp.sql new file mode 100644 index 0000000..239d80a --- /dev/null +++ b/deploy/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 common.update_timestamp(); + +COMMIT; diff --git a/deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql b/deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..56e4503 --- /dev/null +++ b/deploy/kakeibo.articles_update_timestamp@v1.0.0-alpha.3.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/deploy/kakeibo.items.sql b/deploy/kakeibo.items.sql new file mode 100644 index 0000000..d95fbf5 --- /dev/null +++ b/deploy/kakeibo.items.sql @@ -0,0 +1,13 @@ +-- Deploy kakeibo:items to pg +-- requires: schema +-- requires: transactions +-- requires: articles + +BEGIN; + +ALTER TABLE kakeibo.items + 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.items@v1.0.0-alpha.1.sql b/deploy/kakeibo.items@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..0a43f8b --- /dev/null +++ b/deploy/kakeibo.items@v1.0.0-alpha.1.sql @@ -0,0 +1,18 @@ +-- Deploy kakeibo:items to pg +-- requires: schema +-- requires: transactions + +BEGIN; + +CREATE TABLE kakeibo.items ( + id SERIAL PRIMARY KEY, + transaction_id INTEGER NOT NULL REFERENCES kakeibo.transactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT, + category TEXT NOT NULL, + subcategory TEXT CHECK (note <> ''), + amount INTEGER NOT NULL CHECK (amount > 0), + note TEXT CHECK (note <> '') , + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP NOT NULL DEFAULT NOW() +); + +COMMIT; diff --git a/deploy/kakeibo.items_update_timestamp.sql b/deploy/kakeibo.items_update_timestamp.sql new file mode 100644 index 0000000..d389f8f --- /dev/null +++ b/deploy/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 common.update_timestamp(); + +COMMIT; diff --git a/deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql b/deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..f9258b2 --- /dev/null +++ b/deploy/kakeibo.items_update_timestamp@v1.0.0-alpha.3.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/deploy/kakeibo.transaction_types.sql b/deploy/kakeibo.transaction_types.sql new file mode 100644 index 0000000..cf07925 --- /dev/null +++ b/deploy/kakeibo.transaction_types.sql @@ -0,0 +1,12 @@ +-- 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 new file mode 100644 index 0000000..3a4585a --- /dev/null +++ b/deploy/kakeibo.transactions.sql @@ -0,0 +1,12 @@ +-- Deploy kakeibo:transactions to pg +-- requires: schema +-- requires: articles + +BEGIN; + +ALTER TABLE kakeibo.transactions + ADD CONSTRAINT transactions_type_code_fkey + FOREIGN KEY (type_code) + REFERENCES kakeibo.transaction_types (code); + +COMMIT; diff --git a/deploy/kakeibo.transactions@v1.0.0-alpha.1.sql b/deploy/kakeibo.transactions@v1.0.0-alpha.1.sql new file mode 100644 index 0000000..e37b276 --- /dev/null +++ b/deploy/kakeibo.transactions@v1.0.0-alpha.1.sql @@ -0,0 +1,15 @@ +-- Deploy kakeibo:transactions to pg +-- requires: schema + +BEGIN; + +CREATE TABLE kakeibo.transactions ( + id SERIAL PRIMARY KEY, + type_code INTEGER, + date DATE NOT NULL, + note TEXT, + created_at TIMESTAMP NOT NULL DEFAULT NOW(), + updated_at TIMESTAMP NOT NULL DEFAULT NOW() +); + +COMMIT; diff --git a/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql b/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql new file mode 100644 index 0000000..0572a23 --- /dev/null +++ b/deploy/kakeibo.transactions@v1.0.0-alpha.2.sql @@ -0,0 +1,12 @@ +-- 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/deploy/kakeibo.transactions_update_timestamp.sql b/deploy/kakeibo.transactions_update_timestamp.sql new file mode 100644 index 0000000..74ccee5 --- /dev/null +++ b/deploy/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 common.update_timestamp(); + +COMMIT; diff --git a/deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql b/deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.sql new file mode 100644 index 0000000..23c126a --- /dev/null +++ b/deploy/kakeibo.transactions_update_timestamp@v1.0.0-alpha.3.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/deploy/transaction_types.sql b/deploy/transaction_types.sql deleted file mode 100644 index cf07925..0000000 --- a/deploy/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/transactions.sql b/deploy/transactions.sql deleted file mode 100644 index 3a4585a..0000000 --- a/deploy/transactions.sql +++ /dev/null @@ -1,12 +0,0 @@ --- Deploy kakeibo:transactions to pg --- requires: schema --- requires: articles - -BEGIN; - -ALTER TABLE kakeibo.transactions - ADD CONSTRAINT transactions_type_code_fkey - FOREIGN KEY (type_code) - REFERENCES kakeibo.transaction_types (code); - -COMMIT; diff --git a/deploy/transactions@v1.0.0-alpha.1.sql b/deploy/transactions@v1.0.0-alpha.1.sql deleted file mode 100644 index e37b276..0000000 --- a/deploy/transactions@v1.0.0-alpha.1.sql +++ /dev/null @@ -1,15 +0,0 @@ --- Deploy kakeibo:transactions to pg --- requires: schema - -BEGIN; - -CREATE TABLE kakeibo.transactions ( - id SERIAL PRIMARY KEY, - type_code INTEGER, - date DATE NOT NULL, - note TEXT, - created_at TIMESTAMP NOT NULL DEFAULT NOW(), - updated_at TIMESTAMP NOT NULL DEFAULT NOW() -); - -COMMIT; diff --git a/deploy/transactions@v1.0.0-alpha.2.sql b/deploy/transactions@v1.0.0-alpha.2.sql deleted file mode 100644 index 0572a23..0000000 --- a/deploy/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/deploy/transactions_update_timestamp.sql b/deploy/transactions_update_timestamp.sql deleted file mode 100644 index 74ccee5..0000000 --- a/deploy/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 common.update_timestamp(); - -COMMIT; diff --git a/deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql b/deploy/transactions_update_timestamp@v1.0.0-alpha.3.sql deleted file mode 100644 index 23c126a..0000000 --- a/deploy/transactions_update_timestamp@v1.0.0-alpha.3.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; -- cgit v1.2.3