Merlin (2020)

Need search for key, search sql, apply, delete, reverse, .... ? Reverse would work only if we had a previous statement to run or a previous state to recall. All updates should be full "replace" if possible to make this easier.

2021-03-24 11:42:22	V1813431028	EDIT	f_ven_add1	Oystermouth Road
2021-01-13 12:54:00	V1798543557	EDIT	f_ven_type	ART
2020-11-20 16:37:16	L02071577128	LIST	f_list_ven	V765
2020-11-20 16:36:54	L02071577128	LIST	f_list_ven	V687
2020-11-20 14:37:14	L0964642303	LIST	f_list_ven	V01754281771
2020-11-20 14:34:42	L0964642303	LIST	f_list_ven	V0165922284
2020-11-20 14:34:28	L0964642303	LIST	f_list_ven	V442
2020-11-20 14:34:20	L0964642303	LIST	f_list_ven	V944
2020-11-20 13:56:32	L0825651943venue	LIST	L0825651943venue	the blakehay
2020-11-20 13:56:10	L0825651943	LIST	f_list_ven	V01754281771
2020-11-20 13:55:00	L0907087873venue	LIST	L0907087873venue	Hull New Theatre
2020-11-20 13:54:52	L0907087873venue	LIST	L0907087873venue	blake
2020-11-20 13:52:58	L0907087873venue	LIST	L0907087873venue	the
2020-11-20 13:48:53	L0907087873venue	LIST	L0907087873venue	the bla
2020-11-20 13:43:48	L0907087873venue	LIST	L0907087873venue
2020-11-16 17:05:00	L0106688191	LIST	f_list_ph
2020-11-16 17:04:51	L0106688191	LIST	f_list_ph	5
2020-11-16 16:36:23	L1407757745	LIST	f_list_to	29-Sep-21
2020-11-16 16:36:21	L1407757745	LIST	f_list_to	29-Sep-22
2020-11-16 11:33:54	L0106688191	LIST	f_list_to	5-Dec-20
2020-11-16 11:33:50	L0106688191	LIST	f_list_to	5-Dec-21
2020-10-29 13:54:09	L01183751150	LIST	f_list_when

Action could be EDIT, LIST or SQL (sql in value field) or ADD as we wont have a qtix and can't do any modifications to a record until we have that qtix ... so do we apply all sql first or does an sql trigger immediate processing? so if we get an add the qtix is, e.g., V0, we create a new qtix, update the record and then apply the add?? so the sql for the add needs a dummy that we can replace OR the add is not an sql but a json of the fields/values!