Update of /cvsroot/openfirst/logger/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv30441/logger/setup
Modified Files:
setup.mysql
Log Message:
Added 1 more table. Required for browser stats.
Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/logger/setup/setup.mysql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** setup.mysql 23 Aug 2003 19:50:17 -0000 1.9
--- setup.mysql 30 Sep 2003 23:48:00 -0000 1.10
***************
*** 1,3 ****
CREATE TABLE IF NOT EXISTS `ofirst_logger` (`ID` int(6) unsigned NOT NULL auto_increment, `IPAddress` tinytext, `Date` tinytext, `Location` tinytext, `QueryString` tinytext, `HostLookup` tinytext, `Browser` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM;
ALTER TABLE ofirst_logger ADD column Member TEXT;
! INSERT INTO ofirst_config SET modulename='logger',showonmenu='0',active='0',adminnavigation='<a href="$basepath/logger/reset.php">Reset Logger</a> | <a href="$basepath/logger/rawdata.php">Raw Data</a>',includes='logger.php';
--- 1,4 ----
CREATE TABLE IF NOT EXISTS `ofirst_logger` (`ID` int(6) unsigned NOT NULL auto_increment, `IPAddress` tinytext, `Date` tinytext, `Location` tinytext, `QueryString` tinytext, `HostLookup` tinytext, `Browser` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM;
+ CREATE TABLE IF NOT EXISTS `ofirst_hitcount` (`ID` int(6) unsigned NOT NULL auto_increment,`Name` tinytext NOT NULL, `Value` int(6) unsigned, PRIMARY KEY (`ID`)) TYPE=MyISAM;
ALTER TABLE ofirst_logger ADD column Member TEXT;
! INSERT INTO ofirst_config SET modulename='logger',showonmenu='0',active='0',adminnavigation='<a href="$basepath/logger/reset.php">Reset Logger</a> | <a href="$basepath/logger/rawdata.php">Raw Data</a>',modulenavigation='<a href="$basepath/logger/index.php">Logger</a> | <a href="$basepath/logger/stats.php">Usage Statistics</a>',includes='logger.php';
|
