| | |
| | | /// <returns></returns> |
| | | private string GetCreateTableSql(string tableName) |
| | | { |
| | | var sql = $"CREATE TABLE {tableName} (\r\n ID BIGINT NOT NULL\r\n PRIMARY KEY,\r\n Pump1 REAL NOT NULL,\r\n Pump2 REAL NOT NULL,\r\n CurveQH VARCHAR (255) NOT NULL,\r\n CurveQP VARCHAR (255) NOT NULL,\r\n MaxFlow REAL NOT NULL,\r\n MinFlow REAL NOT NULL,\r\n MaxHead REAL NOT NULL,\r\n MinHead REAL NOT NULL,\r\n AnaStatus BIT NOT NULL\r\n);\r\n"; |
| | | var sql = $"CREATE TABLE {tableName} (\r\n ID BIGINT NOT NULL\r\n PRIMARY KEY,\r\n Pump REAL NOT NULL,\r\n CurveQH VARCHAR (255) NOT NULL,\r\n CurveQP VARCHAR (255) NOT NULL,\r\n MaxFlow REAL NOT NULL,\r\n MinFlow REAL NOT NULL,\r\n MaxHead REAL NOT NULL,\r\n MinHead REAL NOT NULL,\r\n AnaStatus BIT NOT NULL\r\n);\r\n"; |
| | | return sql; |
| | | } |
| | | |