PhpRiot
News Archive
PhpRiot Newsletter
Your Email Address:

More information

Rob Allen's Blog: Akrabat_Db_Schema_Manager: table prefix support

Note: This article was originally published at PHPDeveloper on 21 June 2010.
PHPDeveloper

Rob Allen has a new post to his blog today talking about an update he's made to the Akrabat_Db_Schema_Manager component for the Zend Framework to allow it to support table prefixes.

I've updated Akrabat_Db_Schema_Manager so that it now supports table prefixes. It uses the application.ini key of resources.db.table_prefix as I couldn't think of a better one :) and then uses that for the schema_version table's name and also makes it available in your change objects.

He illustrates with a sample setting for your application.ini file and some code to handle the creation and deletion of tables using this prefix setting.

Note that you are responsible for using the prefix property as the change classes cannot enforce what you do within the up() and down() methods. It also follows that you'll have to ensure that your models also use the correct prefix.