Marcus Christie created AIRAVATA-2309:
-----------------------------------------
Summary: SHARING table: MySQL complains "Specified key was too
long; max key length is 3072 bytes"
Key: AIRAVATA-2309
URL: https://issues.apache.org/jira/browse/AIRAVATA-2309
Project: Airavata
Issue Type: Bug
Reporter: Marcus Christie
Assignee: Supun Chathuranga Nakandala
Error occurs while trying to create the SHARING table:
{code:sql}
CREATE TABLE SHARING (
PERMISSION_TYPE_ID VARCHAR(255) NOT NULL,
ENTITY_ID VARCHAR(255) NOT NULL,
GROUP_ID VARCHAR(255) NOT NULL,
SHARING_TYPE VARCHAR(255) NOT NULL,
INHERITED_PARENT_ID VARCHAR(255),
CREATED_TIME BIGINT NOT NULL,
UPDATED_TIME BIGINT NOT NULL,
PRIMARY KEY (PERMISSION_TYPE_ID, ENTITY_ID, GROUP_ID, INHERITED_PARENT_ID),
FOREIGN KEY (PERMISSION_TYPE_ID) REFERENCES
PERMISSION_TYPE(PERMISSION_TYPE_ID) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (INHERITED_PARENT_ID) REFERENCES ENTITY(ENTITY_ID) ON DELETE
CASCADE ON UPDATE CASCADE,
FOREIGN KEY (GROUP_ID) REFERENCES USER_GROUP(GROUP_ID) ON DELETE CASCADE ON
UPDATE CASCADE
);
{code}
This key is fine in the dev database on gw62. I think the reason it fails for
me is that my databases have a default encoding of UTF-8. On gw62 the encoding
is latin1_swedish_ci.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
