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

1 month, 3 weeks ago John Kimathi
This comment has the status of 'removed' and can only be seen by you.

The snipette is part of dump file that I 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.

-- ----------------------------------------------------------------------------
-- Table KIMATHI.OpportunityBase
-- ----------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `KIMATHI`.`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,

please note there are several more columns below
.
.
.
.
.
.
.
.

 
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.