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

zhangliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new 848ae601290 Unify example DB init on example (#37558)
848ae601290 is described below

commit 848ae60129040108c522b332e1a317183d119922
Author: Liang Zhang <[email protected]>
AuthorDate: Sun Dec 28 16:09:31 2025 +0800

    Unify example DB init on example (#37558)
---
 .../resources/scripts/nightly-build-example/init-mysql-container.sh    | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

diff --git 
a/.github/workflows/resources/scripts/nightly-build-example/init-mysql-container.sh
 
b/.github/workflows/resources/scripts/nightly-build-example/init-mysql-container.sh
index bed2cd69bc2..c463e70c48b 100644
--- 
a/.github/workflows/resources/scripts/nightly-build-example/init-mysql-container.sh
+++ 
b/.github/workflows/resources/scripts/nightly-build-example/init-mysql-container.sh
@@ -14,8 +14,7 @@
 # See the License for the specific language governing permissions and
 # limitations under the License.
 #
-
-mysql -uroot -h127.0.0.1 -p123456 -e 'CREATE DATABASE IF NOT EXISTS 
demo_ds_0;CREATE DATABASE IF NOT EXISTS demo_ds_1;CREATE DATABASE IF NOT EXISTS 
demo_ds_2;'
+mysql -uroot -h127.0.0.1 -p123456 -e 'DROP DATABASE IF EXISTS demo_ds_0;DROP 
DATABASE IF EXISTS demo_ds_1;DROP DATABASE IF EXISTS demo_ds_2;CREATE DATABASE 
demo_ds_0;CREATE DATABASE demo_ds_1;CREATE DATABASE demo_ds_2;'
 mysql -uroot -h127.0.0.1 -p123456 -e 'USE demo_ds_0;CREATE TABLE IF NOT EXISTS 
t_order(order_id BIGINT NOT NULL AUTO_INCREMENT, order_type INT(11), user_id 
INT NOT NULL, address_id BIGINT NOT NULL, status VARCHAR(50), PRIMARY KEY 
(order_id));'
 mysql -uroot -h127.0.0.1 -p123456 -e 'USE demo_ds_0;CREATE TABLE IF NOT EXISTS 
t_order_item(order_item_id BIGINT NOT NULL AUTO_INCREMENT, order_id BIGINT NOT 
NULL, user_id INT NOT NULL, phone VARCHAR(50), status VARCHAR(50), PRIMARY KEY 
(order_item_id));'
 mysql -uroot -h127.0.0.1 -p123456 -e 'USE demo_ds_0;CREATE TABLE IF NOT EXISTS 
t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL, 
PRIMARY KEY (address_id));'

Reply via email to