sqllite CREATE

发布于 作者:
if (!ExixtsTable("PointValue"))
            {
                ExecuteSql(@"CREATE TABLE PointValue(
                      Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
                      PointAddress TEXT NOT NULL,
                      Time TEXT NOT NULL,
                      Value NUMERIC NOT NULL
                    )");

                ExecuteSql("CREATE INDEX PointAddress ON PointValue(PointAddress COLLATE BINARY ASC)");
                ExecuteSql("CREATE INDEX Time ON PointValue(Time COLLATE BINARY ASC)");
            }

https://www.cnblogs.com/lrzy/p/18096299