[Openfirst-cvscommit] logger/setup setup.mssql,1.1,1.2
Brought to you by:
xtimg
From: <i-...@us...> - 2003-09-30 23:47:58
|
Update of /cvsroot/openfirst/logger/setup In directory sc8-pr-cvs1:/tmp/cvs-serv30420/logger/setup Modified Files: setup.mssql Log Message: Added 1 more table. Required for browser stats. Index: setup.mssql =================================================================== RCS file: /cvsroot/openfirst/logger/setup/setup.mssql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** setup.mssql 23 Aug 2003 20:30:12 -0000 1.1 --- setup.mssql 30 Sep 2003 23:47:50 -0000 1.2 *************** *** 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'; |