Question

0

98

Views

How to convert line with UNIQUE INDEX key words from mySql to H2

CREATE TABLE IF NOT EXISTS Account (
  `userId` INT NOT NULL AUTO_INCREMENT,
  `first_name` VARCHAR(45) NOT NULL,
  `last_name` VARCHAR(45) NOT NULL,
  `email` VARCHAR(45) NULL,
  `ICQ` INT NULL,
  `home_address` VARCHAR(45) NULL,
  `work_address` VARCHAR(45) NULL,
  `skype` VARCHAR(45) NULL,
  `additional_info` VARCHAR(450) NULL,
  PRIMARY KEY (`userId`))
 UNIQUE INDEX `userID_UNIQUE` (`userId` ASC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account';

how to convert this line: UNIQUE INDEXuserID_UNIQUE(userIdASC) from mySQL syntax to H2 syntax ?

8 months ago · Santiago Trujillo

1 answers

Answer question

0

Answer question

Find remote jobs

Accepted Answer · 2022-05-26T16:10:56.367Z

From the site h2database.com :

ALTER TABLE Account ADD CONSTRAINT userID_UNIQUE UNIQUE(userId);