-- Export generated by tools/export_sql.php -- App: Checklists -- Source DB: Checklists.db -- Generated: 2026-03-31T14:47:55+00:00 CREATE TABLE app_meta (table_name TEXT PRIMARY KEY, schema_hash TEXT NOT NULL); CREATE TABLE IF NOT EXISTS "Kiting" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_o7edge INTEGER, cl_n7edge INTEGER, cl_9edge INTEGER, cl_csock INTEGER, cl_crocs INTEGER, cl_drill1 INTEGER, cl_drill2 INTEGER, cl_ozito INTEGER, cl_drone INTEGER, cl_bar INTEGER, cl_goggles INTEGER, cl_gopro INTEGER, cl_helmet INTEGER, cl_insta INTEGER, cl_360mounts INTEGER, cl_hose INTEGER, cl_kpump INTEGER, cl_kpumpc INTEGER, cl_tpump INTEGER, cl_ptube INTEGER, cl_walker INTEGER, cl_water INTEGER, cl_wipes INTEGER, comment TEXT, ta_comment TEXT, cl_comment TEXT, cl_at INTEGER, cl_kj INTEGER); CREATE TABLE sqlite_sequence(name,seq); CREATE TABLE IF NOT EXISTS "Shopping" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_avo INTEGER, cl_batt INTEGER, cl_berry INTEGER, cl_bis INTEGER, cl_broc INTEGER, cl_caps INTEGER, cl_cd INTEGER, cl_coff INTEGER, cl_crack INTEGER, cl_crumpet INTEGER, cl_dd INTEGER, cl_meat INTEGER, cl_milk INTEGER, cl_oil INTEGER, cl_pr INTEGER, cl_ps INTEGER, cl_rav INTEGER, cl_rice INTEGER, cl_corn INTEGER, cl_wrap INTEGER, cl_wipes INTEGER, comment TEXT, cl_citr INTEGER, cl_fveg INTEGER, cl_gar INTEGER, cl_hon INTEGER, cl_spp INTEGER, cl_sgl INTEGER, cl_scorn INTEGER, cl_tea INTEGER, cl_tpp INTEGER, cl_tps INTEGER, cl_vin INTEGER, cl_bana INTEGER, cl_carr INTEGER, cl_gts INTEGER, cl_mush INTEGER, cl_roll INTEGER, cl_spr INTEGER, cl_yogh INTEGER, cl_po INTEGER, cl_bin INTEGER, cl_eggs INTEGER, ta_comment TEXT, cl_comment TEXT); CREATE TABLE IF NOT EXISTS "Camping" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_gas INTEGER, cl_cooker INTEGER, cl_coff INTEGER, cl_food INTEGER, cl_water INTEGER, comment TEXT); CREATE TABLE IF NOT EXISTS "Leaving" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_car INTEGER, cl_unit INTEGER, comment TEXT, cl_sdr INTEGER, cl_o7edge INTEGER, cl_n7edge INTEGER, cl_9edge INTEGER, cl_csock INTEGER, cl_pbags INTEGER, cl_crocs INTEGER, cl_drill1 INTEGER, cl_drill2 INTEGER, cl_ozito INTEGER, cl_drone INTEGER, cl_ipad INTEGER, cl_bar INTEGER, cl_goggles INTEGER, cl_gopro INTEGER, cl_helmet INTEGER, cl_insta INTEGER, cl_360mounts INTEGER, cl_hose INTEGER, cl_kpump INTEGER, cl_kpumpc INTEGER, cl_tpump INTEGER, cl_ptube INTEGER, cl_usbc INTEGER, cl_ssd INTEGER, cl_walker INTEGER, cl_water INTEGER, cl_weq INTEGER, cl_wipes INTEGER); CREATE TABLE IF NOT EXISTS "Rebuild_Server" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_psm INTEGER, cl_sss INTEGER, cl_vse INTEGER, cl_cur INTEGER, cl_pds INTEGER, cl_scl INTEGER, cl_raa INTEGER, cl_dut INTEGER, cl_vcm INTEGER, cl_rme INTEGER, cl_etp INTEGER, cl_tmb INTEGER, cl_dcs INTEGER, cl_cns INTEGER, cl_scs INTEGER, comment TEXT, ta_comment TEXT, cl_comment TEXT); CREATE TABLE IF NOT EXISTS "TestChecklist" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_check1 INTEGER, cl_check2 INTEGER, cl_check3 INTEGER, comment TEXT, ta_comment TEXT, cl_comment TEXT); CREATE TABLE IF NOT EXISTS "Leaving-Car" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_gjc INTEGER, cl_fuf INTEGER, cl_hut INTEGER, ta_comment TEXT, cl_tjc INTEGER, cl_cowb INTEGER, cl_tbo INTEGER, cl_comment TEXT, cl_cdg INTEGER, cl_ds INTEGER, cl_csg INTEGER, cl_cw INTEGER, cl_mcc INTEGER, cl_bcd INTEGER, cl_pb INTEGER); CREATE TABLE IF NOT EXISTS "Leaving-Camping" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_gas INTEGER, cl_cooker INTEGER, cl_coff INTEGER, cl_food INTEGER, cl_water INTEGER, cl_weq INTEGER, ta_comment TEXT, cl_comment TEXT, cl_extc INTEGER, cl_rdb INTEGER, cl_st INTEGER, cl_fs INTEGER); CREATE TABLE IF NOT EXISTS "Leaving-Kiting" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_o7edge INTEGER, cl_n7edge INTEGER, cl_9edge INTEGER, cl_crocs INTEGER, cl_drill1 INTEGER, cl_drill2 INTEGER, cl_bar INTEGER, cl_bug INTEGER, cl_bra INTEGER, cl_goggles INTEGER, cl_helmet INTEGER, cl_hose INTEGER, cl_kpump INTEGER, cl_tpump INTEGER, ta_comment TEXT, cl_comment TEXT, cl_tyre INTEGER, cl_krb INTEGER); CREATE TABLE IF NOT EXISTS "Leaving-Unit" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_hwo INTEGER, cl_dwl INTEGER, cl_wp INTEGER, cl_tao INTEGER, ta_comment TEXT, cl_comment TEXT, cl_dww INTEGER, cl_blo INTEGER, cl_so INTEGER); CREATE TABLE IF NOT EXISTS "Leaving-Other" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_sdr INTEGER, cl_bah INTEGER, cl_bbp INTEGER, cl_csock INTEGER, cl_pbags INTEGER, cl_drone INTEGER, cl_ht INTEGER, cl_bh INTEGER, cl_hck INTEGER, cl_nht INTEGER, cl_cbo INTEGER, cl_ipad INTEGER, cl_gopro INTEGER, cl_insta INTEGER, cl_mega INTEGER, cl_mome INTEGER, cl_sc INTEGER, cl_toi INTEGER, cl_usbc INTEGER, cl_ssd INTEGER, cl_ueb INTEGER, cl_walker INTEGER, cl_wipes INTEGER, ta_comment TEXT, cl_sdc INTEGER, cl_slr INTEGER, cl_gmks INTEGER, cl_clo INTEGER, cl_momc INTEGER, cl_comment TEXT, cl_wfw INTEGER, cl_fw INTEGER, cl_pillow INTEGER, cl_mz INTEGER, cl_fhg INTEGER, cl_tabs INTEGER, cl_cgt INTEGER, cl_cw INTEGER, cl_twb INTEGER, cl_wb INTEGER, cl_wbs INTEGER, cl_bnt INTEGER, cl_spb INTEGER, cl_ INTEGER, cl_st INTEGER, cl_bb INTEGER, cl_wcd INTEGER, cl_tnd INTEGER, cl_eb INTEGER, cl_ckc INTEGER); CREATE TABLE IF NOT EXISTS "Leaving-Wheely-Stuff" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_sdr INTEGER, cl_bah INTEGER, cl_ft INTEGER, cl_wfw [label,=WheelChair&Front Wheel], cl_sdc INTEGER, cl_comment TEXT); CREATE TABLE IF NOT EXISTS "Leaving-Bike" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_bik INTEGER, cl_hel INTEGER, cl_belt INTEGER, cl_ebs INTEGER, cl_bb INTEGER, cl_bc INTEGER, cl_bl INTEGER, cl_ft INTEGER, cl_tcb INTEGER, cl_db INTEGER, cl_comment TEXT); CREATE TABLE IF NOT EXISTS "Leaving-Wheechair" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_sdr INTEGER, cl_wc, cl_fw, cl_sd INTEGER, cl_sdc INTEGER, cl_ff INTEGER, cl_walker INTEGER, cl_comment TEXT, cl_sc INTEGER); CREATE TABLE IF NOT EXISTS "Leaving-Technology" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_slr INTEGER, cl_drone INTEGER, cl_mac INTEGER, cl_lcc INTEGER, cl_ipad INTEGER, cl_gopro INTEGER, cl_insta INTEGER, cl_mega INTEGER, cl_mome INTEGER, cl_usbc INTEGER, cl_ssd INTEGER, cl_hcc INTEGER, cl_ibc INTEGER, cl_chp INTEGER, cl_aw INTEGER, cl_awc INTEGER, cl_ueb INTEGER, cl_comment TEXT); CREATE TABLE IF NOT EXISTS "Leaving-Bathroom" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_toi INTEGER, cl_csock INTEGER, cl_pbags INTEGER, cl_hck INTEGER, cl_nht INTEGER, cl_cbo INTEGER, cl_npd INTEGER, cl_cd INTEGER, cl_bw INTEGER, cl_hbt INTEGER, cl_tb INTEGER, cl_tp INTEGER, cl_comment TEXT, cl_ptubes INTEGER, cl_ht INTEGER); CREATE TABLE IF NOT EXISTS "Leaving-DisabilityEquipment" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_sdr INTEGER, cl_wc, cl_fw, cl_sd INTEGER, cl_sdc INTEGER, cl_ff INTEGER, cl_walker INTEGER, cl_sc INTEGER, cl_comment TEXT); CREATE TABLE IF NOT EXISTS "Leaving-Clothes" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_uug INTEGER, cl_ts INTEGER, cl_sh INTEGER, cl_gts INTEGER, cl_hs INTEGER, cl_10j INTEGER, cl_10s INTEGER, cl_10t INTEGER, cl_2tp INTEGER, cl_2lp INTEGER, cl_as INTEGER, cl_tt INTEGER, cl_sb INTEGER, cl_er INTEGER, cl_gc INTEGER, cl_belt INTEGER, cl_comment TEXT, cl_cb INTEGER, cl_cc INTEGER, cl_cgt INTEGER); -- DATA: Camping INSERT INTO Camping VALUES(1,'2026-02-09 08:20:04',0,0,0,0,0,''); -- DATA: Kiting INSERT INTO Kiting VALUES(1,'2026-02-09 08:20:04',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,'before rebuild v4.14',NULL,NULL,NULL,NULL); -- DATA: Leaving INSERT INTO Leaving VALUES(1,'2026-02-09 08:20:04',1,1,'',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0); -- DATA: Leaving-Bathroom INSERT INTO "Leaving-Bathroom" VALUES(1,'2026-03-24 01:53:09',1,1,1,1,1,1,1,1,1,1,1,1,'tooth brush charger in clippers bag',1,1); -- DATA: Leaving-Bike INSERT INTO "Leaving-Bike" VALUES(1,'2026-03-24 00:01:11',1,1,1,1,1,1,1,1,1,1,'not taking dilligaf box'); -- DATA: Leaving-Camping INSERT INTO "Leaving-Camping" VALUES(1,'2026-03-21 13:15:54',1,1,1,1,1,1,NULL,'',1,1,1,1); -- DATA: Leaving-Car INSERT INTO "Leaving-Car" VALUES(1,'2026-03-21 13:15:54',0,1,1,NULL,1,1,1,'',1,1,1,1,1,1,1); -- DATA: Leaving-Clothes INSERT INTO "Leaving-Clothes" VALUES(1,'2026-03-24 02:44:03',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,replace(replace('Got 7 pairs Jocks\r\nTshirts-4 in basket and the one I''m wearing makes 5','\r',char(13)),'\n',char(10)),1,1,1); -- DATA: Leaving-DisabilityEquipment INSERT INTO "Leaving-DisabilityEquipment" VALUES(1,'2026-03-24 02:44:03',1,0,1,1,1,1,0,0,''); -- DATA: Leaving-Kiting INSERT INTO "Leaving-Kiting" VALUES(1,'2026-03-21 13:15:54',0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,'',0,0); -- DATA: Leaving-Other INSERT INTO "Leaving-Other" VALUES(1,'2026-03-21 13:15:54',0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,NULL,0,0,1,0,0,'',NULL,0,1,1,1,1,0,1,1,1,1,1,1,NULL,1,1,1,1,1,1); -- DATA: Leaving-Technology INSERT INTO "Leaving-Technology" VALUES(1,'2026-03-24 00:01:11',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,'couldnt find slr charger or tripod'); -- DATA: Leaving-Unit INSERT INTO "Leaving-Unit" VALUES(1,'2026-03-21 13:15:54',1,1,1,1,NULL,replace(replace('Marcus gonna keep weeds under control\r\nTony will turn hot water off after cleaners','\r',char(13)),'\n',char(10)),1,1,1); -- DATA: Leaving-Wheechair INSERT INTO "Leaving-Wheechair" VALUES(1,'2026-03-24 00:01:11',0,0,0,0,0,0,0,'0',NULL); -- DATA: Leaving-Wheely-Stuff INSERT INTO "Leaving-Wheely-Stuff" VALUES(1,'2026-03-22 08:00:56',0,1,1,0,0,'0'); -- DATA: Rebuild_Server INSERT INTO Rebuild_Server VALUES(1,'2026-02-09 08:20:04',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',NULL,'0'); -- DATA: Shopping INSERT INTO Shopping VALUES(1,'2026-02-09 08:20:04',0,0,0,0,0,0,0,1,1,1,1,0,0,0,0,0,0,0,0,0,0,'Add ham & cheese',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL); -- DATA: TestChecklist INSERT INTO TestChecklist VALUES(1,'2026-02-09 08:20:04',0,0,0,'',NULL,NULL); -- DATA: app_meta INSERT INTO app_meta VALUES('Kiting','1b26b9af718277e505d6a0dcd45b85ef7e621742'); INSERT INTO app_meta VALUES('Shopping','16d9b5d22b5206e6d6eb64a39f6cec207ce1ca61'); INSERT INTO app_meta VALUES('Camping','648d2b7e134fd778d3f5f3cae2c2e74ff52e8fce'); INSERT INTO app_meta VALUES('Leaving','63ae8f315befabd49c6220a0a82db291a96bd4ed'); INSERT INTO app_meta VALUES('Rebuild_Server','88afac94c1e362f03ac1118b41770f3c1f6e716d'); INSERT INTO app_meta VALUES('TestChecklist','77ccd50f122776471056074a17ceb1a6b0ea29b1'); INSERT INTO app_meta VALUES('Leaving-Car','160c0ddc31483052279ded191f8f716864c87ea9'); INSERT INTO app_meta VALUES('Leaving-Camping','4a90780ebed9b73e411bd278f662157a3699b21f'); INSERT INTO app_meta VALUES('Leaving-Kiting','15e4c3fe739535295ff0a7fcd3ad803cdc088af3'); INSERT INTO app_meta VALUES('Leaving-Unit','98e00a0d4d51fe018eff83a11eacdb008e6eaaeb'); INSERT INTO app_meta VALUES('Leaving-Other','8dda308cfce4f3d9c8bc2f14f5ddb41a4406a3d3'); INSERT INTO app_meta VALUES('Leaving-Wheely-Stuff','7143d2b2c7359cb945307fd9f2931b0c1c5cce43'); INSERT INTO app_meta VALUES('Leaving-Bike','4b569001b70556c2dadce9ab5ddab872ad183e91'); INSERT INTO app_meta VALUES('Leaving-Wheechair','633757e06d873d23bb398a469a263435c4621299'); INSERT INTO app_meta VALUES('Leaving-Technology','69a8b2a30bd689fdc2acb5df507874b80661fd33'); INSERT INTO app_meta VALUES('Leaving-Bathroom','8f9bc1f339c89709074befad5de3b6b6892e96bb'); INSERT INTO app_meta VALUES('Leaving-DisabilityEquipment','d39061aecd6ac106b206a020872e3e4ca1e769ac'); INSERT INTO app_meta VALUES('Leaving-Clothes','b7d566da9d05da13b9f69fe93e77f27338672a2b');