[patch]DDL builder to config unique key for ORACLE

[ktz <kazu.ktz.tamura@…>]

I wrote patch DDL builder for oracle. By this patch, it is possible to add uneque key query generation for ORACLE.

I have implemented briefly ,so please review carefully.

Best regards.

[ktz <kazu.ktz.tamura@…>]

patch of DDl generator for oracle

[Carsten]

Hello,

I wonder why this patch has never been approved? "unique" constraints are not supported without this patch and we have Propel 1.5 already.

Any chance to get this on 1.5?

Regards, Carsten

[Carsten]

Some more comments on this:

• "$this->prefixTablename( $table->getName() )" doesn't work - I assume $table->getName() should do.

• To benefit from unique columns, DBAs often generate more indexes containing unique columns. Such indexes are declared as unique and preferred by the oracle optimizer. So, it would be great if indexes were allowed to be unique, too, even if the set of columns do not need an explicit unique constraint (that's checked by the index itself).

Regards, Carsten