12345678910111213141516171819202122232425262728293031 |
- 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,'test.anduwe.com',1883,'13f5f8ad2fe545e5bd5549ae081d5f22','123456',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,'2ec56280-82c5-11ee-9972-3dd738949819','3xUV56FrER6OE3f1axzp','na','na','na',0,1);
- CREATE TABLE IF NOT EXISTS "sta" (
- "projId" TEXT
- );
- INSERT INTO sta VALUES('13f5f8ad2fe545e5bd5549ae081d5f22');
- COMMIT;
|