You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2025/12/28 08:09:36 UTC

(shardingsphere) branch master updated: Unify example DB init on example (#37558)

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 <zh...@apache.org>
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));'