A Yii migration to create RBAC tables in the currently configured database.

yii-rbac-tables-migration.php

<?php

class m140108_152635_create_rbac_tables extends CDbMigration {

    public function up() {
        $this->createTable('AuthItem', array(
            'name' => 'string NOT NULL',
            'type' => 'integer NOT NULL',
            'description' => 'text',
            'bizrule' => 'text',
            'data' => 'text',
        ));
        $this->addPrimaryKey('auth_item_pk', 'AuthItem', 'name');

        $this->createTable('AuthItemChild', array(
            'parent' => 'string NOT NULL',
            'child' => 'string NOT NULL',
        ));
        $this->addPrimaryKey('auth_item_child_pk', 'AuthItemChild', 'parent, child');
        $this->addForeignKey('auth_item_child_parent_fk', 'AuthItemChild', 'parent', 'AuthItem', 'name', 'CASCADE', 'CASCADE');
        $this->addForeignKey('auth_item_child_child_fk', 'AuthItemChild', 'child', 'AuthItem', 'name', 'CASCADE', 'CASCADE');

        $this->createTable('AuthAssignment', array(
            'itemname' => 'string NOT NULL',
            'userid' => 'string NOT NULL',
            'bizrule' => 'text',
            'data' => 'text',
        ));
        $this->addPrimaryKey('auth_assignment_pk', 'AuthAssignment', 'itemname, userid');
        $this->addForeignKey('auth_assignment_item_fk', 'AuthAssignment', 'itemname', 'AuthItem', 'name', 'CASCADE', 'CASCADE');
    }

    public function down() {
        $this->dropTable('AuthAssignment');
        $this->dropTable('AuthItemChild');
        $this->dropTable('AuthItem');
    }
}