diff options
Diffstat (limited to 'src/main/resources')
| -rw-r--r-- | src/main/resources/sql/20181209/update_specific_service_cfg.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/main/resources/sql/20181209/update_specific_service_cfg.sql b/src/main/resources/sql/20181209/update_specific_service_cfg.sql new file mode 100644 index 0000000..629f643 --- /dev/null +++ b/src/main/resources/sql/20181209/update_specific_service_cfg.sql @@ -0,0 +1,6 @@ +UPDATE + specific_service_cfg c +SET + c.spec_service_code = c.spec_service_code + 10000 +WHERE + c.cfg_type IN (2, 3) AND c.parent_id = 0;
\ No newline at end of file |