CREATE TABLE `default_table` (
`biz_id` int(11) NOT NULL auto_increment,
`biz_name` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`city` varchar(100) NOT NULL default '',
`state` varchar(100) NOT NULL default '',
`zip` varchar(20) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`hours` varchar(100) NOT NULL default '',
`details` text NOT NULL,
PRIMARY KEY (`biz_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4167 ;
--
-- Dumping data for table `default_table`
--
INSERT INTO `default_table` VALUES (1, 'Global Air Response', '7355 South Peoria Street, A3/suite 209', 'Englewood', 'CO', '80112', '(800) 971-4351', 'http://www.AirResponse.net', 'admin@airresponse.net', '', 'Mon-Sun: 12:00 AM-12:00 AM', 'n<b>Products & Services:</b><br>n<ul>n<li>air ambulance</li>n<li>Air Ambulance Network</li>n<li>Air Ambulances</li>n<li>Air Intensive Care Units</li>n<li>Air Transport</li>n<li>Bedside to Bedside Transport</li>n<li>Domestic Service</li>n<li>Flight Nurses</li>n<li>Flight Physicians</li>n<li>global medical transport</li>n<li>nIntensive & Critical Care Specialistsn</li>n<li>Inter-Facility Transfers</li>n<li>international air ambulance</li>n<li>International Services</li>n<li>Life Support</li>n<li>medical air</li>n<li>medical transport</li>n<li>nMedical Transportation Specialistsn</li>n<li>medical travel</li>n<li>nNon- Emergency Medical Transportationn</li>n<li>Oxygen Equipped</li>n<li>patient transport</li>n<li>Pediatric Transport</li>n<li>repatriation</li>n<li>Stretcher Transport</li>n<li>Wheelchair Carriers</li>n<li>Wheelchair Transport</li>n</ul>n<br><b>Specialties:</b><br>n<ul>n<li>nInternational Medical Transportn</li>n<li>Patient Transportation</li>n<li>Repatriation</li>n</ul>n<br><b>Payment Options:</b><br>n<ul>n<li>American Express</li>n<li>Debit Cards</li>n<li>Discover</li>n<li>MasterCard</li>n<li>Money Orders</li>n<li>Personal Checks</li>n<li>Travelers Checks</li>n<li>VISA</li>n</ul>n<br><b>Languages Spoken:</b><br>n<ul>n<li>English</li>n<li>French</li>n<li>Spanish</li>n</ul>n<br><b>Certification & Affiliations:</b><br>n<ul>n<li>aerospace Medical Association</li>n<li>nAir Medical Physician Associationn</li>n<li>Certified</li>n<li>nFAA 135 Air Carrier Certificaten</li>n<li>nNational Flight Paramedica Associationn</li>n</ul>n<br><b>Additional Information:</b><br>n<span>Global Air Response is a FAA certified air ambulance provider, which operates long range Learjet. Established in 1986.n</span>');
INSERT INTO `default_table` VALUES (2, 'Demopolis City - Airport', '744 Boykin Field Road', 'Demopolis', 'AL', '36732', '(334) 289-0455', '', '', '', '', '');
INSERT INTO `default_table` VALUES (3, 'Brewton Airport', '205 Airport Drive', 'Brewton', 'AL', '36426', '(251) 867-9997', '', '', '', '', '');
|
HighLeads
