Yii 1.1: queryii

manipulate database from yii shell
6 followers

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

Be the first person to leave a comment

Please to leave your comment.

Create extension