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));'