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 434fb7cac90 Create demo_ds_0 tables for example jobs (#37557)
434fb7cac90 is described below
commit 434fb7cac90e8820c4a676e0291806fdbcef9160
Author: Liang Zhang <[email protected]>
AuthorDate: Sun Dec 28 10:51:53 2025 +0800
Create demo_ds_0 tables for example jobs (#37557)
---
.../resources/scripts/nightly-build-example/init-mysql-container.sh | 3 +++
1 file changed, 3 insertions(+)
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 29764bcec70..bed2cd69bc2 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
@@ -16,6 +16,9 @@
#
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 '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));'
mysql -uroot -h127.0.0.1 -p123456 -e 'USE demo_ds_1;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_2;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_1;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));'
