CREATE TABLE `mobilephones` ( `id` bigint(20) NOT NULL auto_increment, `brandname` varchar(255) character set utf8 collate utf8 NOT NULL default '', `model` text character set utf8 collate utf8 NOT NULL, `networkgsm` text character set utf8 collate utf8, `dimension` text character set utf8 collate utf8, `weight` text character set utf8 collate utf8, `displaycolortype` text character set utf8 collate utf8, `displaysize` text character set utf8 collate utf8, `displaycolors` text character set utf8 collate utf8, `batterytype` text character set utf8 collate utf8, `batterycapacity` text character set utf8 collate utf8, `talktime` text character set utf8 collate utf8, `standbytime` text character set utf8 collate utf8, `antenna` text character set utf8 collate utf8, `os` text character set utf8 collate utf8, `osversion` text character set utf8 collate utf8, `gps` text character set utf8 collate utf8, `cameraresolution` text character set utf8 collate utf8, `cameravideocapture` text character set utf8 collate utf8, `cameraflash` text character set utf8 collate utf8, `camerafeatures` text character set utf8 collate utf8, `video` text character set utf8 collate utf8, `videocalling` text character set utf8 collate utf8, `data` text character set utf8 collate utf8, `internetbrowsing` text character set utf8 collate utf8, `usb` text character set utf8 collate utf8, `infrared` text character set utf8 collate utf8, `bluetooth` text character set utf8 collate utf8, `wirelesslan` text character set utf8 collate utf8, `computersyn` text character set utf8 collate utf8, `memory` text character set utf8 collate utf8, `memoryexpansion` text character set utf8 collate utf8, `mms` text character set utf8 collate utf8, `email` text character set utf8 collate utf8, `mp3player` text character set utf8 collate utf8, `radio` text character set utf8 collate utf8, `polyphonicrings` text character set utf8 collate utf8, `vibrationalert` text character set utf8 collate utf8, `alarm` text character set utf8 collate utf8, `calendar` text character set utf8 collate utf8, `calculator` text character set utf8 collate utf8, `phonebookfeatures` text character set utf8 collate utf8, `multiplenumberspercontact` text character set utf8 collate utf8, `multiplelanguage` text character set utf8 collate utf8, `phoneprofiles` text character set utf8 collate utf8, `games` text character set utf8 collate utf8, `java` text character set utf8 collate utf8, `voicedialing` text character set utf8 collate utf8, `voicecommands` text character set utf8 collate utf8, `voicerecording` text character set utf8 collate utf8, `speakerphone` text character set utf8 collate utf8, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1468 ;
