Closed samsond closed 3 years ago
SQL State : 42001 Error Code : 42001 Message : Syntax error in SQL statement "CREATE TABLE ROLE ( ID BIGINT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(64) NOT NULL UNIQUE, CREATE_TIME TIMESTAMP(6) NOT NULL, CREATED_BY VARCHAR(64) NOT NULL, EDIT_TIME TIMESTAMP(6), EDITED_BY VARCHAR(64), INTERNAL_VERSION BIGINT DEFAULT 1 )ENGINE=[*]INNODB"; expected "identifier"; SQL statement: CREATE TABLE ROLE ( ID BIGINT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(64) NOT NULL UNIQUE, CREATE_TIME TIMESTAMP(6) NOT NULL, CREATED_BY VARCHAR(64) NOT NULL, EDIT_TIME TIMESTAMP(6), EDITED_BY VARCHAR(64), INTERNAL_VERSION BIGINT DEFAULT 1 )ENGINE=InnoDB [42001-200] Location : db/migration/V1_1create_tables.sql (/Users/sami/projects/mpp-project/pasteit-services/build/resources/main/db/migration/V1_1create_tables.sql) Line : 1 @rimonmostafiz
SQL State : 42001 Error Code : 42001 Message : Syntax error in SQL statement "CREATE TABLE ROLE ( ID BIGINT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(64) NOT NULL UNIQUE, CREATE_TIME TIMESTAMP(6) NOT NULL, CREATED_BY VARCHAR(64) NOT NULL, EDIT_TIME TIMESTAMP(6), EDITED_BY VARCHAR(64), INTERNAL_VERSION BIGINT DEFAULT 1 )ENGINE=[*]INNODB"; expected "identifier"; SQL statement: CREATE TABLE ROLE ( ID BIGINT PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(64) NOT NULL UNIQUE, CREATE_TIME TIMESTAMP(6) NOT NULL, CREATED_BY VARCHAR(64) NOT NULL, EDIT_TIME TIMESTAMP(6), EDITED_BY VARCHAR(64), INTERNAL_VERSION BIGINT DEFAULT 1 )ENGINE=InnoDB [42001-200] Location : db/migration/V1_1create_tables.sql (/Users/sami/projects/mpp-project/pasteit-services/build/resources/main/db/migration/V1_1create_tables.sql) Line : 1 @rimonmostafiz