Author: Skinkie
Link: http://cod
e.campware.org/phorum/read.php?8,4075,4075#msg-4075
------------------------------------------------------------
--------------------
DROP TABLE IF EXISTS `TimeUnits`;
CREATE TABLE `TimeUnits` (
`Unit` char(1) NOT NULL default '',
`IdLanguage` int(10) unsigned NOT NULL default '0',
`Name` varchar(70) NOT NULL default '',
PRIMARY KEY (`Unit`,`IdLanguage`)
) TYPE=MyISAM;
(line: 672)
My MySQL server borks on this piece.
mysql> CREATE TABLE `TopicFields` (
-> `ArticleType` varchar(250) NOT NULL default
'',
-> `FieldName` varchar(250) NOT NULL default '',
-> `RootTopicId` int(10) NOT NULL default '0',
-> PRIMARY KEY (`ArticleType`,`FieldName`)
-> ) TYPE=MyISAM;
ERROR 1071 (42000): Specified key was too long; max key
length is 1000 bytes
--
Sent from Campware Forums
http://code.campware.
org/phorum
|