Need help with a MySQL Table.

[Nipsino]

Could anybody help me create this table in MySql. The code is below.

query_sql "INSERT INTO question(player,type,time,playermap,playerx,playery,feedback) VALUES('"+getcharid(3)+"','"+@supportnum+"',UNIX_TIMESTAMP(),'"+@map$+"',"+@mapx+","+@mapy+",'"+@question$+"')";

[DarkIrata]

If you want use own time format

CREATE TABLE `question` (

`player`  varchar(255) NULL ,
`type`  int(255) NULL ,
`time`  varchar(255) NULL ,
`playermap`  varchar(255) NULL ,
`playerx`  varchar(255) NULL ,
`playery`  varchar(255) NULL ,
`feedback`  varchar(255) NULL
);

like loginlog

CREATE TABLE `question` (

`player`  varchar(255) NULL ,
`type`  int(255) NULL ,
`time`  datetime NULL 
`playermap`  varchar(255) NULL ,
`playerx`  varchar(255) NULL ,
`playery`  varchar(255) NULL ,
`feedback`  varchar(255) NULL
);

Edited June 20, 2012 by Irata