[latest new] Exporting flight log online to VA

[DanSteph]

Success !! First flight registred in a SQL database...


For those that know SQL here is how the flights table look... not a tiny one

Code:

CREATE TABLE flights (
  id int(16) unsigned NOT NULL auto_increment,
  datestamp datetime NOT NULL default '0000-00-00 00:00:00',
  UserName varchar(22) NOT NULL default '',
  CompanyName varchar(35) NOT NULL default '',
  PilotName varchar(35) NOT NULL default '',
  FlightId varchar(10) NOT NULL default '',
  OnlineNetworkNbr tinyint(4) NOT NULL default '0',
  FlightDate date NOT NULL default '0000-00-00',
  AircraftName varchar(50) NOT NULL default '',
  AircraftType varchar(5) NOT NULL default '',
  NbrPassengers smallint(2) NOT NULL default '0',
  CargoWeight varchar(15) NOT NULL default '',
  Mtow varchar(15) NOT NULL default '',
  StartAircraftWeight varchar(15) NOT NULL default '',
  EndAircraftWeight varchar(15) NOT NULL default '',
  StartFuelQuantity varchar(15) NOT NULL default '',
  EndFuelQuantity varchar(15) NOT NULL default '',
  DepartureIcaoName varchar(50) NOT NULL default '',
  ArrivalIcaoName varchar(50) NOT NULL default '',
  DepartureLocalHour time NOT NULL default '00:00:00',
  ArrivalLocalHour time NOT NULL default '00:00:00',
  DepartureGmtHour time NOT NULL default '00:00:00',
  ArrivalGmtHour time NOT NULL default '00:00:00',
  TotalBlockTime time NOT NULL default '00:00:00',
  TotalBlockTimeNight time NOT NULL default '00:00:00',
  TotalAirbornTime time NOT NULL default '00:00:00',
  TotalTimeOnGround time NOT NULL default '00:00:00',
  MaxAltitude varchar(15) NOT NULL default '',
  CruiseSpeed varchar(15) NOT NULL default '',
  CruiseMachSpeed varchar(15) NOT NULL default '',
  CruiseTimeStartSec time NOT NULL default '00:00:00',
  CruiseTimeStopSec time NOT NULL default '00:00:00',
  CruiseFuelStart varchar(15) NOT NULL default '',
  CruiseFuelStop varchar(15) NOT NULL default '',
  LandingSpeed varchar(15) NOT NULL default '',
  LandingPitch varchar(15) NOT NULL default '',
  TouchDownVertSpeedFt float NOT NULL default '0',
  CaptainSentMayday tinyint(3) NOT NULL default '0',
  CrashFlag tinyint(3) NOT NULL default '0',
  FlightResult varchar(15) NOT NULL default '',
  PassengersOpinion tinyint(4) NOT NULL default '0',
  PassengersOpinionText text NOT NULL,
  FailureText text NOT NULL,
  CasualtiesText text NOT NULL,
  PilotBonusText text NOT NULL,
  BonusPoints int(10) NOT NULL default '0',
  PilotPenalityText text NOT NULL,
  PenalityPoints int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY datestamp (datestamp),
  KEY UserName (UserName),
  KEY CompanyName (CompanyName),
  KEY PilotName (PilotName),
  KEY AircraftName (AircraftName)
) TYPE=MyISAM;