SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `languages`
-- ----------------------------
DROP TABLE IF EXISTS `languages`;
CREATE TABLE `languages` (
  `id` int(11) NOT NULL auto_increment,
  `name` mediumtext NOT NULL,
  `short` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `languages`
-- ----------------------------
BEGIN;
INSERT INTO `languages` VALUES ('1', 'English', 'en'), ('2', 'German', 'de'), ('3', 'French', 'fr'), ('4', 'Dutch', 'nl'), ('5', 'Italian', 'it'), ('6', 'Spanish', 'es'), ('7', 'Polish', 'pl'), ('8', 'Russian', 'ru'), ('9', 'Japanese', 'ja'), ('10', 'Portuguese', 'pt'), ('11', 'Swedish', 'sv'), ('12', 'Chinese', 'zh'), ('13', 'Catalan', 'ca'), ('14', 'Ukrainian', 'uk'), ('15', 'Norwegian (Bokmål)', 'no'), ('16', 'Finnish', 'fi'), ('17', 'Vietnamese', 'vi'), ('18', 'Czech', 'cs'), ('19', 'Hungarian', 'hu'), ('20', 'Korean', 'ko'), ('21', 'Indonesian', 'id'), ('22', 'Turkish', 'tr'), ('23', 'Romanian', 'ro'), ('24', 'Persian', 'fa'), ('25', 'Arabic', 'ar'), ('26', 'Danish', 'da'), ('27', 'Esperanto', 'eo'), ('28', 'Serbian', 'sr'), ('29', 'Lithuanian', 'lt'), ('30', 'Slovak', 'sk'), ('31', 'Malay', 'ms'), ('32', 'Hebrew', 'he'), ('33', 'Bulgarian', 'bg'), ('34', 'Slovenian', 'sl'), ('35', 'Volapük', 'vo'), ('36', 'Kazakh', 'kk'), ('37', 'Waray-Waray', 'war'), ('38', 'Basque', 'eu'), ('39', 'Croatian', 'hr'), ('40', 'Hindi', 'hi'), ('41', 'Estonian', 'et'), ('42', 'Azerbaijani', 'az'), ('43', 'Galician', 'gl'), ('44', 'Simple English', 'simple'), ('45', 'Norwegian (Nynorsk)', 'nn'), ('46', 'Thai', 'th'), ('47', 'Newar / Nepal Bhasa', 'new'), ('48', 'Greek', 'el'), ('49', 'Aromanian', 'roa-rup'), ('50', 'Latin', 'la'), ('51', 'Occitan', 'oc'), ('52', 'Tagalog', 'tl'), ('53', 'Haitian', 'ht'), ('54', 'Macedonian', 'mk'), ('55', 'Georgian', 'ka'), ('56', 'Serbo-Croatian', 'sh'), ('57', 'Telugu', 'te'), ('58', 'Piedmontese', 'pms'), ('59', 'Cebuano', 'ceb'), ('60', 'Tamil', 'ta'), ('61', 'Belarusian (Taraškievica)', 'be-x-old'), ('62', 'Breton', 'br'), ('63', 'Latvian', 'lv'), ('64', 'Javanese', 'jv'), ('65', 'Albanian', 'sq'), ('66', 'Belarusian', 'be'), ('67', 'Marathi', 'mr'), ('68', 'Welsh', 'cy'), ('69', 'Luxembourgish', 'lb'), ('70', 'Icelandic', 'is'), ('71', 'Bosnian', 'bs'), ('72', 'Yoruba', 'yo'), ('73', 'Malagasy', 'mg'), ('74', 'Aragonese', 'an'), ('75', 'Bishnupriya Manipuri', 'bpy'), ('76', 'Lombard', 'lmo'), ('77', 'West Frisian', 'fy'), ('78', 'Bengali', 'bn'), ('79', 'Ido', 'io'), ('80', 'Swahili', 'sw'), ('81', 'Gujarati', 'gu'), ('82', 'Malayalam', 'ml'), ('83', 'Western Panjabi', 'pnb'), ('84', 'Afrikaans', 'af'), ('85', 'Low Saxon', 'nds'), ('86', 'Sicilian', 'scn'), ('87', 'Urdu', 'ur'), ('88', 'Kurdish', 'ku'), ('89', 'Cantonese', 'zh-yue'), ('90', 'Armenian', 'hy'), ('91', 'Quechua', 'qu'), ('92', 'Sundanese', 'su'), ('93', 'Nepali', 'ne'), ('94', 'Zazaki', 'diq'), ('95', 'Asturian', 'ast'), ('96', 'Tatar', 'tt'), ('97', 'Neapolitan', 'nap'), ('98', 'Irish', 'ga'), ('99', 'Chuvash', 'cv'), ('100', 'Samogitian', 'bat-smg'), ('101', 'Walloon', 'wa'), ('102', 'Amharic', 'am'), ('103', 'Kannada', 'kn'), ('104', 'Alemannic', 'als'), ('105', 'Buginese', 'bug'), ('106', 'Burmese', 'my'), ('107', 'Interlingua', 'ia');
COMMIT;

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `languages`
-- ----------------------------
DROP TABLE IF EXISTS `languages`;
CREATE TABLE `languages` (
  `id` int(11) NOT NULL auto_increment,
  `name` mediumtext NOT NULL,
  `local` mediumtext NOT NULL,
  `short` mediumtext NOT NULL,
  `active` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `languages`
-- ----------------------------
BEGIN;
INSERT INTO `languages` VALUES ('1', 'English', 'English', 'en', '0'), ('2', 'German', 'Deutsch', 'de', '0'), ('3', 'French', 'Fran���§ais', 'fr', '0'), ('4', 'Dutch', 'Nederlands', 'nl', '0'), ('5', 'Italian', 'Italiano', 'it', '0'), ('6', 'Spanish', 'Espa���±ol', 'es', '0'), ('7', 'Polish', 'Polski', 'pl', '0'), ('8', 'Russian', '��� ������������º���¸���¹', 'ru', '0'), ('9', 'Japanese', '�¦ï¿½�¥�¦ï¿½�¬�¨�ªï¿½', 'ja', '0'), ('10', 'Portuguese', 'Portugu���ªs', 'pt', '0'), ('11', 'Swedish', 'Svenska', 'sv', '0'), ('12', 'Chinese', '�¤�¸�­�¦ï¿½ï¿½', 'zh', '0'), ('13', 'Catalan', 'Catal��� ', 'ca', '0'), ('14', 'Ukrainian', '���£���º������°������½���������º���°', 'uk', '0'), ('15', 'Norwegian (Bokm���¥l)', 'Norsk (Bokm���¥l)', 'no', '0'), ('16', 'Finnish', 'Suomi', 'fi', '0'), ('17', 'Vietnamese', 'Ti�¡�º�¿ng Vi�¡�»ï¿½t', 'vi', '0'), ('18', 'Czech', '���e���¡tina', 'cs', '0'), ('19', 'Hungarian', 'Magyar', 'hu', '0'), ('20', 'Korean', '�­ï¿½ï¿½�ª�µ�­�¬ï¿½�´', 'ko', '0'), ('21', 'Indonesian', 'Bahasa Indonesia', 'id', '0'), ('22', 'Turkish', 'T���¼rk���§e', 'tr', '0'), ('23', 'Romanian', 'Rom���¢n���', 'ro', '0'), ('24', 'Persian', '������§���±���³���', 'fa', '0'), ('25', 'Arabic', '���§������¹���±���¨������©', 'ar', '0'), ('26', 'Danish', 'Dansk', 'da', '0'), ('27', 'Esperanto', 'Esperanto', 'eo', '0'), ('28', 'Serbian', '���¡������¿������º���¸ / Srpski', 'sr', '0'), ('29', 'Lithuanian', 'Lietuvi���³', 'lt', '0'), ('30', 'Slovak', 'Sloven���ina', 'sk', '0'), ('31', 'Malay', 'Bahasa Melayu', 'ms', '0'), ('32', 'Hebrew', '���¢������¨������ª', 'he', '0'), ('33', 'Bulgarian', '���������»���³���°���������º���¸', 'bg', '0'), ('34', 'Slovenian', 'Sloven���¡���ina', 'sl', '0'), ('35', 'Volap���¼k', 'Volap���¼k', 'vo', '0'), ('36', 'Kazakh', '������°���·���°���������°', 'kk', '0'), ('37', 'Waray-Waray', 'Winaray', 'war', '0'), ('38', 'Basque', 'Euskara', 'eu', '0'), ('39', 'Croatian', 'Hrvatski', 'hr', '0'), ('40', 'Hindi', '� �¤�¹� �¤�¿� �¤�¨� �¥ï¿½� �¤�¦� �¥ï¿½', 'hi', '0'), ('41', 'Estonian', 'Eesti', 'et', '0'), ('42', 'Azerbaijani', 'Az���rbaycanca', 'az', '0'), ('43', 'Galician', 'Galego', 'gl', '0'), ('44', 'Simple English', 'Simple English', 'simple', '0'), ('45', 'Norwegian (Nynorsk)', 'Nynorsk', 'nn', '0'), ('46', 'Thai', '� �¹ï¿½� �¸ï¿½� �¸�¢', 'th', '0'), ('47', 'Newar / Nepal Bhasa', '� �¤�¨� �¥ï¿½� �¤�ª� �¤�¾� �¤�² � �¤�­� �¤�¾� �¤�·� �¤�¾', 'new', '0'), ('48', 'Greek', '������»���»���·���½���¹���º���¬', 'el', '0'), ('49', 'Aromanian', 'Arm���£neashce', 'roa-rup', '0'), ('50', 'Latin', 'Latina', 'la', '0'), ('51', 'Occitan', 'Occitan', 'oc', '0'), ('52', 'Tagalog', 'Tagalog', 'tl', '0'), ('53', 'Haitian', 'Kr���¨yol ayisyen', 'ht', '0'), ('54', 'Macedonian', '������°���º���µ���´���¾���½������º���¸', 'mk', '0'), ('55', 'Georgian', '�¡ï¿½�¥�¡ï¿½ï¿½�¡ï¿½� �¡ï¿½ï¿½�¡ï¿½�£�¡ï¿½ï¿½�¡ï¿½ï¿½', 'ka', '0'), ('56', 'Serbo-Croatian', 'Srpskohrvatski / ���¡������¿������º���¾���������²���°���������º���¸', 'sh', '0'), ('57', 'Telugu', '� �°�¤� �±ï¿½� �°�²� �±ï¿½� �°ï¿½� �±ï¿½', 'te', '0'), ('58', 'Piedmontese', 'Piemont���¨is', 'pms', '0'), ('59', 'Cebuano', 'Sinugboanong Binisaya', 'ceb', '0'), ('60', 'Tamil', '� �®�¤� �®�®� �®�¿� �®�´� �¯ï¿½', 'ta', '0'), ('61', 'Belarusian (Tara���¡kievica)', '������µ���»���°������������º���°��� (������°������°������º���µ���²���������°)', 'be-x-old', '0'), ('62', 'Breton', 'Brezhoneg', 'br', '0'), ('63', 'Latvian', 'Latvie���¡u', 'lv', '0'), ('64', 'Javanese', 'Basa Jawa', 'jv', '0'), ('65', 'Albanian', 'Shqip', 'sq', '0'), ('66', 'Belarusian', '������µ���»���°������������º���°���', 'be', '0'), ('67', 'Marathi', '� �¤�®� �¤�°� �¤�¾� �¤� � �¥ï¿½', 'mr', '0'), ('68', 'Welsh', 'Cymraeg', 'cy', '0'), ('69', 'Luxembourgish', 'L���«tzebuergesch', 'lb', '0'), ('70', 'Icelandic', '���slenska', 'is', '0'), ('71', 'Bosnian', 'Bosanski', 'bs', '0'), ('72', 'Yoruba', 'Yor���¹b���¡', 'yo', '0'), ('73', 'Malagasy', 'Malagasy', 'mg', '0'), ('74', 'Aragonese', 'Aragon���©s', 'an', '0'), ('75', 'Bishnupriya Manipuri', '� �¦ï¿½� �¦�®� �¦�¾� �¦�° � �¦� � �¦�¾� �¦�°/� �¦�¬� �¦�¿� �¦�·� �§ï¿½� �¦�£� �§ï¿½� �¦�ª� �§ï¿½� �¦�°� �¦�¿� �¦�¯� �¦�¼� �¦�¾ � �¦�®� �¦�£� �¦�¿� �¦�ª� �§ï¿½� �¦�°� �§ï¿½', 'bpy', '0'), ('76', 'Lombard', 'Lumbaart', 'lmo', '0'), ('77', 'West Frisian', 'Frysk', 'fy', '0'), ('78', 'Bengali', '� �¦�¬� �¦�¾� �¦ï¿½� �¦�²� �¦�¾', 'bn', '0'), ('79', 'Ido', 'Ido', 'io', '0'), ('80', 'Swahili', 'Kiswahili', 'sw', '0'), ('81', 'Gujarati', '� �ªï¿½� �«ï¿½� �ªï¿½� �ª�°� �ª�¾� �ª�¤� �«ï¿½', 'gu', '0'), ('82', 'Malayalam', '� �´�®� �´�²� �´�¯� �´�¾� �´�³� �´ï¿½', 'ml', '0'), ('83', 'Western Panjabi', '���´���§��� ������©���¾��� ���¾������¬���§���¨��� (Sh���hmukh���« Pa���±j���b���«)', 'pnb', '0'), ('84', 'Afrikaans', 'Afrikaans', 'af', '0'), ('85', 'Low Saxon', 'Plattd���¼���¼tsch', 'nds', '0'), ('86', 'Sicilian', 'Sicilianu', 'scn', '0'), ('87', 'Urdu', '���§���±���¯���', 'ur', '0'), ('88', 'Kurdish', 'Kurd���® / ���������±���¯���', 'ku', '0'), ('89', 'Cantonese', '�§�²�µ�¨�ªï¿½', 'zh-yue', '0'), ('90', 'Armenian', '������¡���µ���¥������¥���¶', 'hy', '0'), ('91', 'Quechua', 'Runa Simi', 'qu', '0'), ('92', 'Sundanese', 'Basa Sunda', 'su', '0'), ('93', 'Nepali', '� �¤�¨� �¥ï¿½� �¤�ª� �¤�¾� �¤�²� �¥ï¿½', 'ne', '0'), ('94', 'Zazaki', 'Zazaki', 'diq', '0'), ('95', 'Asturian', 'Asturianu', 'ast', '0'), ('96', 'Tatar', 'Tatar���§a / ���¢���°������°���������°', 'tt', '0'), ('97', 'Neapolitan', 'Nnapulitano', 'nap', '0'), ('98', 'Irish', 'Gaeilge', 'ga', '0'), ('99', 'Chuvash', '���§������²���°���', 'cv', '0'), ('100', 'Samogitian', '���½emait������¡ka', 'bat-smg', '0'), ('101', 'Walloon', 'Walon', 'wa', '0'), ('102', 'Amharic', '�¡ï¿½� �¡ï¿½ï¿½�¡ï¿½�­�¡ï¿½ï¿½', 'am', '0'), ('103', 'Kannada', '� �²ï¿½� �²�¨� �³ï¿½� �²�¨� �²�¡', 'kn', '0'), ('104', 'Alemannic', 'Alemannisch', 'als', '0'), ('105', 'Buginese', 'Basa Ugi', 'bug', '0'), ('106', 'Burmese', '�¡ï¿½ï¿½�¡ï¿½�¼�¡ï¿½ï¿½�¡ï¿½�º�¡ï¿½ï¿½�¡ï¿½�¬�¡ï¿½ï¿½�¡ï¿½�¬', 'my', '0'), ('107', 'Interlingua', 'Interlingua', 'ia', '0');
COMMIT;

languages-table

Most popular languages on the web table (in order of popularity). 
Handy for auto complete fields and such.

Languages table

mysql, table

MySQL