DB [Need help]

[Nineteh]

Back again with another question haha,

I am making a plugin for a support ticket system and just want to know the php code to make a table and the php code to make a column inside of that table.

So far I have:

if ($mybb->settings['ticket_enable'] == 1){
if($db->table_exists("tickets")
    {
        echo "";
    } else {

//code to create table and columns

    }
}

could someone please help me? I know that I will have to have an array of information, e.g:

$columns = array(
'id' => 'varchar(120)'
etc...
);

and the same for the table


Thanks in advance

---

Got it sorted, DM thanks anyway