[GitHub] [dolphinscheduler] dailidong commented on issue #6002: [Question] What's the relation between these two sql files

[GitBox <gi...@apache.org>]

dailidong commented on issue #6002:
URL: https://github.com/apache/dolphinscheduler/issues/6002#issuecomment-901089375


   good issue, 
   create-dolphinscheduler.sh will use dolphinscheduler_ddl.sql and then it will run a java program
   ```
   CLASS=org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler
   
   exec_command="$DOLPHINSCHEDULER_OPTS -classpath $DOLPHINSCHEDULER_CONF_DIR:$DOLPHINSCHEDULER_LIB_JARS $CLASS"
   
   cd $DOLPHINSCHEDULER_HOME
   $JAVA_HOME/bin/java $exec_command
   ```
   this java program `CreateDolphinScheduler` will first use dolphinscheduler_ddl.sql as a basis, and then upgrade to the version for the corresponding database.
   
   you also can execute dolphinscheduler_mysql.sql  directly instead of the create-dolphinscheduler.sh,
   by the way, the create-dolphinscheduler.sh is used to maintain backward compatibility, You will find that DolphinScheduler also uses this sh file when upgrading to the new version


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org