From 9d75a4a6ccff153a40c7e5d8024c96b8ae5f850b Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 02 九月 2024 11:02:08 +0800 Subject: [PATCH] 1 --- sql/wgcloud-MySQL.sql | 12 +++++++++++- 1 files changed, 11 insertions(+), 1 deletions(-) diff --git a/sql/wgcloud-MySQL.sql b/sql/wgcloud-MySQL.sql index cf75ead..24e2f97 100644 --- a/sql/wgcloud-MySQL.sql +++ b/sql/wgcloud-MySQL.sql @@ -1,3 +1,12 @@ +-- DROP DATABASE IF EXISTS `wgcloud`; + +CREATE DATABASE IF NOT EXISTS `wgcloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; + +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +USE `wgcloud`; + /* Navicat MySQL Data Transfer @@ -76,7 +85,8 @@ `PASSWD` varchar(50) DEFAULT NULL, `IP` char(20) DEFAULT NULL, `PORT` char(10) DEFAULT NULL, - `CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, +-- `CREATE_TIME` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, + `CREATE_TIME` timestamp DEFAULT CURRENT_TIMESTAMP, `DBNAME` char(50) DEFAULT NULL, `DB_STATE` char(1) DEFAULT NULL, `ALIAS_NAME` varchar(50) DEFAULT NULL, -- Gitblit v1.9.3