queryii manipulate database from yii shell

  1. Install
  2. Requirements
  3. Forum
  4. Usage
  5. Change Log

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
7 0
5 followers
419 downloads
Yii Version: 1.1
License: BSD-2-Clause
Category: Database
Developed by: sensorario
Created on: Dec 31, 2011
Last updated: 6 years ago

Downloads

show all

Related Extensions