Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MYSQL Table Structure
#1
Dear Admin,

When I try to install I get following error. What will be the wrong?

ERROR
SQL query:

-- --------------------------------------------------------
--
-- Table structure for table `tblDocumentContent`
--
CREATE TABLE `tblDocumentContent` (

`document` INT( 11 ) NOT NULL DEFAULT '0',
`version` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`comment` TEXT,
`date` INT( 12 ) DEFAULT NULL ,
`createdBy` INT( 11 ) DEFAULT NULL ,
`dir` VARCHAR( 255 ) NOT NULL DEFAULT '',
`orgFileName` VARCHAR( 150 ) NOT NULL DEFAULT '',
`fileType` VARCHAR( 10 ) NOT NULL DEFAULT '',
`mimeType` VARCHAR( 70 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `document` , `version` )
);

MySQL print:

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
Ok, I solve the problem... Just MyISAM problem Wink
Reply


Messages In This Thread
MYSQL Table Structure - by etastr - 03-03-2010, 10:03 PM

Forum Jump:


Users browsing this thread: