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

CREATE TABLE app_meta (table_name TEXT PRIMARY KEY, schema_hash TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS "files" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE IF NOT EXISTS "bugs" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT, desc TEXT, is_fixed INTEGER, file_id INTEGER, has_trouble INTEGER, ta_desc TEXT, FOREIGN KEY(file_id) REFERENCES files(id) ON DELETE CASCADE);
CREATE TABLE IF NOT EXISTS "ideas" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT, idea TEXT, is_used INTEGER, ta_idea TEXT);
CREATE TABLE IF NOT EXISTS "users" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE);
CREATE TABLE IF NOT EXISTS "tbd" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT, job TEXT, is_done INTEGER, user_id INTEGER, ta_job TEXT);


-- DATA: app_meta
INSERT INTO app_meta VALUES('files','9bd4d6590a6e9aa0b2b94617b974283334328745');
INSERT INTO app_meta VALUES('bugs','004e9560b5c15d857981db2e8c8afadd325fde01');
INSERT INTO app_meta VALUES('ideas','a2ad1df8c09d8958eb4ac8ef03bad6b6cdf4279e');
INSERT INTO app_meta VALUES('users','430724acb05808b6fcfe5a154b946ffce7ec27ca');
INSERT INTO app_meta VALUES('tbd','8f7dd3b94d97875124f1a194ebc47a7560b6ce7e');
INSERT INTO app_meta VALUES('__TABLE_SPECS__','40aaccc2b2a3c3ef6cdf26742563226a45096cf8');

-- DATA: bugs
INSERT INTO bugs VALUES(4,'2025-10-24 05:29:53','Tab Order','fix tab order in forms, it looks like check box need to be the last item in the form at the moment',1,3,NULL,NULL);
INSERT INTO bugs VALUES(7,'2025-10-24 05:37:58','Schema Definition Location','Tests fail if schemA doesnt contain users table'',''move schema definition into config, have tests define their own DB and table schema, deleteme',1,4,0,NULL);
INSERT INTO bugs VALUES(8,'2025-10-24 05:40:16','Schema Definition Location','Tests fail if schema doesnt contain users table'',''move schema definition into config, have tests define their own DB and table schema',1,4,0,NULL);
INSERT INTO bugs VALUES(11,'2025-10-25 11:38:01','foreign key not showing name','in the tbd table the assigned to only shows the id number, not the users name',1,4,0,NULL);
INSERT INTO bugs VALUES(16,'2025-11-05 01:00:23','when changinging table','should I clear the search box',1,NULL,0,NULL);
INSERT INTO bugs VALUES(17,'2025-11-05 01:01:20','referenced field','include it in search',1,NULL,0,NULL);
INSERT INTO bugs VALUES(18,'2025-11-05 02:25:29','check seeding of referenced column','we used to seed it with unknown and remove none',1,NULL,0,NULL);
INSERT INTO bugs VALUES(19,'2025-11-05 02:26:09','filters','it looks like weve broken the off filter',1,NULL,0,NULL);
INSERT INTO bugs VALUES(23,'2025-11-07 01:13:14','after adding a row','if the results are filtered when we add the row the filters are off. should they stay on?',1,NULL,0,NULL);
INSERT INTO bugs VALUES(24,'2025-11-09 06:59:38','add empty form','it should not add, it should give a fading banner',1,NULL,0,NULL);
INSERT INTO bugs VALUES(25,'2025-11-09 07:01:42','fix export csv','so it doesnt include html',1,NULL,0,NULL);
INSERT INTO bugs VALUES(26,'2025-11-09 07:24:06','import','should we add a banner on sucess',1,NULL,0,NULL);
INSERT INTO bugs VALUES(27,'2025-11-09 13:06:42','fix tests','a heap of stuff doesnt write to the ledger RESULTS_OK',1,NULL,0,NULL);
INSERT INTO bugs VALUES(28,'2025-11-13 22:34:04','CSV import bugs','gives a constraint violation',1,NULL,0,NULL);
INSERT INTO bugs VALUES(29,'2025-11-19 08:07:49','focus','when I change tables the focus needs to land on the first field in the add box. didnt do anything but it appears to be fixed',1,NULL,0,NULL);
INSERT INTO bugs VALUES(30,'2025-11-19 23:24:19','import CSV has wrong database path',replace(replace('DB: AudioBooks.db\r\nPath: /Users/roblukin/Library/Mobile Documents/com~apple~CloudDocs/web_developement/MySQLiteSite/AudioBooks/tools/AudioBooks.db','\r',char(13)),'\n',char(10)),1,NULL,0,NULL);
INSERT INTO bugs VALUES(31,'2025-11-20 04:12:30','focus','on startup and changing tables we put our focus on the add form, after we delete, if we then change tables we dont have the focus on the add form any more. didnt do anything but it appears to be fixed',1,NULL,0,NULL);
INSERT INTO bugs VALUES(32,'2025-11-20 04:16:43','banner makes table jump',replace(replace('If it ever starts to bug you later, we can smooth it out by, for example:\r\n	•	Keeping the flash element in the layout but making it visibility: hidden instead of removing it, or\r\n	•	Reserving a fixed-height flash area so the table never moves when messages appear/disappear.\r\n','\r',char(13)),'\n',char(10)),0,NULL,1,NULL);
INSERT INTO bugs VALUES(33,'2025-11-20 08:24:57','tab order','not right, it skips filters and then jumps back to them after import csv, and when editing it skips over the boolean checkboxes then comes back to them after save button - weve decided to leave it for now as safari is becoming a problem',0,NULL,1,NULL);
INSERT INTO bugs VALUES(34,'2025-11-24 06:50:36','focus','the focus stay on the add form when you change tables until you edit/delete, then the change table focus wont work, if I remove the ?................ from after index.php it fixes it. didnt do anything but it appears to be fixed',1,NULL,0,NULL);
INSERT INTO bugs VALUES(37,'2025-11-25 11:22:22','Constraint error','give a user friendly error when duplicate name (unique constraint) given ',1,NULL,0,NULL);
INSERT INTO bugs VALUES(38,'2025-11-26 09:21:00','CONFIRM DELETE','I dont think its working',1,NULL,0,NULL);
INSERT INTO bugs VALUES(39,'2025-11-29 05:44:56','filter settings','after editing if we return to the add form we forget the filters..',1,NULL,0,NULL);
INSERT INTO bugs VALUES(46,'2025-12-31 23:44:37','subscriptions','why does it overlap the page? - the website string was too long',1,4,0,NULL);
INSERT INTO bugs VALUES(47,'2026-01-11 04:54:45','listing tables wrong','“When APP is overridden on the command line, scaffold/update output still reflects the tables from root config rather than the app’s intended table set (or makes it unclear which config source is active).”',1,11,0,NULL);
INSERT INTO bugs VALUES(48,'2026-01-11 22:54:17','cli APP= is not overriding config ','is not overriding config any more',1,4,0,NULL);
INSERT INTO bugs VALUES(49,'2026-01-18 09:41:43','add column with constraint = rebuild path.','sqlite wont let us alter or add colums with contstraints, so we need to do it properly for when we want to add a column with a constraint, so that might mean the scaffold has to save the data, drop the table, recreate it with new column and constraints, re-imprt data.',0,11,1,NULL);
INSERT INTO bugs VALUES(51,'2026-01-22 22:54:39','Drop down lists','Sort them alphabetically',1,NULL,0,NULL);
INSERT INTO bugs VALUES(52,'2026-01-23 02:24:49','seeding checklists','when there are multiple checklist tables only the last table seeded via config gets done. at the moment i need to uncomment the seed for each table and run update-db one by one - weve moved to app level configs',1,4,0,NULL);
INSERT INTO bugs VALUES(53,'2026-01-23 07:39:10','actor_id','why are we seeing it on the shows page?',1,NULL,0,NULL);
INSERT INTO bugs VALUES(54,'2026-01-24 08:12:30','tests','TEST dir is not being removed after a successful test run',1,12,0,NULL);
INSERT INTO bugs VALUES(57,'2026-01-30 01:50:51','Unit prefix''s','they will not show on the server at the moment cause the env doesnt get the values from config',0,4,1,NULL);
INSERT INTO bugs VALUES(58,'2026-01-31 23:58:22','file too Big','see how we can logically split it up',1,13,0,NULL);
INSERT INTO bugs VALUES(59,'2026-02-01 03:12:40','wrapper files','they only exist to faclitate a filename change, remove them from listing logic and listing view',1,13,0,NULL);
INSERT INTO bugs VALUES(60,'2026-02-04 09:59:34','TVShows: test still expects “Actors” injection on shows listing',replace(replace('Problem: make test → “TVShows M2M: shows page actor list (via show_actors)” fails because the shows page no longer renders an injected Actors column, so it can’t find Actor_M2M_One.\r\n	•	Expected end-state: No injected columns in listing_view.php. TVShows M2M should be verified via the dedicated show_actors workflow/page, not via shows listing injection.\r\n	•	Fix later: Update/remove the TVShows M2M test expectations so it checks show_actors (or whatever the dedicated UI path is), not shows.\r\n','\r',char(13)),'\n',char(10)),1,NULL,0,NULL);
INSERT INTO bugs VALUES(61,'2026-02-04 23:56:40','Title: TVShows test expects injected Actors column on shows listing2',replace(replace('	Body: We’re moving to “zero injections” in listing_view. Current test_tvshows_m2m asserts actor names appear on shows listing (injected). Future direction: dedicated show_actors workflow/page only; update test accordingly and remove injection requirement.\r\n','\r',char(13)),'\n',char(10)),1,NULL,0,NULL);
INSERT INTO bugs VALUES(62,'2026-02-06 00:15:34','Sort by column','Arrows missing, is not working. Do we have tests to ensure it doesn''t go missing?',1,NULL,0,NULL);
INSERT INTO bugs VALUES(63,'2026-02-06 05:20:32','Checklists','ocmment box is not clearing when we reset',1,NULL,0,NULL);
INSERT INTO bugs VALUES(65,'2026-02-07 04:08:02','cat_all_paste.sh.tpl','i think it should live in root as its not part of scaffold, its only to make my life easier',1,NULL,0,NULL);
INSERT INTO bugs VALUES(66,'2026-02-07 12:01:43','TestUnits','Comments column not being generated',1,4,0,NULL);
INSERT INTO bugs VALUES(67,'2026-02-07 12:16:34','TVShows','actions in the comment column and actors not a sort link, i think we might need to remove that injection ',1,14,0,NULL);
INSERT INTO bugs VALUES(68,'2026-02-07 12:21:44','AudioBooks','narrator column not showing in listing, must be error in sql file, might be narrator spelling, it was but narrator must be hard coded (probably in both listing view and forms). I still need to raise this with josie as they should be built by whats specified in config specs',1,4,1,NULL);
INSERT INTO bugs VALUES(69,'2026-02-07 12:27:50','launcher','local one doesnt know that its local and is showing no ports',1,7,0,NULL);
INSERT INTO bugs VALUES(70,'2026-02-08 00:22:24','Checklists','there is a stray ''b'' on my my checklists page, it is there for all tables except the first one, i cant see anything in my config',1,NULL,0,NULL);
INSERT INTO bugs VALUES(73,'2026-02-16 05:19:26','need to revisit config','see what really belongs there',0,16,0,NULL);
INSERT INTO bugs VALUES(75,'2026-02-26 05:33:02','Add New button appears twice at top of form','remove button after filters',1,14,0,NULL);
INSERT INTO bugs VALUES(80,'2026-03-16 09:25:38','comment field not showing',NULL,1,4,0,'Trading: NT setup checklist');
INSERT INTO bugs VALUES(81,'2026-03-17 05:17:18','sort not working properly',NULL,1,17,0,replace(replace('when i open TBD it only shows uncompleted jobs as specified in config.ini\r\nif i click show all i get all records as expected\r\nbut if i then click a column to sort the list it jumps back to the list of uncompleted jobs as specifid in config.ini.\r\nThe same thing happens when sorting a column\r\n','\r',char(13)),'\n',char(10)));
INSERT INTO bugs VALUES(82,'2026-03-21 05:30:38','Server permissions',NULL,1,NULL,0,'Update rebuild scripts so that they set correct permissions server wide');
INSERT INTO bugs VALUES(83,'2026-03-21 05:32:41','Sudo passwd',NULL,1,NULL,0,'Update server rebuild scripts so they set Sudo to have no password');

-- DATA: files
INSERT INTO files VALUES(3,'2025-10-24 05:29:01','forms.php.tpl');
INSERT INTO files VALUES(4,'2025-10-24 05:38:44','config.sh');
INSERT INTO files VALUES(5,'2025-10-25 06:34:09','base.css.tpl');
INSERT INTO files VALUES(7,'2025-11-04 05:14:41','index.php.tpl');
INSERT INTO files VALUES(8,'2025-11-04 05:15:24','footer.php.tpl');
INSERT INTO files VALUES(9,'2025-11-04 05:15:39','header.php.tpl');
INSERT INTO files VALUES(11,'2026-01-11 04:55:05','scaffold.sh');
INSERT INTO files VALUES(12,'2026-01-24 08:12:46','Makefile');
INSERT INTO files VALUES(13,'2026-01-31 23:59:23','listing_logic.php.tpl');
INSERT INTO files VALUES(14,'2026-01-31 23:59:45','listing_view.php.tpl');
INSERT INTO files VALUES(15,'2026-02-06 05:27:45','listing_logic2.php.tpl');
INSERT INTO files VALUES(16,'2026-02-16 05:18:14','config.sh.defaults');
INSERT INTO files VALUES(17,'2026-03-17 05:17:33','config.ini');

-- DATA: ideas
INSERT INTO ideas VALUES(1,'2025-10-24 05:43:45','Labels',replace(replace('have a label column in all tables for the display name instead of [label=...  ]\r\n(we decided its not really worth it for this scaffold)','\r',char(13)),'\n',char(10)),1,NULL);
INSERT INTO ideas VALUES(2,'2025-10-24 05:45:17','Default Specs/Schema desc','move this definition into the config file so that everything the user needs to fiddle with is in one place',1,NULL);
INSERT INTO ideas VALUES(3,'2025-10-24 05:46:49','Import','need to be able to import csv/sql so we can re-populate database after modifying it''''s strucure',1,NULL);
INSERT INTO ideas VALUES(4,'2025-10-24 05:47:45','check box/booleans','we need an option to search where this has been checked or not',1,NULL);
INSERT INTO ideas VALUES(5,'2025-10-25 00:41:48','add a dynamic bool filter','a filter that’s auto-detected at runtime rather than hard-coded.',1,NULL);
INSERT INTO ideas VALUES(6,'2025-11-04 07:21:53','show all button',replace(replace('when we click it it try leaving the focus where it was, we left t as no focus\r\n','\r',char(13)),'\n',char(10)),1,NULL);
INSERT INTO ideas VALUES(7,'2025-11-04 07:22:51','bugs table','search doesnt appear to be working properly',1,NULL);
INSERT INTO ideas VALUES(8,'2025-11-04 07:24:04','flilters','when I click on them leave the focus on it',1,NULL);
INSERT INTO ideas VALUES(9,'2025-11-25 06:55:29','sum a column','maybe if the column name is amount or something similar we can automatically sum that column, and what happens if the results cover multiple pages? where does the total go?',1,NULL);
INSERT INTO ideas VALUES(10,'2025-12-27 08:57:47','Snapshot',replace(replace('make a snapshot script on mac that collects together all pieces: .zshrc vultr MySQLSite - maybe store it in webdevelopement? - this happens when we freeze a version\r\n','\r',char(13)),'\n',char(10)),1,NULL);
INSERT INTO ideas VALUES(11,'2025-12-31 23:26:10','Checklists','ive been playing with pages for checklists, showing them as filters is a problem, we dont filters. Add a rule for checkboxes so if the column is prefixed with cl_ filters are not added',1,NULL);
INSERT INTO ideas VALUES(13,'2026-01-11 04:57:32','archive records','change the delete button to archive or add a flag to mark as archived',0,NULL);
INSERT INTO ideas VALUES(14,'2026-01-12 08:58:32','nested checklist app',replace(replace('which has categories in a different table - subcategories, lists can then be shown by category (ie leaving-car, leaving-unit etc)\r\n','\r',char(13)),'\n',char(10)),0,NULL);
INSERT INTO ideas VALUES(15,'2026-01-17 10:52:59','Apache','If I install it on my Mac as a server I''ll be able to log in remotely won''t I? And then we won''t need vultr will ii?',0,NULL);
INSERT INTO ideas VALUES(16,'2026-02-05 04:48:55','Hide M2M tables from the table picker ','hide them by default, hide them by default/group them/add a toggle',0,NULL);
INSERT INTO ideas VALUES(17,'2026-02-07 23:24:39','import SQL','should we have a link on the page and maybe we should differentiate between then cause export csv only does tables whereas export sql does the complete db',0,NULL);
INSERT INTO ideas VALUES(18,'2026-03-21 12:22:16','Nested checklists (hierarchical items)',NULL,0,replace(replace('Notes:\r\n- Current scaffold checklists are flat (cl_ columns)\r\n- Nested structure would require row-based model:\r\n  - checklist_items table\r\n  - parent_id (self-reference)\r\n- Would likely need:\r\n  - new UI pattern (tree / indented list)\r\n  - different save/update flow\r\n- Consider as separate “Checklist v2” app, not retrofit','\r',char(13)),'\n',char(10)));
INSERT INTO ideas VALUES(19,'2026-03-31 11:25:30','formulas',NULL,0,'i wonder if we can apply a formula to a field which is specified in config.ini');

-- DATA: tbd
INSERT INTO tbd VALUES(1,'2025-10-25 06:27:56','Add filter tests',replace(replace('	1.	add web-side tests that toggle filters and confirm the row counts change;\r\n	2.	add a CLI test that ensures the new filter-related params (f_*) persist correctly across links;\r\n	3.	maybe include a small snapshot-integrity check to make sure the saved style code and JS are emitted.\r\n','\r',char(13)),'\n',char(10)),1,2,NULL);
INSERT INTO tbd VALUES(2,'2025-10-25 06:40:01','readme','add section on how to implement and use filters',1,2,NULL);
INSERT INTO tbd VALUES(3,'2025-10-26 03:37:41','add to readme how it displays foreign key dropdowns',replace(replace('✅ Now behaviour is:\r\n	•	For file_id, it does SELECT name FROM files WHERE id = ?.\r\n	•	For user_id, it does SELECT name FROM users WHERE id = ?.\r\n	•	If that fails, it shows the numeric id.\r\n','\r',char(13)),'\n',char(10)),1,3,NULL);
INSERT INTO tbd VALUES(4,'2025-10-28 06:41:43','After Restore','seed referenced rows, if seeded then remove none from dropdown, update readme, add tests',1,1,NULL);
INSERT INTO tbd VALUES(5,'2025-11-07 01:19:43','add configurable flag','PRESERVE_FILTERS_AFTER_ADD - this appears to be fixed',1,2,NULL);
INSERT INTO tbd VALUES(6,'2025-11-09 01:42:19','add to readme','once we get it working, about csv import',1,1,NULL);
INSERT INTO tbd VALUES(8,'2025-11-09 05:31:46','import csv','need to add it to other pages',1,1,NULL);
INSERT INTO tbd VALUES(9,'2025-11-13 22:32:17','CSV import flash banner','add to tests so it gives a warning if removed',1,1,NULL);
INSERT INTO tbd VALUES(10,'2025-11-14 09:03:44','Add test',replace(replace('Add a JS-side self-diagnostic echo/marker so tests alert us if the banner-fade script gets deleted or truncated\r\nSomething like:console.log("banner-fade:ok");\r\nOr, better (so it shows up in server logs even in test mode):echo ''<!-- banner_fade_js_loaded -->'';Placed right before the JS fade logic.\r\nThen the testbench can grep for that marker in:TEST/includes/footer.php\r\nor even render output and ensure the marker is present by default (when not in CSV mode).\r\n','\r',char(13)),'\n',char(10)),1,2,NULL);
INSERT INTO tbd VALUES(11,'2025-11-19 03:37:40','README','Josie added draft CSV section, I havent gone through it yet to check ordering and to see what needs to be edited.deleted etc...',1,1,NULL);
INSERT INTO tbd VALUES(12,'2025-11-19 08:12:32','sort','add a sort by column name',1,2,NULL);
INSERT INTO tbd VALUES(13,'2025-11-19 08:20:40','tests','add CSV tests',1,2,NULL);
INSERT INTO tbd VALUES(14,'2025-11-20 04:37:31','put a if debug around this',replace(replace('this is at top of every page\r\nSQLite style: auto\r\n\r\nDB: AudioBooks.db','\r',char(13)),'\n',char(10)),1,2,NULL);
INSERT INTO tbd VALUES(16,'2025-11-20 06:58:51','focus after edit','after editing if we return to the add form we cant retain our focus there...',1,2,NULL);
INSERT INTO tbd VALUES(17,'2025-11-28 01:57:43','update README','withinfo about summing colums named "amount"',1,2,NULL);
INSERT INTO tbd VALUES(20,'2025-12-27 08:56:30','Badges','make the launcher and the apps show the same badges. the badge does not need to be shown twice. remove the second line',1,2,NULL);
INSERT INTO tbd VALUES(21,'2026-01-01 11:26:05','emacs','add vultr scripts and README to init.el, will this README clash with the other README? maybe we can make this bunch of fils open as a seperate project. like open scaffold ctrl-Cso and ctrl-Cvo. and maybe have the current project close when i open a different one',1,2,NULL);
INSERT INTO tbd VALUES(22,'2026-01-07 09:46:47','tell/teach me about GIThub','doesnt belong here',1,48,NULL);
INSERT INTO tbd VALUES(23,'2026-01-07 09:48:04','Swappping between local and remote servers','work out a strategy - maybe with snapshot_server and restore???',1,2,NULL);
INSERT INTO tbd VALUES(24,'2026-01-07 09:49:01','checklists',replace(replace('moved checked items to a seperate window\r\n','\r',char(13)),'\n',char(10)),1,2,NULL);
INSERT INTO tbd VALUES(25,'2026-01-07 09:59:44','edit scaffold on ipad','show me what i need for this, im guessing an ftp program with an editor',1,48,NULL);
INSERT INTO tbd VALUES(26,'2026-01-11 01:08:38','test snapshot and restore ','to server and from server to mac',1,49,NULL);
INSERT INTO tbd VALUES(27,'2026-01-11 02:43:33','README','a short “Lifecycle Contract” section in README.txt',0,2,NULL);
INSERT INTO tbd VALUES(28,'2026-01-11 02:44:32','add target','a read-only list-server-snaps convenience target',0,2,NULL);
INSERT INTO tbd VALUES(29,'2026-01-11 02:45:57','archive records','instead of deleting them',0,2,NULL);
INSERT INTO tbd VALUES(30,'2026-01-11 02:51:42','add context file','to prevent me updating the wrong server',1,2,NULL);
INSERT INTO tbd VALUES(31,'2026-01-11 05:19:06','working context','contexts needs to be enforced in .zcshrc as well - enforced by make context',1,2,NULL);
INSERT INTO tbd VALUES(32,'2026-01-12 08:55:43','order fields','in a common. way between app - the order now follows config',1,49,NULL);
INSERT INTO tbd VALUES(33,'2026-01-19 08:25:33','m2m','then we need to check the tests, and do we need to add tests for this? and we need to update README',1,2,NULL);
INSERT INTO tbd VALUES(34,'2026-01-19 08:47:24','m2m tables - chck that',replace(replace('Join tables (M2M tables) are:\r\n	•	Hidden by default\r\n	•	Automatically visible when DEBUG=1\r\n	•	Documented clearly in the README\r\n','\r',char(13)),'\n',char(10)),1,49,NULL);
INSERT INTO tbd VALUES(35,'2026-01-21 09:23:55','Checklists','add a column for notes area, it should be saved in the db and cleared when we reset - done but not working any more, i put in a bug report',1,2,NULL);
INSERT INTO tbd VALUES(36,'2026-01-23 02:10:00','Checklists','add comments box below the checklist, make it update whenever you click a box in the checklist, this will avoid haveing to add a button',1,2,NULL);
INSERT INTO tbd VALUES(37,'2026-02-02 01:04:09','import sql','we need to add a link - i now have a script MySQLiteSite/rebuild_db_from_sql.sh - should this be a feature on the website?',0,2,NULL);
INSERT INTO tbd VALUES(38,'2026-02-05 05:22:51','remove injection','for TVShows',1,48,NULL);
INSERT INTO tbd VALUES(39,'2026-02-06 06:50:41','Checklists comment saving','change from on click to  as we type',1,NULL,NULL);
INSERT INTO tbd VALUES(40,'2026-02-07 04:13:53','add a comment field to test units',NULL,1,NULL,NULL);
INSERT INTO tbd VALUES(41,'2026-02-11 10:53:57','rebuild server v3.1','no adding features unttill after the rebuild',0,49,NULL);
INSERT INTO tbd VALUES(42,'2026-02-16 12:56:31','Add UI labels for table names',replace(replace('josie suggested: \r\nTABLE_LABELS=(\r\n  "codes:Stock Codes"\r\n  "sectors:Sectors"\r\n  "trades:Trades"\r\n), they would only be for the drop down displays','\r',char(13)),'\n',char(10)),0,NULL,NULL);
INSERT INTO tbd VALUES(43,'2026-03-16 06:57:50','add checklist','for pushing new config file to server and to make update-db when making schema or db changes',0,NULL,NULL);
INSERT INTO tbd VALUES(44,'2026-03-16 07:02:51','show totals','add functionality to specify table to show totals on when there is more than 1 table',0,NULL,NULL);

-- DATA: users
INSERT INTO users VALUES(2,'2025-10-25 06:19:24','Josie & Rob');
INSERT INTO users VALUES(3,'2025-10-26 04:22:44','Not assigned');
INSERT INTO users VALUES(48,'2025-12-27 08:58:30','Josie');
INSERT INTO users VALUES(49,'2025-12-27 08:58:36','Rob');