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

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

Line 129 is the one below that goes like....... CREATE TABLE IF NOT EXISTS `KIMATHI`.`OpportunityBase` (

See the snipette below.

<<code [inline={true}] [indent=L] [wrap={true}]>>
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,
<</code>>
Also note there are several other columns that follow the last column 
 
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.