تالار گفتمان nCIS.ir

public function up()
	{
            $this->createTable('tbl_project',
                    array(
                    'id' => 'pk',
                    'name' =>'string NOT NULL',
                    'description' =>'text NOT NULL',
                    'create_time' =>'datetime DEFAULT NULL',
                    'create_user_id' =>'int(11) DEFAULT NULL',
                    'update_time' =>'datetime DEFAULT NULL',
                    'update_user_id' =>'int(11) DEFAULT NULL',
                ),
                'ENGINE=InnoDB'    
            );
	}

نقل قول:

and failed to execute the SQL statement: CDbCommand failed
atement: SQLSTATE[HY000]: General error: 1 near "ENGINE": s
statement executed was: CREATE TABLE 'tbl_project' (
"id" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
"name" varchar(255) NOT NULL,
"description" text NOT NULL,
"create_time" datetime DEFAULT NULL,
"create_user_id" int(11) DEFAULT NULL,
"update_time" datetime DEFAULT NULL,
"update_user_id" int(11) DEFAULT NULL
) ENGINE=InnoDB' in D:yiiframeworkdbCDbCommand.php:358