SQLite format 3@ k  k-æçûöñçìâ‚=„QtablesensorssensorsCREATE TABLE [sensors] ( [sensor_id] [varchar(8)], [sensor_locationid] smallint, [sensor_type] integer, [sensor_status] integer, [sensor_last_update] [varchar(20)], [battery_status] [VARCHAR(10)], CONSTRAINT [sqlite_autoindex_sensors_1] PRIMARY KEY ([sensor_id]))-Aindexsqlite_autoindex_sensors_1sensorsf'tablestatusstatusCREATE TABLE status ( sensor_status integer, status_description varchar(10) )##gtablesensortypessensortypesCREATE TABLE sensortypes ( sensor_type integer primary key, sensor_name varchar(10), sensor_description text)L ‚gtablelocationslocationsCREATE TABLE [locations] ( [location_id] integer PRIMARY KEY, [location_name] text, [area_id] smallint, [location_description] t7>?<7   —å¾—%EMS10AMS10A wireless motion sensor%EDS10ADS10A wireless switch sensor)unknownunknown sensor wwß\3n®}tablearmstatusarmstatus CREATE TABLE [armstatus] ( [arm_status_f'tablestatusstatusCREATE TABLE status ( sensor_status integer, status_description varchar(10) ){!!Atablealarmmodesalarmmodes CREATE TABLE [alarmmodes] ( [alarm_mode_id] integer, [alarm_mode_name] varchar(20))T''‚gtablebatterystatusbatterystatusCREATE TABLE [batterystatus] ( [batterystatus_ID] INTEGER(1), [batterystatus_name] VARCHAR(10), CONSTRAINT [] PRIMARY KEY ([batterystatus_ID]) ON CONFLICT IGNORE)9M'indexsqlite_autoindex_batterystatus_1batterystatus}tablearmstatusarmstatus CREATE TABLE [armstatus] ( [arm_status_id] integer PRIMARY KEY ON CONFLICT IGNORE, [arm_status_name] varchar(20))#--ytablelocationsubtypeslocationsubtypes CREATE TABLE [locationsubtypes] ( [sub_type_id] integer PRIMARY KEY AUTOINCREMENT, [sub_type_name] varchar(20))P ++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) œœBÇÑÑP ++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)#!##‚ tablesensortypessensortypesCREATE TA#!##‚ tablesensortypessensortypesCREATE TABLE [sensortypes] ( [sensor_type] integer PRIMARY KEY, [sensor_name] varchar(10), [sensor_description] text).ctableareasareasCREATE TABLE [areas] ( [area_id] INTEGER(2) NOT NULL ON CONFLICT ABORT, [area_description] TEXT(25))„67ˆCtablesensorssensorsCREATE TABLE [sensors] ( [sensor_id] varchar(8) NOT NULL ON CONFLICT FAIL UNIQUE, [sensor_locationid] smallint CONSTRAINT [locationid] REFERENCES [locations]([location_id]), [sensor_type] integer CONSTRAINT [sensortype] REFERENCES [sensortypes]([sensor_type]) ON DELETE SET DEFAULT, [sensor_status] integer, [sensor_last_update] varchar(20), [battery_status] INTEGER(1) CONSTRAINT [battery_status] REFERENCES [batterystatus]([batterystatus_ID]), CONSTRAINT [sqlite_autoindex_sensors_1] PRIMARY KEY ([sensor_id])) ÞõëÞ unknown alert normal ººéÅÅÅ##gtablesensortyƒ :…ctablelocationsloc…ctablelocationslocationsCREATE TABLE [locations] ( [location_id] integer PRIMARY KEY, [lo-8Aindexsqlite_autoindex_sensors_1sensorsócc†'tabletemp_table_27E74EF9F4E64890AD24B841846B1C72temp_table_27E74EF9F4E64890AD24B841846B1C72CREATE TABLE "temp_table_27E74EF9F4E64890AD24B841846B1C72" ( [location_id] integer PRIMARY K-8Aindexsqlite_autoindex_sensors_1sensors‚;11ƒUtablecurrentalarmstatuscurrentalarmstatus CREATE TABLE [currentalarmstatus] ( [current_mode] INTEGER(1) NOT NULL ON CONFLICT IGNORE CONSTRAINT [current_mode] REFERENCES [alarmmodes]([alarm_mode_id]), [last_update] VARCHAR(20), [method] TEXT, [id] VARCHAR)|<)1ƒ)triggerdisarmed_alarmcurrentalarmstatusCREATE TRIGGER [disarmed_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 0) BEGIN UPDATE locations SET arm_status = 0 WHERE locations.arm_status = 1; END ×÷ìã× unknownroom windowdoor|2)1ƒ)triggerdisarmed_alarmcurrentalarmstatusCREATE TRIGGER [disarmed_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 0) BEGIN UPDATE locations SET arm_status = 0 WHERE locations.arm_status = 1; ENDw3-1ƒtriggerarmed_away_alarmcurrentalarmstatusCREATE TRIGGER [armed_away_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 2) BEGIN UPDATE locations SET arm_status = 1 WHERE locations.arm_status = 0; END‚4-1ƒStriggerarmed_home_alarmcurrentalarmstatusCREATE TRIGGER [armed_home_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 1) BEGIN UPDATE locations SET arm_status = 1 WHERE locations.arm_status = 0 AND locations.sub_type != 2; END êôê CUSTOM DISARMED!ARMED_AWAY armed unarmed ®óäÔɽ® TRIGGERED CUSTOM PANIC!ARMED_AWAY  !ARMED_HOME DISARMED ùùæîƒH/†_tablelocationslocationsCREATE TABLE [locations] ( [location_id] integer PRIMARY KEY, [location_name] text, [area_id] smallint CONSTRAINT [areas] REFERENCES [areas]([area_w3-1ƒtriggerarmed_away_alarmcurrentalarmstatusCREATE TRIGGER [armed_away_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 2) BEGIN UPDATE locations SET arm_status = 1 WHERE locations.arm_status = 0; ‚5/1ƒItriggerNO_INSERT_ALLOWEDcurrentalarmstatusCREATE TRIGGER [NO_INSERT_ALLOWED] BEFORE INSERT ON [currentalarmstatus] WHEN ((SELECT Count(*) FROM currentalarmstatus) > 0) BEGIN SELECT RAISE(ABORT, 'No new records allowed on this table, updates only!'); END‚611ƒWtriggerNO_DELETES_ALLOWEDcurrentalarmstatusCREATE TRIGGER [NO_DELETES_ALLOWED] BEFORE DELETE ON [currentalarmstatus] WHEN ((SELECT Count(*) FROM currentalarmstatus) <= 1) BEGIN SELECT RAISE(ABORT, 'No record deletions allowed on this table, updates only!' êê )ÅD@}tablearmstatusarmstatus CREATE TABLE [armstatus] ( [arm_status_id] integer PRIMARY KEY ON CONFLICT IGNORE, [arm_status_name] varchar(20))w-1ƒtriggerarmed_away_alarmcurrentalarmstatusCREATE Tw-1ƒtriggerarmed_away_alarmcurrentalarmstatusCREATE TRIGGER [armed_away_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 2) BEGIN UPDATE locations SET arm_status = 1 WHERE locations.arm_status = 0; END‚-1ƒStriggerarmed_home_alarmcurrentalarmstatusCREATE TRIGGER [armed_home_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 1) BEGIN UPDATE locations SET arm_status = 1 WHERE locations.arm_status = 0 AND locations.sub_type != 2; ENDT''‚gtablebatterystatusbatterystatusCREATE TABLE [batterystatus] ( [batterystatus_ID] INTEGER(1), [batterystatus_name] VARCHAR(10), CONSTRAINT [] PRIMARY KEY ([batterystatus_ID-locationsubtypes öâíââ normal low null òíí÷òü  ððêêê0\"11‚ctablecurrentalarmstatuscurrental‚&/1ƒItriggerNO_INSERT_ALLOWEDcurrentalarmstatusCREATE TRIGGER [NO_INSERT_ALLOWED] BEFORE INSERT ON [currentalarmstatus] WHEN ((SELECT Count(*) FROM currenw=-1ƒtriggerar|<)1ƒ)triggerdisarmed_alarmcurrentalarmstatusCREATE TRIGGER [disarmed_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 0) BEGIN UPDATE locations SET arm_status = 0 WHERE locations.arm_status = 1; ENDw=-1ƒtriggerarmed_away_alarmcurrentalarmstatusCREATE TRIGGER [armed_away_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 2) BEGIN UPDATE locations SET arm_status = 1 WHERE locations.arm_status = 0; END‚>-1ƒStriggerarmed_home_alarmcurrentalarmstatusCREATE TRIGGER [armed_home_alarm] AFTER UPDATE ON [currentalarmstatus] WHEN (NEW.current_mode = 1) BEGIN UPDATE locations SET arm_status = 1 WHERE locations.arm_status = 0 AND locations.sub_type != 2; END gæg³â‹„ ,ˆtablesensorssensorsCREATE TABLE [sensors] ( [sensor_id] varchar(8), [sensor_locationid„67ˆCtablesensorssensorsCREATE TABLE [sensors] ( [sensor_id] varchar(8) NOT NULL ON CONFLICT FAIL UNIQUE, [sensor_locationid] smallint CONSTRAINT [locationid] REFERENCES [locations]([location_id]), [sensor_type] integer ‚|A…GtablelocationslocationsCREATE TABLE [locations] ( [location_id] integer PRIMARY KEY, [location_name] text, [area_id] smallint, [location_description] text, [sub_type] integer CONSTRAINT [sub_type] REFERENCES [locationsubtypes]([sub_type_id]) ON DELETE SET DEFAULT, [arm_status] integer CONSTRAINT [armstatus] REFERENCES [armstatus]([arm_status_id]))‚@11ƒWtriggerNO_DELETES_ALLOWEDcurrentalarmstatusCREATE TRIGGER [NO_DELETES_ALLOWED] BEFORE DELETE ON [currentalarmstatus] WHEN ((SELECT Count(*) FROM currentalarmstatus) <= 1) BEGIN SELECT RAISE(ABORT, 'No record deletions allowed on this table, updates only!'); END îî‚?/1ƒItriggerNO_INSERT_ALLOWEDcurrentalarmstatusCREATE TRIGGER [NO_INSERT_ALLOWED] BEFORE INSERT ON [currentalarmstatus] WHEN ((SELECT Count(*) FROM currentalarmstatus) > 0) BEGIN SELECT RAISE(ABORT, 'No new records allowed on this table, updates only!'); END ôô unknown ‚Ιunknownunknown49 9 master_bathroom_windowmaster bathroom window1 7 7 master_bedroom_windowmaster bedroom window €èµ€39 9 master_bathroom_windowmaster bathroom window17 7 master_bedroom_windowmaster bedroom windowunknownunknown