From ce8955cf3887159195d40af391a1bc7aa1d50d3c Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期六, 01 八月 2020 14:10:58 +0800
Subject: [PATCH] 设置主键自动增长
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index 42dc5aa..0fbe909 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -1056,7 +1056,7 @@
public static void createDev_Restart_PlanTable(MysqlConnPool pool, boolean recreate) {
String sql_str_del = " DROP TABLE IF EXISTS "+Sql_Mysql.Dev_Restart_Plan_Table;
String sql_str = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dev_Restart_Plan_Table + " (" +
- " num bigint(20) NOT NULL," +
+ " num bigint(20) NOT NULL AUTO_INCREMENT," +
" dev_id int(11) NOT NULL DEFAULT '0' COMMENT '设备id'," +
" restart_starttime datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '重启开始时间'," +
" restart_cycle int(11) NOT NULL DEFAULT '1' COMMENT '重启周期'," +
--
Gitblit v1.9.1