Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 2.5.0b5

Request #12157 Manager changeConstraint()
Submitted: 2007-10-01 04:09 UTC
From: ifeghali Assigned:
Status: Open Package: MDB2 (version CVS)
PHP Version: Irrelevant OS:
Roadmaps: (Not assigned)    
Subscription  


 [2007-10-01 04:09 UTC] ifeghali (Igor Feghali)
Description: ------------ Currently MDB2_Schema doesn't handle schemas with multiple keys defined as a primary key (one being an auto increment field) because MDB2 lack the necessary tool to change a primary key. Please take a look at Bug #12154. Instead of a new method changeConstraint() another approach would be to detect inside createConstraint() when we are trying to create a PRIMARY KEY when one already exists, in this case MDB could assume that we want to replace this key. Expected result: ---------------- Ability to perform such query: ALTER TABLE `wp_options` DROP PRIMARY KEY , ADD PRIMARY KEY ( `option_id` , `blog_id` , `option_name` )

Comments