From 213a0973e4280504c9b180dcf101638c06e60b46 Mon Sep 17 00:00:00 2001 From: Metabox Date: Wed, 7 Aug 2019 07:27:36 +1000 Subject: [PATCH] . --- htdocs/cgi-bin/login_ctr.cgi | 19 ++++++++++--------- 1 file changed, 10 insertions(+), 9 deletions(-) diff --git a/htdocs/cgi-bin/login_ctr.cgi b/htdocs/cgi-bin/login_ctr.cgi index e125052..a5f4e53 100755 --- a/htdocs/cgi-bin/login_ctr.cgi +++ b/htdocs/cgi-bin/login_ctr.cgi @@ -190,7 +190,7 @@ try{ $st = $db->prepare('INSERT INTO LOG VALUES (?,?,?,?,?)'); $st->execute( 3, $today, "DB Created!",0,0); - } + } $st = $db->prepare(selSQLTbl('CAT')); $st->execute(); if(!$st->fetchrow_array()) { @@ -277,17 +277,18 @@ try{ #alter table CONFIG add DESCRIPTION VCHAR(128); my $stmt = qq( - CREATE TABLE CONFIG( - ID TINY PRIMARY KEY NOT NULL, - NAME VCHAR(16), - VALUE VCHAR(28), - DESCRIPTION VCHAR(128) - ); - CREATE INDEX idx_config_name ON CONFIG (NAME); - ); + CREATE TABLE CONFIG( + ID TINY PRIMARY KEY NOT NULL, + NAME VCHAR(16), + VALUE VCHAR(28), + DESCRIPTION VCHAR(128) + ); + CREATE INDEX idx_config_name ON CONFIG (NAME); + ); $rv = $db->do($stmt); $st->finish(); $changed = 1; + } else{ #PRAGMA table_info(CONFIG); <-To check current structure -- 2.34.1