Comments - Too many key parts specified; max 16 parts allowed

3 years, 11 months ago John Kimathi
This comment has the status of 'removed' and can only be seen by you.

The dump file was generated while converting MsSQL to MySQL using MySQL Workbench.

Line 129 is highlighted in bold below.

Please note that there are several other columns following the last column in the snipette below, i.e `StatusCode` INT NULL,

-- ----------------------------------------------------------------------------
-- Table GTASA_MSCRM.OpportunityBase
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `GTASA_MSCRM`.`OpportunityBase` (
  `OpportunityId` VARCHAR(64) NOT NULL,
  `PriceLevelId` VARCHAR(64) NULL,
  `OpportunityRatingCode` INT NULL,
  `PriorityCode` INT NULL,
  `Name` VARCHAR(300) CHARACTER SET 'utf8mb4' NULL,
  `StepId` VARCHAR(64) NULL,
  `Description` LONGTEXT CHARACTER SET 'utf8mb4' NULL,
  `EstimatedValue` DECIMAL(19,4) NULL,
  `StepName` VARCHAR(200) CHARACTER SET 'utf8mb4' NULL,
  `SalesStageCode` INT NULL,
  `ParticipatesInWorkflow` TINYINT(1) NULL DEFAULT 0,
  `PricingErrorCode` INT NULL,
  `EstimatedCloseDate` DATETIME(6) NULL,
  `CloseProbability` INT NULL,
  `ActualValue` DECIMAL(19,4) NULL,
  `ActualCloseDate` DATETIME(6) NULL,
  `OwningBusinessUnit` VARCHAR(64) NULL,
  `OriginatingLeadId` VARCHAR(64) NULL,
  `CreatedOn` DATETIME(6) NULL,
  `IsPrivate` TINYINT(1) NULL DEFAULT 0,
  `CreatedBy` VARCHAR(64) NULL,
  `ModifiedOn` DATETIME(6) NULL,
  `ModifiedBy` VARCHAR(64) NULL,
  `VersionNumber` VARBINARY(8) NULL,
  `StateCode` INT NOT NULL,
  `StatusCode` INT NULL,
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.