Create Table on Sql?

[PewN]

how can i make a sql table like create a table on a text my sql.

 id | character id | item_id | quantity 

like this

CREATE TABLE IF NOT EXISTS `guildpack` (
 `id` int(11) NOT NULL auto_increment,
 `account_id` int(11) NOT NULL default '0',
 `name` varchar(23) NOT NULL default '',
 `last_ip` varchar(100) NOT NULL default '',
 PRIMARY KEY (`account_id`),
 KEY (`id`)
) ENGINE=MyISAM;

i already make but i don't know if this is correct

CREATE TABLE IF NOT EXISTS `claimreward` (
 `id` int(11) NOT NULL auto_increment,
 `char_id` int(11) NOT NULL default '0',
 `item_id` int(11) NOT NULL default '',
 `quantity` int(11) NOT NULL default '',
 PRIMARY KEY (`character_id`),
 KEY (`id`)
) ENGINE=MyISAM;

Edited September 7, 2012 by bVersatile

[Peopleperson49]

Put this inside your script somewhere. I wrote this at work and it has not been tested, but I think its okay. So somebody please correct if necessary.

Peopleperson49

function createTable { query_sql("CREATE TABLE IF NOT EXISTS `claimreward` (`id` int(11) NOT NULL auto_increment,`char_id` int(11) NOT NULL default '0',`item_id` int(11) NOT NULL default '',`quantity` int(11) NOT NULL default '',PRIMARY KEY (`character_id`),KEY (`id`) ) ENGINE=MyISAM;

OnInit:
createTable();
end;