[SQL] Making tables - help

[ond]

Hello, I wonder if someone could help me with making a piece of c++ code into a table to my database, the problem is that I lost my old db and I had to make a new one and then it got lost.

Anyway, this is what I wanna make in to sql:

stmt.setQuery("INSERT INTO `player_frags` (`killer_id`, `killed_id`, `date`) VALUES ");

If I need to add something else, let me know!

Thanks for now : )

 

[Chris]

I have no idea whether this is sufficient enough or not as I have not seen the original table, but this is what I could create by looking at your SQL query.

CREATE TABLE `player_frags` (
     `killer_id` INT(11) NOT NULL,
     `killed_id` INT(11) NOT NULL,
     `date` TIMESTAMP ON UPDATE NOW( )
) ENGINE = InnoDB;

 

[ond]

hey thanks!