Requesting Creating SQL TABLE

[Delta]

query_sql "SELECT `id`,`nameid`,`amount`,`identify`,`refine`,`attribute`,`card0`,`card1`,`card2`,`card3` FROM `reward_table` WHERE `char_id`

[Cydh]

maybe?

CREATE TABLE `reward_table` (

`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,

`char_id` INT(11) UNSIGNED NOT NULL,

`nameid` SMALLINT(5) UNSIGNED NOT NULL,

`amount` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',

`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',

`identify` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',

`attribute` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',

`card0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',

`card1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',

`card2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',

`card3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

) Engine=InnoDB AUTO_INCREMENT=1;

[Delta]

Thanks

 

 

maybe?

CREATE TABLE `reward_table` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`char_id` INT(11) UNSIGNED NOT NULL,
`nameid` SMALLINT(5) UNSIGNED NOT NULL,
`amount` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
`refine` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`identify` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attribute` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`card0` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`card1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`card2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`card3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) Engine=InnoDB AUTO_INCREMENT=1;

 

Thanks cydh it is working now! Is there site that I can read and learn about making sql tables? 

 

btw one last request, I'll send a pm to you. 

[exchisu]

same ask.. but a different.. i need to create a table named feedback on sql too with this values...

 

i dont know sql.. anybody can help me please ?

 feedback(player,type,time,playermap,playerx,playery,feedback,status)