sta/cfg/project_czhaolilai.sql

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;