From 8ac76fbbb15b67ea282675b131a3a7c5133dc079 Mon Sep 17 00:00:00 2001 From: Will Budic Date: Mon, 2 Mar 2020 17:56:52 +1100 Subject: [PATCH] missed sql create temp statement. --- htdocs/cgi-bin/login_ctr.cgi | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/htdocs/cgi-bin/login_ctr.cgi b/htdocs/cgi-bin/login_ctr.cgi index 5a087e3..b9d40cd 100755 --- a/htdocs/cgi-bin/login_ctr.cgi +++ b/htdocs/cgi-bin/login_ctr.cgi @@ -241,7 +241,9 @@ sub checkCreateTables { SELECT ID_CAT, DATE, LOG, AMOUNT, AFLAG FROM life_log_login_ctr_temp_table ORDER by DATE;'); $db->do('DROP TABLE life_log_login_ctr_temp_table;'); - #Experimenentla sofar NOTES table has LID changed to proper number type. + #Experimental sofar NOTES table has LID changed to proper number type. + $db->do(qq(CREATE TABLE life_log_rename_column_new_table ( + LID INTEGER NOT NULL PRIMARY KEY, DOC TEXT);)); $db->do('INSERT INTO life_log_rename_column_new_table SELECT `LID`,`DOC` FROM `NOTES`;'); $db->do('DROP TABLE `NOTES`;'); $db->do('ALTER TABLE `life_log_rename_column_new_table` RENAME TO `NOTES`'); -- 2.34.1