From 3e253c674f3ebe0da414d34751c5c259a378375a Mon Sep 17 00:00:00 2001 From: pansen <pansen626@sina.com> Date: 星期五, 25 一月 2019 20:58:55 +0800 Subject: [PATCH] 添加布控模块功能 --- QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp b/QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp index 14a18d1..f72924a 100644 --- a/QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp +++ b/QiaoJiaSystem/LocalDBTool/SqliteToolkit.hpp @@ -108,7 +108,7 @@ std::string getTableInfosSql() { //uuid,tableName,tableDesc,tableType,bwType,startTime,endTime std::string sql = - "select uuid,tableName,tableType,bwType,startTime,endTime,uploadFlag,cmpThreshold,enabled from " + + "select uuid,tableName,tableType,bwType,startTime,endTime,uploadFlag,cmpThreshold,enabled,create_by from " + g_tableName + " where del_flag = 0"; return sql; } @@ -241,7 +241,8 @@ sql.append("create_time BLOB DEFAULT (datetime('now', 'localtime')),"); sql.append("update_time DATETIME DEFAULT NULL,"); sql.append("create_by varchar(255) DEFAULT NULL,"); - sql.append("del_flag INTEGER DEFAULT 0"); + sql.append("del_flag INTEGER DEFAULT 0,"); + sql.append(" enabled varchar(255) DEFAULT 1"); sql.append(");"); // 浜鸿劯鐗瑰緛琛� sql.append("CREATE TABLE " + g_dbName + "."); -- Gitblit v1.8.0