-- Export generated by tools/export_sql.php
-- App: TBD
-- Source DB: TBD.db
-- Generated: 2026-03-31T14:48:42+00:00

CREATE TABLE app_meta (table_name TEXT PRIMARY KEY, schema_hash TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS "names" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE, comment TEXT);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE IF NOT EXISTS "jobs" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE, name_id INTEGER, is_priority INTEGER, is_finished INTEGER, comment TEXT, ta_comment TEXT, FOREIGN KEY(name_id) REFERENCES names(id));


-- DATA: app_meta
INSERT INTO app_meta VALUES('names','cd17019c721387cc8411285b43fc79174524f415');
INSERT INTO app_meta VALUES('jobs','c4c2804f603b4e32646f993b776d6c19a9732f41');

-- DATA: jobs
INSERT INTO jobs VALUES(1,'2025-12-26 06:31:47','Get Rainwater',2,0,0,NULL,NULL);
INSERT INTO jobs VALUES(3,'2025-12-26 06:41:19','Ring Sportsmed',4,1,1,'Tell them that the nerve ablation didnt really work, i thought it did a little bit at first and now it just seems to be going backwards. Organise to have the shoulder replacement done in July. We''ll have to meet with the surgeon to plan everything because my gag reflex and coughing is going to be an issue especially in that first week and im going to need a lot more help and probably somewhere to go for rehab. I wnato have everything organised before I go away at end March',NULL);
INSERT INTO jobs VALUES(5,'2026-01-08 21:49:08','book in car',1,1,1,'book in car to get air con fixed','drop in car tues 24th');
INSERT INTO jobs VALUES(6,'2026-01-08 21:50:38','add both http and https to ipad browser',1,1,1,NULL,NULL);
INSERT INTO jobs VALUES(7,'2026-01-12 04:29:03','uridomes and bags',1,1,1,'get more',NULL);
INSERT INTO jobs VALUES(9,'2026-01-12 08:52:50','replace skillet',1,0,1,'with a grrenpan one',NULL);
INSERT INTO jobs VALUES(11,'2026-01-19 21:59:38','Play ih8 coming cooking invoice',1,1,1,NULL,NULL);
INSERT INTO jobs VALUES(13,'2026-01-21 23:04:57','RAA',1,0,1,'does or can the contents cover public liability, i ddnt recieve the quote for the car insurance',NULL);
INSERT INTO jobs VALUES(14,'2026-01-21 23:05:26','get hair cut',1,0,1,NULL,NULL);
INSERT INTO jobs VALUES(18,'2026-01-28 01:42:39','NDIS Plan',1,1,1,'tell alice and karlie that i got a letter saying my plan will be rolled over. we have to get them to put the cooking back in and karlie have you chased up anyone yet sort out a more accessible van for me? - karlie/me/Alice/Sandra in correspondence',NULL);
INSERT INTO jobs VALUES(22,'2026-02-01 06:25:44','Additional Driver Info',1,0,1,'get fom Marcus',NULL);
INSERT INTO jobs VALUES(24,'2026-02-03 03:18:19','Giant zip ties',1,0,0,'Put together',NULL);
INSERT INTO jobs VALUES(28,'2026-02-06 01:41:30','Download latest expeditionary force audiobook',1,0,1,NULL,NULL);
INSERT INTO jobs VALUES(31,'2026-02-22 00:37:27','Download Decayed Legacy',1,0,1,NULL,NULL);
INSERT INTO jobs VALUES(32,'2026-02-25 07:40:10','pay aus post thing',1,0,1,'I think its the box renewal',NULL);
INSERT INTO jobs VALUES(33,'2026-03-02 00:04:38','Script',1,1,1,'Pick it up',NULL);
INSERT INTO jobs VALUES(34,'2026-03-02 00:05:39','Trading report',1,0,1,'Email to Sandra',NULL);
INSERT INTO jobs VALUES(36,'2026-03-04 10:56:34','Complete Anesthestist questionnaire and prepare for meeting',1,1,1,NULL,replace(replace('returned 13/3\r\nStill have to do a dry run with the online meeting software','\r',char(13)),'\n',char(10)));
INSERT INTO jobs VALUES(39,'2026-03-09 12:16:34','Chase up b Brad Williams',1,1,1,NULL,'emailed reception 12/3/26');
INSERT INTO jobs VALUES(42,'2026-03-12 23:14:37','make appt to see jordon',1,1,1,NULL,'at xtracare when i go over to get grant');
INSERT INTO jobs VALUES(43,'2026-03-13 02:27:45','Add to shopping checklist',1,0,1,NULL,'Eggs');
INSERT INTO jobs VALUES(44,'2026-03-13 09:01:42','Camera Club',1,0,1,NULL,'work out how to post yachts pic');
INSERT INTO jobs VALUES(45,'2026-03-13 23:07:16','add functionality to config,ini to display text on the page',1,0,0,NULL,NULL);
INSERT INTO jobs VALUES(46,'2026-03-16 06:49:39','show totals',1,0,0,NULL,'add functionality to specify tables to apply to when there is more than 1');
INSERT INTO jobs VALUES(47,'2026-03-16 22:11:26','Sad chiro bill of 38 to trust expenses',1,0,1,NULL,'With storm on 16/3');
INSERT INTO jobs VALUES(48,'2026-03-18 23:06:18','txt marcus',1,0,1,NULL,'ask him to come up sometime next week and help me pack/load all my shit');
INSERT INTO jobs VALUES(49,'2026-03-20 00:31:21','spasticity referal',1,0,1,NULL,'contact john about completing the spasticity referal lucy sent, i want to get something to reduce spacsticity so it doesnt go off and compromise mmy shoulder, suggest last week in may cause ill be in queensland and my op is in june');
INSERT INTO jobs VALUES(50,'2026-03-20 00:32:31','Pay anasthetic doctors invoice',1,0,1,NULL,replace(replace('see email dated 18th march\r\nThe receipt reference for your payment is 200410596.\r\n','\r',char(13)),'\n',char(10)));
INSERT INTO jobs VALUES(52,'2026-03-21 13:45:55','As wheelchair smart drive and chargers and bike charger r',1,1,1,NULL,'To checklists');
INSERT INTO jobs VALUES(53,'2026-03-22 05:55:09','Files from server',1,0,1,NULL,'Give Josie init.el to check from server, copy Checklists/configuration.sh from server back to Mac');
INSERT INTO jobs VALUES(54,'2026-03-24 11:57:12','Download Phantom Deadfall',1,0,0,NULL,NULL);
INSERT INTO jobs VALUES(62,'2026-03-31 04:35:43','sign form for williams OT',1,1,0,NULL,replace(replace('once newplan dates known\r\nsee email dated 30th March','\r',char(13)),'\n',char(10)));

-- DATA: names
INSERT INTO names VALUES(1,'2025-12-26 06:29:09','Rob',NULL);
INSERT INTO names VALUES(2,'2025-12-26 06:29:12','Tony',NULL);
INSERT INTO names VALUES(3,'2025-12-26 06:29:16','Lisa',NULL);
INSERT INTO names VALUES(4,'2025-12-26 06:29:23','Sandra',NULL);
INSERT INTO names VALUES(5,'2025-12-26 06:30:02','Marcus Pruis','NDIS suport worker');