queryii Follow @yiiframework

Create, drop, truncate table using yii shell command.phpmyadmin and others instruments are not necessary with queryii.

Install ¶

Extract QueryiiCommand.php into /protected/commands/shell folder of your application.

Requirements ¶

Yii 1.1 or above

Forum ¶

http://www.yiiframework.com/forum/index.php?/topic/27262-extension-queryii/

Usage ¶

Execute yii console and run these command:

queryii alter <table-name> add <column-type> <column-name>
queryii alter <table-name> drop <column-name>
queryii alter <table-name> change <column-name> <column-type>

queryii create <table-name>

queryii custom user
queryii custom rbac

queryii drop <table-name>

queryii help
queryii help alter

queryii rename <table-name>

queryii truncate <table-name>

Change Log ¶

v0.3 (January 2nd, 2011) ¶

• rename table
• added phpdoc comments

v0.2 (January 2nd, 2011) ¶

• change type of a field
• custom commands (for user and rbac tables)

v0.1 (December 31, 2011) ¶

• create table
• drop table
• truncate table
• add or drop field from a table