From 3dc7677431faf1dda0be0a783f6bc3a19be220c3 Mon Sep 17 00:00:00 2001 From: Metabox Date: Tue, 1 Oct 2019 04:41:00 +1000 Subject: [PATCH] Added STICKY COLUMN to LOG. --- dbLifeLog/main.cnf | 4 ++-- htdocs/cgi-bin/login_ctr.cgi | 3 ++- 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/dbLifeLog/main.cnf b/dbLifeLog/main.cnf index 3f66822..364fe0e 100644 --- a/dbLifeLog/main.cnf +++ b/dbLifeLog/main.cnf @@ -74,6 +74,6 @@ PRAGMA foreign_keys = 1; UPDATE LOG SET AFLAG=1 WHERE ID_CAT=%INCOME_ID%; UPDATE LOG SET AFLAG=2 WHERE ID_CAT=%EXPENSE_ID%; - - +LOG<6>|Run Query ' ver. 1.6 +ALTER TABLE LOG ADD STICKY BOOL DEFAULT 0; diff --git a/htdocs/cgi-bin/login_ctr.cgi b/htdocs/cgi-bin/login_ctr.cgi index ca1021a..9a43ab8 100755 --- a/htdocs/cgi-bin/login_ctr.cgi +++ b/htdocs/cgi-bin/login_ctr.cgi @@ -189,7 +189,8 @@ try{ LOG VCHAR(128) NOT NULL, AMOUNT INTEGER DEFAULT 0, AFLAG TINY DEFAULT 0, - RTF BOOL DEFAULT 0 + RTF BOOL DEFAULT 0, + STICKY; ); CREATE INDEX idx_log_dates ON LOG (DATE); ); -- 2.34.1