CREATE TABLE Administrators (
  MemberNo smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (MemberNo)
) TYPE=MyISAM;


INSERT INTO Administrators VALUES (1);


CREATE TABLE AircraftData (
  NNo varchar(6) NOT NULL default '',
  Year varchar(4) default NULL,
  MakeModel varchar(30) NOT NULL default '',
  Category enum('Airplane','Glider','Rotorcraft','LTA') default NULL,
  Class enum('Single-Engine Land','Single-Engine Sea','Multi-Engine Land','Multi-Engine Sea','Glider') default NULL,
  HP tinyint(4) NOT NULL default '0',
  Complex tinyint(4) NOT NULL default '0',
  Tailwheel tinyint(4) NOT NULL default '0',
  EngineSize smallint(6) default NULL,
  FuelCapacity smallint(6) default NULL,
  IFRVFR enum('IFR/VFR','VFR Only') default NULL,
  DayNight enum('Day/Night','Day Only') default NULL,
  MinPQ tinytext,
  EmptyWeight smallint(6) default NULL,
  GrossWeight smallint(6) default NULL,
  Arm decimal(8,2) default NULL,
  Rate decimal(6,2) default NULL,
  Status enum('Up','Down') default NULL,
  ImageURL varchar(50) default NULL,
  PRIMARY KEY  (NNo)
) TYPE=MyISAM;


CREATE TABLE CFIs (
  InstructorNo smallint(5) unsigned NOT NULL default '0',
  InstructionGiven smallint(5) unsigned NOT NULL default '0',
  Comments tinytext,
  PRIMARY KEY  (InstructorNo)
) TYPE=MyISAM;


CREATE TABLE Members (
  MemberNo smallint(5) unsigned NOT NULL auto_increment,
  EMail varchar(50) default NULL,
  LastName varchar(20) default NULL,
  FirstName varchar(20) default NULL,
  CertNo varchar(9) NOT NULL default '0',
  Street varchar(30) default NULL,
  City varchar(30) default NULL,
  State enum('AL','AK','AZ','AR','CA','CO','CT','DE','DC','FL','GA','HI','ID','IL','IN','IA','KS','KY','LA','ME','MD','MA','MI','MN','MS','MO','MT','NE','NV','NH','NJ','NM','NY','NC','ND','OH','OK','OR','PA','RI','SC','SD','TN','TX','UT','VT','VA','WA','WV','WI','WY') default NULL,
  Zip varchar(5) default NULL,
  HomePhone varchar(13) default 'None',
  WorkPhone varchar(13) default 'None',
  CellPhone varchar(13) default 'None',
  Pager varchar(13) default 'None',
  Grounded tinyint(4) NOT NULL default '1',
  Pass varchar(50) default NULL,
  PRIMARY KEY  (MemberNo)
) TYPE=MyISAM;


INSERT INTO Members VALUES (1,'','Administrator','Club','0','','','AK','','','','','',0,'Clq1FUnQNP78c');


CREATE TABLE PilotCert (
  CertNo char(9) NOT NULL default '',
  CertType enum('none','Student','Recreational','Private','Commercial','CFI','ATP') default NULL,
  Airplane tinyint(4) NOT NULL default '0',
  Glider tinyint(4) NOT NULL default '0',
  Rotorcraft tinyint(4) NOT NULL default '0',
  LTA tinyint(4) NOT NULL default '0',
  SingleEngine tinyint(4) NOT NULL default '0',
  MultiEngine tinyint(4) NOT NULL default '0',
  Land tinyint(4) NOT NULL default '0',
  Sea tinyint(4) NOT NULL default '0',
  Instrument tinyint(4) NOT NULL default '0',
  HP tinyint(4) NOT NULL default '0',
  Complex tinyint(4) NOT NULL default '0',
  Tailwheel tinyint(4) NOT NULL default '0',
  TotalTime smallint(6) NOT NULL default '0',
  PRIMARY KEY  (CertNo)
) TYPE=MyISAM;



INSERT INTO PilotCert VALUES ('0','none',0,0,0,0,0,0,0,0,0,0,0,0,0);


CREATE TABLE Schedule (
  NNo char(6) NOT NULL default '',
  ScdFrom datetime NOT NULL default '0000-00-00 00:00:00',
  ScdTo datetime NOT NULL default '0000-00-00 00:00:00',
  MemberNo smallint(5) unsigned NOT NULL default '0'
) TYPE=MyISAM;