Update of /cvsroot/openfirst/forum/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv28323/setup
Added Files:
setup.mssql setup.mysql
Log Message:
Setup for Forum module. MSSQL script is untested.
--- NEW FILE: setup.mssql ---
CREATE TABLE IF NOT EXISTS `ofirst_forum` (`ID` int(6) unsigned NOT NULL auto_increment, `name` varchar(45) NOT NULL default 'main', `message` tinytext, `subforum` bigint(12) unsigned NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '0', `closed` tinyint(1) default '0', UNIQUE KEY `ID` (`ID`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM;
INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Subforums</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php';
--- NEW FILE: setup.mysql ---
CREATE TABLE IF NOT EXISTS `ofirst_forum` (`ID` int(6) unsigned NOT NULL auto_increment, `name` varchar(45) NOT NULL default 'main', `message` tinytext, `subforum` bigint(12) unsigned NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '0', `closed` tinyint(1) default '0', UNIQUE KEY `ID` (`ID`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM;
CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM;
INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Subforums</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php';
|
