Re: [campsite-support] Re: sql doesn't work
  • Vote Up0Vote Down importimport
    Posts: 0Member
    Please upgrade your MySQL install.

    Mugur

    wrote: Author: Skinkie
    Link: http://code.campware.org/phorum/read.php?8,4075,4076#msg-4076
    --------------------------------------------------------------------------------

    As reference:

    DROP TABLE IF EXISTS `TopicFields`;
    CREATE TABLE `TopicFields` (
    `ArticleType` varchar(166) NOT NULL default '',
    `FieldName` varchar(166) NOT NULL default '',
    `RootTopicId` int(11) NOT NULL default '0',
    PRIMARY KEY (`ArticleType`,`FieldName`)
    ) TYPE=MyISAM;

    Does work.

    --
    Sent from Campware Forums
    http://code.campware.org/phorum



    ---------------------------------
    Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.