Can anybody translate this to MySQL ?

[Bomb-Head]

Hi, i am looking at the tut on techtuts.com about the automatic DJ timetable, and in the first bit it says he cant be bothord to write out the mysql so he will just say the rows, but im no good at mysql so would anybody be able to translate this into a mysql query:

create a new table called timetable

rows:

id---------int(10)-----auto_increment
username---varchar(225)
time
date
ip
comments---varchar(225)
name-------varchar(255)


Any helpwould be appreciated so much and +rep will be given.

[Liam.]

Lol here you go:

CREATE TABLE `timetable` (
`id` INT(11) NOT NULL AUTO_INCREMENT ,
`username` text NOT NULL ,
`time` text NOT NULL ,
`date` text NOT NULL ,
`ip` text NOT NULL ,
`comments` text NOT NULL ,
`name` text NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE=MyISAM;


Think thats correct :P <3

[Bomb-Head]

Lol here you go:

CREATE TABLE `timetable` (
`id` INT(11) NOT NULL AUTO_INCREMENT ,
`username` text NOT NULL ,
`time` text NOT NULL ,
`date` text NOT NULL ,
`ip` text NOT NULL ,
`comments` text NOT NULL ,
`name` text NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE=MyISAM;


Think thats correct :P <3

Thank you so much. :D +rep

[Liam.]

no problem