[eluser]Unknown[/eluser]
Hi to everyone,
I'm trying to execute a simple query with DBForge, my db is Oracle Express 10g.
This is the code:
$this->load->dbforge();
$fields = array(
'id' => array(
'type' => 'INT',
'constraint' => '5',
'unsigned' => TRUE,
'auto_increment' => TRUE
),
'age' => array(
'type' => 'INT',
'constraint' => '3'
)
);
$this->dbforge->add_field($fields);
$this->dbforge->add_key('id', TRUE);
$this->dbforge->create_table('demo_table', TRUE);
When i try to load this controller, i get this error:
A Database Error Occurred
Error Number: 922
ORA-00922: missing or invalid option
CREATE TABLE IF NOT EXISTS "demo_table" ( "id" INT NOT NULL CONSTRAINT 5, "age" INT NOT NULL CONSTRAINT 3, CONSTRAINT demo_table PRIMARY KEY ("id") )
Filename: C:\Program Files (x86)\EasyPHP-5.3.8.0\www\ci_oracle\system\database\DB_driver.php
Line Number: 366
What do you think? Is there any error in my code or is it a bug?