From c4cac1f47018ddae442654bdfa4b580a37638295 Mon Sep 17 00:00:00 2001 From: jack <jack.su@pollex.com.tw> Date: 星期二, 06 九月 2022 09:51:31 +0800 Subject: [PATCH] [UPDATE] 整理SQL [UPDATE] 將customer data from 為空的資料改為PAM --- pamapi/src/doc/sql/executed/20211201_j.sql | 0 pamapi/src/doc/sql/executed/20220210_w.sql | 0 pamapi/src/doc/sql/executed/淨空整個系統資料(除顧問).sql | 0 pamapi/src/doc/sql/executed/20220217_w.sql | 0 pamapi/src/doc/sql/executed/20220215_w.sql | 0 pamapi/src/doc/sql/executed/20220122_w.sql | 0 pamapi/src/doc/sql/executed/20211129_w.sql | 0 pamapi/src/doc/sql/executed/20220329_j.sql | 0 pamapi/src/doc/sql/executed/20211229_j.sql | 0 pamapi/src/doc/sql/executed/20211202_w.sql | 0 pamapi/src/doc/sql/executed/20211222_w.sql | 0 pamapi/src/doc/sql/20220906_j.sql | 5 +++++ pamapi/src/doc/sql/executed/20220114_j.sql | 0 pamapi/src/doc/sql/executed/20220121_j.sql | 0 pamapi/src/doc/sql/executed/20211104_w.sql | 0 pamapi/src/doc/sql/executed/20220216_w.sql | 0 pamapi/src/doc/sql/executed/20220126_w.sql | 0 pamapi/src/doc/sql/executed/20220112_j.sql | 0 pamapi/src/doc/sql/executed/20220330_j.sql | 0 pamapi/src/doc/sql/executed/20211229_w.sql | 0 pamapi/src/doc/sql/executed/20220221_w.sql | 0 pamapi/src/doc/sql/executed/20211201_w.sql | 0 pamapi/src/doc/sql/executed/20220103_w.sql | 0 pamapi/src/doc/sql/executed/20211130_w.sql | 0 pamapi/src/doc/sql/executed/20211203_w.sql | 0 pamapi/src/doc/sql/executed/20211108_w.sql | 0 pamapi/src/doc/sql/executed/20220120_j.sql | 0 pamapi/src/doc/sql/executed/20211213_w.sql | 0 28 files changed, 5 insertions(+), 0 deletions(-) diff --git a/pamapi/src/doc/sql/20220906_j.sql b/pamapi/src/doc/sql/20220906_j.sql new file mode 100644 index 0000000..6b05603 --- /dev/null +++ b/pamapi/src/doc/sql/20220906_j.sql @@ -0,0 +1,5 @@ +-- ���ustomer data from null�����pam -- + +UPDATE public.customer +SET data_from='PAM' +WHERE data_from is null; diff --git a/pamapi/src/doc/sql/20211104_w.sql b/pamapi/src/doc/sql/executed/20211104_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211104_w.sql rename to pamapi/src/doc/sql/executed/20211104_w.sql diff --git a/pamapi/src/doc/sql/20211108_w.sql b/pamapi/src/doc/sql/executed/20211108_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211108_w.sql rename to pamapi/src/doc/sql/executed/20211108_w.sql diff --git a/pamapi/src/doc/sql/20211129_w.sql b/pamapi/src/doc/sql/executed/20211129_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211129_w.sql rename to pamapi/src/doc/sql/executed/20211129_w.sql diff --git a/pamapi/src/doc/sql/20211130_w.sql b/pamapi/src/doc/sql/executed/20211130_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211130_w.sql rename to pamapi/src/doc/sql/executed/20211130_w.sql diff --git a/pamapi/src/doc/sql/20211201_j.sql b/pamapi/src/doc/sql/executed/20211201_j.sql similarity index 100% rename from pamapi/src/doc/sql/20211201_j.sql rename to pamapi/src/doc/sql/executed/20211201_j.sql diff --git a/pamapi/src/doc/sql/20211201_w.sql b/pamapi/src/doc/sql/executed/20211201_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211201_w.sql rename to pamapi/src/doc/sql/executed/20211201_w.sql diff --git a/pamapi/src/doc/sql/20211202_w.sql b/pamapi/src/doc/sql/executed/20211202_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211202_w.sql rename to pamapi/src/doc/sql/executed/20211202_w.sql diff --git a/pamapi/src/doc/sql/20211203_w.sql b/pamapi/src/doc/sql/executed/20211203_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211203_w.sql rename to pamapi/src/doc/sql/executed/20211203_w.sql diff --git a/pamapi/src/doc/sql/20211213_w.sql b/pamapi/src/doc/sql/executed/20211213_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211213_w.sql rename to pamapi/src/doc/sql/executed/20211213_w.sql diff --git a/pamapi/src/doc/sql/20211222_w.sql b/pamapi/src/doc/sql/executed/20211222_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211222_w.sql rename to pamapi/src/doc/sql/executed/20211222_w.sql diff --git a/pamapi/src/doc/sql/20211229_j.sql b/pamapi/src/doc/sql/executed/20211229_j.sql similarity index 100% rename from pamapi/src/doc/sql/20211229_j.sql rename to pamapi/src/doc/sql/executed/20211229_j.sql diff --git a/pamapi/src/doc/sql/20211229_w.sql b/pamapi/src/doc/sql/executed/20211229_w.sql similarity index 100% rename from pamapi/src/doc/sql/20211229_w.sql rename to pamapi/src/doc/sql/executed/20211229_w.sql diff --git a/pamapi/src/doc/sql/20220103_w.sql b/pamapi/src/doc/sql/executed/20220103_w.sql similarity index 100% rename from pamapi/src/doc/sql/20220103_w.sql rename to pamapi/src/doc/sql/executed/20220103_w.sql diff --git a/pamapi/src/doc/sql/20220112_j.sql b/pamapi/src/doc/sql/executed/20220112_j.sql similarity index 100% rename from pamapi/src/doc/sql/20220112_j.sql rename to pamapi/src/doc/sql/executed/20220112_j.sql diff --git a/pamapi/src/doc/sql/20220114_j.sql b/pamapi/src/doc/sql/executed/20220114_j.sql similarity index 100% rename from pamapi/src/doc/sql/20220114_j.sql rename to pamapi/src/doc/sql/executed/20220114_j.sql diff --git a/pamapi/src/doc/sql/20220120_j.sql b/pamapi/src/doc/sql/executed/20220120_j.sql similarity index 100% rename from pamapi/src/doc/sql/20220120_j.sql rename to pamapi/src/doc/sql/executed/20220120_j.sql diff --git a/pamapi/src/doc/sql/20220121_j.sql b/pamapi/src/doc/sql/executed/20220121_j.sql similarity index 100% rename from pamapi/src/doc/sql/20220121_j.sql rename to pamapi/src/doc/sql/executed/20220121_j.sql diff --git a/pamapi/src/doc/sql/20220122_w.sql b/pamapi/src/doc/sql/executed/20220122_w.sql similarity index 100% rename from pamapi/src/doc/sql/20220122_w.sql rename to pamapi/src/doc/sql/executed/20220122_w.sql diff --git a/pamapi/src/doc/sql/20220126_w.sql b/pamapi/src/doc/sql/executed/20220126_w.sql similarity index 100% rename from pamapi/src/doc/sql/20220126_w.sql rename to pamapi/src/doc/sql/executed/20220126_w.sql diff --git a/pamapi/src/doc/sql/20220210_w.sql b/pamapi/src/doc/sql/executed/20220210_w.sql similarity index 100% rename from pamapi/src/doc/sql/20220210_w.sql rename to pamapi/src/doc/sql/executed/20220210_w.sql diff --git a/pamapi/src/doc/sql/20220215_w.sql b/pamapi/src/doc/sql/executed/20220215_w.sql similarity index 100% rename from pamapi/src/doc/sql/20220215_w.sql rename to pamapi/src/doc/sql/executed/20220215_w.sql diff --git a/pamapi/src/doc/sql/20220216_w.sql b/pamapi/src/doc/sql/executed/20220216_w.sql similarity index 100% rename from pamapi/src/doc/sql/20220216_w.sql rename to pamapi/src/doc/sql/executed/20220216_w.sql diff --git a/pamapi/src/doc/sql/20220217_w.sql b/pamapi/src/doc/sql/executed/20220217_w.sql similarity index 100% rename from pamapi/src/doc/sql/20220217_w.sql rename to pamapi/src/doc/sql/executed/20220217_w.sql diff --git a/pamapi/src/doc/sql/20220221_w.sql b/pamapi/src/doc/sql/executed/20220221_w.sql similarity index 100% rename from pamapi/src/doc/sql/20220221_w.sql rename to pamapi/src/doc/sql/executed/20220221_w.sql diff --git a/pamapi/src/doc/sql/20220329_j.sql b/pamapi/src/doc/sql/executed/20220329_j.sql similarity index 100% rename from pamapi/src/doc/sql/20220329_j.sql rename to pamapi/src/doc/sql/executed/20220329_j.sql diff --git a/pamapi/src/doc/sql/20220330_j.sql b/pamapi/src/doc/sql/executed/20220330_j.sql similarity index 100% rename from pamapi/src/doc/sql/20220330_j.sql rename to pamapi/src/doc/sql/executed/20220330_j.sql diff --git "a/pamapi/src/doc/sql/\346\267\250\347\251\272\346\225\264\345\200\213\347\263\273\347\265\261\350\263\207\346\226\231\050\351\231\244\351\241\247\345\225\217\051.sql" "b/pamapi/src/doc/sql/executed/\346\267\250\347\251\272\346\225\264\345\200\213\347\263\273\347\265\261\350\263\207\346\226\231\050\351\231\244\351\241\247\345\225\217\051.sql" similarity index 100% rename from "pamapi/src/doc/sql/\346\267\250\347\251\272\346\225\264\345\200\213\347\263\273\347\265\261\350\263\207\346\226\231\050\351\231\244\351\241\247\345\225\217\051.sql" rename to "pamapi/src/doc/sql/executed/\346\267\250\347\251\272\346\225\264\345\200\213\347\263\273\347\265\261\350\263\207\346\226\231\050\351\231\244\351\241\247\345\225\217\051.sql" -- Gitblit v1.8.0