Re: [Campsite Support] Re: sql doesn't work
Mugur Rus <[email protected]> Mon, 22 May 2006 14:48:04 -0700 (PDT)
| Newsgroups | gmane.comp.cms.campsite.general |
|---|---|
| Message-ID | <[email protected]> |
--0-778220122-1148334484=:76529 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Please upgrade your MySQL install. Mugur <[email protected]> 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=3DMyISAM; Does work. --=20 Sent from Campware Forums http://code.campware.org/phorum =09 --------------------------------- Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates= . --0-778220122-1148334484=:76529 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Please upgrade your MySQL install.<br><br>Mugur<br><br><b><i> <phorum@= code.campware.org></i></b> wrote:<blockquote class=3D"replbq" style=3D= "border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left:= 5px;"> Author: Skinkie<br>Link: http://code.campware.org/phorum/read.ph= p?8,4075,4076#msg-4076<br>-----------------------------------------------= ---------------------------------<br><br>As reference:<br><br>DROP TABLE = IF EXISTS `TopicFields`;<br>CREATE TABLE `TopicFields` (<br> `ArticleTyp= e` varchar(166) NOT NULL default '',<br> `FieldName` varchar(166) NOT NU= LL default '',<br> `RootTopicId` int(11) NOT NULL default '0',<br> PRIM= ARY KEY (`ArticleType`,`FieldName`)<br>) TYPE=3DMyISAM;<br><br>Does work= .<br><br>-- <br>Sent from Campware Forums<br>http://code.campware.org/pho= rum<br></blockquote><br><p> <hr size=3D1><a href=3D"http://us.rd.yahoo.com/mail_us/taglines/postman= 3/*http://us.rd.yahoo.com/evt=3D39666/*http://messenger.yahoo.com">Yahoo!= Messenger with Voice.</a> PC-to-Phone calls for ridiculously low rates. --0-778220122-1148334484=:76529--