How to create table in Codeigniter?

1
2
3

$this->load->database();

$this->db->query("CREATE TABLE IF NOT EXISTS my_table (id INT, name VARCHAR(50))");

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

$this->load->dbforge();

$fields = array(
        'id' => array(
                'type' => 'INT',
                'constraint' => 5,
                'unsigned' => TRUE,
                'auto_increment' => TRUE
        ),
        'name' => array(
                'type' => 'VARCHAR',
                'constraint' => '100',
        ),
        'email' => array(
                'type' => 'VARCHAR',
                'constraint' => '100',
                'null' => TRUE,
        ),
);

$this->dbforge->add_field($fields);
$this->dbforge->add_key('id', TRUE);
$this->dbforge->create_table('my_table');