HELP! VERY BIG PROBLEM!

[chrisbontnewydd]

I accidentally deleted the schedules table from the PHPVMS database, and now I can't add or import routes! What do I do?

[Nabeel]

copy the CREATE TABLE from the install.sql file, or:

CREATE TABLE `phpvms_schedules` (
  `id` int(11) NOT NULL auto_increment,
  `code` char(3) NOT NULL default '',
  `flightnum` varchar(10) NOT NULL default '0',
  `leg` smallint(6) NOT NULL default '1',
  `depicao` varchar(4) NOT NULL default '',
  `arricao` varchar(4) NOT NULL default '',
  `route` text NOT NULL,
  `aircraft` text NOT NULL,
  `distance` float NOT NULL default '0',
  `deptime` varchar(15) NOT NULL default '',
  `arrtime` varchar(15) NOT NULL default '',
  `flighttime` FLOAT NOT NULL default '0',
  `daysofweek` VARCHAR( 7 ) NOT NULL DEFAULT '0123456',
  `maxload` INT(11) NOT NULL,
  `price` FLOAT NOT NULL,
  `flighttype` VARCHAR( 1 ) NOT NULL DEFAULT 'P',
  `timesflown` int(11) NOT NULL default '0',
  `notes` text NOT NULL,
  `enabled` int(11) NOT NULL default '1',
  `bidid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `depicao` (`depicao`),
  KEY `flightnum` (`flightnum`),
  KEY `depicao_arricao` (`depicao`,`arricao`),
  KEY `code` (`code`)
) ENGINE=InnoDB ;

Run that in phpmyadmin. Make sure to change the phpvms_ to your proper table prefix.