[Openfirst-cvscommit] logger/setup setup.mysql,1.8,1.9
Brought to you by:
xtimg
From: <xt...@us...> - 2003-08-23 21:01:09
|
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'; |