[Openfirst-cvscommit] downloads/setup setup.mysql,1.2,1.2.2.1

[Jamie <ast...@us...>]

Update of /cvsroot/openfirst/downloads/setup
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25250/downloads/setup

Modified Files:
      Tag: REL1_1_BRANCH
	setup.mysql 
Log Message:
All modules install (under MySQL).
Emoticon known to work.

-install.php updated to current method
-problems with auth.php fixed? (Watch auth.php, it's a tricky one)
-ofirst_dbfetch_array() added (Need to port to HEAD)
-var name mismatch fixed in globals.php
-serious updates to logger (no longer tracks total and pagetotal)
-issues with poll removed

Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/downloads/setup/setup.mysql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -d -r1.2 -r1.2.2.1
*** setup.mysql	23 Nov 2003 17:28:19 -0000	1.2
--- setup.mysql	28 Aug 2005 03:43:29 -0000	1.2.2.1
***************
*** 1,3 ****
  CREATE TABLE `ofirst_downloads` (`ID` bigint(12) unsigned NOT NULL auto_increment, `Category` varchar(35) NOT NULL default '', `Title` tinytext NOT NULL, `Description` mediumtext, `mime` tinytext, `ext` tinytext, `DateAdded` date NOT NULL default '0000-00-00', `FileData` longblob NOT NULL, `hits` int(12) default '0',  PRIMARY KEY  (`ID`),  UNIQUE KEY `ID` (`ID`),  KEY `ID_2` (`ID`)) TYPE=MyISAM
  CREATE TABLE `ofirst_downloadcat` (`ID` int(12) NOT NULL auto_increment, `Category` varchar(35) NOT NULL default '', `Description` tinytext, `Icon` tinytext, PRIMARY KEY  (`ID`), UNIQUE KEY `ID` (`ID`,`Category`(12)), KEY `ID_2` (`ID`)) TYPE=MyISAM
! INSERT INTO ofirst_config SET modulename='downloads',showonmenu='0',active='0',adminnavigation='<a href="$basepath/downloads/admin">Category Editor</a>',modulenavigation='<a href="$basepath/downloads/">Downloads Home</a>',includes='';
--- 1,3 ----
  CREATE TABLE `ofirst_downloads` (`ID` bigint(12) unsigned NOT NULL auto_increment, `Category` varchar(35) NOT NULL default '', `Title` tinytext NOT NULL, `Description` mediumtext, `mime` tinytext, `ext` tinytext, `DateAdded` date NOT NULL default '0000-00-00', `FileData` longblob NOT NULL, `hits` int(12) default '0',  PRIMARY KEY  (`ID`),  UNIQUE KEY `ID` (`ID`),  KEY `ID_2` (`ID`)) TYPE=MyISAM
  CREATE TABLE `ofirst_downloadcat` (`ID` int(12) NOT NULL auto_increment, `Category` varchar(35) NOT NULL default '', `Description` tinytext, `Icon` tinytext, PRIMARY KEY  (`ID`), UNIQUE KEY `ID` (`ID`,`Category`(12)), KEY `ID_2` (`ID`)) TYPE=MyISAM
! REPLACE INTO ofirst_config SET modulename='downloads',showonmenu='0',active='0',adminnavigation='<a href="$basepath/downloads/admin">Category Editor</a>',modulenavigation='<a href="$basepath/downloads/">Downloads Home</a>',includes='';