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

CREATE TABLE app_meta (table_name TEXT PRIMARY KEY, schema_hash TEXT NOT NULL);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE IF NOT EXISTS "streamers" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE, comment TEXT);
CREATE TABLE IF NOT EXISTS "shows" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE, streamer_id INTEGER, season INTEGER, episode INTEGER, is_active INTEGER, is_done INTEGER, comment TEXT, actor_id INTEGER, FOREIGN KEY(streamer_id) REFERENCES streamers(id));
CREATE TABLE IF NOT EXISTS "actors" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE, comment TEXT);
CREATE TABLE IF NOT EXISTS "show_actors" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, show_id INTEGER, actor_id INTEGER, FOREIGN KEY(show_id) REFERENCES shows(id), FOREIGN KEY(actor_id) REFERENCES actors(id), UNIQUE(show_id, actor_id));


-- DATA: actors
INSERT INTO actors VALUES(1,'2025-12-16 12:42:56','Jason Momoa',NULL);
INSERT INTO actors VALUES(2,'2026-01-10 10:31:20','Claire Danes',NULL);
INSERT INTO actors VALUES(3,'2026-01-11 12:31:44','Harrison Ford',NULL);
INSERT INTO actors VALUES(4,'2026-01-12 06:19:15','Helen Miram',NULL);
INSERT INTO actors VALUES(5,'2026-01-26 09:07:55','Zoe Saldaña',NULL);
INSERT INTO actors VALUES(6,'2026-03-21 09:57:43','Moren Baccarin',NULL);
INSERT INTO actors VALUES(7,'2026-03-26 05:51:10','Matt Lauria',NULL);
INSERT INTO actors VALUES(8,'2026-03-28 08:59:37','John Noble(Walter)',NULL);
INSERT INTO actors VALUES(9,'2026-03-28 09:01:05','Anna Torv(Olivia)',NULL);
INSERT INTO actors VALUES(10,'2026-03-28 09:03:53','Joshua Jackson(Peter)',NULL);

-- DATA: app_meta
INSERT INTO app_meta VALUES('streamer','0b4730b2403a68a7f8c476634fa8f48c8585718d');
INSERT INTO app_meta VALUES('show','365d1c87f63b144414df88d8b5673d48cc2d4189');
INSERT INTO app_meta VALUES('streamers','def95b4fa9f7b75dc07ecb368ae92bef0e206450');
INSERT INTO app_meta VALUES('shows','fa6a778e968127ba91ffd31560a1c4635ebdd317');
INSERT INTO app_meta VALUES('stars','99bdef5b8b9ac8adcc14009dec90e1d7736b90d9');
INSERT INTO app_meta VALUES('actors','dfe1315749a8e9dfa2ccdd0c1fd88d9600e68860');
INSERT INTO app_meta VALUES('show_actors','11ee05ff5caf93a205aadcc3e470e3a1e82957e7');

-- DATA: show_actors
INSERT INTO show_actors VALUES(7,'2026-02-08 08:52:31',122,4);
INSERT INTO show_actors VALUES(8,'2026-03-26 05:52:19',138,7);
INSERT INTO show_actors VALUES(9,'2026-03-28 09:06:04',11,9);
INSERT INTO show_actors VALUES(10,'2026-03-28 09:06:33',11,10);
INSERT INTO show_actors VALUES(11,'2026-03-28 09:07:16',11,8);

-- DATA: shows
INSERT INTO shows VALUES(1,'2025-11-22 11:01:23','Last Frontier',1,1,10,1,0,NULL,NULL);
INSERT INTO shows VALUES(2,'2025-11-22 11:15:05','Foundation',1,3,10,1,0,NULL,NULL);
INSERT INTO shows VALUES(3,'2025-11-22 11:15:38','Pluribus',1,1,7,1,0,'it was shit, i stopped watching',NULL);
INSERT INTO shows VALUES(4,'2025-11-22 11:17:34','Down Cemetery Road',1,1,8,1,1,NULL,NULL);
INSERT INTO shows VALUES(5,'2025-11-22 11:18:08','Slow Horses',1,999,999,1,0,NULL,NULL);
INSERT INTO shows VALUES(6,'2025-11-22 11:20:17','Silo',1,2,10,1,0,NULL,NULL);
INSERT INTO shows VALUES(7,'2025-11-22 11:21:32','Chief of War',1,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(8,'2025-11-22 11:22:30','Bad Monkey',1,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(9,'2025-11-22 11:24:40','Disclaimer',1,1,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(10,'2025-11-22 11:25:03','Hijack',1,1,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(11,'2025-11-22 11:29:46','Fringe',5,2,20,1,0,'2nd time round',9);
INSERT INTO shows VALUES(12,'2025-11-22 11:31:49','Supergirl',2,2,NULL,1,0,'not sure if its still there',NULL);
INSERT INTO shows VALUES(13,'2025-11-22 11:37:03','The Last Ship',8,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(14,'2025-11-22 11:37:42','Elementary',8,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(15,'2025-11-22 11:38:05','Black Sails',8,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(16,'2025-11-22 11:39:03','Yellowstone',8,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(17,'2025-11-22 11:40:26','Billions',8,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(18,'2025-11-22 11:41:37','Luthor',8,NULL,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(19,'2025-11-22 11:41:57','Torchwood',8,4,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(20,'2025-11-22 11:43:22','Riviera',7,3,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(21,'2025-11-22 11:44:29','Mr Mercedies',7,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(22,'2025-11-22 11:44:54','Tin Star',7,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(23,'2025-11-22 11:46:33','War of the Worlds',7,1,NULL,1,0,'the one with robot dogs',NULL);
INSERT INTO shows VALUES(24,'2025-11-22 11:47:02','Temple',7,1,3,1,0,NULL,NULL);
INSERT INTO shows VALUES(25,'2025-11-22 11:48:04','Marvels Agents of Sheild',9,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(26,'2025-11-22 11:48:56','The Walking Dead',9,8,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(27,'2025-11-22 11:50:03','DC''s Legends of Tomorrow',9,1,14,1,0,NULL,NULL);
INSERT INTO shows VALUES(28,'2025-11-23 09:52:42','Invasion',1,1,2,1,0,NULL,NULL);
INSERT INTO shows VALUES(29,'2025-11-23 09:54:07','Shooter',4,3,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(31,'2025-11-23 09:55:56','WU Assasin',4,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(32,'2025-11-23 09:56:56','Queen Of The South',4,4,1,1,0,NULL,NULL);
INSERT INTO shows VALUES(33,'2025-11-23 09:57:20','FOOBAR',4,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(34,'2025-11-23 09:58:11','The Night Agent',4,3,5,1,0,NULL,NULL);
INSERT INTO shows VALUES(35,'2025-11-23 09:59:05','Oblivion',4,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(36,'2025-11-23 09:59:38','1899',4,1,2,1,0,NULL,NULL);
INSERT INTO shows VALUES(37,'2025-11-23 10:00:21','Altered Carbon',4,2,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(38,'2025-11-23 10:00:52','Another Life',4,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(39,'2025-11-23 10:01:14','Blood & Bone',4,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(40,'2025-11-23 10:01:39','Dr Who',4,11,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(41,'2025-11-23 10:02:10','Iron Fist',4,1,7,1,0,NULL,NULL);
INSERT INTO shows VALUES(42,'2025-11-23 10:02:39','Lost In Space',4,2,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(43,'2025-11-23 10:03:20','Manifest',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(44,'2025-11-23 10:05:11','Monkey',4,3,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(45,'2025-11-23 10:05:39','Outlander',4,7,NULL,1,1,'I think it''s finished',NULL);
INSERT INTO shows VALUES(46,'2025-11-23 10:06:03','Stranger Things',4,5,8,1,1,NULL,NULL);
INSERT INTO shows VALUES(47,'2025-11-23 10:06:29','The Expanse',4,2,13,1,0,NULL,NULL);
INSERT INTO shows VALUES(48,'2025-11-23 10:07:58','The Peaky Blinders',4,6,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(49,'2025-11-23 10:08:30','The Sandman',4,1,2,1,0,NULL,NULL);
INSERT INTO shows VALUES(50,'2025-11-23 10:08:58','The Umbrella Academy',4,3,4,1,0,NULL,NULL);
INSERT INTO shows VALUES(51,'2025-11-23 10:09:47','The Witcher',4,4,7,1,0,NULL,NULL);
INSERT INTO shows VALUES(52,'2025-11-23 10:10:13','House of Cards',4,1,5,1,0,NULL,NULL);
INSERT INTO shows VALUES(53,'2025-11-23 10:10:45','Luke Cage',4,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(54,'2025-11-23 10:11:11','The Blacklist ',4,1,4,1,0,NULL,NULL);
INSERT INTO shows VALUES(55,'2025-11-23 10:11:38',' Outer Banks',4,3,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(57,'2025-11-23 10:13:38','The Arrow',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(58,'2025-11-23 10:13:50','Designated Survivor',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(59,'2025-11-23 10:14:20','From Dusk till Dawn',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(60,'2025-11-23 10:14:46','Jessica Jones',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(61,'2025-11-23 10:15:11','Lucifer',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(62,'2025-11-23 10:15:36','Marvels Defenders',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(63,'2025-11-23 10:16:00','Money Heist',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(64,'2025-11-23 10:16:16','The 100',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(65,'2025-11-23 10:16:37','Vikings',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(66,'2025-11-23 10:17:09','Wanted',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(67,'2025-11-23 10:17:29','Weeds',4,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(68,'2025-11-23 10:27:02','Firefly',10,NULL,NULL,1,1,'not sure if its still there',NULL);
INSERT INTO shows VALUES(69,'2025-11-23 10:27:52','Game of Thrones',10,NULL,NULL,1,1,replace(replace('not sure if its still there\r\n','\r',char(13)),'\n',char(10)),NULL);
INSERT INTO shows VALUES(70,'2025-11-23 10:28:29','Homeland',10,NULL,NULL,1,1,'not sure if its still there',NULL);
INSERT INTO shows VALUES(71,'2025-11-23 10:32:04','CatWeasel',10,1,5,1,0,'not sure if its still there',NULL);
INSERT INTO shows VALUES(72,'2025-11-23 10:33:55','Married With Children',10,4,2,1,0,'not sure if its still there',NULL);
INSERT INTO shows VALUES(73,'2025-11-23 10:38:08','Agent Carter',11,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(74,'2025-11-23 10:39:21','The Mandalorian',11,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(75,'2025-11-23 10:40:28','Caprica',11,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(76,'2025-11-23 10:40:47','Boba Fet',11,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(77,'2025-11-23 10:41:26','Alien Earth',11,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(78,'2025-11-23 10:41:59','Andor',11,2,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(79,'2025-11-23 10:43:14','Secret Invasion',11,1,3,1,0,NULL,NULL);
INSERT INTO shows VALUES(80,'2025-11-23 10:43:53','The Falcon and the Winter Soldier',11,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(81,'2025-11-23 10:45:26','Reacher',5,3,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(82,'2025-11-23 10:45:53','Count Down',5,NULL,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(83,'2025-11-23 10:46:46','Hunters',5,2,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(84,'2025-11-23 10:49:12','The Bondsman',5,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(85,'2025-11-23 10:50:17','Tulsa King',6,3,10,1,0,NULL,NULL);
INSERT INTO shows VALUES(86,'2025-11-23 10:51:41','Outer Range',5,2,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(87,'2025-11-23 10:52:07','Treadstone',5,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(88,'2025-11-23 10:52:35','The Terminal List',5,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(89,'2025-11-23 10:53:30','The Boys',5,4,4,1,0,NULL,NULL);
INSERT INTO shows VALUES(90,'2025-11-23 10:54:31','Citadel',5,3,NULL,1,0,'Season 2 was a French one about Diana, 3 was an Indian one about Honey Bunny',NULL);
INSERT INTO shows VALUES(91,'2025-11-23 10:55:34','Halo',6,2,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(92,'2025-11-23 10:56:05','1883',6,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(93,'2025-11-25 07:27:32','The Tragically Hip',5,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(94,'2025-11-25 07:28:11','The Continental',5,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(95,'2025-11-25 07:28:49','Smallville',5,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(96,'2025-11-25 07:29:10','The English',5,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(97,'2025-11-25 07:29:42','Goliath',5,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(98,'2025-11-25 07:30:12','Yellowjackets',6,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(99,'2025-11-25 07:32:21','Star Trek Discovery ',6,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(100,'2025-11-25 07:33:40','Beacon 23',5,NULL,NULL,1,0,'a bit shit, not sure where we are up to',NULL);
INSERT INTO shows VALUES(101,'2025-11-25 07:38:27','Fallout',5,2,7,1,0,NULL,NULL);
INSERT INTO shows VALUES(102,'2025-11-25 11:09:21','Rogue',5,4,6,1,0,'havent watched season 1',NULL);
INSERT INTO shows VALUES(103,'2025-11-25 11:10:34','Jack Ryan',5,4,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(104,'2025-11-25 11:11:10','Carnival Row',5,2,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(105,'2025-11-25 11:13:56','Secret Level',5,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(106,'2025-11-25 11:14:34','Star Trek: Strange New Worlds',6,3,9,1,0,NULL,NULL);
INSERT INTO shows VALUES(107,'2025-11-25 11:15:19','Lord of the Rings: The Rings of Power',5,2,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(108,'2025-11-25 11:16:30','La Brea',5,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(109,'2025-11-25 11:17:11','Mobland',5,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(110,'2025-11-25 11:18:56','Landman',6,2,9,1,0,NULL,NULL);
INSERT INTO shows VALUES(111,'2025-11-25 11:24:32','Those About to Die',5,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(112,'2025-11-25 11:25:24','The Agency',6,1,10,1,0,'Finished season 1',NULL);
INSERT INTO shows VALUES(113,'2025-11-25 11:25:53','The Devils Hour',5,2,1,1,0,NULL,NULL);
INSERT INTO shows VALUES(114,'2025-11-25 11:26:34','Rabbit Hole',6,1,NULL,1,0,NULL,NULL);
INSERT INTO shows VALUES(115,'2025-11-25 11:27:32','Lioness',6,2,NULL,1,0,NULL,5);
INSERT INTO shows VALUES(116,'2025-11-25 11:28:25','Wheel Of Time',5,3,6,1,0,NULL,NULL);
INSERT INTO shows VALUES(117,'2025-11-27 10:44:51','The Terminal List: Dark Wolf',5,1,7,1,0,NULL,NULL);
INSERT INTO shows VALUES(118,'2025-11-29 10:34:21','Malice',5,1,1,1,0,NULL,NULL);
INSERT INTO shows VALUES(119,'2025-12-16 12:08:11','Tehran',1,1,1,1,0,NULL,NULL);
INSERT INTO shows VALUES(120,'2025-12-16 12:26:11','See',1,1,2,1,0,NULL,1);
INSERT INTO shows VALUES(121,'2026-01-10 10:27:33','The BEAST in me',4,1,8,1,1,NULL,2);
INSERT INTO shows VALUES(122,'2026-01-11 12:34:33','1923',5,2,7,1,1,NULL,3);
INSERT INTO shows VALUES(123,'2026-01-19 05:48:27','Star Trek: Starfleet Academy',6,1,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(124,'2026-01-19 05:55:27','Star Trek: Section 31',6,NULL,NULL,1,1,NULL,NULL);
INSERT INTO shows VALUES(128,'2026-01-30 03:50:51','Steal',5,1,5,1,0,NULL,NULL);
INSERT INTO shows VALUES(131,'2026-02-28 08:36:00','Monarch',1,2,1,1,0,NULL,NULL);
INSERT INTO shows VALUES(132,'2026-03-01 12:18:49','Scorpion',5,4,23,1,1,NULL,NULL);
INSERT INTO shows VALUES(138,'2026-03-21 09:53:00','Sheriff Country',6,1,3,1,0,NULL,6);

-- DATA: streamers
INSERT INTO streamers VALUES(1,'2025-11-22 11:00:21','AppleTV',NULL);
INSERT INTO streamers VALUES(2,'2025-11-22 11:28:03','9Now',NULL);
INSERT INTO streamers VALUES(3,'2025-11-22 11:28:12','7Plus',NULL);
INSERT INTO streamers VALUES(4,'2025-11-22 11:28:25','Netflix',NULL);
INSERT INTO streamers VALUES(5,'2025-11-22 11:28:36','Prime',NULL);
INSERT INTO streamers VALUES(6,'2025-11-22 11:28:52','Paramount',NULL);
INSERT INTO streamers VALUES(7,'2025-11-22 11:33:45','SBS on Demand',NULL);
INSERT INTO streamers VALUES(8,'2025-11-22 11:33:50','Stan',NULL);
INSERT INTO streamers VALUES(9,'2025-11-22 11:34:31','Netflix-US',NULL);
INSERT INTO streamers VALUES(10,'2025-11-23 10:29:03','Laptop',NULL);
INSERT INTO streamers VALUES(11,'2025-11-23 10:37:25','Disney+',NULL);