1234567891011121314151617181920212223242526272829303132 |
- PRAGMA foreign_keys=OFF;
- BEGIN TRANSACTION;
- CREATE TABLE IF NOT EXISTS "mqtt" (
- "enable" INTEGER,
- "servip" TEXT(24),
- "servport" INTEGER,
- "username" TEXT(64),
- "passwd" TEXT(64),
- "timezone" INTEGER,
- "idx" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE
- );
- INSERT INTO mqtt VALUES(1,'119.45.116.112',18883,'6d15dcddfa8c4f34bec38df070ecdbe7','7*pB7DgE^4hp',0,1);
- CREATE TABLE IF NOT EXISTS "tbmqtt" (
- "enable" INTEGER,
- "servip" TEXT(24),
- "servport" INTEGER,
- "clientid" TEXT(64),
- "accesstoken" TEXT(64),
- "username" TEXT(64),
- "passwd" TEXT(64),
- "topic" TEXT(128),
- "timezone" INTEGER,
- "idx" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE
- );
- INSERT INTO tbmqtt VALUES(1,'124.222.45.156',1883,'c1e3bb00-9181-11ee-9972-3dd738949819','XbgTQd0IvVfREDGhh4qy','na','na','na',0,1);
- CREATE TABLE IF NOT EXISTS "sta" (
- "projId" TEXT,
- "mode" INTEGER
- );
- INSERT INTO sta VALUES('6d15dcddfa8c4f34bec38df070ecdbe7', 0);
- COMMIT;
|