-- Export generated by tools/export_sql.php
-- App: Contents
-- Source DB: Contents.db
-- Generated: 2026-03-31T14:47:54+00:00

CREATE TABLE app_meta (table_name TEXT PRIMARY KEY, schema_hash TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS "rooms" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE, comment TEXT, ta_comment TEXT);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE IF NOT EXISTS "items" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, room_id INTEGER, name TEXT UNIQUE, amount REAL, comment TEXT, FOREIGN KEY(room_id) REFERENCES rooms(id));


-- DATA: app_meta
INSERT INTO app_meta VALUES('rooms','48a0dc33896184486e73812d6970d2ffccef1c42');
INSERT INTO app_meta VALUES('items','a5f58129064e05ec209f149aaac2d915eada2204');

-- DATA: items
INSERT INTO items VALUES(1,'2025-11-28 01:40:31',1,'Old Kites',3000.0,NULL);
INSERT INTO items VALUES(2,'2025-11-28 03:07:40',1,'WebberQ',500.0,'???????????');
INSERT INTO items VALUES(3,'2025-11-28 03:12:25',2,'clothes',2000.0,NULL);
INSERT INTO items VALUES(4,'2025-11-28 03:12:39',2,'TV',1000.0,NULL);
INSERT INTO items VALUES(5,'2025-11-28 03:13:25',2,'Lift Bed',2000.0,NULL);
INSERT INTO items VALUES(6,'2025-11-28 03:13:43',2,'Spare bed',500.0,NULL);
INSERT INTO items VALUES(7,'2025-11-28 03:15:06',3,'Wheelchair/Bike',10000.0,NULL);
INSERT INTO items VALUES(8,'2025-11-28 03:15:28',3,'Cupboard',500.0,NULL);
INSERT INTO items VALUES(9,'2025-11-28 03:16:18',3,'Goog kites',5000.0,NULL);
INSERT INTO items VALUES(10,'2025-11-28 03:17:25',3,'GT Kite Buggy',4000.0,NULL);
INSERT INTO items VALUES(11,'2025-11-28 03:17:49',3,'Steam mop',500.0,NULL);
INSERT INTO items VALUES(12,'2025-11-28 03:18:54',3,'Wash machine',1200.0,'NDIS');
INSERT INTO items VALUES(13,'2025-11-28 03:20:01',3,'Peter Lyn Kite Buggy',500.0,NULL);
INSERT INTO items VALUES(14,'2025-11-28 03:21:34',3,'Trailer (Wheelchair/Bike)',500.0,NULL);
INSERT INTO items VALUES(15,'2025-11-28 03:22:52',3,'Tools',1000.0,NULL);
INSERT INTO items VALUES(16,'2025-11-28 03:23:37',4,'Benchop Oven',500.0,'NDIS');
INSERT INTO items VALUES(17,'2025-11-28 03:24:01',4,'Fridge',2500.0,NULL);
INSERT INTO items VALUES(18,'2025-11-28 03:25:06',4,'Kettle (tilting)',250.0,NULL);
INSERT INTO items VALUES(19,'2025-11-28 03:25:55',4,'Grill (Greenpan)',500.0,NULL);
INSERT INTO items VALUES(20,'2025-11-28 03:26:37',4,'Microwave',250.0,NULL);
INSERT INTO items VALUES(21,'2025-11-28 03:26:51',5,'Roomba',500.0,NULL);
INSERT INTO items VALUES(22,'2025-11-28 03:27:22',4,'Toaster',100.0,NULL);
INSERT INTO items VALUES(23,'2025-11-28 03:28:25',5,'Apple Watch Ultra',1200.0,NULL);
INSERT INTO items VALUES(24,'2025-11-28 03:29:25',5,'UE Megaboom bluetooth speaker',250.0,NULL);
INSERT INTO items VALUES(25,'2025-11-28 03:30:14',5,'Cane chairs',500.0,NULL);
INSERT INTO items VALUES(26,'2025-11-28 03:31:32',5,'Dining table',500.0,NULL);
INSERT INTO items VALUES(27,'2025-11-28 03:31:44',5,'Drone',1500.0,NULL);
INSERT INTO items VALUES(28,'2025-11-28 03:32:26',5,'iphone',1000.0,NULL);
INSERT INTO items VALUES(29,'2025-11-28 03:32:41',5,'Lift Chair',2000.0,NULL);
INSERT INTO items VALUES(30,'2025-11-28 03:33:21',5,'Main Laptop',3000.0,NULL);
INSERT INTO items VALUES(31,'2025-11-28 03:33:43',5,'Main TV',2000.0,NULL);

-- DATA: rooms
INSERT INTO rooms VALUES(1,'2025-11-28 01:38:17','Balcony',NULL,NULL);
INSERT INTO rooms VALUES(2,'2025-11-28 01:38:24','Bedoom 1',NULL,NULL);
INSERT INTO rooms VALUES(3,'2025-11-28 01:38:29','Garage',NULL,NULL);
INSERT INTO rooms VALUES(4,'2025-11-28 01:38:44','Kitchen',NULL,NULL);
INSERT INTO rooms VALUES(5,'2025-11-28 01:38:53','Loungeroom',NULL,NULL);
INSERT INTO rooms VALUES(6,'2025-11-28 03:36:37','bedroom 2',NULL,NULL);