This is an automated email from the ASF dual-hosted git repository.
zhonghongsheng 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 b6510c711fb Refactor nightly-generator-init.sh (#24761)
b6510c711fb is described below
commit b6510c711fb1cf39823f9556b505d3ed12ed3bc3
Author: Liang Zhang <[email protected]>
AuthorDate: Wed Mar 22 20:49:54 2023 +0800
Refactor nightly-generator-init.sh (#24761)
---
.github/workflows/resources/sql/nightly-generator-init.sh | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
diff --git a/.github/workflows/resources/sql/nightly-generator-init.sh
b/.github/workflows/resources/sql/nightly-generator-init.sh
index 51e92d3f83b..29764bcec70 100644
--- a/.github/workflows/resources/sql/nightly-generator-init.sh
+++ b/.github/workflows/resources/sql/nightly-generator-init.sh
@@ -16,9 +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_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));'
-mysql -uroot -h127.0.0.1 -p123456 -e 'use demo_ds_2;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_1;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_2;CREATE TABLE IF NOT EXISTS
t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL,
PRIMARY KEY (address_id));'
\ No newline at end of file
+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));'
+mysql -uroot -h127.0.0.1 -p123456 -e 'USE demo_ds_2;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_1;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_2;CREATE TABLE IF NOT EXISTS
t_address (address_id BIGINT NOT NULL, address_name VARCHAR(100) NOT NULL,
PRIMARY KEY (address_id));'
