Update of /cvsroot/openfirst/logger/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv8822
Modified Files:
setup.mysql
Log Message:
Add member column, as required by new functionality.
Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/logger/setup/setup.mysql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** setup.mysql 28 Jun 2003 16:08:38 -0000 1.8
--- setup.mysql 23 Aug 2003 19:50:17 -0000 1.9
***************
*** 1,2 ****
! CREATE TABLE `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;
! 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';
\ No newline at end of file
--- 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';
|
