The attached patch adds a db_rename function to allow tables to be renamed.

CommentFileSizeAuthor
db_rename.patch1.65 KBdrewish

Comments

nedjo’s picture

nedjo
he/him/his
Primary language English
commented

+1, this would be a useful addition.

The patch http://drupal.org/node/140860 to get consistent table names in core would use this.

MySQL supports a RENAME TABLE syntax. Is the ALTER TABLE syntax used in the patch equally supported?

drewish’s picture

drewish commented

good question. it is supported by both mysql 4.1 and 5.0+. i've found it supported for postgresql versions back to 7.3.

bjaspan’s picture

bjaspan commented
Status: Needs review » Reviewed & tested by the community

This is a good addition to the API. Tested on MySQL and PostgresQL, works fine.

dries’s picture

dries commented
Status: Reviewed & tested by the community » Fixed

Committed to CVS HEAD. Thanks.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)