db.sql

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE commands (
	id INTEGER NOT NULL,
	device_id INTEGER,
	target_name VARCHAR(256),
	function_name VARCHAR(256),
	ir_command VARCHAR(512),
	PRIMARY KEY (id),
	FOREIGN KEY(device_id) REFERENCES devices (id)
);
INSERT INTO commands VALUES(1,1,'テレビ','電源ボタン','2600320172390f0e0e2b0f0d0f0e0f0d0f0e0f0e0e0e0f0e0e0e0f0e0f0d0f0e0f2a0f0e0e0e0f0e0e0e0f0e0f0d0f0e0f0e0e0e0f2a0f0e0e0e0f0e0f0d0f0e0f0e0e0e0f0e0e2b0f0d0f2a0f2a0f2b0e2b0f0d0f0e0f2a0f0e0e2b0e2b0f2a0f2a0f0e0e2b0e00098c72390f0e0e2b0f0d0f0e0f0d0f0e0f0e0e0e0f0e0e0e0f0e0f0d0f0e0f2a0f0e0e0e0f0e0e0e0f0e0f0d0f0e0f0e0e0e0f2a0f0e0f0d0f0e0f0d0f0e0f0e0e0e0f0e0e2b0f0d0f2a0f2b0e2b0e2b0f0d0f0e0f2a0f0e0e2b0f2a0f2a0f2a0f0e0e2b0f00098b72390f0e0e2b0f0d0f0e0f0d0f0e0f0e0e0e0f0e0f0d0f0e0f0d0f0e0f2a0f0e0e0e0f0e0f0d0f0e0f0e0e0e0f0e0e0e0f2a0f0e0f0d0f0e0f0d0f0e0f0e0e0e0f0e0e2b0f0d0f2a0f2b0e2b0f2a0f0d0f0e0f2a0f0e0e2b0f2a0f2a0f2a0f0e0e2b0f000d05000000000000');
INSERT INTO commands VALUES(2,1,'電灯','電源ボタン','260058004320b72132103310120f12101210101211111110331012101110121012100f13111033101210330f1210121012100f12121012101210120f1210121012100f13120f12101210330f12103310330f10123310321011000d05');
CREATE TABLE devices (
	id INTEGER NOT NULL,
	name VARCHAR(256),
	devtype INTEGER,
	host VARCHAR(256),
	mac_address VARCHAR(256),
	PRIMARY KEY (id)
);
INSERT INTO devices VALUES(1,'リビング',10039,'192.168.10.61','69c96f34ea34');
COMMIT;