| | |
| | | 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; |
| | | } |
| | |
| | | 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 + "."); |