U++ forum: Welcome to the forum

Multi-column unique index [message #37134]

Tue, 28 August 2012 18:48

dolik.rce
Messages: 1789
Registered: August 2008
Location: Czech Republic

Ultimate Contributor

Hi,

I just noticed (when I needed it Smile

) that MySql package doesn't currently support multi-column unique index. This feature is implemented for Oracle, Postgre and Sqlite, but not for MySql and MSSQL. I am only familiar with MySql, where this can be fixed by adding following code to MySqlSchema.h:

#define DUAL_UNIQUE(k1, k2)        ATTRIBUTE("alter table @t add unique index DQ_@t$" #k1 #k2 " (" #k1 ", " #k2 ");",\
                                             "alter table @t drop index DQ_@t$" #k1 #k2 ";")

#define UNIQUE_LIST(u, l)          ATTRIBUTE("alter table @t add unique index UQ_@t$" #u " (" l ");",\
                                             "alter table @t drop index UQ_@t$" #u ";")

I succesfuly tested this code with 5.5.27, but if I remember correctly it should work even with older versions.

Is there any reason why this was omitted from the schema? If not, can someone please commit it? Smile

Best regards,
Honza

Report message to a moderator