Gents, quick question, I'm trying to create an index in a domain class for MySQL and checking the table the index doesn't get created, it's because MySQL has a max length for the index and it's less than the size of the field/column. Is there a way to define the size of the index over a larger column size?
For instance in MySQL SQL I can do:
CREATE TABLE t1 (
col1 VARCHAR(10),
col2 VARCHAR(4096),
INDEX (col1, col2(10))
);
Is there a DSL to do that?