[dolphinscheduler] branch 3.1.9-prepare updated: Update dolphinscheduler_ddl.sql (#14945)

[kerwin]

This is an automated email from the ASF dual-hosted git repository.

kerwin pushed a commit to branch 3.1.9-prepare
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git


The following commit(s) were added to refs/heads/3.1.9-prepare by this push:
     new 1102238c1d Update dolphinscheduler_ddl.sql (#14945)
1102238c1d is described below

commit 1102238c1ded4fecb3799c3422588d59934498d7
Author: fuchanghai <33984497+fuchang...@users.noreply.github.com>
AuthorDate: Thu Sep 21 16:34:26 2023 +0800

    Update dolphinscheduler_ddl.sql (#14945)
---
 .../sql/upgrade/3.1.6_schema/postgresql/dolphinscheduler_ddl.sql    | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git 
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.1.6_schema/postgresql/dolphinscheduler_ddl.sql
 
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.1.6_schema/postgresql/dolphinscheduler_ddl.sql
index 4a14f326b9..e8baedc05a 100644
--- 
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.1.6_schema/postgresql/dolphinscheduler_ddl.sql
+++ 
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.1.6_schema/postgresql/dolphinscheduler_ddl.sql
@@ -14,3 +14,9 @@
  * See the License for the specific language governing permissions and
  * limitations under the License.
 */
+
+ALTER TABLE t_ds_process_definition ADD COLUMN IF NOT EXISTS execution_type 
int NULL DEFAULT '0';
+
+ALTER TABLE t_ds_process_definition_log ADD COLUMN IF NOT EXISTS 
execution_type int NULL DEFAULT '0';
+
+ALTER TABLE t_ds_process_instance ADD COLUMN IF NOT EXISTS 
next_process_instance_id int NULL DEFAULT '0';