· 8 years ago · Jan 22, 2018, 05:30 PM
1CREATE TABLE IF NOT EXISTS `aircraft_types` (
2 `id` int(10) unsigned NOT NULL auto_increment,
3 `type` char(1) NOT NULL,
4 `mfgr` varchar(30) default NULL,
5 `model` varchar(30) default NULL,
6 `code` varchar(4) default NULL,
7 `engineqty` tinyint(4) default NULL,
8 `enginetype` char(1) default NULL,
9 `weightclass` char(1) default NULL,
10 `descentrate` varchar(10) default NULL,
11 `serviceceiling` varchar(10) default NULL,
12 `cruisetas` varchar(10) default NULL,
13 PRIMARY KEY (`id`),
14 KEY `code` (`code`)
15) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=752 ;