From cb1b3291a304c177ca87b8ce29a93f8676822c1d Mon Sep 17 00:00:00 2001 From: Will Budicm Date: Sat, 29 Aug 2020 12:50:27 +1000 Subject: [PATCH] upd migration. --- htdocs/cgi-bin/login_ctr.cgi | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/htdocs/cgi-bin/login_ctr.cgi b/htdocs/cgi-bin/login_ctr.cgi index 4d9cca3..3808868 100755 --- a/htdocs/cgi-bin/login_ctr.cgi +++ b/htdocs/cgi-bin/login_ctr.cgi @@ -246,11 +246,12 @@ sub checkCreateTables { } } } - + #is above v.1.6 has a notes table. + $db->do('DROP TABLE VW_LOG;'); + delete($curr_tables{'VW_LOG'}); } $db->do('DROP TABLE LOG;'); #v.1.8 Has fixes, time also properly to take into the sort. Not crucial to drop. - $db->do('DROP TABLE VW_LOG;');delete($curr_tables{'VW_LOG'}); $db->do(&Settings::createLOGStmt); $db->do('INSERT INTO LOG (ID_CAT, DATE, LOG, AMOUNT,AFLAG) SELECT ID_CAT, DATE, LOG, AMOUNT, AFLAG FROM life_log_login_ctr_temp_table ORDER by DATE;'); -- 2.34.1