Error message but don't why

[G-BAzz]

I have copied script that came with a program, the idea is to copy and past into SQL to create tables but when I do I get the following error message yet I can not see what exactly what is wrong, (Running PHP5)

Error
SQL query:

CREATE TABLE pirep(

IDPIREP varchar( 255 ) NOT NULL default '',
CreatedOntimestamp/COLOR default NULL ,
IDPilot varchar( 255 ) default NULL ,
PilotName varchar( 255 ) default NULL ,
AircraftTitle varchar( 255 ) default NULL ,
AircraftType varchar( 255 ) default NULL ,
TailNumber varchar( 255 ) default NULL ,
Airline varchar( 255 ) default NULL ,
FlightNumber varchar( 255 ) default NULL ,
FlightType varchar( 255 ) default NULL ,
FlightLevel varchar( 255 ) default NULL ,
Passenger varchar( 255 ) default NULL ,
Cargo varchar( 255 ) default NULL ,
ZFW varchar( 255 ) default NULL ,
OriginAirport varchar( 255 ) default NULL ,
OriginGate varchar( 255 ) default NULL ,
OriginRunway varchar( 255 ) default NULL ,
OriginTA varchar( 255 ) default NULL ,
DestinationAirport varchar( 255 ) default NULL ,
DestinationGate varchar( 255 ) default NULL ,
DestinationRunway varchar( 255 ) default NULL ,
DestinationTA varchar( 255 ) default NULL ,
AlternateAirport varchar( 255 ) default NULL ,
SID varchar( 255 ) default NULL ,
STAR varchar( 255 ) default NULL ,
DistanceFlight varchar( 255 ) default NULL ,
DistanceRoute varchar( 255 ) default NULL ,
OUTTime varchar( 255 ) default NULL ,
OFFTime varchar( 255 ) default NULL ,
ONTime varchar( 255 ) default NULL ,
INTime varchar( 255 ) default NULL ,
BlockTime varchar( 255 ) default NULL ,
FlightTime varchar( 255 ) default NULL ,
DayFlightTime varchar( 255 ) default NULL ,
NightFlightTime varchar( 255 ) default NULL ,
BlockFuel varchar( 255 ) default NULL ,
FlightFuel varchar( 255 ) default NULL ,
TakeoffIAS varchar( 255 ) default NULL ,
LandingIAS varchar( 255 ) default NULL ,
LandingVS varchar( 255 ) default NULL ,
FlightMapJPG varchar( 255 ) default NULL ,
FlightMapWeatherJPG varchar( 255 ) default NULL ,
FlightMapTaxiOutJPG varchar( 255 ) default NULL ,
FlightMapTaxiInJPG varchar( 255 ) default NULL ,
FlightScore varchar( 255 ) default NULL ,
FlightCritique text,
FlightPlan text,
COMMENT text,
PRIMARY KEY ( IDPIREP )
) TYPE = MYISAM

MySQL said:

#1067 - Invalid default value for 'CreatedOn'

[NogDog]

Per the manual, "If a DEFAULT value is specified for the first TIMESTAMP column in a table, it is not ignored. The default can be CURRENT_TIMESTAMP or a constant date and time value." So it would appear that NULL is not valid.

[G-BAzz]

Sorry for any trouble but new to PHP scripting and I am pulling my hair out at the moment,

I have tried various ways of changing the script but nothing seem to come back OK and keep getting an error, any ideas where the following is going wrong?

IDPIREP varchar( 255 ) NOT NULL default '',
CreatedOncurrent_timestamp( 14 ) NULL default,
IDPilot varchar( 255 ) default NULL ,
PilotName varchar( 255 ) default NULL ,
AircraftTitle varchar( 255 ) default NULL ,
AircraftType varchar( 255 ) default NULL ,
TailNumber varchar( 255 ) default NULL ,
Airline varchar( 255 ) default NULL ,

(this is just the first 8 lines of script)

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'current_timestamp(14) NULL default ,
IDPilot varchar(255) default NULL,
Pi' at line 3

[HalfaBee]

Put a space between CreatedOn and timestamp

[NogDog]

CreatedOn  TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,

[G-BAzz]

The last script worked, many thanks