


--
-- Table structure for table `__databaseFields`
--

CREATE TABLE `__databaseFields` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(75) NOT NULL,
  `fieldType` varchar(30) NOT NULL,
  `type` varchar(20) NOT NULL,
  `length` int NOT NULL,
  `listCalculation` text NOT NULL,
  `detailsCalculation` text NOT NULL,
  `table` varchar(50) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `name` (`name`),
  KEY `table` (`table`)
) ENGINE=MyISAM AUTO_INCREMENT=13821 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__fieldLabels`
--

CREATE TABLE `__fieldLabels` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tab` varchar(50) DEFAULT NULL,
  `field` varchar(50) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `labelID` varchar(30) DEFAULT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=471 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__headingFieldLabels`
--

CREATE TABLE `__headingFieldLabels` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tab` varchar(50) NOT NULL,
  `field` varchar(50) NOT NULL,
  `label` varchar(50) NOT NULL,
  `labelID` varchar(50) DEFAULT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__fields`
--

CREATE TABLE `__fields` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(75) NOT NULL,
  `label` varchar(50) NOT NULL,
  `source` varchar(20) NOT NULL,
  `table` varchar(50) NOT NULL,
  `field` varchar(75) NOT NULL,
  `displayType` varchar(20) DEFAULT NULL,
  `displayOptions` varchar(20) NOT NULL,
  `display` varchar(20) NOT NULL,
  `dimIf` text NOT NULL,
  `hideIf` text NOT NULL,
  `runScriptOnChange` text NOT NULL,
  `textColumns` int DEFAULT NULL,
  `textRows` int NOT NULL,
  `validation` varchar(20) NOT NULL,
  `editType` varchar(20) NOT NULL,
  `relatedTable` varchar(50) DEFAULT NULL,
  `relatedField` varchar(50) DEFAULT NULL,
  `relatedMatchField` varchar(50) DEFAULT NULL,
  `relatedFieldID` int DEFAULT NULL,
  `relatedFilterField1` varchar(50) DEFAULT NULL,
  `localFilterField1` varchar(50) DEFAULT NULL,
  `relatedFilterField3` varchar(50) NOT NULL,
  `relatedFilterValue` varchar(50) NOT NULL,
  `relatedFilterField2` varchar(100) NOT NULL,
  `localFilterField2` varchar(100) NOT NULL,
  `relatedFilterOperator` varchar(20) NOT NULL,
  `relatedLinkOperator` varchar(10) NOT NULL,
  `relatedOrderField` varchar(100) NOT NULL,
  `fieldOptions` text NOT NULL,
  `compositeFieldGroup` text NOT NULL,
  `filterOptions` varchar(300) NOT NULL,
  `resetFields` text,
  `dateStartOffset` int NOT NULL,
  `dateStopOffset` int NOT NULL,
  `initialValueType` varchar(25) NOT NULL,
  `initialValue` varchar(50) NOT NULL,
  `notes` text NOT NULL,
  `calculation` text NOT NULL,
  `sqlCalculation` text NOT NULL,
  `tab` varchar(50) DEFAULT NULL,
  `order` int NOT NULL,
  `fieldType` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `displayOptions` (`displayOptions`)
) ENGINE=MyISAM AUTO_INCREMENT=15621 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__headingFields`
--

CREATE TABLE `__headingFields` (
  `id` int NOT NULL AUTO_INCREMENT,
  `label` varchar(50) NOT NULL,
  `name` varchar(75) NOT NULL,
  `type` varchar(20) NOT NULL,
  `headingType` varchar(20) NOT NULL,
  `listType` varchar(20) NOT NULL,
  `listOptions` varchar(20) NOT NULL,
  `value` varchar(50) NOT NULL,
  `inlineEdit` varchar(20) NOT NULL,
  `table` varchar(50) NOT NULL,
  `textLength` int NOT NULL,
  `displayWidth` int NOT NULL,
  `displayOrder` int DEFAULT NULL,
  `displayType` varchar(20) NOT NULL,
  `display` varchar(20) NOT NULL,
  `flags` varchar(200) NOT NULL,
  `operator` varchar(20) NOT NULL,
  `localField` varchar(75) DEFAULT NULL,
  `relatedTable` varchar(50) DEFAULT NULL,
  `relatedField` varchar(30) DEFAULT NULL,
  `relatedMatchField` varchar(30) DEFAULT NULL,
  `relatedFilterField` varchar(50) NOT NULL,
  `localFilterHeading` varchar(50) NOT NULL,
  `initialValueType` varchar(25) NOT NULL,
  `initialValue` varchar(50) NOT NULL,
  `dateStartOffset` int NOT NULL,
  `dateStopOffset` int NOT NULL,
  `resetFields` text NOT NULL,
  `sqlCalculation` text NOT NULL,
  `tab` varchar(50) DEFAULT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `listOptions` (`listOptions`),
  KEY `table` (`table`),
  KEY `localField` (`localField`)
) ENGINE=MyISAM AUTO_INCREMENT=4906 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__subTabHeadingFields`
--

CREATE TABLE `__subTabHeadingFields` (
  `id` int NOT NULL AUTO_INCREMENT,
  `label` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `type` varchar(20) NOT NULL,
  `inlineEdit` varchar(20) NOT NULL,
  `table` varchar(50) NOT NULL,
  `textLength` int NOT NULL,
  `displayWidth` int NOT NULL,
  `display` varchar(20) NOT NULL,
  `operator` varchar(20) NOT NULL,
  `order` int NOT NULL,
  `localField` varchar(30) DEFAULT NULL,
  `relatedTable` varchar(30) DEFAULT NULL,
  `relatedField` varchar(30) DEFAULT NULL,
  `relatedMatchField` varchar(50) DEFAULT NULL,
  `relatedFilterField` varchar(50) NOT NULL,
  `localFilterHeading` varchar(50) NOT NULL,
  `initialValue` varchar(50) NOT NULL,
  `dateStartOffset` int NOT NULL,
  `dateStopOffset` int NOT NULL,
  `resetFields` text NOT NULL,
  `sqlCalculation` text NOT NULL,
  `tab` varchar(30) DEFAULT NULL,
  `subTab` varchar(30) DEFAULT NULL,
  `parentID` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__subTabs`
--

CREATE TABLE `__subTabs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tab` varchar(50) DEFAULT NULL,
  `table` varchar(50) NOT NULL,
  `type` varchar(10) NOT NULL,
  `operator` varchar(20) NOT NULL,
  `showSearch` int NOT NULL,
  `useCustomHeadings` int NOT NULL,
  `tabRelationField` varchar(30) DEFAULT NULL,
  `tabFilterField1` varchar(50) NOT NULL,
  `tabFilterField2` varchar(50) NOT NULL,
  `tabFilterField3` varchar(50) NOT NULL,
  `tabFilterField4` varchar(50) NOT NULL,
  `wsNodeField` varchar(100) NOT NULL,
  `subTabRelationField` varchar(30) DEFAULT NULL,
  `linkTable` varchar(50) DEFAULT NULL,
  `linkField1` varchar(30) DEFAULT NULL,
  `linkField2` varchar(30) DEFAULT NULL,
  `subTab` varchar(50) DEFAULT NULL,
  `allowInList` text NOT NULL,
  `flags` varchar(100) NOT NULL,
  `selectedHeadingField` varchar(50) NOT NULL,
  `defaultFields` text NOT NULL,
  `jsonStoreField` varchar(50) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=248 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__tables`
--

CREATE TABLE `__tables` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `application` varchar(50) NOT NULL,
  `source` varchar(20) NOT NULL,
  `wsAddress` varchar(100) NOT NULL,
  `wsType` varchar(50) NOT NULL,
  `idField` varchar(50) NOT NULL,
  `exportOptions` varchar(50) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=1395 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__tabs`
--

CREATE TABLE `__tabs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `application` varchar(50) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `label` varchar(50) DEFAULT NULL,
  `pluralLabel` varchar(50) DEFAULT NULL,
  `capitalLabel` varchar(50) DEFAULT NULL,
  `pluralCapitalLabel` varchar(50) DEFAULT NULL,
  `table` varchar(50) NOT NULL,
  `cacheTTL` varchar(6) NOT NULL,
  `display` int NOT NULL,
  `useTable` text NOT NULL,
  `titleField` varchar(50) NOT NULL,
  `listTitleField` text NOT NULL,
  `listDescriptionField` varchar(20) NOT NULL,
  `listImageField` varchar(20) NOT NULL,
  `selectedHeadingField` varchar(50) NOT NULL,
  `listIntroText` text NOT NULL,
  `detailsIntroText` text NOT NULL,
  `orderBy` text NOT NULL,
  `groupBy` text NOT NULL,
  `visualGroup` varchar(50) NOT NULL,
  `allowInList` text NOT NULL,
  `flags` text NOT NULL,
  `visualLocationXField` varchar(50) NOT NULL,
  `visualLocationYField` varchar(50) NOT NULL,
  `visualLocationField` varchar(12) NOT NULL,
  `ownerID` int NOT NULL,
  `groupID` int NOT NULL,
  `ownerAccess` varchar(200) NOT NULL,
  `groupAccess` varchar(200) NOT NULL,
  `worldAccess` varchar(200) NOT NULL,
  `transactionLogging` varchar(100) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `table` (`table`)
) ENGINE=MyISAM AUTO_INCREMENT=1423 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__tabActions`
--

CREATE TABLE `__tabActions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `label` varchar(50) NOT NULL,
  `tab` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `subTab` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `field` varchar(30) NOT NULL,
  `type` varchar(20) NOT NULL,
  `selector` varchar(200) NOT NULL,
  `iOSSelector` varchar(200) NOT NULL,
  `logic` varchar(20) NOT NULL,
  `enabled` varchar(20) NOT NULL,
  `legend` varchar(50) NOT NULL,
  `altLegend` varchar(50) NOT NULL,
  `webIcon` varchar(250) NOT NULL,
  `altWebIcon` varchar(250) NOT NULL,
  `iOSIcon` varchar(50) NOT NULL,
  `iOSSystemItem` varchar(20) NOT NULL,
  `prompt` text NOT NULL,
  `style` varchar(50) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__sessions`
--

CREATE TABLE `__sessions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sessionID` varchar(200) NOT NULL,
  `cookie` varchar(200) NOT NULL,
  `ipAddress` varchar(20) NOT NULL,
  `userID` int NOT NULL,
  `userType` int NOT NULL,
  `lastCommand` datetime NOT NULL,
  `loggedIn` varchar(10) DEFAULT NULL,
  `loginTime` datetime NOT NULL,
  `lastCommandTime` datetime NOT NULL,
  `searchTerm` varchar(50) NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8048 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__publicSessions`
--

CREATE TABLE `__publicSessions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sessionID` varchar(50) NOT NULL,
  `userCookie` varchar(50) NOT NULL,
  `IP` varchar(20) NOT NULL,
  `userAgent` text NOT NULL,
  `userID` int NOT NULL,
  `userType` int NOT NULL,
  `siteID` int DEFAULT NULL,
  `platform` varchar(100) NOT NULL,
  `loggedIn` varchar(10) DEFAULT NULL,
  `loginTime` datetime NOT NULL,
  `firstCommandTime` datetime NOT NULL,
  `lastCommandTime` datetime NOT NULL,
  `searchTerm` varchar(50) NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19023 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__publicUserCookies`
--

CREATE TABLE `__publicUserCookies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userCookie` varchar(100) NOT NULL,
  `platform` varchar(100) NOT NULL,
  `ipAddress` varchar(20) NOT NULL,
  `userAgent` text NOT NULL,
  `firstVisitDateTime` datetime NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=245599 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__publicUsers`
--

CREATE TABLE `__publicUsers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL DEFAULT '',
  `lastPassword` varchar(100) DEFAULT NULL,
  `usertype` varchar(25) DEFAULT NULL,
  `status` tinyint DEFAULT '0',
  `sendEmail` tinyint DEFAULT '0',
  `userID` varchar(100) NOT NULL,
  `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `activation` varchar(100) NOT NULL DEFAULT '',
  `notes` text NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__applications`
--

CREATE TABLE `__applications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `label` varchar(50) NOT NULL,
  `tablePrefix` varchar(20) NOT NULL,
  `folder` varchar(20) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;




--
-- Dumping data for table `__applications`
--
-- WHERE:  __applications.tablePrefix = '__'

INSERT INTO `__applications` (`id`, `name`, `label`, `tablePrefix`, `folder`, `order`, `__groupID`, `__ownerID`) VALUES (9,'dm','Data manager','__','dataManagement',9,NULL,NULL);




--
-- Table structure for table `__apnsRegistrations`
--

CREATE TABLE `__apnsRegistrations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `siteID` int NOT NULL,
  `IPAddress` varchar(32) NOT NULL,
  `userID` varchar(32) NOT NULL,
  `userCookie` varchar(200) NOT NULL,
  `PHPSessionID` varchar(200) NOT NULL,
  `deviceToken` varchar(100) NOT NULL,
  `userAgent` varchar(500) NOT NULL,
  `requestTime` varchar(32) NOT NULL,
  `dateTime` datetime NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__locationEvents`
--

CREATE TABLE `__locationEvents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `siteID` int NOT NULL,
  `IPAddress` varchar(32) NOT NULL,
  `userID` varchar(32) NOT NULL,
  `userCookie` varchar(200) NOT NULL,
  `PHPSessionID` varchar(200) NOT NULL,
  `eventType` varchar(20) NOT NULL,
  `region` varchar(50) NOT NULL,
  `userAgent` varchar(500) NOT NULL,
  `requestTime` varchar(32) NOT NULL,
  `dateTime` datetime NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21082 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__wsEndpoints`
--

CREATE TABLE `__wsEndpoints` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `parentID` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `__wsEndpoints`
--

INSERT INTO `__wsEndpoints` VALUES (1,'wpPosts','Wordpress posts',2,NULL,NULL),(2,'wpTaxonomies','Wordpress taxonomies',2,NULL,NULL),(3,'wpCategories','Wordpress categories',2,NULL,NULL);







--
-- Table structure for table `__wsTypes`
--

CREATE TABLE `__wsTypes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `__wsTypes`
--

INSERT INTO `__wsTypes` VALUES (1,'phpArray','PHP array',NULL,NULL),(2,'wordpress','Wordpress',NULL,NULL);




--
-- Table structure for table `__countries`
--

CREATE TABLE `__countries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `official_name_ar` varchar(100) NOT NULL,
  `official_name_cn` varchar(100) NOT NULL,
  `official_name_en` varchar(100) NOT NULL,
  `official_name_es` varchar(100) NOT NULL,
  `official_name_fr` varchar(100) NOT NULL,
  `official_name_ru` varchar(100) NOT NULL,
  `ISO3166_1_Alpha_2` varchar(10) NOT NULL,
  `ISO3166_1_Alpha_3` varchar(10) NOT NULL,
  `ISO3166_1_numeric` int NOT NULL,
  `ISO4217_currency_alphabetic_code` varchar(5) NOT NULL,
  `name` varchar(100) NOT NULL,
  `capital` varchar(100) NOT NULL,
  `continent` varchar(5) NOT NULL,
  `dial` varchar(10) NOT NULL,
  `intermediate_region_code` int NOT NULL,
  `languages` int NOT NULL,
  `region_code` int NOT NULL,
  `sub_region_code` int NOT NULL,
  `tld` varchar(10) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `__countries`
--

INSERT INTO `__countries` VALUES (252,'أفغانستان','阿富汗','Afghanistan','Afganistán','Afghanistan','Афганистан','AF','AFG',4,'AFN','Afghanistan','Kabul','AS','93',0,0,142,34,'.af',0,NULL,NULL),(253,'ألبانيا','阿尔巴尼亚','Albania','Albania','Albanie','Албания','AL','ALB',8,'ALL','Albania','Tirana','EU','355',0,0,150,39,'.al',0,NULL,NULL),(254,'الجزائر','阿尔及利亚','Algeria','Argelia','Algérie','Алжир','DZ','DZA',12,'DZD','Algeria','Algiers','AF','213',0,0,2,15,'.dz',0,NULL,NULL),(255,'ساموا الأمريكية','美属萨摩亚','American Samoa','Samoa Americana','Samoa américaines','Американское Самоа','AS','ASM',16,'USD','American Samoa','Pago Pago','OC','1-684',0,0,9,61,'.as',0,NULL,NULL),(256,'أندورا','安道尔','Andorra','Andorra','Andorre','Андорра','AD','AND',20,'EUR','Andorra','Andorra la Vella','EU','376',0,0,150,39,'.ad',0,NULL,NULL),(257,'أنغولا','安哥拉','Angola','Angola','Angola','Ангола','AO','AGO',24,'AOA','Angola','Luanda','AF','244',17,0,2,202,'.ao',0,NULL,NULL),(258,'أنغيلا','安圭拉','Anguilla','Anguila','Anguilla','Ангилья','AI','AIA',660,'XCD','Anguilla','The Valley','NA','1-264',29,0,19,419,'.ai',0,NULL,NULL),(259,'أنتاركتيكا','南极洲','Antarctica','Antártida','Antarctique','Антарктике','AQ','ATA',10,'','Antarctica','','AN','672',0,0,0,0,'.aq',0,NULL,NULL),(260,'أنتيغوا وبربودا','安提瓜和巴布达','Antigua and Barbuda','Antigua y Barbuda','Antigua-et-Barbuda','Антигуа и Барбуда','AG','ATG',28,'XCD','Antigua & Barbuda','St. John\'s','NA','1-268',29,0,19,419,'.ag',0,NULL,NULL),(261,'الأرجنتين','阿根廷','Argentina','Argentina','Argentine','Аргентина','AR','ARG',32,'ARS','Argentina','Buenos Aires','SA','54',5,0,19,419,'.ar',0,NULL,NULL),(262,'أرمينيا','亚美尼亚','Armenia','Armenia','Arménie','Армения','AM','ARM',51,'AMD','Armenia','Yerevan','AS','374',0,0,142,145,'.am',0,NULL,NULL),(263,'أروبا','阿鲁巴','Aruba','Aruba','Aruba','Аруба','AW','ABW',533,'AWG','Aruba','Oranjestad','NA','297',29,0,19,419,'.aw',0,NULL,NULL),(264,'أستراليا','澳大利亚','Australia','Australia','Australie','Австралия','AU','AUS',36,'AUD','Australia','Canberra','OC','61',0,0,9,53,'.au',0,NULL,NULL),(265,'النمسا','奥地利','Austria','Austria','Autriche','Австрия','AT','AUT',40,'EUR','Austria','Vienna','EU','43',0,0,150,155,'.at',0,NULL,NULL),(266,'أذربيجان','阿塞拜疆','Azerbaijan','Azerbaiyán','Azerbaïdjan','Азербайджан','AZ','AZE',31,'AZN','Azerbaijan','Baku','AS','994',0,0,142,145,'.az',0,NULL,NULL),(267,'جزر البهاما','巴哈马','Bahamas','Bahamas','Bahamas','Багамские Острова','BS','BHS',44,'BSD','Bahamas','Nassau','NA','1-242',29,0,19,419,'.bs',0,NULL,NULL),(268,'البحرين','巴林','Bahrain','Bahrein','Bahreïn','Бахрейн','BH','BHR',48,'BHD','Bahrain','Manama','AS','973',0,0,142,145,'.bh',0,NULL,NULL),(269,'بنغلاديش','孟加拉国','Bangladesh','Bangladesh','Bangladesh','Бангладеш','BD','BGD',50,'BDT','Bangladesh','Dhaka','AS','880',0,0,142,34,'.bd',0,NULL,NULL),(270,'بربادوس','巴巴多斯','Barbados','Barbados','Barbade','Барбадос','BB','BRB',52,'BBD','Barbados','Bridgetown','NA','1-246',29,0,19,419,'.bb',0,NULL,NULL),(271,'بيلاروس','白俄罗斯','Belarus','Belarús','Bélarus','Беларусь','BY','BLR',112,'BYN','Belarus','Minsk','EU','375',0,0,150,151,'.by',0,NULL,NULL),(272,'بلجيكا','比利时','Belgium','Bélgica','Belgique','Бельгия','BE','BEL',56,'EUR','Belgium','Brussels','EU','32',0,0,150,155,'.be',0,NULL,NULL),(273,'بليز','伯利兹','Belize','Belice','Belize','Белиз','BZ','BLZ',84,'BZD','Belize','Belmopan','NA','501',13,0,19,419,'.bz',0,NULL,NULL),(274,'بنن','贝宁','Benin','Benin','Bénin','Бенин','BJ','BEN',204,'XOF','Benin','Porto-Novo','AF','229',11,0,2,202,'.bj',0,NULL,NULL),(275,'برمودا','百慕大','Bermuda','Bermuda','Bermudes','Бермудские острова','BM','BMU',60,'BMD','Bermuda','Hamilton','NA','1-441',0,0,19,21,'.bm',0,NULL,NULL),(276,'بوتان','不丹','Bhutan','Bhután','Bhoutan','Бутан','BT','BTN',64,'INR,B','Bhutan','Thimphu','AS','975',0,0,142,34,'.bt',0,NULL,NULL),(277,'بوليفيا (دولة - المتعددة القوميات)','玻利维亚(多民族国)','Bolivia (Plurinational State of)','Bolivia (Estado Plurinacional de)','Bolivie (État plurinational de)','Боливия (Многонациональное Государство)','BO','BOL',68,'BOB','Bolivia','Sucre','SA','591',5,0,19,419,'.bo',0,NULL,NULL),(278,'بونير وسان يوستاتيوس وسابا','博纳尔,圣俄斯塔休斯和萨巴','Bonaire, Sint Eustatius and Saba','Bonaire, San Eustaquio y Saba','Bonaire, Saint-Eustache et Saba','Бонайре, Саба и Синт-Эстатиус','BQ','BES',535,'USD','Caribbean Netherlands','','NA','599',29,0,19,419,'.bq',0,NULL,NULL),(279,'البوسنة والهرسك','波斯尼亚和黑塞哥维那','Bosnia and Herzegovina','Bosnia y Herzegovina','Bosnie-Herzégovine','Босния и Герцеговина','BA','BIH',70,'BAM','Bosnia','Sarajevo','EU','387',0,0,150,39,'.ba',0,NULL,NULL),(280,'بوتسوانا','博茨瓦纳','Botswana','Botswana','Botswana','Ботсвана','BW','BWA',72,'BWP','Botswana','Gaborone','AF','267',18,0,2,202,'.bw',0,NULL,NULL),(281,'جزيرة بوفيت','布维岛','Bouvet Island','Isla Bouvet','Île Bouvet','Остров Буве','BV','BVT',74,'NOK','Bouvet Island','','AN','47',5,0,19,419,'.bv',0,NULL,NULL),(282,'البرازيل','巴西','Brazil','Brasil','Brésil','Бразилия','BR','BRA',76,'BRL','Brazil','Brasilia','SA','55',5,0,19,419,'.br',0,NULL,NULL),(283,'المحيط الهندي الإقليم البريطاني في','英属印度洋领土','British Indian Ocean Territory','Territorio Británico del Océano Índico','Territoire britannique de l\'océan Indien','Британская территория в Индийском океане','IO','IOT',86,'USD','British Indian Ocean Territory','Diego Garcia','AS','246',14,0,2,202,'.io',0,NULL,NULL),(284,'جزر فرجن البريطانية','英属维尔京群岛','British Virgin Islands','Islas Vírgenes Británicas','Îles Vierges britanniques','Британские Виргинские острова','VG','VGB',92,'USD','British Virgin Islands','Road Town','NA','1-284',29,0,19,419,'.vg',0,NULL,NULL),(285,'بروني دار السلام','文莱达鲁萨兰国','Brunei Darussalam','Brunei Darussalam','Brunéi Darussalam','Бруней-Даруссалам','BN','BRN',96,'BND','Brunei','Bandar Seri Begawan','AS','673',0,0,142,35,'.bn',0,NULL,NULL),(286,'بلغاريا','保加利亚','Bulgaria','Bulgaria','Bulgarie','Болгария','BG','BGR',100,'BGN','Bulgaria','Sofia','EU','359',0,0,150,151,'.bg',0,NULL,NULL),(287,'بوركينا فاسو','布基纳法索','Burkina Faso','Burkina Faso','Burkina Faso','Буркина-Фасо','BF','BFA',854,'XOF','Burkina Faso','Ouagadougou','AF','226',11,0,2,202,'.bf',0,NULL,NULL),(288,'بوروندي','布隆迪','Burundi','Burundi','Burundi','Бурунди','BI','BDI',108,'BIF','Burundi','Bujumbura','AF','257',14,0,2,202,'.bi',0,NULL,NULL),(289,'كابو فيردي','佛得角','Cabo Verde','Cabo Verde','Cabo Verde','Кабо-Верде','CV','CPV',132,'CVE','Cape Verde','Praia','AF','238',11,0,2,202,'.cv',0,NULL,NULL),(290,'كمبوديا','柬埔寨','Cambodia','Camboya','Cambodge','Камбоджа','KH','KHM',116,'KHR','Cambodia','Phnom Penh','AS','855',0,0,142,35,'.kh',0,NULL,NULL),(291,'الكاميرون','喀麦隆','Cameroon','Camerún','Cameroun','Камерун','CM','CMR',120,'XAF','Cameroon','Yaounde','AF','237',17,0,2,202,'.cm',0,NULL,NULL),(292,'كندا','加拿大','Canada','Canadá','Canada','Канада','CA','CAN',124,'CAD','Canada','Ottawa','NA','1',0,0,19,21,'.ca',0,NULL,NULL),(293,'جزر كايمان','开曼群岛','Cayman Islands','Islas Caimán','Îles Caïmanes','Кайман острова','KY','CYM',136,'KYD','Cayman Islands','George Town','NA','1-345',29,0,19,419,'.ky',0,NULL,NULL),(294,'جمهورية أفريقيا الوسطى','中非共和国','Central African Republic','República Centroafricana','République centrafricaine','Центральноафриканская Республика','CF','CAF',140,'XAF','Central African Republic','Bangui','AF','236',17,0,2,202,'.cf',0,NULL,NULL),(295,'تشاد','乍得','Chad','Chad','Tchad','Чад','TD','TCD',148,'XAF','Chad','N\'Djamena','AF','235',17,0,2,202,'.td',0,NULL,NULL),(296,'شيلي','智利','Chile','Chile','Chili','Чили','CL','CHL',152,'CLP','Chile','Santiago','SA','56',5,0,19,419,'.cl',0,NULL,NULL),(297,'الصين','中国','China','China','Chine','Китай','CN','CHN',156,'CNY','China','Beijing','AS','86',0,0,142,30,'.cn',0,NULL,NULL),(298,'منطقة هونغ كونغ الصينية الإدارية الخاصة','中国香港特别行政区','China, Hong Kong Special Administrative Region','China, región administrativa especial de Hong Kong','Chine, région administrative spéciale de Hong Kong','Китай, Специальный административный район Гонконг','HK','HKG',344,'HKD','Hong Kong','Hong Kong','AS','852',0,0,142,30,'.hk',0,NULL,NULL),(299,'منطقة ماكاو الإدارية الخاصة التابعة للصين','中国澳门特别行政区','China, Macao Special Administrative Region','China, región administrativa especial de Macao','Chine, région administrative spéciale de Macao','Китай, Специальный административный район Макао','MO','MAC',446,'MOP','Macau','Macao','AS','853',0,0,142,30,'.mo',0,NULL,NULL),(300,'جزيرة كريسماس','圣诞岛','Christmas Island','Isla de Navidad','Île Christmas','остров Рождества','CX','CXR',162,'AUD','Christmas Island','Flying Fish Cove','AS','61',0,0,9,53,'.cx',0,NULL,NULL),(301,'جزر كوكوس (كيلينغ)','科科斯(基林)群岛','Cocos (Keeling) Islands','Islas Cocos (Keeling)','Îles des Cocos (Keeling)','Кокосовых (Килинг) островов','CC','CCK',166,'AUD','Cocos (Keeling) Islands','West Island','AS','61',0,0,9,53,'.cc',0,NULL,NULL),(302,'كولومبيا','哥伦比亚','Colombia','Colombia','Colombie','Колумбия','CO','COL',170,'COP','Colombia','Bogota','SA','57',5,0,19,419,'.co',0,NULL,NULL),(303,'جزر القمر','科摩罗','Comoros','Comoras','Comores','Коморские Острова','KM','COM',174,'KMF','Comoros','Moroni','AF','269',14,0,2,202,'.km',0,NULL,NULL),(304,'الكونغو','刚果','Congo','Congo','Congo','Конго','CG','COG',178,'XAF','Congo - Brazzaville','Brazzaville','AF','242',17,0,2,202,'.cg',0,NULL,NULL),(305,'جزر كوك','库克群岛','Cook Islands','Islas Cook','Îles Cook','Острова Кука','CK','COK',184,'NZD','Cook Islands','Avarua','OC','682',0,0,9,61,'.ck',0,NULL,NULL),(306,'كوستاريكا','哥斯达黎加','Costa Rica','Costa Rica','Costa Rica','Коста-Рика','CR','CRI',188,'CRC','Costa Rica','San Jose','NA','506',13,0,19,419,'.cr',0,NULL,NULL),(307,'كرواتيا','克罗地亚','Croatia','Croacia','Croatie','Хорватия','HR','HRV',191,'HRK','Croatia','Zagreb','EU','385',0,0,150,39,'.hr',0,NULL,NULL),(308,'كوبا','古巴','Cuba','Cuba','Cuba','Куба','CU','CUB',192,'CUP,C','Cuba','Havana','NA','53',29,0,19,419,'.cu',0,NULL,NULL),(309,'كوراساو','库拉索','Curaçao','Curaçao','Curaçao','Кюрасао','CW','CUW',531,'ANG','Curaçao','Willemstad','NA','599',29,0,19,419,'.cw',0,NULL,NULL),(310,'قبرص','塞浦路斯','Cyprus','Chipre','Chypre','Кипр','CY','CYP',196,'EUR','Cyprus','Nicosia','EU','357',0,0,142,145,'.cy',0,NULL,NULL),(311,'تشيكيا','捷克','Czechia','Chequia','Tchéquie','Чехия','CZ','CZE',203,'CZK','Czechia','Prague','EU','420',0,0,150,151,'.cz',0,NULL,NULL),(312,'كوت ديفوار','科特迪瓦','Côte d\'Ivoire','Côte d\'Ivoire','Côte d\'Ivoire','Кот-д\'Ивуар','CI','CIV',384,'XOF','Côte d’Ivoire','Yamoussoukro','AF','225',11,0,2,202,'.ci',0,NULL,NULL),(313,'جمهورية كوريا الشعبية الديمقراطية','朝鲜民主主义人民共和国','Democratic People\'s Republic of Korea','República Popular Democrática de Corea','République populaire démocratique de Corée','Корейская Народно-Демократическая Республика','KP','PRK',408,'KPW','North Korea','Pyongyang','AS','850',0,0,142,30,'.kp',0,NULL,NULL),(314,'جمهورية الكونغو الديمقراطية','刚果民主共和国','Democratic Republic of the Congo','República Democrática del Congo','République démocratique du Congo','Демократическая Республика Конго','CD','COD',180,'CDF','Congo - Kinshasa','Kinshasa','AF','243',17,0,2,202,'.cd',0,NULL,NULL),(315,'الدانمرك','丹麦','Denmark','Dinamarca','Danemark','Дания','DK','DNK',208,'DKK','Denmark','Copenhagen','EU','45',0,0,150,154,'.dk',0,NULL,NULL),(316,'جيبوتي','吉布提','Djibouti','Djibouti','Djibouti','Джибути','DJ','DJI',262,'DJF','Djibouti','Djibouti','AF','253',14,0,2,202,'.dj',0,NULL,NULL),(317,'دومينيكا','多米尼克','Dominica','Dominica','Dominique','Доминика','DM','DMA',212,'XCD','Dominica','Roseau','NA','1-767',29,0,19,419,'.dm',0,NULL,NULL),(318,'الجمهورية الدومينيكية','多米尼加','Dominican Republic','República Dominicana','République dominicaine','Доминиканская Республика','DO','DOM',214,'DOP','Dominican Republic','Santo Domingo','NA','1-809,1-82',29,0,19,419,'.do',0,NULL,NULL),(319,'إكوادور','厄瓜多尔','Ecuador','Ecuador','Équateur','Эквадор','EC','ECU',218,'USD','Ecuador','Quito','SA','593',5,0,19,419,'.ec',0,NULL,NULL),(320,'مصر','埃及','Egypt','Egipto','Égypte','Египет','EG','EGY',818,'EGP','Egypt','Cairo','AF','20',0,0,2,15,'.eg',0,NULL,NULL),(321,'السلفادور','萨尔瓦多','El Salvador','El Salvador','El Salvador','Сальвадор','SV','SLV',222,'SVC,U','El Salvador','San Salvador','NA','503',13,0,19,419,'.sv',0,NULL,NULL),(322,'غينيا الاستوائية','赤道几内亚','Equatorial Guinea','Guinea Ecuatorial','Guinée équatoriale','Экваториальная Гвинея','GQ','GNQ',226,'XAF','Equatorial Guinea','Malabo','AF','240',17,0,2,202,'.gq',0,NULL,NULL),(323,'إريتريا','厄立特里亚','Eritrea','Eritrea','Érythrée','Эритрея','ER','ERI',232,'ERN','Eritrea','Asmara','AF','291',14,0,2,202,'.er',0,NULL,NULL),(324,'إستونيا','爱沙尼亚','Estonia','Estonia','Estonie','Эстония','EE','EST',233,'EUR','Estonia','Tallinn','EU','372',0,0,150,154,'.ee',0,NULL,NULL),(325,'إثيوبيا','埃塞俄比亚','Ethiopia','Etiopía','Éthiopie','Эфиопия','ET','ETH',231,'ETB','Ethiopia','Addis Ababa','AF','251',14,0,2,202,'.et',0,NULL,NULL),(326,'جزر فوكلاند (مالفيناس)','福克兰群岛(马尔维纳斯)','Falkland Islands (Malvinas)','Islas Malvinas (Falkland)','Îles Falkland (Malvinas)','Фолклендские (Мальвинские) острова','FK','FLK',238,'','Falkland Islands','Stanley','SA','500',5,0,19,419,'.fk',0,NULL,NULL),(327,'جزر فايرو','法罗群岛','Faroe Islands','Islas Feroe','Îles Féroé','Фарерские острова','FO','FRO',234,'DKK','Faroe Islands','Torshavn','EU','298',0,0,150,154,'.fo',0,NULL,NULL),(328,'فيجي','斐济','Fiji','Fiji','Fidji','Фиджи','FJ','FJI',242,'FJD','Fiji','Suva','OC','679',0,0,9,54,'.fj',0,NULL,NULL),(329,'فنلندا','芬兰','Finland','Finlandia','Finlande','Финляндия','FI','FIN',246,'EUR','Finland','Helsinki','EU','358',0,0,150,154,'.fi',0,NULL,NULL),(330,'فرنسا','法国','France','Francia','France','Франция','FR','FRA',250,'EUR','France','Paris','EU','33',0,0,150,155,'.fr',0,NULL,NULL),(331,'غيانا الفرنسية','法属圭亚那','French Guiana','Guayana Francesa','Guyane française','Французская Гвиана','GF','GUF',254,'EUR','French Guiana','Cayenne','SA','594',5,0,19,419,'.gf',0,NULL,NULL),(332,'بولينيزيا الفرنسية','法属波利尼西亚','French Polynesia','Polinesia Francesa','Polynésie française','Французская Полинезия','PF','PYF',258,'XPF','French Polynesia','Papeete','OC','689',0,0,9,61,'.pf',0,NULL,NULL),(333,'الأراضي الفرنسية الجنوبية الجنوبية','法属南方领地','French Southern Territories','Territorio de las Tierras Australes Francesas','Terres australes françaises','Южные земли (французская заморская территория)','TF','ATF',260,'EUR','French Southern Territories','Port-aux-Francais','AN','262',14,0,2,202,'.tf',0,NULL,NULL),(334,'غابون','加蓬','Gabon','Gabón','Gabon','Габон','GA','GAB',266,'XAF','Gabon','Libreville','AF','241',17,0,2,202,'.ga',0,NULL,NULL),(335,'غامبيا','冈比亚','Gambia','Gambia','Gambie','Гамбия','GM','GMB',270,'GMD','Gambia','Banjul','AF','220',11,0,2,202,'.gm',0,NULL,NULL),(336,'جورجيا','格鲁吉亚','Georgia','Georgia','Géorgie','Грузия','GE','GEO',268,'GEL','Georgia','Tbilisi','AS','995',0,0,142,145,'.ge',0,NULL,NULL),(337,'ألمانيا','德国','Germany','Alemania','Allemagne','Германия','DE','DEU',276,'EUR','Germany','Berlin','EU','49',0,0,150,155,'.de',0,NULL,NULL),(338,'غانا','加纳','Ghana','Ghana','Ghana','Гана','GH','GHA',288,'GHS','Ghana','Accra','AF','233',11,0,2,202,'.gh',0,NULL,NULL),(339,'جبل طارق','直布罗陀','Gibraltar','Gibraltar','Gibraltar','Гибралтар','GI','GIB',292,'GIP','Gibraltar','Gibraltar','EU','350',0,0,150,39,'.gi',0,NULL,NULL),(340,'اليونان','希腊','Greece','Grecia','Grèce','Греция','GR','GRC',300,'EUR','Greece','Athens','EU','30',0,0,150,39,'.gr',0,NULL,NULL),(341,'غرينلند','格陵兰','Greenland','Groenlandia','Groenland','Гренландия','GL','GRL',304,'DKK','Greenland','Nuuk','NA','299',0,0,19,21,'.gl',0,NULL,NULL),(342,'غرينادا','格林纳达','Grenada','Granada','Grenade','Гренада','GD','GRD',308,'XCD','Grenada','St. George\'s','NA','1-473',29,0,19,419,'.gd',0,NULL,NULL),(343,'غواديلوب','瓜德罗普','Guadeloupe','Guadalupe','Guadeloupe','Гваделупа','GP','GLP',312,'EUR','Guadeloupe','Basse-Terre','NA','590',29,0,19,419,'.gp',0,NULL,NULL),(344,'غوام','关岛','Guam','Guam','Guam','Гуам','GU','GUM',316,'USD','Guam','Hagatna','OC','1-671',0,0,9,57,'.gu',0,NULL,NULL),(345,'غواتيمالا','危地马拉','Guatemala','Guatemala','Guatemala','Гватемала','GT','GTM',320,'GTQ','Guatemala','Guatemala City','NA','502',13,0,19,419,'.gt',0,NULL,NULL),(346,'غيرنزي','根西','Guernsey','Guernsey','Guernesey','Гернси','GG','GGY',831,'GBP','Guernsey','St Peter Port','EU','44',830,0,150,154,'.gg',0,NULL,NULL),(347,'غينيا','几内亚','Guinea','Guinea','Guinée','Гвинея','GN','GIN',324,'GNF','Guinea','Conakry','AF','224',11,0,2,202,'.gn',0,NULL,NULL),(348,'غينيا - بيساو','几内亚比绍','Guinea-Bissau','Guinea-Bissau','Guinée-Bissau','Гвинея-Бисау','GW','GNB',624,'XOF','Guinea-Bissau','Bissau','AF','245',11,0,2,202,'.gw',0,NULL,NULL),(349,'غيانا','圭亚那','Guyana','Guyana','Guyana','Гайана','GY','GUY',328,'GYD','Guyana','Georgetown','SA','592',5,0,19,419,'.gy',0,NULL,NULL),(350,'هايتي','海地','Haiti','Haití','Haïti','Гаити','HT','HTI',332,'HTG,U','Haiti','Port-au-Prince','NA','509',29,0,19,419,'.ht',0,NULL,NULL),(351,'جزيرة هيرد وجزر ماكدونالد','赫德岛和麦克唐纳岛','Heard Island and McDonald Islands','Islas Heard y McDonald','Île Heard-et-Îles MacDonald','Остров Херд и острова Макдональд','HM','HMD',334,'AUD','Heard & McDonald Islands','','AN','672',0,0,9,53,'.hm',0,NULL,NULL),(352,'الكرسي الرسولي','教廷','Holy See','Santa Sede','Saint-Siège','Святой Престол','VA','VAT',336,'EUR','Vatican City','Vatican City','EU','39-06',0,0,150,39,'.va',0,NULL,NULL),(353,'هندوراس','洪都拉斯','Honduras','Honduras','Honduras','Гондурас','HN','HND',340,'HNL','Honduras','Tegucigalpa','NA','504',13,0,19,419,'.hn',0,NULL,NULL),(354,'هنغاريا','匈牙利','Hungary','Hungría','Hongrie','Венгрия','HU','HUN',348,'HUF','Hungary','Budapest','EU','36',0,0,150,151,'.hu',0,NULL,NULL),(355,'آيسلندا','冰岛','Iceland','Islandia','Islande','Исландия','IS','ISL',352,'ISK','Iceland','Reykjavik','EU','354',0,0,150,154,'.is',0,NULL,NULL),(356,'الهند','印度','India','India','Inde','Индия','IN','IND',356,'INR','India','New Delhi','AS','91',0,0,142,34,'.in',0,NULL,NULL),(357,'إندونيسيا','印度尼西亚','Indonesia','Indonesia','Indonésie','Индонезия','ID','IDN',360,'IDR','Indonesia','Jakarta','AS','62',0,0,142,35,'.id',0,NULL,NULL),(358,'إيران (جمهورية - الإسلامية)','伊朗(伊斯兰共和国)','Iran (Islamic Republic of)','Irán (República Islámica del)','Iran (République islamique d\')','Иран (Исламская Республика)','IR','IRN',364,'IRR','Iran','Tehran','AS','98',0,0,142,34,'.ir',0,NULL,NULL),(359,'العراق','伊拉克','Iraq','Iraq','Iraq','Ирак','IQ','IRQ',368,'IQD','Iraq','Baghdad','AS','964',0,0,142,145,'.iq',0,NULL,NULL),(360,'آيرلندا','爱尔兰','Ireland','Irlanda','Irlande','Ирландия','IE','IRL',372,'EUR','Ireland','Dublin','EU','353',0,0,150,154,'.ie',0,NULL,NULL),(361,'جزيرة مان','马恩岛','Isle of Man','Isla de Man','Île de Man','Остров Мэн','IM','IMN',833,'GBP','Isle of Man','Douglas','EU','44',0,0,150,154,'.im',0,NULL,NULL),(362,'إسرائيل','以色列','Israel','Israel','Israël','Израиль','IL','ISR',376,'ILS','Israel','Jerusalem','AS','972',0,0,142,145,'.il',0,NULL,NULL),(363,'إيطاليا','意大利','Italy','Italia','Italie','Италия','IT','ITA',380,'EUR','Italy','Rome','EU','39',0,0,150,39,'.it',0,NULL,NULL),(364,'جامايكا','牙买加','Jamaica','Jamaica','Jamaïque','Ямайка','JM','JAM',388,'JMD','Jamaica','Kingston','NA','1-876',29,0,19,419,'.jm',0,NULL,NULL),(365,'اليابان','日本','Japan','Japón','Japon','Япония','JP','JPN',392,'JPY','Japan','Tokyo','AS','81',0,0,142,30,'.jp',0,NULL,NULL),(366,'جيرزي','泽西','Jersey','Jersey','Jersey','Джерси','JE','JEY',832,'GBP','Jersey','Saint Helier','EU','44',830,0,150,154,'.je',0,NULL,NULL),(367,'الأردن','约旦','Jordan','Jordania','Jordanie','Иордания','JO','JOR',400,'JOD','Jordan','Amman','AS','962',0,0,142,145,'.jo',0,NULL,NULL),(368,'كازاخستان','哈萨克斯坦','Kazakhstan','Kazajstán','Kazakhstan','Казахстан','KZ','KAZ',398,'KZT','Kazakhstan','Astana','AS','7',0,0,142,143,'.kz',0,NULL,NULL),(369,'كينيا','肯尼亚','Kenya','Kenya','Kenya','Кения','KE','KEN',404,'KES','Kenya','Nairobi','AF','254',14,0,2,202,'.ke',0,NULL,NULL),(370,'كيريباس','基里巴斯','Kiribati','Kiribati','Kiribati','Кирибати','KI','KIR',296,'AUD','Kiribati','Tarawa','OC','686',0,0,9,57,'.ki',0,NULL,NULL),(371,'الكويت','科威特','Kuwait','Kuwait','Koweït','Кувейт','KW','KWT',414,'KWD','Kuwait','Kuwait City','AS','965',0,0,142,145,'.kw',0,NULL,NULL),(372,'قيرغيزستان','吉尔吉斯斯坦','Kyrgyzstan','Kirguistán','Kirghizistan','Кыргызстан','KG','KGZ',417,'KGS','Kyrgyzstan','Bishkek','AS','996',0,0,142,143,'.kg',0,NULL,NULL),(373,'جمهورية لاو الديمقراطية الشعبية','老挝人民民主共和国','Lao People\'s Democratic Republic','República Democrática Popular Lao','République démocratique populaire lao','Лаосская Народно-Демократическая Республика','LA','LAO',418,'LAK','Laos','Vientiane','AS','856',0,0,142,35,'.la',0,NULL,NULL),(374,'لاتفيا','拉脱维亚','Latvia','Letonia','Lettonie','Латвия','LV','LVA',428,'EUR','Latvia','Riga','EU','371',0,0,150,154,'.lv',0,NULL,NULL),(375,'لبنان','黎巴嫩','Lebanon','Líbano','Liban','Ливан','LB','LBN',422,'LBP','Lebanon','Beirut','AS','961',0,0,142,145,'.lb',0,NULL,NULL),(376,'ليسوتو','莱索托','Lesotho','Lesotho','Lesotho','Лесото','LS','LSO',426,'LSL,Z','Lesotho','Maseru','AF','266',18,0,2,202,'.ls',0,NULL,NULL),(377,'ليبريا','利比里亚','Liberia','Liberia','Libéria','Либерия','LR','LBR',430,'LRD','Liberia','Monrovia','AF','231',11,0,2,202,'.lr',0,NULL,NULL),(378,'ليبيا','利比亚','Libya','Libia','Libye','Ливия','LY','LBY',434,'LYD','Libya','Tripoli','AF','218',0,0,2,15,'.ly',0,NULL,NULL),(379,'ليختنشتاين','列支敦士登','Liechtenstein','Liechtenstein','Liechtenstein','Лихтенштейн','LI','LIE',438,'CHF','Liechtenstein','Vaduz','EU','423',0,0,150,155,'.li',0,NULL,NULL),(380,'ليتوانيا','立陶宛','Lithuania','Lituania','Lituanie','Литва','LT','LTU',440,'EUR','Lithuania','Vilnius','EU','370',0,0,150,154,'.lt',0,NULL,NULL),(381,'لكسمبرغ','卢森堡','Luxembourg','Luxemburgo','Luxembourg','Люксембург','LU','LUX',442,'EUR','Luxembourg','Luxembourg','EU','352',0,0,150,155,'.lu',0,NULL,NULL),(382,'مدغشقر','马达加斯加','Madagascar','Madagascar','Madagascar','Мадагаскар','MG','MDG',450,'MGA','Madagascar','Antananarivo','AF','261',14,0,2,202,'.mg',0,NULL,NULL),(383,'ملاوي','马拉维','Malawi','Malawi','Malawi','Малави','MW','MWI',454,'MWK','Malawi','Lilongwe','AF','265',14,0,2,202,'.mw',0,NULL,NULL),(384,'ماليزيا','马来西亚','Malaysia','Malasia','Malaisie','Малайзия','MY','MYS',458,'MYR','Malaysia','Kuala Lumpur','AS','60',0,0,142,35,'.my',0,NULL,NULL),(385,'ملديف','马尔代夫','Maldives','Maldivas','Maldives','Мальдивские Острова','MV','MDV',462,'MVR','Maldives','Male','AS','960',0,0,142,34,'.mv',0,NULL,NULL),(386,'مالي','马里','Mali','Malí','Mali','Мали','ML','MLI',466,'XOF','Mali','Bamako','AF','223',11,0,2,202,'.ml',0,NULL,NULL),(387,'مالطة','马耳他','Malta','Malta','Malte','Мальта','MT','MLT',470,'EUR','Malta','Valletta','EU','356',0,0,150,39,'.mt',0,NULL,NULL),(388,'جزر مارشال','马绍尔群岛','Marshall Islands','Islas Marshall','Îles Marshall','Маршалловы Острова','MH','MHL',584,'USD','Marshall Islands','Majuro','OC','692',0,0,9,57,'.mh',0,NULL,NULL),(389,'مارتينيك','马提尼克','Martinique','Martinica','Martinique','Мартиника','MQ','MTQ',474,'EUR','Martinique','Fort-de-France','NA','596',29,0,19,419,'.mq',0,NULL,NULL),(390,'موريتانيا','毛里塔尼亚','Mauritania','Mauritania','Mauritanie','Мавритания','MR','MRT',478,'MRO','Mauritania','Nouakchott','AF','222',11,0,2,202,'.mr',0,NULL,NULL),(391,'موريشيوس','毛里求斯','Mauritius','Mauricio','Maurice','Маврикий','MU','MUS',480,'MUR','Mauritius','Port Louis','AF','230',14,0,2,202,'.mu',0,NULL,NULL),(392,'جزيرة مايوت','马约特','Mayotte','Mayotte','Mayotte','Острове Майотта','YT','MYT',175,'EUR','Mayotte','Mamoudzou','AF','262',14,0,2,202,'.yt',0,NULL,NULL),(393,'المكسيك','墨西哥','Mexico','México','Mexique','Мексика','MX','MEX',484,'MXN','Mexico','Mexico City','NA','52',13,0,19,419,'.mx',0,NULL,NULL),(394,'ميكرونيزيا (ولايات - الموحدة)','密克罗尼西亚(联邦)','Micronesia (Federated States of)','Micronesia (Estados Federados de)','Micronésie (États fédérés de)','Микронезия (Федеративные Штаты)','FM','FSM',583,'USD','Micronesia','Palikir','OC','691',0,0,9,57,'.fm',0,NULL,NULL),(395,'موناكو','摩纳哥','Monaco','Mónaco','Monaco','Монако','MC','MCO',492,'EUR','Monaco','Monaco','EU','377',0,0,150,155,'.mc',0,NULL,NULL),(396,'منغوليا','蒙古','Mongolia','Mongolia','Mongolie','Монголия','MN','MNG',496,'MNT','Mongolia','Ulan Bator','AS','976',0,0,142,30,'.mn',0,NULL,NULL),(397,'الجبل الأسود','黑山','Montenegro','Montenegro','Monténégro','Черногория','ME','MNE',499,'EUR','Montenegro','Podgorica','EU','382',0,0,150,39,'.me',0,NULL,NULL),(398,'مونتسيرات','蒙特塞拉特','Montserrat','Montserrat','Montserrat','Монтсеррат','MS','MSR',500,'XCD','Montserrat','Plymouth','NA','1-664',29,0,19,419,'.ms',0,NULL,NULL),(399,'المغرب','摩洛哥','Morocco','Marruecos','Maroc','Марокко','MA','MAR',504,'MAD','Morocco','Rabat','AF','212',0,0,2,15,'.ma',0,NULL,NULL),(400,'موزامبيق','莫桑比克','Mozambique','Mozambique','Mozambique','Мозамбик','MZ','MOZ',508,'MZN','Mozambique','Maputo','AF','258',14,0,2,202,'.mz',0,NULL,NULL),(401,'ميانمار','缅甸','Myanmar','Myanmar','Myanmar','Мьянма','MM','MMR',104,'MMK','Myanmar','Nay Pyi Taw','AS','95',0,0,142,35,'.mm',0,NULL,NULL),(402,'ناميبيا','纳米比亚','Namibia','Namibia','Namibie','Намибия','NA','NAM',516,'NAD,Z','Namibia','Windhoek','AF','264',18,0,2,202,'.na',0,NULL,NULL),(403,'ناورو','瑙鲁','Nauru','Nauru','Nauru','Науру','NR','NRU',520,'AUD','Nauru','Yaren','OC','674',0,0,9,57,'.nr',0,NULL,NULL),(404,'نيبال','尼泊尔','Nepal','Nepal','Népal','Непал','NP','NPL',524,'NPR','Nepal','Kathmandu','AS','977',0,0,142,34,'.np',0,NULL,NULL),(405,'هولندا','荷兰','Netherlands','Países Bajos','Pays-Bas','Нидерланды','NL','NLD',528,'EUR','Netherlands','Amsterdam','EU','31',0,0,150,155,'.nl',0,NULL,NULL),(406,'كاليدونيا الجديدة','新喀里多尼亚','New Caledonia','Nueva Caledonia','Nouvelle-Calédonie','Новая Каледония','NC','NCL',540,'XPF','New Caledonia','Noumea','OC','687',0,0,9,54,'.nc',0,NULL,NULL),(407,'نيوزيلندا','新西兰','New Zealand','Nueva Zelandia','Nouvelle-Zélande','Новая Зеландия','NZ','NZL',554,'NZD','New Zealand','Wellington','OC','64',0,0,9,53,'.nz',0,NULL,NULL),(408,'نيكاراغوا','尼加拉瓜','Nicaragua','Nicaragua','Nicaragua','Никарагуа','NI','NIC',558,'NIO','Nicaragua','Managua','NA','505',13,0,19,419,'.ni',0,NULL,NULL),(409,'النيجر','尼日尔','Niger','Níger','Niger','Нигер','NE','NER',562,'XOF','Niger','Niamey','AF','227',11,0,2,202,'.ne',0,NULL,NULL),(410,'نيجيريا','尼日利亚','Nigeria','Nigeria','Nigéria','Нигерия','NG','NGA',566,'NGN','Nigeria','Abuja','AF','234',11,0,2,202,'.ng',0,NULL,NULL),(411,'نيوي','纽埃','Niue','Niue','Nioué','Ниуэ','NU','NIU',570,'NZD','Niue','Alofi','OC','683',0,0,9,61,'.nu',0,NULL,NULL),(412,'جزيرة نورفلك','诺福克岛','Norfolk Island','Islas Norfolk','Île Norfolk','Остров Норфолк','NF','NFK',574,'AUD','Norfolk Island','Kingston','OC','672',0,0,9,53,'.nf',0,NULL,NULL),(413,'جزر ماريانا الشمالية','北马里亚纳群岛','Northern Mariana Islands','Islas Marianas Septentrionales','Îles Mariannes du Nord','Северные Марианские острова','MP','MNP',580,'USD','Northern Mariana Islands','Saipan','OC','1-670',0,0,9,57,'.mp',0,NULL,NULL),(414,'النرويج','挪威','Norway','Noruega','Norvège','Норвегия','NO','NOR',578,'NOK','Norway','Oslo','EU','47',0,0,150,154,'.no',0,NULL,NULL),(415,'عمان','阿曼','Oman','Omán','Oman','Оман','OM','OMN',512,'OMR','Oman','Muscat','AS','968',0,0,142,145,'.om',0,NULL,NULL),(416,'باكستان','巴基斯坦','Pakistan','Pakistán','Pakistan','Пакистан','PK','PAK',586,'PKR','Pakistan','Islamabad','AS','92',0,0,142,34,'.pk',0,NULL,NULL),(417,'بالاو','帕劳','Palau','Palau','Palaos','Палау','PW','PLW',585,'USD','Palau','Melekeok','OC','680',0,0,9,57,'.pw',0,NULL,NULL),(418,'بنما','巴拿马','Panama','Panamá','Panama','Панама','PA','PAN',591,'PAB,U','Panama','Panama City','NA','507',13,0,19,419,'.pa',0,NULL,NULL),(419,'بابوا غينيا الجديدة','巴布亚新几内亚','Papua New Guinea','Papua Nueva Guinea','Papouasie-Nouvelle-Guinée','Папуа-Новая Гвинея','PG','PNG',598,'PGK','Papua New Guinea','Port Moresby','OC','675',0,0,9,54,'.pg',0,NULL,NULL),(420,'باراغواي','巴拉圭','Paraguay','Paraguay','Paraguay','Парагвай','PY','PRY',600,'PYG','Paraguay','Asuncion','SA','595',5,0,19,419,'.py',0,NULL,NULL),(421,'بيرو','秘鲁','Peru','Perú','Pérou','Перу','PE','PER',604,'PEN','Peru','Lima','SA','51',5,0,19,419,'.pe',0,NULL,NULL),(422,'الفلبين','菲律宾','Philippines','Filipinas','Philippines','Филиппины','PH','PHL',608,'PHP','Philippines','Manila','AS','63',0,0,142,35,'.ph',0,NULL,NULL),(423,'بيتكيرن','皮特凯恩','Pitcairn','Pitcairn','Pitcairn','Питкэрн','PN','PCN',612,'NZD','Pitcairn Islands','Adamstown','OC','870',0,0,9,61,'.pn',0,NULL,NULL),(424,'بولندا','波兰','Poland','Polonia','Pologne','Польша','PL','POL',616,'PLN','Poland','Warsaw','EU','48',0,0,150,151,'.pl',0,NULL,NULL),(425,'البرتغال','葡萄牙','Portugal','Portugal','Portugal','Португалия','PT','PRT',620,'EUR','Portugal','Lisbon','EU','351',0,0,150,39,'.pt',0,NULL,NULL),(426,'بورتوريكو','波多黎各','Puerto Rico','Puerto Rico','Porto Rico','Пуэрто-Рико','PR','PRI',630,'USD','Puerto Rico','San Juan','NA','1',29,0,19,419,'.pr',0,NULL,NULL),(427,'قطر','卡塔尔','Qatar','Qatar','Qatar','Катар','QA','QAT',634,'QAR','Qatar','Doha','AS','974',0,0,142,145,'.qa',0,NULL,NULL),(428,'جمهورية كوريا','大韩民国','Republic of Korea','República de Corea','République de Corée','Республика Корея','KR','KOR',410,'KRW','South Korea','Seoul','AS','82',0,0,142,30,'.kr',0,NULL,NULL),(429,'جمهورية مولدوفا','摩尔多瓦共和国','Republic of Moldova','República de Moldova','République de Moldova','Республика Молдова','MD','MDA',498,'MDL','Moldova','Chisinau','EU','373',0,0,150,151,'.md',0,NULL,NULL),(430,'رومانيا','罗马尼亚','Romania','Rumania','Roumanie','Румыния','RO','ROU',642,'RON','Romania','Bucharest','EU','40',0,0,150,151,'.ro',0,NULL,NULL),(431,'الاتحاد الروسي','俄罗斯联邦','Russian Federation','Federación de Rusia','Fédération de Russie','Российская Федерация','RU','RUS',643,'RUB','Russia','Moscow','EU','7',0,0,150,151,'.ru',0,NULL,NULL),(432,'رواندا','卢旺达','Rwanda','Rwanda','Rwanda','Руанда','RW','RWA',646,'RWF','Rwanda','Kigali','AF','250',14,0,2,202,'.rw',0,NULL,NULL),(433,'ريونيون','留尼汪','Réunion','Reunión','Réunion','Реюньон','RE','REU',638,'EUR','Réunion','Saint-Denis','AF','262',14,0,2,202,'.re',0,NULL,NULL),(434,'سان بارتليمي','圣巴泰勒米','Saint Barthélemy','San Bartolomé','Saint-Barthélemy','Святой Варфоломей','BL','BLM',652,'EUR','St. Barthélemy','Gustavia','NA','590',29,0,19,419,'.gp',0,NULL,NULL),(435,'سانت هيلانة','圣赫勒拿','Saint Helena','Santa Elena','Sainte-Hélène','Остров Святой Елены','SH','SHN',654,'SHP','St. Helena','Jamestown','AF','290',11,0,2,202,'.sh',0,NULL,NULL),(436,'سانت كيتس ونيفس','圣基茨和尼维斯','Saint Kitts and Nevis','Saint Kitts y Nevis','Saint-Kitts-et-Nevis','Сент-Китс и Невис','KN','KNA',659,'XCD','St. Kitts & Nevis','Basseterre','NA','1-869',29,0,19,419,'.kn',0,NULL,NULL),(437,'سانت لوسيا','圣卢西亚','Saint Lucia','Santa Lucía','Sainte-Lucie','Сент-Люсия','LC','LCA',662,'XCD','St. Lucia','Castries','NA','1-758',29,0,19,419,'.lc',0,NULL,NULL),(438,'سان مارتن','圣马丁(法属)','Saint Martin (French Part)','San Martín (parte francesa)','Saint-Martin (partie française)','Сен-Мартен','MF','MAF',663,'EUR','St. Martin','Marigot','NA','590',29,0,19,419,'.gp',0,NULL,NULL),(439,'سان بيار وميكلون','圣皮埃尔和密克隆','Saint Pierre and Miquelon','Saint Pierre y Miquelon','Saint-Pierre-et-Miquelon','Сен-Пьер и Микелон','PM','SPM',666,'EUR','St. Pierre & Miquelon','Saint-Pierre','NA','508',0,0,19,21,'.pm',0,NULL,NULL),(440,'سانت فنسنت وجزر غرينادين','圣文森特和格林纳丁斯','Saint Vincent and the Grenadines','San Vicente y las Granadinas','Saint-Vincent-et-les Grenadines','Сент-Винсент и Гренадины','VC','VCT',670,'XCD','St. Vincent & Grenadines','Kingstown','NA','1-784',29,0,19,419,'.vc',0,NULL,NULL),(441,'ساموا','萨摩亚','Samoa','Samoa','Samoa','Самоа','WS','WSM',882,'WST','Samoa','Apia','OC','685',0,0,9,61,'.ws',0,NULL,NULL),(442,'سان مارينو','圣马力诺','San Marino','San Marino','Saint-Marin','Сан-Марино','SM','SMR',674,'EUR','San Marino','San Marino','EU','378',0,0,150,39,'.sm',0,NULL,NULL),(443,'سان تومي وبرينسيبي','圣多美和普林西比','Sao Tome and Principe','Santo Tomé y Príncipe','Sao Tomé-et-Principe','Сан-Томе и Принсипи','ST','STP',678,'STD','São Tomé & Príncipe','Sao Tome','AF','239',17,0,2,202,'.st',0,NULL,NULL),(445,'المملكة العربية السعودية','沙特阿拉伯','Saudi Arabia','Arabia Saudita','Arabie saoudite','Саудовская Аравия','SA','SAU',682,'SAR','Saudi Arabia','Riyadh','AS','966',0,0,142,145,'.sa',0,NULL,NULL),(446,'السنغال','塞内加尔','Senegal','Senegal','Sénégal','Сенегал','SN','SEN',686,'XOF','Senegal','Dakar','AF','221',11,0,2,202,'.sn',0,NULL,NULL),(447,'صربيا','塞尔维亚','Serbia','Serbia','Serbie','Сербия','RS','SRB',688,'RSD','Serbia','Belgrade','EU','381',0,0,150,39,'.rs',0,NULL,NULL),(448,'سيشيل','塞舌尔','Seychelles','Seychelles','Seychelles','Сейшельские Острова','SC','SYC',690,'SCR','Seychelles','Victoria','AF','248',14,0,2,202,'.sc',0,NULL,NULL),(449,'سيراليون','塞拉利昂','Sierra Leone','Sierra Leona','Sierra Leone','Сьерра-Леоне','SL','SLE',694,'SLL','Sierra Leone','Freetown','AF','232',11,0,2,202,'.sl',0,NULL,NULL),(450,'سنغافورة','新加坡','Singapore','Singapur','Singapour','Сингапур','SG','SGP',702,'SGD','Singapore','Singapore','AS','65',0,0,142,35,'.sg',0,NULL,NULL),(451,'سانت مارتن','圣马丁(荷属)','Sint Maarten (Dutch part)','San Martín (parte holandés)','Saint-Martin (partie néerlandaise)','Синт-Мартен','SX','SXM',534,'ANG','Sint Maarten','Philipsburg','NA','1-721',29,0,19,419,'.sx',0,NULL,NULL),(452,'سلوفاكيا','斯洛伐克','Slovakia','Eslovaquia','Slovaquie','Словакия','SK','SVK',703,'EUR','Slovakia','Bratislava','EU','421',0,0,150,151,'.sk',0,NULL,NULL),(453,'سلوفينيا','斯洛文尼亚','Slovenia','Eslovenia','Slovénie','Словения','SI','SVN',705,'EUR','Slovenia','Ljubljana','EU','386',0,0,150,39,'.si',0,NULL,NULL),(454,'جزر سليمان','所罗门群岛','Solomon Islands','Islas Salomón','Îles Salomon','Соломоновы Острова','SB','SLB',90,'SBD','Solomon Islands','Honiara','OC','677',0,0,9,54,'.sb',0,NULL,NULL),(455,'الصومال','索马里','Somalia','Somalia','Somalie','Сомали','SO','SOM',706,'SOS','Somalia','Mogadishu','AF','252',14,0,2,202,'.so',0,NULL,NULL),(456,'جنوب أفريقيا','南非','South Africa','Sudáfrica','Afrique du Sud','Южная Африка','ZA','ZAF',710,'ZAR','South Africa','Pretoria','AF','27',18,0,2,202,'.za',0,NULL,NULL),(457,'جورجيا الجنوبية وجزر ساندويتش الجنوبية','南乔治亚岛和南桑德韦奇岛','South Georgia and the South Sandwich Islands','Georgia del Sur y las Islas Sandwich del Sur','Géorgie du Sud-et-les Îles Sandwich du Sud','Южная Джорджия и Южные Сандвичевы острова','GS','SGS',239,'','South Georgia & South Sandwich Islands','Grytviken','AN','500',5,0,19,419,'.gs',0,NULL,NULL),(458,'جنوب السودان','南苏丹','South Sudan','Sudán del Sur','Soudan du Sud','Южный Судан','SS','SSD',728,'SSP','South Sudan','Juba','AF','211',14,0,2,202,'',0,NULL,NULL),(459,'إسبانيا','西班牙','Spain','España','Espagne','Испания','ES','ESP',724,'EUR','Spain','Madrid','EU','34',0,0,150,39,'.es',0,NULL,NULL),(460,'سري لانكا','斯里兰卡','Sri Lanka','Sri Lanka','Sri Lanka','Шри-Ланка','LK','LKA',144,'LKR','Sri Lanka','Colombo','AS','94',0,0,142,34,'.lk',0,NULL,NULL),(461,'دولة فلسطين','巴勒斯坦国','State of Palestine','Estado de Palestina','État de Palestine','Государство Палестина','PS','PSE',275,'','Palestine','East Jerusalem','AS','970',0,0,142,145,'.ps',0,NULL,NULL),(462,'السودان','苏丹','Sudan','Sudán','Soudan','Судан','SD','SDN',729,'SDG','Sudan','Khartoum','AF','249',0,0,2,15,'.sd',0,NULL,NULL),(463,'سورينام','苏里南','Suriname','Suriname','Suriname','Суринам','SR','SUR',740,'SRD','Suriname','Paramaribo','SA','597',5,0,19,419,'.sr',0,NULL,NULL),(464,'جزر سفالبارد وجان ماين','斯瓦尔巴岛和扬马延岛','Svalbard and Jan Mayen Islands','Islas Svalbard y Jan Mayen','Îles Svalbard-et-Jan Mayen','Острова Свальбард и Ян-Майен','SJ','SJM',744,'NOK','Svalbard & Jan Mayen','Longyearbyen','EU','47',0,0,150,154,'.sj',0,NULL,NULL),(465,'سوازيلند','斯威士兰','Swaziland','Swazilandia','Swaziland','Свазиленд','SZ','SWZ',748,'SZL','Swaziland','Mbabane','AF','268',18,0,2,202,'.sz',0,NULL,NULL),(466,'السويد','瑞典','Sweden','Suecia','Suède','Швеция','SE','SWE',752,'SEK','Sweden','Stockholm','EU','46',0,0,150,154,'.se',0,NULL,NULL),(467,'سويسرا','瑞士','Switzerland','Suiza','Suisse','Швейцария','CH','CHE',756,'CHF','Switzerland','Bern','EU','41',0,0,150,155,'.ch',0,NULL,NULL),(468,'الجمهورية العربية السورية','阿拉伯叙利亚共和国','Syrian Arab Republic','República Árabe Siria','République arabe syrienne','Сирийская Арабская Республика','SY','SYR',760,'SYP','Syria','Damascus','AS','963',0,0,142,145,'.sy',0,NULL,NULL),(469,'طاجيكستان','塔吉克斯坦','Tajikistan','Tayikistán','Tadjikistan','Таджикистан','TJ','TJK',762,'TJS','Tajikistan','Dushanbe','AS','992',0,0,142,143,'.tj',0,NULL,NULL),(470,'تايلند','泰国','Thailand','Tailandia','Thaïlande','Таиланд','TH','THA',764,'THB','Thailand','Bangkok','AS','66',0,0,142,35,'.th',0,NULL,NULL),(471,'جمهورية مقدونيا اليوغوسلافية سابقاً','前南斯拉夫的马其顿共和国','The former Yugoslav Republic of Macedonia','ex República Yugoslava de Macedonia','ex-République yougoslave de Macédoine','бывшая югославская Республика Македония','MK','MKD',807,'MKD','Macedonia','Skopje','EU','389',0,0,150,39,'.mk',0,NULL,NULL),(472,'تيمور- ليشتي','东帝汶','Timor-Leste','Timor-Leste','Timor-Leste','Тимор-Лешти','TL','TLS',626,'USD','Timor-Leste','Dili','OC','670',0,0,142,35,'.tl',0,NULL,NULL),(473,'توغو','多哥','Togo','Togo','Togo','Того','TG','TGO',768,'XOF','Togo','Lome','AF','228',11,0,2,202,'.tg',0,NULL,NULL),(474,'توكيلاو','托克劳','Tokelau','Tokelau','Tokélaou','Токелау','TK','TKL',772,'NZD','Tokelau','','OC','690',0,0,9,61,'.tk',0,NULL,NULL),(475,'تونغا','汤加','Tonga','Tonga','Tonga','Тонга','TO','TON',776,'TOP','Tonga','Nuku\'alofa','OC','676',0,0,9,61,'.to',0,NULL,NULL),(476,'ترينيداد وتوباغو','特立尼达和多巴哥','Trinidad and Tobago','Trinidad y Tabago','Trinité-et-Tobago','Тринидад и Тобаго','TT','TTO',780,'TTD','Trinidad & Tobago','Port of Spain','NA','1-868',29,0,19,419,'.tt',0,NULL,NULL),(477,'تونس','突尼斯','Tunisia','Túnez','Tunisie','Тунис','TN','TUN',788,'TND','Tunisia','Tunis','AF','216',0,0,2,15,'.tn',0,NULL,NULL),(478,'تركيا','土耳其','Turkey','Turquía','Turquie','Турция','TR','TUR',792,'TRY','Turkey','Ankara','AS','90',0,0,142,145,'.tr',0,NULL,NULL),(479,'تركمانستان','土库曼斯坦','Turkmenistan','Turkmenistán','Turkménistan','Туркменистан','TM','TKM',795,'TMT','Turkmenistan','Ashgabat','AS','993',0,0,142,143,'.tm',0,NULL,NULL),(480,'جزر تركس وكايكوس','特克斯和凯科斯群岛','Turks and Caicos Islands','Islas Turcas y Caicos','Îles Turques-et-Caïques','Острова Тёркс и Кайкос','TC','TCA',796,'USD','Turks & Caicos Islands','Cockburn Town','NA','1-649',29,0,19,419,'.tc',0,NULL,NULL),(481,'توفالو','图瓦卢','Tuvalu','Tuvalu','Tuvalu','Тувалу','TV','TUV',798,'AUD','Tuvalu','Funafuti','OC','688',0,0,9,61,'.tv',0,NULL,NULL),(482,'أوغندا','乌干达','Uganda','Uganda','Ouganda','Уганда','UG','UGA',800,'UGX','Uganda','Kampala','AF','256',14,0,2,202,'.ug',0,NULL,NULL),(483,'أوكرانيا','乌克兰','Ukraine','Ucrania','Ukraine','Украина','UA','UKR',804,'UAH','Ukraine','Kiev','EU','380',0,0,150,151,'.ua',0,NULL,NULL),(484,'الإمارات العربية المتحدة','阿拉伯联合酋长国','United Arab Emirates','Emiratos Árabes Unidos','Émirats arabes unis','Объединенные Арабские Эмираты','AE','ARE',784,'AED','United Arab Emirates','Abu Dhabi','AS','971',0,0,142,145,'.ae',0,NULL,NULL),(485,'المملكة المتحدة لبريطانيا العظمى وآيرلندا الشمالية','大不列颠及北爱尔兰联合王国','United Kingdom of Great Britain and Northern Ireland','Reino Unido de Gran Bretaña e Irlanda del Norte','Royaume-Uni de Grande-Bretagne et d\'Irlande du Nord','Соединенное Королевство Великобритании и Северной Ирландии','GB','GBR',826,'GBP','United Kingdom','London','EU','44',0,0,150,154,'.uk',0,NULL,NULL),(486,'جمهورية تنزانيا المتحدة','坦桑尼亚联合共和国','United Republic of Tanzania','República Unida de Tanzanía','République-Unie de Tanzanie','Объединенная Республика Танзания','TZ','TZA',834,'TZS','Tanzania','Dodoma','AF','255',14,0,2,202,'.tz',0,NULL,NULL),(487,'نائية التابعة للولايات المتحدة','美国本土外小岛屿','United States Minor Outlying Islands','Islas menores alejadas de Estados Unidos','Îles mineures éloignées des États-Unis','Внешние малые острова Coeдинeнныx Штaтoв','UM','UMI',581,'USD','U.S. Outlying Islands','','OC','',0,0,9,57,'.um',0,NULL,NULL),(488,'جزر فرجن التابعة للولايات المتحدة','美属维尔京群岛','United States Virgin Islands','Islas Vírgenes de los Estados Unidos','Îles Vierges américaines','Виргинские oстрова Coeдинeнныx Штaтoв','VI','VIR',850,'USD','U.S. Virgin Islands','Charlotte Amalie','NA','1-340',29,0,19,419,'.vi',0,NULL,NULL),(489,'الولايات المتحدة الأمريكية','美利坚合众国','United States of America','Estados Unidos de América','États-Unis d\'Amérique','Соединенные Штаты Америки','US','USA',840,'USD','US','Washington','NA','1',0,0,19,21,'.us',0,NULL,NULL),(490,'أوروغواي','乌拉圭','Uruguay','Uruguay','Uruguay','Уругвай','UY','URY',858,'UYU','Uruguay','Montevideo','SA','598',5,0,19,419,'.uy',0,NULL,NULL),(491,'أوزبكستان','乌兹别克斯坦','Uzbekistan','Uzbekistán','Ouzbékistan','Узбекистан','UZ','UZB',860,'UZS','Uzbekistan','Tashkent','AS','998',0,0,142,143,'.uz',0,NULL,NULL),(492,'فانواتو','瓦努阿图','Vanuatu','Vanuatu','Vanuatu','Вануату','VU','VUT',548,'VUV','Vanuatu','Port Vila','OC','678',0,0,9,54,'.vu',0,NULL,NULL),(493,'فنزويلا (جمهورية - البوليفارية)','委内瑞拉(玻利瓦尔共和国)','Venezuela (Bolivarian Republic of)','Venezuela (República Bolivariana de)','Venezuela (République bolivarienne du)','Венесуэла (Боливарианская Республика)','VE','VEN',862,'VEF','Venezuela','Caracas','SA','58',5,0,19,419,'.ve',0,NULL,NULL),(494,'فييت نام','越南','Viet Nam','Viet Nam','Viet Nam','Вьетнам','VN','VNM',704,'VND','Vietnam','Hanoi','AS','84',0,0,142,35,'.vn',0,NULL,NULL),(495,'جزر واليس وفوتونا','瓦利斯群岛和富图纳群岛','Wallis and Futuna Islands','Islas Wallis y Futuna','Îles Wallis-et-Futuna','Острова Уоллис и Футуна','WF','WLF',876,'XPF','Wallis & Futuna','Mata Utu','OC','681',0,0,9,61,'.wf',0,NULL,NULL),(496,'الصحراء الغربية','西撒哈拉','Western Sahara','Sáhara Occidental','Sahara occidental','Западная Сахара','EH','ESH',732,'MAD','Western Sahara','El-Aaiun','AF','212',0,0,2,15,'.eh',0,NULL,NULL),(497,'اليمن','也门','Yemen','Yemen','Yémen','Йемен','YE','YEM',887,'YER','Yemen','Sanaa','AS','967',0,0,142,145,'.ye',0,NULL,NULL),(498,'زامبيا','赞比亚','Zambia','Zambia','Zambie','Замбия','ZM','ZMB',894,'ZMW','Zambia','Lusaka','AF','260',14,0,2,202,'.zm',0,NULL,NULL),(499,'زمبابوي','津巴布韦','Zimbabwe','Zimbabwe','Zimbabwe','Зимбабве','ZW','ZWE',716,'ZWL','Zimbabwe','Harare','AF','263',14,0,2,202,'.zw',0,NULL,NULL),(500,'جزر ألاند','奥兰群岛','Åland Islands','Islas Åland','Îles d\'Åland','Аландские острова','AX','ALA',248,'EUR','Åland Islands','Mariehamn','EU','358',0,0,150,154,'.ax',0,NULL,NULL);




--
-- Table structure for table `__languages`
--

CREATE TABLE `__languages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ISO_639_2_B` varchar(3) NOT NULL,
  `ISO_639_2_T` varchar(3) NOT NULL,
  `ISO_639_1` varchar(3) NOT NULL,
  `name_en` varchar(100) NOT NULL,
  `name_fr` varchar(100) NOT NULL,
  `name_de` varchar(100) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=994 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `__languages`
--

INSERT INTO `__languages` VALUES (498,'aar','aar','aa','Afar','afar','Danakil-Sprache',0,NULL,NULL),(499,'abk','abk','ab','Abkhazian','abkhaze','Abchasisch',0,NULL,NULL),(500,'ace','ace',' ','Achinese','aceh','Aceh-Sprache',0,NULL,NULL),(501,'ach','ach',' ','Acoli','acoli','Acholi-Sprache',0,NULL,NULL),(502,'ada','ada',' ','Adangme','adangme','Adangme-Sprache',0,NULL,NULL),(503,'ady','ady',' ','Adyghe; Adygei','adyghé','Adygisch',0,NULL,NULL),(504,'afa','afa',' ','Afro-Asiatic languages','afro-asiatiques, langues','Hamitosemitische Sprachen (Andere)',0,NULL,NULL),(505,'afh','afh',' ','Afrihili','afrihili','Afrihili',0,NULL,NULL),(506,'afr','afr','af','Afrikaans','afrikaans','Afrikaans',0,NULL,NULL),(507,'ain','ain',' ','Ainu','aïnou','Ainu-Sprache',0,NULL,NULL),(508,'aka','aka','ak','Akan','akan','Akan-Sprache',0,NULL,NULL),(509,'akk','akk',' ','Akkadian','akkadien','Akkadisch',0,NULL,NULL),(510,'alb','sqi','sq','Albanian','albanais','Albanisch',0,NULL,NULL),(511,'ale','ale',' ','Aleut','aléoute','Aleutisch',0,NULL,NULL),(512,'alg','alg',' ','Algonquian languages','algonquines, langues','Algonkin-Sprachen (Andere)',0,NULL,NULL),(513,'alt','alt',' ','Southern Altai','altai du Sud','Altaisch',0,NULL,NULL),(514,'amh','amh','am','Amharic','amharique','Amharisch',0,NULL,NULL),(515,'ang','ang',' ','English, Old (ca.450-1100)','anglo-saxon (ca.450-1100)','Altenglisch',0,NULL,NULL),(516,'anp','anp',' ','Angika','angika','Anga-Sprache',0,NULL,NULL),(517,'apa','apa',' ','Apache languages','apaches, langues','Apachen-Sprachen',0,NULL,NULL),(518,'ara','ara','ar','Arabic','arabe','Arabisch',0,NULL,NULL),(519,'arc','arc',' ','Official Aramaic (700-300 BCE); Imperial Aramaic (700-300 BCE)','araméen d\'empire (700-300 BCE)','Aramäisch',0,NULL,NULL),(520,'arg','arg','an','Aragonese','aragonais','Aragonesisch',0,NULL,NULL),(521,'arm','hye','hy','Armenian','arménien','Armenisch',0,NULL,NULL),(522,'arn','arn',' ','Mapudungun; Mapuche','mapudungun; mapuche; mapuce','Arauka-Sprachen',0,NULL,NULL),(523,'arp','arp',' ','Arapaho','arapaho','Arapaho-Sprache',0,NULL,NULL),(524,'art','art',' ','Artificial languages','artificielles, langues','Kunstsprachen (Andere)',0,NULL,NULL),(525,'arw','arw',' ','Arawak','arawak','Arawak-Sprachen',0,NULL,NULL),(526,'asm','asm','as','Assamese','assamais','Assamesisch',0,NULL,NULL),(527,'ast','ast',' ','Asturian; Bable; Leonese; Asturleonese','asturien; bable; léonais; asturoléonais','Asturisch',0,NULL,NULL),(528,'ath','ath',' ','Athapascan languages','athapascanes, langues','Athapaskische Sprachen (Andere)',0,NULL,NULL),(529,'aus','aus',' ','Australian languages','australiennes, langues','Australische Sprachen',0,NULL,NULL),(530,'ava','ava','av','Avaric','avar','Awarisch',0,NULL,NULL),(531,'ave','ave','ae','Avestan','avestique','Avestisch',0,NULL,NULL),(532,'awa','awa',' ','Awadhi','awadhi','Awadhi',0,NULL,NULL),(533,'aym','aym','ay','Aymara','aymara','Aymará-Sprache',0,NULL,NULL),(534,'aze','aze','az','Azerbaijani','azéri','Aserbeidschanisch',0,NULL,NULL),(535,'bad','bad',' ','Banda languages','banda, langues','Banda-Sprachen (Ubangi-Sprachen)',0,NULL,NULL),(536,'bai','bai',' ','Bamileke languages','bamiléké, langues','Bamileke-Sprachen',0,NULL,NULL),(537,'bak','bak','ba','Bashkir','bachkir','Baschkirisch',0,NULL,NULL),(538,'bal','bal',' ','Baluchi','baloutchi','Belutschisch',0,NULL,NULL),(539,'bam','bam','bm','Bambara','bambara','Bambara-Sprache',0,NULL,NULL),(540,'ban','ban',' ','Balinese','balinais','Balinesisch',0,NULL,NULL),(541,'baq','eus','eu','Basque','basque','Baskisch',0,NULL,NULL),(542,'bas','bas',' ','Basa','basa','Basaa-Sprache',0,NULL,NULL),(543,'bat','bat',' ','Baltic languages','baltes, langues','Baltische Sprachen (Andere)',0,NULL,NULL),(544,'bej','bej',' ','Beja; Bedawiyet','bedja','Bedauye',0,NULL,NULL),(545,'bel','bel','be','Belarusian','biélorusse','Weißrussisch',0,NULL,NULL),(546,'bem','bem',' ','Bemba','bemba','Bemba-Sprache',0,NULL,NULL),(547,'ben','ben','bn','Bengali','bengali','Bengali',0,NULL,NULL),(548,'ber','ber',' ','Berber languages','berbères, langues','Berbersprachen (Andere)',0,NULL,NULL),(549,'bho','bho',' ','Bhojpuri','bhojpuri','Bhojpuri',0,NULL,NULL),(550,'bih','bih','bh','Bihari languages','langues biharis','Bihari (Andere)',0,NULL,NULL),(551,'bik','bik',' ','Bikol','bikol','Bikol-Sprache',0,NULL,NULL),(552,'bin','bin',' ','Bini; Edo','bini; edo','Edo-Sprache',0,NULL,NULL),(553,'bis','bis','bi','Bislama','bichlamar','Beach-la-mar',0,NULL,NULL),(554,'bla','bla',' ','Siksika','blackfoot','Blackfoot-Sprache',0,NULL,NULL),(555,'bnt','bnt',' ','Bantu languages','bantou, langues','Bantusprachen (Andere)',0,NULL,NULL),(556,'tib','bod','bo','Tibetan','tibétain','Tibetisch',0,NULL,NULL),(557,'bos','bos','bs','Bosnian','bosniaque','Bosnisch',0,NULL,NULL),(558,'bra','bra',' ','Braj','braj','Braj-Bhakha',0,NULL,NULL),(559,'bre','bre','br','Breton','breton','Bretonisch',0,NULL,NULL),(560,'btk','btk',' ','Batak languages','batak, langues','Batak-Sprache',0,NULL,NULL),(561,'bua','bua',' ','Buriat','bouriate','Burjatisch',0,NULL,NULL),(562,'bug','bug',' ','Buginese','bugi','Bugi-Sprache',0,NULL,NULL),(563,'bul','bul','bg','Bulgarian','bulgare','Bulgarisch',0,NULL,NULL),(564,'bur','mya','my','Burmese','birman','Birmanisch',0,NULL,NULL),(565,'byn','byn',' ','Blin; Bilin','blin; bilen','Bilin-Sprache',0,NULL,NULL),(566,'cad','cad',' ','Caddo','caddo','Caddo-Sprachen',0,NULL,NULL),(567,'cai','cai',' ','Central American Indian languages','amérindiennes de l\'Amérique centrale, langues','Indianersprachen, Zentralamerika (Andere)',0,NULL,NULL),(568,'car','car',' ','Galibi Carib','karib; galibi; carib','Karibische Sprachen',0,NULL,NULL),(569,'cat','cat','ca','Catalan; Valencian','catalan; valencien','Katalanisch',0,NULL,NULL),(570,'cau','cau',' ','Caucasian languages','caucasiennes, langues','Kaukasische Sprachen (Andere)',0,NULL,NULL),(571,'ceb','ceb',' ','Cebuano','cebuano','Cebuano',0,NULL,NULL),(572,'cel','cel',' ','Celtic languages','celtiques, langues; celtes, langues','Keltische Sprachen (Andere)',0,NULL,NULL),(573,'cze','ces','cs','Czech','tchèque','Tschechisch',0,NULL,NULL),(574,'cha','cha','ch','Chamorro','chamorro','Chamorro-Sprache',0,NULL,NULL),(575,'chb','chb',' ','Chibcha','chibcha','Chibcha-Sprachen',0,NULL,NULL),(576,'che','che','ce','Chechen','tchétchène','Tschetschenisch',0,NULL,NULL),(577,'chg','chg',' ','Chagatai','djaghataï','Tschagataisch',0,NULL,NULL),(578,'chi','zho','zh','Chinese','chinois','Chinesisch',0,NULL,NULL),(579,'chk','chk',' ','Chuukese','chuuk','Trukesisch',0,NULL,NULL),(580,'chm','chm',' ','Mari','mari','Tscheremissisch',0,NULL,NULL),(581,'chn','chn',' ','Chinook jargon','chinook, jargon','Chinook-Jargon',0,NULL,NULL),(582,'cho','cho',' ','Choctaw','choctaw','Choctaw-Sprache',0,NULL,NULL),(583,'chp','chp',' ','Chipewyan; Dene Suline','chipewyan','Chipewyan-Sprache',0,NULL,NULL),(584,'chr','chr',' ','Cherokee','cherokee','Cherokee-Sprache',0,NULL,NULL),(585,'chu','chu','cu','Church Slavic; Old Slavonic; Church Slavonic; Old Bulgarian; Old Church Slavonic','slavon d\'église; vieux slave; slavon liturgique; vieux bulgare','Kirchenslawisch',0,NULL,NULL),(586,'chv','chv','cv','Chuvash','tchouvache','Tschuwaschisch',0,NULL,NULL),(587,'chy','chy',' ','Cheyenne','cheyenne','Cheyenne-Sprache',0,NULL,NULL),(588,'cmc','cmc',' ','Chamic languages','chames, langues','Cham-Sprachen',0,NULL,NULL),(589,'cnr','cnr',' ','Montenegrin','monténégrin','Montenegrinisch',0,NULL,NULL),(590,'cop','cop',' ','Coptic','copte','Koptisch',0,NULL,NULL),(591,'cor','cor','kw','Cornish','cornique','Kornisch',0,NULL,NULL),(592,'cos','cos','co','Corsican','corse','Korsisch',0,NULL,NULL),(593,'cpe','cpe',' ','Creoles and pidgins, English based','créoles et pidgins basés sur l\'anglais','Kreolisch-Englisch (Andere)',0,NULL,NULL),(594,'cpf','cpf',' ','Creoles and pidgins, French-based','créoles et pidgins basés sur le français','Kreolisch-Französisch (Andere)',0,NULL,NULL),(595,'cpp','cpp',' ','Creoles and pidgins, Portuguese-based','créoles et pidgins basés sur le portugais','Kreolisch-Portugiesisch (Andere)',0,NULL,NULL),(596,'cre','cre','cr','Cree','cree','Cree-Sprache',0,NULL,NULL),(597,'crh','crh',' ','Crimean Tatar; Crimean Turkish','tatar de Crimé','Krimtatarisch',0,NULL,NULL),(598,'crp','crp',' ','Creoles and pidgins','créoles et pidgins','Kreolische Sprachen; Pidginsprachen (Andere)',0,NULL,NULL),(599,'csb','csb',' ','Kashubian','kachoube','Kaschubisch',0,NULL,NULL),(600,'cus','cus',' ','Cushitic languages','couchitiques, langues','Kuschitische Sprachen (Andere)',0,NULL,NULL),(601,'wel','cym','cy','Welsh','gallois','Kymrisch',0,NULL,NULL),(603,'dak','dak',' ','Dakota','dakota','Dakota-Sprache',0,NULL,NULL),(604,'dan','dan','da','Danish','danois','Dänisch',0,NULL,NULL),(605,'dar','dar',' ','Dargwa','dargwa','Darginisch',0,NULL,NULL),(606,'day','day',' ','Land Dayak languages','dayak, langues','Dajakisch',0,NULL,NULL),(607,'del','del',' ','Delaware','delaware','Delaware-Sprache',0,NULL,NULL),(608,'den','den',' ','Slave (Athapascan)','esclave (athapascan)','Slave-Sprache',0,NULL,NULL),(609,'ger','deu','de','German','allemand','Deutsch',0,NULL,NULL),(610,'dgr','dgr',' ','Dogrib','dogrib','Dogrib-Sprache',0,NULL,NULL),(611,'din','din',' ','Dinka','dinka','Dinka-Sprache',0,NULL,NULL),(612,'div','div','dv','Divehi; Dhivehi; Maldivian','maldivien','Maledivisch',0,NULL,NULL),(613,'doi','doi',' ','Dogri','dogri','Dogri',0,NULL,NULL),(614,'dra','dra',' ','Dravidian languages','dravidiennes, langues','Drawidische Sprachen (Andere)',0,NULL,NULL),(615,'dsb','dsb',' ','Lower Sorbian','bas-sorabe','Niedersorbisch',0,NULL,NULL),(616,'dua','dua',' ','Duala','douala','Duala-Sprachen',0,NULL,NULL),(617,'dum','dum',' ','Dutch, Middle (ca.1050-1350)','néerlandais moyen (ca. 1050-1350)','Mittelniederländisch',0,NULL,NULL),(618,'dut','nld','nl','Dutch; Flemish','néerlandais; flamand','Niederländisch',0,NULL,NULL),(619,'dyu','dyu',' ','Dyula','dioula','Dyula-Sprache',0,NULL,NULL),(620,'dzo','dzo','dz','Dzongkha','dzongkha','Dzongkha',0,NULL,NULL),(621,'efi','efi',' ','Efik','efik','Efik',0,NULL,NULL),(622,'egy','egy',' ','Egyptian (Ancient)','égyptien','Ägyptisch',0,NULL,NULL),(623,'eka','eka',' ','Ekajuk','ekajuk','Ekajuk',0,NULL,NULL),(624,'gre','ell','el','Greek, Modern (1453-)','grec moderne (après 1453)','Neugriechisch',0,NULL,NULL),(625,'elx','elx',' ','Elamite','élamite','Elamisch',0,NULL,NULL),(626,'eng','eng','en','English','anglais','Englisch',0,NULL,NULL),(627,'enm','enm',' ','English, Middle (1100-1500)','anglais moyen (1100-1500)','Mittelenglisch',0,NULL,NULL),(628,'epo','epo','eo','Esperanto','espéranto','Esperanto',0,NULL,NULL),(629,'est','est','et','Estonian','estonien','Estnisch',0,NULL,NULL),(631,'ewe','ewe','ee','Ewe','éwé','Ewe-Sprache',0,NULL,NULL),(632,'ewo','ewo',' ','Ewondo','éwondo','Ewondo',0,NULL,NULL),(633,'fan','fan',' ','Fang','fang','Pangwe-Sprache',0,NULL,NULL),(634,'fao','fao','fo','Faroese','féroïen','Färöisch',0,NULL,NULL),(635,'per','fas','fa','Farsi','persan','Persisch',0,NULL,NULL),(636,'fat','fat',' ','Fanti','fanti','Fante-Sprache',0,NULL,NULL),(637,'fij','fij','fj','Fijian','fidjien','Fidschi-Sprache',0,NULL,NULL),(638,'fil','fil',' ','Filipino; Pilipino','filipino; pilipino','Pilipino',0,NULL,NULL),(639,'fin','fin','fi','Finnish','finnois','Finnisch',0,NULL,NULL),(640,'fiu','fiu',' ','Finno-Ugrian languages','finno-ougriennes, langues','Finnougrische Sprachen (Andere)',0,NULL,NULL),(641,'fon','fon',' ','Fon','fon','Fon-Sprache',0,NULL,NULL),(642,'fre','fra','fr','French','français','Französisch',0,NULL,NULL),(643,'frm','frm',' ','French, Middle (ca.1400-1600)','français moyen (1400-1600)','Mittelfranzösisch',0,NULL,NULL),(644,'fro','fro',' ','French, Old (842-ca.1400)','français ancien (842-ca.1400)','Altfranzösisch',0,NULL,NULL),(645,'frr','frr',' ','Northern Frisian','frison septentrional','Nordfriesisch',0,NULL,NULL),(646,'frs','frs',' ','Eastern Frisian','frison oriental','Ostfriesisch',0,NULL,NULL),(647,'fry','fry','fy','Western Frisian','frison occidental','Friesisch',0,NULL,NULL),(648,'ful','ful','ff','Fulah','peul','Ful',0,NULL,NULL),(649,'fur','fur',' ','Friulian','frioulan','Friulisch',0,NULL,NULL),(650,'gaa','gaa',' ','Ga','ga','Ga-Sprache',0,NULL,NULL),(651,'gay','gay',' ','Gayo','gayo','Gayo-Sprache',0,NULL,NULL),(652,'gba','gba',' ','Gbaya','gbaya','Gbaya-Sprache',0,NULL,NULL),(653,'gem','gem',' ','Germanic languages','germaniques, langues','Germanische Sprachen (Andere)',0,NULL,NULL),(654,'geo','kat','ka','Georgian','géorgien','Georgisch',0,NULL,NULL),(656,'gez','gez',' ','Geez','guèze','Altäthiopisch',0,NULL,NULL),(657,'gil','gil',' ','Gilbertese','kiribati','Gilbertesisch',0,NULL,NULL),(658,'gla','gla','gd','Gaelic; Scottish Gaelic','gaélique; gaélique écossais','Gälisch-Schottisch',0,NULL,NULL),(659,'gle','gle','ga','Irish','irlandais','Irisch',0,NULL,NULL),(660,'glg','glg','gl','Galician','galicien','Galicisch',0,NULL,NULL),(661,'glv','glv','gv','Manx','manx; mannois','Manx',0,NULL,NULL),(662,'gmh','gmh',' ','German, Middle High (ca.1050-1500)','allemand, moyen haut (ca. 1050-1500)','Mittelhochdeutsch',0,NULL,NULL),(663,'goh','goh',' ','German, Old High (ca.750-1050)','allemand, vieux haut (ca. 750-1050)','Althochdeutsch',0,NULL,NULL),(664,'gon','gon',' ','Gondi','gond','Gondi-Sprache',0,NULL,NULL),(665,'gor','gor',' ','Gorontalo','gorontalo','Gorontalesisch',0,NULL,NULL),(666,'got','got',' ','Gothic','gothique','Gotisch',0,NULL,NULL),(667,'grb','grb',' ','Grebo','grebo','Grebo-Sprache',0,NULL,NULL),(668,'grc','grc',' ','Greek, Ancient (to 1453)','grec ancien (jusqu\'à 1453)','Griechisch',0,NULL,NULL),(670,'grn','grn','gn','Guarani','guarani','Guaraní-Sprache',0,NULL,NULL),(671,'gsw','gsw',' ','Swiss German; Alemannic; Alsatian','suisse alémanique; alémanique; alsacien','Schweizerdeutsch',0,NULL,NULL),(672,'guj','guj','gu','Gujarati','goudjrati','Gujarati-Sprache',0,NULL,NULL),(673,'gwi','gwi',' ','Gwich\'in','gwich\'in','Kutchin-Sprache',0,NULL,NULL),(674,'hai','hai',' ','Haida','haida','Haida-Sprache',0,NULL,NULL),(675,'hat','hat','ht','Haitian; Haitian Creole','haïtien; créole haïtien','Haïtien (Haiti-Kreolisch)',0,NULL,NULL),(676,'hau','hau','ha','Hausa','haoussa','Haussa-Sprache',0,NULL,NULL),(677,'haw','haw',' ','Hawaiian','hawaïen','Hawaiisch',0,NULL,NULL),(678,'heb','heb','he','Hebrew','hébreu','Hebräisch',0,NULL,NULL),(679,'her','her','hz','Herero','herero','Herero-Sprache',0,NULL,NULL),(680,'hil','hil',' ','Hiligaynon','hiligaynon','Hiligaynon-Sprache',0,NULL,NULL),(681,'him','him',' ','Himachali languages; Western Pahari languages','langues himachalis; langues paharis occidentales','Himachali',0,NULL,NULL),(682,'hin','hin','hi','Hindi','hindi','Hindi',0,NULL,NULL),(683,'hit','hit',' ','Hittite','hittite','Hethitisch',0,NULL,NULL),(684,'hmn','hmn',' ','Hmong; Mong','hmong','Miao-Sprachen',0,NULL,NULL),(685,'hmo','hmo','ho','Hiri Motu','hiri motu','Hiri-Motu',0,NULL,NULL),(686,'hrv','hrv','hr','Croatian','croate','Kroatisch',0,NULL,NULL),(687,'hsb','hsb',' ','Upper Sorbian','haut-sorabe','Obersorbisch',0,NULL,NULL),(688,'hun','hun','hu','Hungarian','hongrois','Ungarisch',0,NULL,NULL),(689,'hup','hup',' ','Hupa','hupa','Hupa-Sprache',0,NULL,NULL),(691,'iba','iba',' ','Iban','iban','Iban-Sprache',0,NULL,NULL),(692,'ibo','ibo','ig','Igbo','igbo','Ibo-Sprache',0,NULL,NULL),(693,'ice','isl','is','Icelandic','islandais','Isländisch',0,NULL,NULL),(694,'ido','ido','io','Ido','ido','Ido',0,NULL,NULL),(695,'iii','iii','ii','Sichuan Yi; Nuosu','yi de Sichuan','Lalo-Sprache',0,NULL,NULL),(696,'ijo','ijo',' ','Ijo languages','ijo, langues','Ijo-Sprache',0,NULL,NULL),(697,'iku','iku','iu','Inuktitut','inuktitut','Inuktitut',0,NULL,NULL),(698,'ile','ile','ie','Interlingue; Occidental','interlingue','Interlingue',0,NULL,NULL),(699,'ilo','ilo',' ','Iloko','ilocano','Ilokano-Sprache',0,NULL,NULL),(700,'ina','ina','ia','Interlingua (International Auxiliary Language Association)','interlingua (langue auxiliaire internationale)','Interlingua',0,NULL,NULL),(701,'inc','inc',' ','Indic languages','indo-aryennes, langues','Indoarische Sprachen (Andere)',0,NULL,NULL),(702,'ind','ind','id','Indonesian','indonésien','Bahasa Indonesia',0,NULL,NULL),(703,'ine','ine',' ','Indo-European languages','indo-européennes, langues','Indogermanische Sprachen (Andere)',0,NULL,NULL),(704,'inh','inh',' ','Ingush','ingouche','Inguschisch',0,NULL,NULL),(705,'ipk','ipk','ik','Inupiaq','inupiaq','Inupik',0,NULL,NULL),(706,'ira','ira',' ','Iranian languages','iraniennes, langues','Iranische Sprachen (Andere)',0,NULL,NULL),(707,'iro','iro',' ','Iroquoian languages','iroquoises, langues','Irokesische Sprachen',0,NULL,NULL),(709,'ita','ita','it','Italian','italien','Italienisch',0,NULL,NULL),(710,'jav','jav','jv','Javanese','javanais','Javanisch',0,NULL,NULL),(711,'jbo','jbo',' ','Lojban','lojban','Lojban',0,NULL,NULL),(712,'jpn','jpn','ja','Japanese','japonais','Japanisch',0,NULL,NULL),(713,'jpr','jpr',' ','Judeo-Persian','judéo-persan','Jüdisch-Persisch',0,NULL,NULL),(714,'jrb','jrb',' ','Judeo-Arabic','judéo-arabe','Jüdisch-Arabisch',0,NULL,NULL),(715,'kaa','kaa',' ','Kara-Kalpak','karakalpak','Karakalpakisch',0,NULL,NULL),(716,'kab','kab',' ','Kabyle','kabyle','Kabylisch',0,NULL,NULL),(717,'kac','kac',' ','Kachin; Jingpho','kachin; jingpho','Kachin-Sprache',0,NULL,NULL),(718,'kal','kal','kl','Kalaallisut; Greenlandic','groenlandais','Grönländisch',0,NULL,NULL),(719,'kam','kam',' ','Kamba','kamba','Kamba-Sprache',0,NULL,NULL),(720,'kan','kan','kn','Kannada','kannada','Kannada',0,NULL,NULL),(721,'kar','kar',' ','Karen languages','karen, langues','Karenisch',0,NULL,NULL),(722,'kas','kas','ks','Kashmiri','kashmiri','Kaschmiri',0,NULL,NULL),(724,'kau','kau','kr','Kanuri','kanouri','Kanuri-Sprache',0,NULL,NULL),(725,'kaw','kaw',' ','Kawi','kawi','Kawi',0,NULL,NULL),(726,'kaz','kaz','kk','Kazakh','kazakh','Kasachisch',0,NULL,NULL),(727,'kbd','kbd',' ','Kabardian','kabardien','Kabardinisch',0,NULL,NULL),(728,'kha','kha',' ','Khasi','khasi','Khasi-Sprache',0,NULL,NULL),(729,'khi','khi',' ','Khoisan languages','khoïsan, langues','Khoisan-Sprachen (Andere)',0,NULL,NULL),(730,'khm','khm','km','Central Khmer','khmer central','Kambodschanisch',0,NULL,NULL),(731,'kho','kho',' ','Khotanese; Sakan','khotanais; sakan','Sakisch',0,NULL,NULL),(732,'kik','kik','ki','Kikuyu; Gikuyu','kikuyu','Kikuyu-Sprache',0,NULL,NULL),(733,'kin','kin','rw','Kinyarwanda','rwanda','Rwanda-Sprache',0,NULL,NULL),(734,'kir','kir','ky','Kirghiz; Kyrgyz','kirghiz','Kirgisisch',0,NULL,NULL),(735,'kmb','kmb',' ','Kimbundu','kimbundu','Kimbundu-Sprache',0,NULL,NULL),(736,'kok','kok',' ','Konkani','konkani','Konkani',0,NULL,NULL),(737,'kom','kom','kv','Komi','kom','Komi-Sprache',0,NULL,NULL),(738,'kon','kon','kg','Kongo','kongo','Kongo-Sprache',0,NULL,NULL),(739,'kor','kor','ko','Korean','coréen','Koreanisch',0,NULL,NULL),(740,'kos','kos',' ','Kosraean','kosrae','Kosraeanisch',0,NULL,NULL),(741,'kpe','kpe',' ','Kpelle','kpellé','Kpelle-Sprache',0,NULL,NULL),(742,'krc','krc',' ','Karachay-Balkar','karatchai balkar','Karatschaiisch-Balkarisch',0,NULL,NULL),(743,'krl','krl',' ','Karelian','carélien','Karelisch',0,NULL,NULL),(744,'kro','kro',' ','Kru languages','krou, langues','Kru-Sprachen (Andere)',0,NULL,NULL),(745,'kru','kru',' ','Kurukh','kurukh','Oraon-Sprache',0,NULL,NULL),(746,'kua','kua','kj','Kuanyama; Kwanyama','kuanyama; kwanyama','Kwanyama-Sprache',0,NULL,NULL),(747,'kum','kum',' ','Kumyk','koumyk','Kumükisch',0,NULL,NULL),(748,'kur','kur','ku','Kurdish','kurde','Kurdisch',0,NULL,NULL),(749,'kut','kut',' ','Kutenai','kutenai','Kutenai-Sprache',0,NULL,NULL),(750,'lad','lad',' ','Ladino','judéo-espagnol','Judenspanisch',0,NULL,NULL),(751,'lah','lah',' ','Lahnda','lahnda','Lahnda',0,NULL,NULL),(752,'lam','lam',' ','Lamba','lamba','Lamba-Sprache (Bantusprache)',0,NULL,NULL),(753,'lao','lao','lo','Lao','lao','Laotisch',0,NULL,NULL),(754,'lat','lat','la','Latin','latin','Latein',0,NULL,NULL),(755,'lav','lav','lv','Latvian','letton','Lettisch',0,NULL,NULL),(756,'lez','lez',' ','Lezghian','lezghien','Lesgisch',0,NULL,NULL),(757,'lim','lim','li','Limburgan; Limburger; Limburgish','limbourgeois','Limburgisch',0,NULL,NULL),(758,'lin','lin','ln','Lingala','lingala','Lingala',0,NULL,NULL),(759,'lit','lit','lt','Lithuanian','lituanien','Litauisch',0,NULL,NULL),(760,'lol','lol',' ','Mongo','mongo','Mongo-Sprache',0,NULL,NULL),(761,'loz','loz',' ','Lozi','lozi','Rotse-Sprache',0,NULL,NULL),(762,'ltz','ltz','lb','Luxembourgish; Letzeburgesch','luxembourgeois','Luxemburgisch',0,NULL,NULL),(763,'lua','lua',' ','Luba-Lulua','luba-lulua','Lulua-Sprache',0,NULL,NULL),(764,'lub','lub','lu','Luba-Katanga','luba-katanga','Luba-Katanga-Sprache',0,NULL,NULL),(765,'lug','lug','lg','Ganda','ganda','Ganda-Sprache',0,NULL,NULL),(766,'lui','lui',' ','Luiseno','luiseno','Luiseño-Sprache',0,NULL,NULL),(767,'lun','lun',' ','Lunda','lunda','Lunda-Sprache',0,NULL,NULL),(768,'luo','luo',' ','Luo (Kenya and Tanzania)','luo (Kenya et Tanzanie)','Luo-Sprache',0,NULL,NULL),(769,'lus','lus',' ','Lushai','lushai','Lushai-Sprache',0,NULL,NULL),(770,'mac','mkd','mk','Macedonian','macédonien','Makedonisch',0,NULL,NULL),(771,'mad','mad',' ','Madurese','madourais','Maduresisch',0,NULL,NULL),(772,'mag','mag',' ','Magahi','magahi','Khotta',0,NULL,NULL),(773,'mah','mah','mh','Marshallese','marshall','Marschallesisch',0,NULL,NULL),(774,'mai','mai',' ','Maithili','maithili','Maithili',0,NULL,NULL),(775,'mak','mak',' ','Makasar','makassar','Makassarisch',0,NULL,NULL),(776,'mal','mal','ml','Malayalam','malayalam','Malayalam',0,NULL,NULL),(777,'man','man',' ','Mandingo','mandingue','Malinke-Sprache',0,NULL,NULL),(778,'mao','mri','mi','Maori','maori','Maori-Sprache',0,NULL,NULL),(779,'map','map',' ','Austronesian languages','austronésiennes, langues','Austronesische Sprachen (Andere)',0,NULL,NULL),(780,'mar','mar','mr','Marathi','marathe','Marathi',0,NULL,NULL),(781,'mas','mas',' ','Masai','massaï','Massai-Sprache',0,NULL,NULL),(782,'may','msa','ms','Malay','malais','Malaiisch',0,NULL,NULL),(783,'mdf','mdf',' ','Moksha','moksa','Mokscha-Sprache',0,NULL,NULL),(784,'mdr','mdr',' ','Mandar','mandar','Mandaresisch',0,NULL,NULL),(785,'men','men',' ','Mende','mendé','Mende-Sprache',0,NULL,NULL),(786,'mga','mga',' ','Irish, Middle (900-1200)','irlandais moyen (900-1200)','Mittelirisch',0,NULL,NULL),(787,'mic','mic',' ','Mi\'kmaq; Micmac','mi\'kmaq; micmac','Micmac-Sprache',0,NULL,NULL),(788,'min','min',' ','Minangkabau','minangkabau','Minangkabau-Sprache',0,NULL,NULL),(789,'mis','mis',' ','Uncoded languages','langues non codées','Einzelne andere Sprachen',0,NULL,NULL),(791,'mkh','mkh',' ','Mon-Khmer languages','môn-khmer, langues','Mon-Khmer-Sprachen (Andere)',0,NULL,NULL),(792,'mlg','mlg','mg','Malagasy','malgache','Malagassi-Sprache',0,NULL,NULL),(793,'mlt','mlt','mt','Maltese','maltais','Maltesisch',0,NULL,NULL),(794,'mnc','mnc',' ','Manchu','mandchou','Mandschurisch',0,NULL,NULL),(795,'mni','mni',' ','Manipuri','manipuri','Meithei-Sprache',0,NULL,NULL),(796,'mno','mno',' ','Manobo languages','manobo, langues','Manobo-Sprachen',0,NULL,NULL),(797,'moh','moh',' ','Mohawk','mohawk','Mohawk-Sprache',0,NULL,NULL),(798,'mon','mon','mn','Mongolian','mongol','Mongolisch',0,NULL,NULL),(799,'mos','mos',' ','Mossi','moré','Mossi-Sprache',0,NULL,NULL),(800,'mul','mul',' ','Multiple languages','multilingue','Mehrere Sprachen',0,NULL,NULL),(801,'mun','mun',' ','Munda languages','mounda, langues','Mundasprachen (Andere)',0,NULL,NULL),(802,'mus','mus',' ','Creek','muskogee','Muskogisch',0,NULL,NULL),(803,'mwl','mwl',' ','Mirandese','mirandais','Mirandesisch',0,NULL,NULL),(804,'mwr','mwr',' ','Marwari','marvari','Marwari',0,NULL,NULL),(806,'myn','myn',' ','Mayan languages','maya, langues','Maya-Sprachen',0,NULL,NULL),(807,'myv','myv',' ','Erzya','erza','Erza-Mordwinisch',0,NULL,NULL),(808,'nah','nah',' ','Nahuatl languages','nahuatl, langues','Nahuatl',0,NULL,NULL),(809,'nai','nai',' ','North American Indian languages','nord-amérindiennes, langues','Indianersprachen, Nordamerika (Andere)',0,NULL,NULL),(810,'nap','nap',' ','Neapolitan','napolitain','Neapel / Mundart',0,NULL,NULL),(811,'nau','nau','na','Nauru','nauruan','Nauruanisch',0,NULL,NULL),(812,'nav','nav','nv','Navajo; Navaho','navaho','Navajo-Sprache',0,NULL,NULL),(813,'nbl','nbl','nr','Ndebele, South; South Ndebele','ndébélé du Sud','Ndebele-Sprache (Transvaal)',0,NULL,NULL),(814,'nde','nde','nd','Ndebele, North; North Ndebele','ndébélé du Nord','Ndebele-Sprache (Simbabwe)',0,NULL,NULL),(815,'ndo','ndo','ng','Ndonga','ndonga','Ndonga',0,NULL,NULL),(816,'nds','nds',' ','Low German; Low Saxon; German, Low; Saxon, Low','bas allemand; bas saxon; allemand, bas; saxon, bas','Niederdeutsch',0,NULL,NULL),(817,'nep','nep','ne','Nepali','népalais','Nepali',0,NULL,NULL),(818,'new','new',' ','Nepal Bhasa; Newari','nepal bhasa; newari','Newari',0,NULL,NULL),(819,'nia','nia',' ','Nias','nias','Nias-Sprache',0,NULL,NULL),(820,'nic','nic',' ','Niger-Kordofanian languages','nigéro-kordofaniennes, langues','Nigerkordofanische Sprachen (Andere)',0,NULL,NULL),(821,'niu','niu',' ','Niuean','niué','Niue-Sprache',0,NULL,NULL),(822,'nno','nno','nn','Norwegian Nynorsk; Nynorsk, Norwegian','norvégien nynorsk; nynorsk, norvégien','Nynorsk',0,NULL,NULL),(823,'nob','nob','nb','Bokmål, Norwegian; Norwegian Bokmål','norvégien bokmål','Bokmål',0,NULL,NULL),(824,'nog','nog',' ','Nogai','nogaï; nogay','Nogaisch',0,NULL,NULL),(825,'non','non',' ','Norse, Old','norrois, vieux','Altnorwegisch',0,NULL,NULL),(826,'nor','nor','no','Norwegian','norvégien','Norwegisch',0,NULL,NULL),(827,'nqo','nqo',' ','N\'Ko','n\'ko','N\'Ko',0,NULL,NULL),(828,'nso','nso',' ','Pedi; Sepedi; Northern Sotho','pedi; sepedi; sotho du Nord','Pedi-Sprache',0,NULL,NULL),(829,'nub','nub',' ','Nubian languages','nubiennes, langues','Nubische Sprachen',0,NULL,NULL),(830,'nwc','nwc',' ','Classical Newari; Old Newari; Classical Nepal Bhasa','newari classique','Alt-Newari',0,NULL,NULL),(831,'nya','nya','ny','Chichewa; Chewa; Nyanja','chichewa; chewa; nyanja','Nyanja-Sprache',0,NULL,NULL),(832,'nym','nym',' ','Nyamwezi','nyamwezi','Nyamwezi-Sprache',0,NULL,NULL),(833,'nyn','nyn',' ','Nyankole','nyankolé','Nkole-Sprache',0,NULL,NULL),(834,'nyo','nyo',' ','Nyoro','nyoro','Nyoro-Sprache',0,NULL,NULL),(835,'nzi','nzi',' ','Nzima','nzema','Nzima-Sprache',0,NULL,NULL),(836,'oci','oci','oc','Occitan (post 1500)','occitan (après 1500)','Okzitanisch',0,NULL,NULL),(837,'oji','oji','oj','Ojibwa','ojibwa','Ojibwa-Sprache',0,NULL,NULL),(838,'ori','ori','or','Oriya','oriya','Oriya-Sprache',0,NULL,NULL),(839,'orm','orm','om','Oromo','galla','Galla-Sprache',0,NULL,NULL),(840,'osa','osa',' ','Osage','osage','Osage-Sprache',0,NULL,NULL),(841,'oss','oss','os','Ossetian; Ossetic','ossète','Ossetisch',0,NULL,NULL),(842,'ota','ota',' ','Turkish, Ottoman (1500-1928)','turc ottoman (1500-1928)','Osmanisch',0,NULL,NULL),(843,'oto','oto',' ','Otomian languages','otomi, langues','Otomangue-Sprachen',0,NULL,NULL),(844,'paa','paa',' ','Papuan languages','papoues, langues','Papuasprachen (Andere)',0,NULL,NULL),(845,'pag','pag',' ','Pangasinan','pangasinan','Pangasinan-Sprache',0,NULL,NULL),(846,'pal','pal',' ','Pahlavi','pahlavi','Mittelpersisch',0,NULL,NULL),(847,'pam','pam',' ','Pampanga; Kapampangan','pampangan','Pampanggan-Sprache',0,NULL,NULL),(848,'pan','pan','pa','Panjabi; Punjabi','pendjabi','Pandschabi-Sprache',0,NULL,NULL),(849,'pap','pap',' ','Papiamento','papiamento','Papiamento',0,NULL,NULL),(850,'pau','pau',' ','Palauan','palau','Palau-Sprache',0,NULL,NULL),(851,'peo','peo',' ','Persian, Old (ca.600-400 B.C.)','perse, vieux (ca. 600-400 av. J.-C.)','Altpersisch',0,NULL,NULL),(852,'phi','phi',' ','Philippine languages','philippines, langues','Philippinisch-Austronesisch (Andere)',0,NULL,NULL),(853,'phn','phn',' ','Phoenician','phénicien','Phönikisch',0,NULL,NULL),(854,'pli','pli','pi','Pali','pali','Pali',0,NULL,NULL),(855,'pol','pol','pl','Polish','polonais','Polnisch',0,NULL,NULL),(856,'pon','pon',' ','Pohnpeian','pohnpei','Ponapeanisch',0,NULL,NULL),(857,'por','por','pt','Portuguese','portugais','Portugiesisch',0,NULL,NULL),(858,'pra','pra',' ','Prakrit languages','prâkrit, langues','Prakrit',0,NULL,NULL),(859,'pro','pro',' ','Provençal, Old (to 1500);Occitan, Old (to 1500)','provençal ancien (jusqu\'à 1500); occitan ancien (jusqu\'à 1500)','Altokzitanisch',0,NULL,NULL),(860,'pus','pus','ps','Pushto; Pashto','pachto','Paschtu',0,NULL,NULL),(861,'qaa','qaa',' ','Reserved for local use','réservée à l\'usage local','Reserviert für lokale Verwendung',0,NULL,NULL),(862,'que','que','qu','Quechua','quechua','Quechua-Sprache',0,NULL,NULL),(863,'raj','raj',' ','Rajasthani','rajasthani','Rajasthani',0,NULL,NULL),(864,'rap','rap',' ','Rapanui','rapanui','Osterinsel-Sprache',0,NULL,NULL),(865,'rar','rar',' ','Rarotongan; Cook Islands Maori','rarotonga; maori des îles Cook','Rarotonganisch',0,NULL,NULL),(866,'roa','roa',' ','Romance languages','romanes, langues','Romanische Sprachen (Andere)',0,NULL,NULL),(867,'roh','roh','rm','Romansh','romanche','Rätoromanisch',0,NULL,NULL),(868,'rom','rom',' ','Romany','tsigane','Romani (Sprache)',0,NULL,NULL),(869,'rum','ron','ro','Romanian; Moldavian; Moldovan','roumain; moldave','Rumänisch',0,NULL,NULL),(870,'run','run','rn','Rundi','rundi','Rundi-Sprache',0,NULL,NULL),(871,'rup','rup',' ','Aromanian; Arumanian; Macedo-Romanian','aroumain; macédo-roumain','Aromunisch',0,NULL,NULL),(872,'rus','rus','ru','Russian','russe','Russisch',0,NULL,NULL),(873,'sad','sad',' ','Sandawe','sandawe','Sandawe-Sprache',0,NULL,NULL),(874,'sag','sag','sg','Sango','sango','Sango-Sprache',0,NULL,NULL),(875,'sah','sah',' ','Yakut','iakoute','Jakutisch',0,NULL,NULL),(876,'sai','sai',' ','South American Indian languages','sud-amérindiennes, langues','Indianersprachen, Südamerika (Andere)',0,NULL,NULL),(877,'sal','sal',' ','Salishan languages','salishennes, langues','Salish-Sprache',0,NULL,NULL),(878,'sam','sam',' ','Samaritan Aramaic','samaritain','Samaritanisch',0,NULL,NULL),(879,'san','san','sa','Sanskrit','sanskrit','Sanskrit',0,NULL,NULL),(880,'sas','sas',' ','Sasak','sasak','Sasak',0,NULL,NULL),(881,'sat','sat',' ','Santali','santal','Santali',0,NULL,NULL),(882,'scn','scn',' ','Sicilian','sicilien','Sizilianisch',0,NULL,NULL),(883,'sco','sco',' ','Scots','écossais','Schottisch',0,NULL,NULL),(884,'sel','sel',' ','Selkup','selkoupe','Selkupisch',0,NULL,NULL),(885,'sem','sem',' ','Semitic languages','sémitiques, langues','Semitische Sprachen (Andere)',0,NULL,NULL),(886,'sga','sga',' ','Irish, Old (to 900)','irlandais ancien (jusqu\'à 900)','Altirisch',0,NULL,NULL),(887,'sgn','sgn',' ','Sign Languages','langues des signes','Zeichensprachen',0,NULL,NULL),(888,'shn','shn',' ','Shan','chan','Schan-Sprache',0,NULL,NULL),(889,'sid','sid',' ','Sidamo','sidamo','Sidamo-Sprache',0,NULL,NULL),(890,'sin','sin','si','Sinhala; Sinhalese','singhalais','Singhalesisch',0,NULL,NULL),(891,'sio','sio',' ','Siouan languages','sioux, langues','Sioux-Sprachen (Andere)',0,NULL,NULL),(892,'sit','sit',' ','Sino-Tibetan languages','sino-tibétaines, langues','Sinotibetische Sprachen (Andere)',0,NULL,NULL),(893,'sla','sla',' ','Slavic languages','slaves, langues','Slawische Sprachen (Andere)',0,NULL,NULL),(894,'slo','slk','sk','Slovak','slovaque','Slowakisch',0,NULL,NULL),(895,'slv','slv','sl','Slovenian','slovène','Slowenisch',0,NULL,NULL),(896,'sma','sma',' ','Southern Sami','sami du Sud','Südsaamisch',0,NULL,NULL),(897,'sme','sme','se','Northern Sami','sami du Nord','Nordsaamisch',0,NULL,NULL),(898,'smi','smi',' ','Sami languages','sames, langues','Saamisch',0,NULL,NULL),(899,'smj','smj',' ','Lule Sami','sami de Lule','Lulesaamisch',0,NULL,NULL),(900,'smn','smn',' ','Inari Sami','sami d\'Inari','Inarisaamisch',0,NULL,NULL),(901,'smo','smo','sm','Samoan','samoan','Samoanisch',0,NULL,NULL),(902,'sms','sms',' ','Skolt Sami','sami skolt','Skoltsaamisch',0,NULL,NULL),(903,'sna','sna','sn','Shona','shona','Schona-Sprache',0,NULL,NULL),(904,'snd','snd','sd','Sindhi','sindhi','Sindhi-Sprache',0,NULL,NULL),(905,'snk','snk',' ','Soninke','soninké','Soninke-Sprache',0,NULL,NULL),(906,'sog','sog',' ','Sogdian','sogdien','Sogdisch',0,NULL,NULL),(907,'som','som','so','Somali','somali','Somali',0,NULL,NULL),(908,'son','son',' ','Songhai languages','songhai, langues','Songhai-Sprache',0,NULL,NULL),(909,'sot','sot','st','Sotho, Southern','sotho du Sud','Süd-Sotho-Sprache',0,NULL,NULL),(910,'spa','spa','es','Spanish; Castilian','espagnol; castillan','Spanisch',0,NULL,NULL),(911,'srd','srd','sc','Sardinian','sarde','Sardisch',0,NULL,NULL),(912,'srn','srn',' ','Sranan Tongo','sranan tongo','Sranantongo',0,NULL,NULL),(913,'srp','srp','sr','Serbian','serbe','Serbisch',0,NULL,NULL),(914,'srr','srr',' ','Serer','sérère','Serer-Sprache',0,NULL,NULL),(915,'ssa','ssa',' ','Nilo-Saharan languages','nilo-sahariennes, langues','Nilosaharanische Sprachen (Andere)',0,NULL,NULL),(916,'ssw','ssw','ss','Swati','swati','Swasi-Sprache',0,NULL,NULL),(917,'suk','suk',' ','Sukuma','sukuma','Sukuma-Sprache',0,NULL,NULL),(918,'sun','sun','su','Sundanese','soundanais','Sundanesisch',0,NULL,NULL),(919,'sus','sus',' ','Susu','soussou','Susu',0,NULL,NULL),(920,'sux','sux',' ','Sumerian','sumérien','Sumerisch',0,NULL,NULL),(921,'swa','swa','sw','Swahili','swahili','Swahili',0,NULL,NULL),(922,'swe','swe','sv','Swedish','suédois','Schwedisch',0,NULL,NULL),(923,'syc','syc',' ','Classical Syriac','syriaque classique','Syrisch',0,NULL,NULL),(924,'syr','syr',' ','Syriac','syriaque','Neuostaramäisch',0,NULL,NULL),(925,'tah','tah','ty','Tahitian','tahitien','Tahitisch',0,NULL,NULL),(926,'tai','tai',' ','Tai languages','tai, langues','Thaisprachen (Andere)',0,NULL,NULL),(927,'tam','tam','ta','Tamil','tamoul','Tamil',0,NULL,NULL),(928,'tat','tat','tt','Tatar','tatar','Tatarisch',0,NULL,NULL),(929,'tel','tel','te','Telugu','télougou','Telugu-Sprache',0,NULL,NULL),(930,'tem','tem',' ','Timne','temne','Temne-Sprache',0,NULL,NULL),(931,'ter','ter',' ','Tereno','tereno','Tereno-Sprache',0,NULL,NULL),(932,'tet','tet',' ','Tetum','tetum','Tetum-Sprache',0,NULL,NULL),(933,'tgk','tgk','tg','Tajik','tadjik','Tadschikisch',0,NULL,NULL),(934,'tgl','tgl','tl','Tagalog','tagalog','Tagalog',0,NULL,NULL),(935,'tha','tha','th','Thai','thaï','Thailändisch',0,NULL,NULL),(936,'tig','tig',' ','Tigre','tigré','Tigre-Sprache',0,NULL,NULL),(937,'tir','tir','ti','Tigrinya','tigrigna','Tigrinja-Sprache',0,NULL,NULL),(938,'tiv','tiv',' ','Tiv','tiv','Tiv-Sprache',0,NULL,NULL),(939,'tkl','tkl',' ','Tokelau','tokelau','Tokelauanisch',0,NULL,NULL),(940,'tlh','tlh',' ','Klingon; tlhIngan-Hol','klingon','Klingonisch',0,NULL,NULL),(941,'tli','tli',' ','Tlingit','tlingit','Tlingit-Sprache',0,NULL,NULL),(942,'tmh','tmh',' ','Tamashek','tamacheq','Tamašeq',0,NULL,NULL),(943,'tog','tog',' ','Tonga (Nyasa)','tonga (Nyasa)','Tonga (Bantusprache, Sambia)',0,NULL,NULL),(944,'ton','ton','to','Tonga (Tonga Islands)','tongan (Îles Tonga)','Tongaisch',0,NULL,NULL),(945,'tpi','tpi',' ','Tok Pisin','tok pisin','Neumelanesisch',0,NULL,NULL),(946,'tsi','tsi',' ','Tsimshian','tsimshian','Tsimshian-Sprache',0,NULL,NULL),(947,'tsn','tsn','tn','Tswana','tswana','Tswana-Sprache',0,NULL,NULL),(948,'tso','tso','ts','Tsonga','tsonga','Tsonga-Sprache',0,NULL,NULL),(949,'tuk','tuk','tk','Turkmen','turkmène','Turkmenisch',0,NULL,NULL),(950,'tum','tum',' ','Tumbuka','tumbuka','Tumbuka-Sprache',0,NULL,NULL),(951,'tup','tup',' ','Tupi languages','tupi, langues','Tupi-Sprache',0,NULL,NULL),(952,'tur','tur','tr','Turkish','turc','Türkisch',0,NULL,NULL),(953,'tut','tut',' ','Altaic languages','altaïques, langues','Altaische Sprachen (Andere)',0,NULL,NULL),(954,'tvl','tvl',' ','Tuvalu','tuvalu','Elliceanisch',0,NULL,NULL),(955,'twi','twi','tw','Twi','twi','Twi-Sprache',0,NULL,NULL),(956,'tyv','tyv',' ','Tuvinian','touva','Tuwinisch',0,NULL,NULL),(957,'udm','udm',' ','Udmurt','oudmourte','Udmurtisch',0,NULL,NULL),(958,'uga','uga',' ','Ugaritic','ougaritique','Ugaritisch',0,NULL,NULL),(959,'uig','uig','ug','Uighur; Uyghur','ouïgour','Uigurisch',0,NULL,NULL),(960,'ukr','ukr','uk','Ukrainian','ukrainien','Ukrainisch',0,NULL,NULL),(961,'umb','umb',' ','Umbundu','umbundu','Mbundu-Sprache',0,NULL,NULL),(962,'und','und',' ','Undetermined','indéterminée','Nicht zu entscheiden',0,NULL,NULL),(963,'urd','urd','ur','Urdu','ourdou','Urdu',0,NULL,NULL),(964,'uzb','uzb','uz','Uzbek','ouszbek','Usbekisch',0,NULL,NULL),(965,'vai','vai',' ','Vai','vaï','Vai-Sprache',0,NULL,NULL),(966,'ven','ven','ve','Venda','venda','Venda-Sprache',0,NULL,NULL),(967,'vie','vie','vi','Vietnamese','vietnamien','Vietnamesisch',0,NULL,NULL),(968,'vol','vol','vo','Volapük','volapük','Volapük',0,NULL,NULL),(969,'vot','vot',' ','Votic','vote','Wotisch',0,NULL,NULL),(970,'wak','wak',' ','Wakashan languages','wakashanes, langues','Wakash-Sprachen',0,NULL,NULL),(971,'wal','wal',' ','Wolaitta; Wolaytta','wolaitta; wolaytta','Walamo-Sprache',0,NULL,NULL),(972,'war','war',' ','Waray','waray','Waray',0,NULL,NULL),(973,'was','was',' ','Washo','washo','Washo-Sprache',0,NULL,NULL),(974,'wen','wen',' ','Sorbian languages','sorabes, langues','Sorbisch (Andere)',0,NULL,NULL),(975,'wln','wln','wa','Walloon','wallon','Wallonisch',0,NULL,NULL),(976,'wol','wol','wo','Wolof','wolof','Wolof-Sprache',0,NULL,NULL),(977,'xal','xal',' ','Kalmyk; Oirat','kalmouk; oïrat','Kalmückisch',0,NULL,NULL),(978,'xho','xho','xh','Xhosa','xhosa','Xhosa-Sprache',0,NULL,NULL),(979,'yao','yao',' ','Yao','yao','Yao-Sprache (Bantusprache)',0,NULL,NULL),(980,'yap','yap',' ','Yapese','yapois','Yapesisch',0,NULL,NULL),(981,'yid','yid','yi','Yiddish','yiddish','Jiddisch',0,NULL,NULL),(982,'yor','yor','yo','Yoruba','yoruba','Yoruba-Sprache',0,NULL,NULL),(983,'ypk','ypk',' ','Yupik languages','yupik, langues','Ypik-Sprachen',0,NULL,NULL),(984,'zap','zap',' ','Zapotec','zapotèque','Zapotekisch',0,NULL,NULL),(985,'zbl','zbl',' ','Blissymbols; Blissymbolics; Bliss','symboles Bliss; Bliss','Bliss-Symbol',0,NULL,NULL),(986,'zen','zen',' ','Zenaga','zenaga','Zenaga',0,NULL,NULL),(987,'zgh','zgh',' ','Standard Moroccan Tamazight','amazighe standard marocain','',0,NULL,NULL),(988,'zha','zha','za','Zhuang; Chuang','zhuang; chuang','Zhuang',0,NULL,NULL),(989,'znd','znd',' ','Zande languages','zandé, langues','Zande-Sprachen',0,NULL,NULL),(990,'zul','zul','zu','Zulu','zoulou','Zulu-Sprache',0,NULL,NULL),(991,'zun','zun',' ','Zuni','zuni','Zuñi-Sprache',0,NULL,NULL),(992,'zxx','zxx',' ','No linguistic content; Not applicable','pas de contenu linguistique; non applicable','Kein linguistischer Inhalt',0,NULL,NULL),(993,'zza','zza',' ','Zaza; Dimili; Dimli; Kirdki; Kirmanjki; Zazaki','zaza; dimili; dimli; kirdki; kirmanjki; zazaki','Zazaki',0,NULL,NULL);




--
-- Table structure for table `__messageLog`
--

CREATE TABLE `__messageLog` (
  `id` int NOT NULL AUTO_INCREMENT,
  `siteID` int NOT NULL,
  `IPAddress` varchar(32) NOT NULL,
  `userID` varchar(32) NOT NULL,
  `userCookie` varchar(50) NOT NULL,
  `PHPSessionID` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `platform` varchar(32) NOT NULL,
  `userAgent` varchar(500) NOT NULL,
  `requestTime` varchar(32) NOT NULL,
  `dateTime` datetime NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=551522 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__transactionLog`
--

CREATE TABLE `__transactionLog` (
  `application` varchar(20) NOT NULL,
  `userID` int NOT NULL,
  `userGroups` varchar(100) NOT NULL,
  `ipAddress` varchar(20) NOT NULL,
  `method` varchar(50) NOT NULL,
  `tab` varchar(50) NOT NULL,
  `subTab` varchar(50) NOT NULL,
  `wsNode` varchar(200) NOT NULL,
  `field` varchar(50) NOT NULL,
  `itemID` int NOT NULL,
  `parameters` text NOT NULL,
  `previousValue` text NOT NULL,
  `dateTime` datetime NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=211475 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__users`
--

CREATE TABLE `__users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `username` varchar(150) NOT NULL DEFAULT '',
  `title` varchar(30) NOT NULL,
  `image` varchar(50) DEFAULT NULL,
  `biog` text NOT NULL,
  `email` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL DEFAULT '',
  `lastPassword` varchar(100) DEFAULT NULL,
  `userType` varchar(25) DEFAULT NULL,
  `userGroup` int NOT NULL,
  `status` tinyint DEFAULT '0',
  `sendEmail` tinyint DEFAULT '0',
  `gid` tinyint unsigned NOT NULL DEFAULT '1',
  `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `activation` varchar(100) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  `applications` varchar(50) NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `usertype` (`userType`),
  KEY `idx_name` (`name`),
  KEY `gid_block` (`gid`,`status`),
  KEY `username` (`username`),
  KEY `email` (`email`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__userGroups`
--

CREATE TABLE `__userGroups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `title` varchar(50) NOT NULL,
  `application` varchar(50) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__usersInGroups`
--

CREATE TABLE `__usersInGroups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userID` int NOT NULL,
  `groupID` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__usersInApplications`
--

CREATE TABLE `__usersInApplications` (
  `userID` int NOT NULL,
  `application` varchar(10) NOT NULL,
  `order` int NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__userTypes`
--

CREATE TABLE `__userTypes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `label` varchar(20) NOT NULL,
  `name` varchar(50) NOT NULL,
  `level` int NOT NULL,
  `application` varchar(50) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;




--
-- Table structure for table `__columnTypes`
--

CREATE TABLE `__columnTypes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `label` varchar(30) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `__columnTypes`
--

INSERT INTO `__columnTypes` VALUES (1,'textField','Text',1,NULL,NULL),(2,'textArea','Text area',2,NULL,NULL),(3,'html','HTML',3,NULL,NULL),(4,'number','Number',4,NULL,NULL),(5,'internalAsset','Internal asset',5,NULL,NULL),(6,'dateTime','Date time',6,NULL,NULL),(7,'location','Location',7,NULL,NULL),(8,'iBeacon','iBeacon',8,NULL,NULL),(9,'valueList','Value list',9,NULL,NULL),(10,'postCode','Post code',10,NULL,NULL),(11,'url','URL',11,NULL,NULL),(12,'internetAddress','Internet address',12,NULL,NULL),(13,'internetHandle','Internet handle',13,NULL,NULL),(14,'boolean','Boolean',14,NULL,NULL),(15,'sqlCalculation','SQL',15,NULL,NULL),(16,'integer','Integer',16,NULL,NULL),(17,'int(','MySQL int',17,NULL,NULL),(18,'varchar','MySQL varchar',18,NULL,NULL),(19,'text','MYSQL text',19,NULL,NULL);




--
-- Table structure for table `__fieldOptions`
--

CREATE TABLE `__fieldOptions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `label` varchar(30) NOT NULL,
  `fieldUse` varchar(100) NOT NULL,
  `fieldType` varchar(30) NOT NULL,
  `sqlCalculation` text NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `name_2` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `__fieldOptions`
--

INSERT INTO `__fieldOptions` VALUES (1,'','','','','',1,NULL,NULL),(2,'ddmmmyy','1 January 70','fieldDisplay,headingFieldList','dateTime','return \'DATE_FORMAT(\'.$fieldLabel.\', \"%d %M %y\")\';',2,NULL,NULL),(3,'ddmmmyyyy','1 January 1970','fieldDisplay,headingFieldList','dateTime','return \'DATE_FORMAT(\'.$fieldLabel.\', \"%d %M %Y\")\';',3,NULL,NULL),(4,'hh.mm','09.41','fieldDisplay,headingFieldList','dateTime','return \'DATE_FORMAT(\'.$fieldLabel.\', \"%k.%i\")\';',4,NULL,NULL),(5,'ddmmmyyyyhh.mm','1 January 1970 00:00','fieldDisplay,headingFieldList','dateTime','return \'DATE_FORMAT(\'.$fieldLabel.\', \"%d %M %Y %k.%i\")\';',4,NULL,NULL);




--
-- Table structure for table `__fieldTypes`
--

CREATE TABLE `__fieldTypes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `label` varchar(50) NOT NULL,
  `fieldUse` varchar(250) NOT NULL,
  `columnType` varchar(250) NOT NULL,
  `order` int NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `__fieldTypes`
--

INSERT INTO `__fieldTypes` VALUES (1,'textField','Text field','fieldDisplay,fieldEdit,headingFieldList,headingFieldFilter','textField,number,location,int(',1,NULL,NULL),(7,'video','Video','fieldDisplay,fieldEdit','textField,internalAsset,url,va',7,NULL,NULL),(8,'dateTime','Date time','fieldDisplay,fieldEdit,headingFieldList,headingFieldFilter','dateTime',8,NULL,NULL),(9,'map','Map','fieldDisplay,headingFieldList','location,varchar',9,NULL,NULL),(12,'selector','Selector','fieldEdit,headingFieldFilter','textField,number,valueList,boo',12,NULL,NULL),(13,'textArea','Text area','fieldDisplay,fieldEdit','textArea,sqlCalculation,text',13,NULL,NULL),(14,'image','Image','fieldEdit,headingFieldList','textField,internalAsset,varcha',14,NULL,NULL),(18,'checkboxes','Checkboxes','fieldEdit,headingFieldFilter','valueList,varchar,text',18,NULL,NULL),(19,'radioButtons','Radio buttons','fieldEdit','textField,valueList,varchar,te',19,NULL,NULL),(22,'location','Location','fieldDisplay,fieldEdit,heading','textField,location,varchar,tex',22,NULL,NULL),(23,'iBeacon','Nearest iBeacon','fieldEdit','iBeacon',23,NULL,NULL),(24,'checkbox','Switch','fieldEdit','boolean',24,NULL,NULL),(25,'calculation','Calculation (client)','fieldEdit','text',25,NULL,NULL),(26,'text','Text','fieldDisplay,fieldEdit,headingFieldList,headingFieldFilter','textField,number,varchar,text',26,NULL,NULL),(28,'slider','Slider','fieldEdit,headingFieldList,headingFieldFilter','number',28,NULL,NULL),(29,'compositeField','Composite field','fieldDisplay,fieldEdit','',29,NULL,NULL),(32,'dateTimeInterval','Date time interval','headingFieldFilter','',32,NULL,NULL),(34,'geoLocation','Location','fieldDisplay,headingFieldList','',34,NULL,NULL),(35,'selector','Selector','fieldEdit,headingFieldFilter','textField,valueList',35,NULL,NULL),(39,'html','HTML','fieldDisplay,fieldEdit,heading','html',38,NULL,NULL),(40,'textarea','Text area (original)','fieldDisplay,fieldEdit','textArea',39,NULL,NULL),(41,'lookup','Lookup','fieldDisplay,headingFieldList','textField,textArea,number,date',40,NULL,NULL),(42,'externalImage','External image','fieldDisplay,fieldEdit,headingFieldList','textField,url',41,NULL,NULL),(43,'userGroups','Group','headingFieldFilter','textField,valueList,integer',12,NULL,NULL),(44,'userID','User','headingFieldFilter','textField,valueList,integer',12,NULL,NULL),(45,'file','File','fieldEdit','textField,internalAsset,varcha',14,NULL,NULL),(46,'imageDisplay','Image display','fieldDisplay,fieldEdit,headingFieldList','textField,internalAsset,varcha',14,NULL,NULL),(47,'externalVideo','External video','fieldDisplay,fieldEdit,headingFieldList','textField,url',41,NULL,NULL),(48,'date','Date','fieldDisplay,fieldEdit,headingFieldList,headingFieldFilter','date',8,NULL,NULL);




--
-- Table structure for table `__fieldTypesAndColumnTypes`
--

CREATE TABLE `__fieldTypesAndColumnTypes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fieldTypeID` int NOT NULL,
  `columnType` varchar(20) NOT NULL,
  `__groupID` int DEFAULT NULL,
  `__ownerID` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `__fieldTypesAndColumnTypes`
--





--
-- Dumping data for table `__databaseFields`
--
-- WHERE:  __databaseFields.table regexp '__'






--
-- Dumping data for table `__fieldLabels`
--
-- WHERE:  __fieldLabels.tab regexp '__'

INSERT INTO `__fieldLabels` (`id`, `tab`, `field`, `label`, `labelID`, `order`, `__groupID`, `__ownerID`) VALUES (42,'__tabs','display','Hide','1',42,NULL,NULL),(43,'__tabs','display','Display','2',43,NULL,NULL),(44,'__headingFields','parentType','tab','1',44,NULL,NULL),(45,'__headingFields','parentType','sub tab','2',45,NULL,NULL),(46,'__headingFields','type','text','text',46,NULL,NULL),(47,'__headingFields','type','selector','selector',47,NULL,NULL),(48,'__fields','type','Text','text',48,NULL,NULL),(49,'__fields','type','Date','date',0,NULL,NULL),(50,'__fields','type','Date/time','dateTime',0,NULL,NULL),(51,'__fields','type','Selector','selector',51,NULL,NULL),(52,'__fields','validation','required','text',52,NULL,NULL),(53,'__fields','validation','min 8 chars, no spac','username',53,NULL,NULL),(54,'__fields','validation','must be selected','nonZero',54,NULL,NULL),(55,'__fields','validation','must be number','number',55,NULL,NULL),(56,'__fields','validation','valid address','email',56,NULL,NULL),(208,'__subTabs','flags','Use separate relation queries','useSeparateRelationQueries',182,NULL,NULL),(60,'__fields','type','Text area','textarea',60,NULL,NULL),(61,'__subTabs','type','One to many','list',61,NULL,NULL),(62,'__subTabs','type','Many to many','linkList',62,NULL,NULL),(63,'__subTabs','showSearch','Yes','1',63,NULL,NULL),(64,'__subTabs','showSearch','No','0',64,NULL,NULL),(65,'__headingFields','resetFields','Search field 1','searchField1',65,NULL,NULL),(66,'__headingFields','resetFields','Search field 2','searchField2',66,NULL,NULL),(67,'__headingFields','resetFields','Search field 3','searchField3',67,NULL,NULL),(68,'__headingFields','resetFields','Search field 4','searchField4',68,NULL,NULL),(69,'__tabs','allowInList','Delete items','delete',4,NULL,NULL),(70,'__tabs','allowInList','Reorder items','reorder',9,NULL,NULL),(71,'__fields','type','File','file',71,NULL,NULL),(72,'__fields','type','Image','image',72,NULL,NULL),(73,'__subTabs','useCustomHeadings','Yes','1',73,NULL,NULL),(74,'__subTabs','useCustomHeadings','No','0',74,NULL,NULL),(75,'__headingFields','localFilterHeading','Search field 1','searchField1',75,NULL,NULL),(76,'__headingFields','localFilterHeading','Search field 2','searchField2',76,NULL,NULL),(77,'__headingFields','localFilterHeading','Search field 3','searchField3',77,NULL,NULL),(78,'__headingFields','localFilterHeading','Search field 4','searchField4',100,NULL,NULL),(106,'__fields','type','Video','video',106,NULL,NULL),(319,'__subTabs','allowInList','Delete items','delete',0,NULL,NULL),(322,'__subTabs','allowInList','Reorder items','reorder',0,NULL,NULL),(112,'__subTabHeadingFields','type','text','1',112,NULL,NULL),(113,'__subTabHeadingFields','type','selector','2',113,NULL,NULL),(101,'__fields','type','Checkboxes','checkboxes',101,NULL,NULL),(110,'__fields','type','Generic file','file',110,NULL,NULL),(80,'__fields','fieldType','varchar(5)','varchar(5)',84,NULL,NULL),(81,'__fields','fieldType','varchar(10)','varchar(10)',85,NULL,NULL),(82,'__fields','fieldType','varchar(15)','varchar(15)',86,NULL,NULL),(83,'__fields','fieldType','varchar(20)','varchar(20)',87,NULL,NULL),(84,'__fields','fieldType','varchar(30)','varchar(30)',88,NULL,NULL),(85,'__fields','fieldType','varchar(40)','varchar(40)',89,NULL,NULL),(86,'__fields','fieldType','varchar(50)','varchar(50)',90,NULL,NULL),(87,'__fields','fieldType','varchar(60)','varchar(60)',91,NULL,NULL),(88,'__fields','fieldType','varchar(100)','varchar(100)',92,NULL,NULL),(89,'__fields','fieldType','tinytext','tinytext',93,NULL,NULL),(90,'__fields','fieldType','text','text',94,NULL,NULL),(91,'__fields','fieldType','int(1)','int(1)',95,NULL,NULL),(92,'__fields','fieldType','int(2)','int(2)',96,NULL,NULL),(93,'__fields','fieldType','int(3)','int(3)',97,NULL,NULL),(94,'__fields','fieldType','int(4)','int(4)',98,NULL,NULL),(95,'__fields','fieldType','int(5)','int(5)',95,NULL,NULL),(96,'__fields','fieldType','int(6)','int(6)',96,NULL,NULL),(97,'__fields','fieldType','int(7)','int(7)',97,NULL,NULL),(98,'__fields','fieldType','int(8)','int(8)',98,NULL,NULL),(99,'__fields','fieldType','int(9)','int(9)',99,NULL,NULL),(100,'__fields','fieldType','int(10)','int(10)',100,NULL,NULL),(103,'__tabs','useTable','Configuration','config',1,NULL,NULL),(104,'__tabs','useTable','Management','manage',1,NULL,NULL),(105,'__fields','type','Radio buttons','radioButtons',105,NULL,NULL),(115,'__tabs','allowInList','Flag items','flag',10,NULL,NULL),(116,'__fields','type','Lookup','lookup',51,NULL,NULL),(117,'__headingFields','operator','Match','1',1,NULL,NULL),(118,'__headingFields','operator','Equal','2',2,NULL,NULL),(119,'__headingFields','operator','Greater than','3',3,NULL,NULL),(120,'__headingFields','operator','Less than','4',4,NULL,NULL),(121,'__headingFields','operator','not','5',0,NULL,NULL),(122,'__subTabHeadingFields','operator','Like','1',117,NULL,NULL),(123,'__subTabHeadingFields','operator','Equals','2',118,NULL,NULL),(124,'__subTabHeadingFields','operator','Greater','3',119,NULL,NULL),(125,'__subTabHeadingFields','operator','Less than','4',120,NULL,NULL),(126,'__subTabHeadingFields','operator','not','5',121,NULL,NULL),(127,'__headingFields','type','Date','date',122,NULL,NULL),(128,'__fields','display','Show','show',83,NULL,NULL),(129,'__fields','display','Hide','hide',0,NULL,NULL),(130,'__fields','type','Display only','display',85,NULL,NULL),(131,'__headingFields','inlineEdit','Always','always',1,NULL,NULL),(132,'__headingFields','inlineEdit','Allow','allow',2,NULL,NULL),(133,'__headingFields','inlineEdit','Never','never',2,NULL,NULL),(134,'__subTabHeadingFields','inlineEdit','Always','always',1,NULL,NULL),(135,'__subTabHeadingFields','inlineEdit','Allow','allow',2,NULL,NULL),(136,'__subTabHeadingFields','inlineEdit','Never','never',3,NULL,NULL),(137,'__fields','type','Calculation (client)','calculation',123,NULL,NULL),(203,'__fields','relatedFilterOperator','REGEXP','REGEXP',177,NULL,NULL),(185,'__tabs','allowInList','New item','new',11,NULL,NULL),(187,'__tabs','allowInList','Show title','title',1,NULL,NULL),(186,'__tabs','allowInList','Headings','headings',2,NULL,NULL),(193,'__tabs','allowInList','Duplicate items','duplicate',8,NULL,NULL),(194,'__tabs','allowInList','Edit items','edit',7,NULL,NULL),(195,'__tabs','allowInList','Filters','filters',3,NULL,NULL),(196,'__headingFields','type','Display only','display',171,NULL,NULL),(197,'__headingFields','display','Show','show',172,NULL,NULL),(198,'__headingFields','display','Hide','hide',173,NULL,NULL),(199,'__subTabHeadingFields','display','Show','show',174,NULL,NULL),(200,'__subTabHeadingFields','display','Hide','hide',175,NULL,NULL),(201,'__headingFields','localFilterHeading','Parent','parent',0,NULL,NULL),(202,'__fields','relatedFilterOperator','Equals','equals',176,NULL,NULL),(206,'__headingFields','operator','Whole word match','8',8,NULL,NULL),(207,'__tabs','flags','Use separate relation queries','useSeparateRelationQueries',0,NULL,NULL),(211,'__headingFields','resetFields','Search field 5','searchField5',185,NULL,NULL),(212,'__headingFields','resetFields','Search field 6','searchField6',186,NULL,NULL),(213,'__headingFields','resetFields','Search field 7','searchField7',187,NULL,NULL),(214,'__headingFields','resetFields','Search field 8','searchField8',188,NULL,NULL),(215,'__headingFields','localFilterHeading','Search field 5','searchField5',189,NULL,NULL),(216,'__headingFields','localFilterHeading','Search field 6','searchField6',190,NULL,NULL),(217,'__headingFields','localFilterHeading','Search field 7','searchField7',191,NULL,NULL),(218,'__headingFields','localFilterHeading','Search field 8','searchField8',192,NULL,NULL),(228,'__fields','relatedLinkOperator','and','and',202,NULL,NULL),(229,'__fields','relatedLinkOperator','or','or',203,NULL,NULL),(230,'__fields','filterOptions','Used resolved values as filter','useResolvedFilterValues',204,NULL,NULL),(241,'__tables','source','Database','database',207,NULL,NULL),(242,'__tables','source','Web service','webService',208,NULL,NULL),(245,'__headingFields','operator','Value list and','9',0,NULL,NULL),(246,'__headingFields','operator','Less than or equal','6',6,NULL,NULL),(247,'__headingFields','type','Value','value',211,NULL,NULL),(248,'__fields','initialValueType','User ID','userID',0,NULL,NULL),(249,'__fields','initialValueType','Location','geoLocation',0,NULL,NULL),(250,'__fields','initialValueType','Date/time','dateTime',214,NULL,NULL),(251,'__fields','initialValueType','User group','userGroup',215,NULL,NULL),(252,'__headingFields','initialValueType','User ID','userID',216,NULL,NULL),(253,'__fields','initialValueType','Value','value',217,NULL,NULL),(254,'__headingFields','initialValueType','Value','value',218,NULL,NULL),(255,'__headingFields','initialValueType','Location latitude','geoLocationLatitude',219,NULL,NULL),(256,'__headingFields','initialValueType','Date/time','dateTime',220,NULL,NULL),(257,'__headingFields','initialValueType','User group','userGroup',221,NULL,NULL),(258,'__headingFields','initialValueType','Nearest iBeacon major','iBeaconMajor',222,NULL,NULL),(259,'__fields','initialValueType','Nearest iBeacon','iBeacon',223,NULL,NULL),(260,'__fields','type','Location','geoLocation',0,NULL,NULL),(261,'__fields','type','Nearest iBeacon','iBeacon',0,NULL,NULL),(262,'__headingFields','type','Location','geoLocation',226,NULL,NULL),(263,'__headingFields','type','iBeacon','iBeacon',0,NULL,NULL),(266,'__fields','type','External video','externalVideo',0,NULL,NULL),(264,'__fields','type','Switch','checkbox',0,NULL,NULL),(265,'__fields','type','External image','externalImage',0,NULL,NULL),(267,'__tables','source','On device service','onDeviceService',227,NULL,NULL),(268,'__subTabs','flags','Pass delete command to sub tab','deleteSubTabItems',228,NULL,NULL),(269,'__tabActions','type','List item','listItem',344,NULL,NULL),(270,'__tabActions','type','Details','details',345,NULL,NULL),(271,'__tabActions','type','Field','field',346,NULL,NULL),(272,'__tabActions','enabled','Enabled','enabled',232,NULL,NULL),(273,'__tabActions','enabled','Disabled','disabled',233,NULL,NULL),(274,'__tabActions','logic','Momentary','momentary',234,NULL,NULL),(275,'__tabActions','logic','Toggle','toggle',235,NULL,NULL),(276,'__tabActions','iOSSystemItem','Done','done',236,NULL,NULL),(277,'__tabActions','iOSSystemItem','Edit','edit',237,NULL,NULL),(278,'__tabActions','iOSSystemItem','Cancel','cancel',238,NULL,NULL),(279,'__tabActions','iOSSystemItem','Edit','edit',239,NULL,NULL),(280,'__tabActions','iOSSystemItem','Save','save',240,NULL,NULL),(281,'__tabActions','iOSSystemItem','Add','add',241,NULL,NULL),(282,'__tabActions','iOSSystemItem','Compose','compose',242,NULL,NULL),(283,'__tabActions','iOSSystemItem','Reply','reply',243,NULL,NULL),(284,'__tabActions','iOSSystemItem','Action','action',244,NULL,NULL),(285,'__tabActions','iOSSystemItem','Organise','organise',245,NULL,NULL),(286,'__tabActions','iOSSystemItem','Bookmarks','bookmarks',246,NULL,NULL),(287,'__tabActions','iOSSystemItem','Search','search',247,NULL,NULL),(288,'__tabActions','iOSSystemItem','Refresh','refresh',248,NULL,NULL),(289,'__tabActions','iOSSystemItem','Stop','stop',249,NULL,NULL),(290,'__tabActions','iOSSystemItem','Camera','camera',250,NULL,NULL),(291,'__tabActions','iOSSystemItem','Trash','trash',251,NULL,NULL),(292,'__tabActions','iOSSystemItem','Play','play',252,NULL,NULL),(293,'__tabActions','iOSSystemItem','Pause','pause',253,NULL,NULL),(294,'__tabActions','iOSSystemItem','Rewind','rewind',254,NULL,NULL),(295,'__tabActions','iOSSystemItem','Fast forward','fastForward',255,NULL,NULL),(296,'__tabActions','iOSSystemItem','Undo','undo',256,NULL,NULL),(297,'__tabActions','iOSSystemItem','Redo','redo',257,NULL,NULL),(298,'__tabActions','type','List view','list',343,NULL,NULL),(299,'__fields','type','Calculation (SQL)','sqlCalculation',258,NULL,NULL),(300,'__headingFields','type','SQL calculation','sqlCalculation',259,NULL,NULL),(301,'__tabs','allowInList','Visual display','visualDisplay',260,NULL,NULL),(302,'__headingFields','flags','Use value as style','useAsStyle',261,NULL,NULL),(303,'__headingFields','initialValueType','Nearest iBeacon minor','iBeaconMinor',262,NULL,NULL),(304,'__headingFields','initialValueType','Location longitude','geoLocationLongitude',263,NULL,NULL),(305,'__tabs','allowInList','Add counts to groups','addCountsToGroups',6,NULL,NULL),(306,'__headingFields','display','Group with previous field','groupWithPrevious',265,NULL,NULL),(307,'__subTabs','flags','Pass create command to sub tab','createSubTabItems',266,NULL,NULL),(308,'__subTabs','flags','Pass duplicate command to sub ','duplicateSubTabItems',267,NULL,NULL),(309,'__users','status','Enabled','1',268,NULL,NULL),(310,'__users','status','Awaiting activation','0',269,NULL,NULL),(311,'__users','status','Not enabled','-1',270,NULL,NULL),(312,'__tabs','allowInList','Visual display drag items','visualDisplayDragItems',331,NULL,NULL),(313,'__fields','fieldOptions','Run script on change','runScriptOnChange',273,NULL,NULL),(314,'__fields','fieldOptions','Run script on mouseover','runScriptOnMouseover',371,NULL,NULL),(315,'__fields','fieldOptions','Run script on click','runScriptOnClick',372,NULL,NULL),(325,'__headingFields','resetFields','Search field 9','searchField9',274,NULL,NULL),(326,'__headingFields','resetFields','Search field 10','searchField10',275,NULL,NULL),(327,'__headingFields','resetFields','Search field 11','searchField11',276,NULL,NULL),(328,'__headingFields','resetFields','Search field 12','searchField12',277,NULL,NULL),(329,'__subTabs','type','One to one','linkOne',278,NULL,NULL),(330,'__fields','display','Show in header','showInHeader',0,NULL,NULL),(331,'__databaseFields','fieldType','Text','text',1,NULL,NULL),(332,'__databaseFields','fieldType','Text area','textArea',2,NULL,NULL),(333,'__databaseFields','fieldType','HTML','html',3,NULL,NULL),(334,'__databaseFields','fieldType','Number','number',4,NULL,NULL),(335,'__databaseFields','fieldType','Internal asset','internalAsset',6,NULL,NULL),(336,'__databaseFields','fieldType','Date time','dateTime',285,NULL,NULL),(337,'__databaseFields','fieldType','Location','location',284,NULL,NULL),(338,'__databaseFields','fieldType','iBeacon','iBeacon',286,NULL,NULL),(339,'__databaseFields','fieldType','Value list','valueList',5,NULL,NULL),(340,'__fields','displayType','Text label','text',289,NULL,NULL),(341,'__fields','displayType','textArea','Text area',290,NULL,NULL),(342,'__fields','displayType','HTML','html',291,NULL,NULL),(343,'__fields','displayType','Image','image',292,NULL,NULL),(344,'__fields','displayType','Video','video',370,NULL,NULL),(345,'__fields','displayType','Date time','dateTime',0,NULL,NULL),(346,'__fields','displayType','Map','map',0,NULL,NULL),(347,'__tabs','flags','Open details in display mode','openInDisplayMode',296,NULL,NULL),(348,'__tabs','flags','Allow details display mode tog','allowDisplayModeToggle',330,NULL,NULL),(349,'__fields','displayType','External image','externalImage',0,NULL,NULL),(350,'__fields','displayType','External video','externalVideo',288,NULL,NULL),(351,'__headingFields','type','Date/time interval','dateTimeInterval',297,NULL,NULL),(352,'__headingFields','type','Number interval','numberInterval',298,NULL,NULL),(353,'__databaseFields','fieldType','Post code','postCode',283,NULL,NULL),(354,'__databaseFields','fieldType','URL','url',7,NULL,NULL),(355,'__databaseFields','fieldType','Internet address','internetAddress',8,NULL,NULL),(356,'__databaseFields','fieldType','Internet handle','internetHandle',9,NULL,NULL),(357,'__fieldTypes','fieldUse','Field (display)','fieldDisplay',299,NULL,NULL),(358,'__fieldTypes','fieldUse','Field (edit)','fieldEdit',300,NULL,NULL),(359,'__fieldTypes','fieldUse','Heading field (list)','headingFieldList',301,NULL,NULL),(360,'__fieldTypes','fieldUse','Heading field (filter)','headingFieldFilter',302,NULL,NULL),(361,'__fieldTypes','fieldUse','Heading field (header)','headingFieldHeader',303,NULL,NULL),(362,'__headingFields','operator','Value list or','10',304,NULL,NULL),(363,'__headingFields','operator','Interval','0',305,NULL,NULL),(397,'__subTabs','allowInList','Show labels only when editing','showLabelsOnlyWhenEditing',321,NULL,NULL),(398,'__subTabs','allowInList','Show filters only when editing','showFiltersOnlyWhenEditing',322,NULL,NULL),(399,'__fieldOptions','fieldUse','Field (display)','fieldDisplay',323,NULL,NULL),(400,'__fieldOptions','fieldUse','Field (edit)','fieldEdit',324,NULL,NULL),(401,'__fieldOptions','fieldUse','Heading field (list)','headingFieldList',325,NULL,NULL),(402,'__fieldOptions','fieldUse','Heading field (filter)','headingFieldFilter',326,NULL,NULL),(403,'__fieldOptions','fieldUse','Heading field (header)','headingFieldHeader',327,NULL,NULL),(406,'__tabs','flags','Remove duplicate relationships','removeDuplicateRelationships',0,NULL,NULL),(407,'__tabs','allowInList','Item count','itemCount',5,NULL,NULL),(408,'__tabs','allowInList','Automatically refresh','autoRefresh',332,NULL,NULL),(409,'__fields','source','Database','database',333,NULL,NULL),(410,'__fields','source','User ID','userID',334,NULL,NULL),(411,'__fields','source','User group','userGroupID',335,NULL,NULL),(412,'__fields','source','Cookie','userCookie',336,NULL,NULL),(413,'__headingFields','operator','Find in set','FIND_IN_SET',337,NULL,NULL),(415,'__fields','relatedFilterOperator','Find in set','FIND_IN_SET',339,NULL,NULL),(418,'__fields','relatedFilterOperator','Not equal','notEquals',342,NULL,NULL),(419,'__subTabs','type','Many to one','manyToOne',343,NULL,NULL),(420,'__tabs','flags','Sort list descending','sortDescending',344,NULL,NULL),(421,'__tabs','allowInList','Show only lists','onlyLists',345,NULL,NULL),(422,'__tables','source','On device database','onDeviceDatabase',346,NULL,NULL),(423,'__tabActions','type','Open list view','openList',348,NULL,NULL),(424,'__tabActions','type','Close list view','closeList',349,NULL,NULL),(425,'__tabActions','type','Open details view','openDetails',350,NULL,NULL),(426,'__tabActions','type','Close details view','closeDetails',365,NULL,NULL),(427,'__headingFields','operator','Greater than or equal','7',351,NULL,NULL),(428,'__tabs','allowInList','Create item if none exist','createItemIfNoneFound',352,NULL,NULL),(429,'__headingFields','value','Cookie','cookie',353,NULL,NULL),(430,'__headingFields','value','User ID','userID',354,NULL,NULL),(431,'__subTabs','allowInList','Filter by group','filterByGroup',322,NULL,NULL),(432,'__tabs','groupAccess','Create','create',1,NULL,NULL),(433,'__tabs','groupAccess','Delete','delete',2,NULL,NULL),(434,'__tabs','groupAccess','Write','write',3,NULL,NULL),(435,'__tabs','groupAccess','Read','read',4,NULL,NULL),(436,'__tabs','flags','Apply access controls','applyAccessControls',355,NULL,NULL),(437,'__tabs','worldAccess','Create','create',356,NULL,NULL),(438,'__tabs','worldAccess','Delete','delete',357,NULL,NULL),(439,'__tabs','worldAccess','Write','write',358,NULL,NULL),(440,'__tabs','worldAccess','Read','read',359,NULL,NULL),(441,'__subTabs','flags','Link list not editable','linkListNotEditable',360,NULL,NULL),(442,'__tabs','transactionLogging','Create tab items','createTabItems',361,NULL,NULL),(443,'__tabs','transactionLogging','Delete tab items','deleteTabItems',363,NULL,NULL),(444,'__tabs','transactionLogging','Update tab items','updateTabItems',362,NULL,NULL),(445,'__tabs','transactionLogging','Search tab items','searchTabItems',364,NULL,NULL),(446,'__tabActions','type','Field update','fieldUpdate',347,NULL,NULL),(447,'__tables',NULL,'New serviceList',NULL,366,NULL,NULL),(448,'__tables','exportOptions','Structure only','structure',367,NULL,NULL),(449,'__tables','exportOptions','Structure and data','structureAndData',368,NULL,NULL),(450,'__fields','type','File','file',369,NULL,NULL),(452,'__fields','displayType','Date','date',0,NULL,NULL),(453,'__fields','fieldOptions','Force wrap','forceWrap',271,NULL,NULL),(454,'__fields','fieldOptions','Wrap in CData','useCData',272,NULL,NULL),(455,'__headingFields','operator','Value list or, or null','11',373,NULL,NULL),(456,'__tabs','allowInList','Update last modified date time','updateLastModifiedDateTime',374,NULL,NULL),(457,'__apiMethods','responseType','Details - single','detailsSingle',375,NULL,NULL),(458,'__apiMethods','responseType','List','list',377,NULL,NULL),(459,'__apiMethods','responseType','Details - list','detailsList',376,NULL,NULL),(460,'__apiMethods','responseType','ID only','id',379,NULL,NULL),(461,'__apiMethods','responseType','List - IDs','idList',378,NULL,NULL),(462,'__apiMethods','responseType','ID only','id',380,NULL,NULL),(463,'__apiParameters','type','Text','text',381,NULL,NULL),(464,'__apiParameters','type','Integer','integer',383,NULL,NULL),(465,'__apiParameters','type','Json','json',384,NULL,NULL),(466,'__apiParameters','type','PHP array','phpArray',385,NULL,NULL),(467,'__apiParameters','type','PHP object','phpObject',386,NULL,NULL),(468,'__apiParameters','flags','Optional','optional',388,NULL,NULL),(469,'__apiParameters','type','Comma separated list','commaSeparatedList',387,NULL,NULL),(470,'__apiParameters','type','Text true/false','textTrueFalse',382,NULL,NULL);




--
-- Dumping data for table `__headingFieldLabels`
--
-- WHERE:  __headingFieldLabels.tab regexp '__'





--
-- Dumping data for table `__fields`
--
-- WHERE:  __fields.table regexp '__'






--
-- Dumping data for table `__headingFields`
--
-- WHERE:  __headingFields.table regexp '__'

INSERT INTO `__headingFields` (`id`, `label`, `name`, `type`, `headingType`, `listType`, `listOptions`, `value`, `inlineEdit`, `table`, `textLength`, `displayWidth`, `displayOrder`, `displayType`, `display`, `flags`, `operator`, `localField`, `relatedTable`, `relatedField`, `relatedMatchField`, `relatedFilterField`, `localFilterHeading`, `initialValueType`, `initialValue`, `dateStartOffset`, `dateStopOffset`, `resetFields`, `sqlCalculation`, `tab`, `order`, `__groupID`, `__ownerID`) VALUES (49,'Tab','tab','selector','','','','','','__fields',20,160,NULL,'','','','','tab','__tabs','name','name','0','','','',0,0,'','','__fields',48,NULL,NULL),(46,'Tab','tab','selector','','','','','','__subTabs',20,180,NULL,'','','','','tab','__tabs','name','name','0','','','',0,0,'','','__subTabs',46,NULL,NULL),(47,'Sub tab','subTab','text','','','','','','__subTabs',20,180,NULL,'','','','1','subTab','','','','','','','',0,0,'','','__subTabs',47,NULL,NULL),(48,'Type','type','selector','','','','','','__subTabs',10,120,NULL,'','','','','type','__fieldLabels','label','labelID','0','','','',0,0,'','','__subTabs',48,NULL,NULL),(50,'Name','name','text','','','','0','','__fields',15,100,NULL,'','','','0','name','','','','','','','',0,0,'','','__fields',49,NULL,NULL),(52,'Tab','tab','selector','','','','','','__headingFields',20,150,NULL,'','','','','tab','__tabs','name','name','0','','','',0,0,'','','__headingFields',51,NULL,NULL),(53,'Label','label','text','','','','','','__headingFields',9,100,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__headingFields',52,NULL,NULL),(54,'Type','type','selector','','','','','','__headingFields',9,90,NULL,'','','','','type','__fieldLabels','label','labelID','0','','','',0,0,'','','__headingFields',560,NULL,NULL),(55,'Name','name','text','','','','','','__tabs',20,200,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__tabs',55,NULL,NULL),(58,'Label','label','text','','','','','','__tabs',20,200,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__tabs',56,NULL,NULL),(57,'Display','display','selector','','','','','','__tabs',0,100,NULL,'','hide','','','display','__fieldLabels','label','labelID','','','','',0,0,'','','__tabs',602,NULL,NULL),(64,'Value','labelID','text','','','','','','__fieldLabels',0,150,NULL,'','','','','labelID',NULL,NULL,NULL,'','','','',0,0,'','','__fieldLabels',61,NULL,NULL),(59,'Tab','tab','selector','','','','','','__fieldLabels',0,175,NULL,'','','','','tab','__tabs','name','name','0','','','',0,0,'searchField2','','__fieldLabels',57,NULL,NULL),(60,'Field','field','selector','','','','','','__fieldLabels',0,150,NULL,'','','','2','field','__fields','label','name','tab','searchField1','','',0,0,'','','__fieldLabels',58,NULL,NULL),(61,'Label','label','text','','','','','','__fieldLabels',0,150,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__fieldLabels',59,NULL,NULL),(65,'Tab','tab','selector','','','','','','__subTabHeadingFields',0,200,1,'','','','','tab','__tabs','name','name','0','','','',0,0,'searchField2,searchField3','','__subTabHeadingFields',62,NULL,NULL),(66,'Sub tab','subTab','selector','','','','','','__subTabHeadingFields',0,200,2,'','','','','parentID','__subTabs','subTab','id','tab','searchField1','','',0,0,'searchField3','','__subTabHeadingFields',63,NULL,NULL),(67,'Local field','localField','text','','','','','','__subTabHeadingFields',0,200,3,'','','','','localField','__fields','label','name','0','searchField1','','',0,0,'','','__subTabHeadingFields',64,NULL,NULL),(69,'Name','name','text','','','','','','__tables',10,200,1,'','','','','name','','0','0','0','','','',0,0,'','','__tables',66,NULL,NULL),(75,'Table','table','text','','','','','','__databaseFields',20,175,NULL,'','hide','','','table',NULL,NULL,NULL,'','','','',0,0,'','','__databaseFields',69,NULL,NULL),(74,'Name','name','text','','','','','','__databaseFields',20,150,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__databaseFields',68,NULL,NULL),(147,'Label','label','text','','','','','','__fields',12,100,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__fields',108,NULL,NULL),(420,'Name','name','text','','','','','','__users',20,200,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','users',416,NULL,NULL),(421,'User type','userType','selector','','','','','','__users',0,150,0,'','','','','usertype','fieldLabels','label','labelID','','','','',0,0,'','','users',417,NULL,NULL),(511,'Initial value','initialValue','text','','','','','','__headingFields',10,90,0,'','hide','','','initialValue','','0','0','0','','','',0,0,'','','__headingFields',902,NULL,NULL),(510,'Name','name','text','','','','','','__headingFields',8,100,0,'','','','','name','','','','','','','',0,0,'','','__headingFields',53,NULL,NULL),(509,'Type','type','text','','','','','','__fields',9,80,0,'','','','','editType','','','','','','','',0,0,'','','__fields',559,NULL,NULL),(512,'Label','label','text','','','','','','__subTabHeadingFields',0,200,3,'','','','','label','','0','0','0','','','',0,0,'','','__subTabHeadingFields',505,NULL,NULL),(513,'Name','name','text','','','','','','__subTabHeadingFields',0,200,3,'','','','','name','','0','0','0','','','',0,0,'','','__subTabHeadingFields',506,NULL,NULL),(514,'Type','type','text','','','','','','__subTabHeadingFields',0,200,3,'','','','','type','','0','0','0','','','',0,0,'','','__subTabHeadingFields',507,NULL,NULL),(515,'Initial value','initialValue','text','','','','','','__subTabHeadingFields',0,200,3,'','','','','initialValue','','0','0','0','','','',0,0,'','','__subTabHeadingFields',508,NULL,NULL),(551,'name','name','text','','','','','','__wsTypes',20,200,0,'','','','','name','','','','','','','',0,0,'','','wsTypes',544,NULL,NULL),(552,'Title','title','text','','','','','','__wsTypes',20,200,0,'','','','','title','','','','','','','',0,0,'','','wsTypes',545,NULL,NULL),(556,'Name','name','text','','','','','','__wsEndpoints',20,200,0,'','','','','name','','','','','','','',0,0,'','','wsEndpoints',549,NULL,NULL),(557,'Title','title','text','','','','','','__wsEndpoints',20,200,0,'','','','','title','','','','','','','',0,0,'','','wsEndpoints',550,NULL,NULL),(558,'Parent','parentID','selector','','','','','','__wsEndpoints',0,200,0,'','','','','parentID','__wsTypes','title','id','','','','',0,0,'','','wsEndpoints',551,NULL,NULL),(563,'List calculation','listCalculation','text','','','','','','__databaseFields',20,175,0,'','hide','','','listCalculation','','','','','','','',0,0,'','','__databaseFields',556,NULL,NULL),(564,'Details calculation','detailsCalculation','text','','','','','','__databaseFields',20,175,0,'','hide','','','detailsCalculation','','','','','','','',0,0,'','','__databaseFields',557,NULL,NULL),(565,'Field','field','text','','','','','','__fields',9,80,0,'','','','','field','','','','','','','',0,0,'','','__fields',558,NULL,NULL),(566,'Table','table','text','','','','','','__fields',15,120,0,'','','','','table','','','','','','','',0,0,'','','__fields',502,NULL,NULL),(567,'Table','table','text','','','','','','__headingFields',9,100,0,'','','','','table','','','','','','','',0,0,'','','__headingFields',503,NULL,NULL),(568,'Field','field','text','','','','','','__headingFields',9,90,0,'','','','','localField','','','','','','','',0,0,'','','__headingFields',504,NULL,NULL),(588,'Title','title','text','','','','','','__wsNodes',10,150,NULL,'','','','','title','','0','0','0','','','',0,0,'','','wsNodes',580,NULL,NULL),(589,'Type','wsType','selector','','','','','','__wsNodes',0,150,0,'','hide','','','type','__wsTypes','title','name','','','','',0,0,'','','wsNodes',581,NULL,NULL),(590,'Parent','parentID','selector','','','','','','__wsNodes',0,150,0,'','hide','','','parentID','jos_sites','title','id','','','','',0,0,'','','wsNodes',582,NULL,NULL),(591,'Name','name','text','','','','','','__wsNodes',10,150,0,'','hide','','','name','','0','0','0','','','',0,0,'','','wsNodes',583,NULL,NULL),(594,'Name','name','text','','','','','','__userGroups',10,120,NULL,'','hide','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__userGroups',586,NULL,NULL),(595,'Title','title','text','','','','','','__userGroups',10,120,0,'','','','','title','','','','','','','',0,0,'','','__userGroups',587,NULL,NULL),(601,'Name','name','text','','','','','','__users',10,120,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__users',593,NULL,NULL),(602,'Username','username','text','','','','','','__users',10,90,0,'','','','','username','','','','','','','',0,0,'','','__users',594,NULL,NULL),(603,'User type','userType','selector','','','','','','__users',0,90,0,'','','','','usertype','__userTypes','label','id','','','','',0,0,'','','__users',1107,NULL,NULL),(605,'Label','label','text','','','','','','__userTypes',10,120,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__userTypes',597,NULL,NULL),(606,'Level','level','text','','','','','','__userTypes',5,50,0,'','','','','level','','','','','','','',0,0,'','','__userTypes',598,NULL,NULL),(608,'Tab','tab','selector','','','','','','__tabActions',20,150,NULL,'','','','','tab','__tabs','name','name','','','','',0,0,'searchField2','','__tabActions',600,NULL,NULL),(609,'Sub tab','subTab','selector','','','','','','__tabActions',20,150,0,'','','','','subTab','__subTabs','subTab','subTab','tab','searchField1','','',0,0,'','','__tabActions',601,NULL,NULL),(610,'Title','title','text','','','','','','__tabs',20,200,0,'','','','','title','','','','','','','',0,0,'','','__tabs',54,NULL,NULL),(611,'Selector','selector','text','','','','','','__tabActions',20,150,0,'','','','','selector','','0','0','0','','','',0,0,'','','__tabActions',603,NULL,NULL),(620,'Tab','tab','selector','','','','','','__headingFieldLabels',0,150,0,'','','','','tab','__tabs','name','name','0','','','',0,0,'searchField2','','__headingFieldLabels',604,NULL,NULL),(621,'Field','field','selector','','','','','','__headingFieldLabels',0,150,0,'','','','2','field','__headingFields','label','name','tab','searchField1','','',0,0,'','','__headingFieldLabels',605,NULL,NULL),(622,'Label','label','text','','','','','','__headingFieldLabels',0,150,0,'','','','','label','','','','','','','',0,0,'','','__headingFieldLabels',606,NULL,NULL),(623,'Value','labelID','text','','','','','','__headingFieldLabels',0,150,0,'','','','','labelID','','','','','','','',0,0,'','','__headingFieldLabels',607,NULL,NULL),(1878,'Name','name','text','','','','','','__fieldTypes',10,150,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__fieldTypes',4,NULL,NULL),(1879,'Label','label','text','','','','','','__fieldTypes',10,150,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__fieldTypes',6,NULL,NULL),(1880,'FieldUse','fieldUse','text','','','','','','__fieldTypes',10,150,NULL,'','','','','fieldUse',NULL,NULL,NULL,'','','','',0,0,'','','__fieldTypes',8,NULL,NULL),(1881,'ColumnType','columnType','text','','','','','','__fieldTypes',10,150,NULL,'','','','','columnType',NULL,NULL,NULL,'','','','',0,0,'','','__fieldTypes',10,NULL,NULL),(1884,'Name','name','text','','','','','','__columnTypes',10,150,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__columnTypes',4,NULL,NULL),(1885,'Label','label','text','','','','','','__columnTypes',10,150,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__columnTypes',6,NULL,NULL),(2857,'Name','name','text','','','','','','__fieldOptions',10,150,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__fieldOptions',4,NULL,NULL),(2858,'Label','label','text','','','','','','__fieldOptions',10,150,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__fieldOptions',6,NULL,NULL),(2859,'Field use','fieldUse','selector','','lookup','','0','','__fieldOptions',10,150,NULL,'','','','','fieldUse','__fieldLabels','label','labelID','','','','',0,0,'','','__fieldOptions',8,NULL,NULL),(2860,'FieldType','fieldType','selector','','','','','','__fieldOptions',10,150,NULL,'','','','','fieldType','__fieldTypes','label','name','','','','',0,0,'','','__fieldOptions',10,NULL,NULL),(2862,'Order','order','text','','','','','','__fieldOptions',10,150,NULL,'','','','','order',NULL,NULL,NULL,'','','','',0,0,'','','__fieldOptions',14,NULL,NULL),(2937,'Order','order','text','','','','','','__languages',10,150,NULL,'','','','','order',NULL,NULL,NULL,'','','','',0,0,'','','__languages',2,NULL,NULL),(2918,'Name','name','text','','','','','','__countries',10,120,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__countries',24,NULL,NULL),(2919,'Capital','capital','text','','','','','','__countries',10,120,NULL,'','','','','capital',NULL,NULL,NULL,'','','','',0,0,'','','__countries',26,NULL,NULL),(2920,'Continent','continent','text','','','','','','__countries',3,70,NULL,'','','','','continent',NULL,NULL,NULL,'','','','',0,0,'','','__countries',28,NULL,NULL),(2921,'Dial','dial','text','','','','','','__countries',4,60,NULL,'','','','','dial',NULL,NULL,NULL,'','','','',0,0,'','','__countries',30,NULL,NULL),(2922,'Intermediate_region_code','intermediate_region_code','text','','','','','','__countries',10,120,NULL,'','','','','intermediate_region_code',NULL,NULL,NULL,'','','','',0,0,'','','__countries',32,NULL,NULL),(2923,'Languages','languages','text','','','','','','__countries',5,100,NULL,'','','','','languages',NULL,NULL,NULL,'','','','',0,0,'','','__countries',34,NULL,NULL),(2924,'Region_code','region_code','text','','','','','','__countries',10,150,NULL,'','','','','region_code',NULL,NULL,NULL,'','','','',0,0,'','','__countries',36,NULL,NULL),(2925,'Sub_region_code','sub_region_code','text','','','','','','__countries',10,150,NULL,'','','','','sub_region_code',NULL,NULL,NULL,'','','','',0,0,'','','__countries',38,NULL,NULL),(2926,'Tld','tld','text','','','','','','__countries',10,150,NULL,'','','','','tld',NULL,NULL,NULL,'','','','',0,0,'','','__countries',40,NULL,NULL),(2927,'Order','order','text','','','','','','__countries',10,150,NULL,'','','','','order',NULL,NULL,NULL,'','','','',0,0,'','','__countries',42,NULL,NULL),(2929,'ISO_639_1','ISO_639_1','text','','','','','','__languages',4,80,NULL,'','','','','ISO_639_1',NULL,NULL,NULL,'','','','',0,0,'','','__languages',4,NULL,NULL),(2930,'ISO_639_2_B','ISO_639_2_B','text','','','','','','__languages',4,80,NULL,'','','','','ISO_639_2_B',NULL,NULL,NULL,'','','','',0,0,'','','__languages',6,NULL,NULL),(2931,'ISO_639_2_T','ISO_639_2_T','text','','','','','','__languages',4,80,NULL,'','','','','ISO_639_2_T',NULL,NULL,NULL,'','','','',0,0,'','','__languages',8,NULL,NULL),(2932,'Name_en','name_en','text','','','','','','__languages',10,130,NULL,'','','','','name_en',NULL,NULL,NULL,'','','','',0,0,'','','__languages',10,NULL,NULL),(2933,'Name_fr','name_fr','text','','','','','','__languages',10,130,NULL,'','','','','name_fr',NULL,NULL,NULL,'','','','',0,0,'','','__languages',12,NULL,NULL),(2934,'Name_de','name_de','text','','','','','','__languages',10,130,NULL,'','','','','name_de',NULL,NULL,NULL,'','','','',0,0,'','','__languages',14,NULL,NULL),(2936,'Id','id','text','','','','','','__languages',10,150,NULL,'','','','','id',NULL,NULL,NULL,'','','','',0,0,'','','__languages',1,NULL,NULL),(3280,'Operator','operator','selector','','','','','','__headingFields',9,90,0,'','hide','','','operator','','','','0','','','',0,0,'','','__headingFields',827,NULL,NULL),(3568,'List type','listType','text','','','','0','','__headingFields',9,90,0,'','','','','listType','','','','0','','','',0,0,'','','__headingFields',561,NULL,NULL),(3972,'Message','message','text','','','','','','__messageLog',20,500,0,'','','','','message','','','','','','','',0,0,'','','__messageLog',937,NULL,NULL),(3973,'Timestamp','timestamp','text','','','','','','__messageLog',12,120,0,'','','','3','requestTime','','','','','','','',0,0,'','','__messageLog',938,NULL,NULL),(3971,'Date and time','dateTime','date','','','','','','__messageLog',0,200,0,'','','','','dateTime','','','','','','','',0,0,'','','__messageLog',936,NULL,NULL),(4047,'Group ID','groupID','','','','','','','__usersInGroups',0,0,NULL,'','','','','groupID',NULL,NULL,NULL,'','','','',0,0,'','','__usersInGroups',1,NULL,NULL),(4048,'User ID','userID','','','','','','','__usersInGroups',0,0,0,'','','','','userID','','','','','','','',0,0,'','','__usersInGroups',972,NULL,NULL),(4054,'Name','name','text','','','','','','__userGroups',10,120,0,'','hide','','','name','','','','','','','',0,0,'','','__userGroupsForTestSuites',978,NULL,NULL),(4055,'Title','title','text','','','','','','__userGroups',10,120,0,'','','','','title','','','','','','','',0,0,'','','__userGroupsForTestSuites',979,NULL,NULL),(4148,'IP address','ipAddress','text','','','','','','__messageLog',12,120,0,'','','','2','IPAddress','','','','','','','',0,0,'','','__messageLog',1031,NULL,NULL),(4150,'Application','application','text','','','','0','','__transactionLog',4,50,NULL,'','','','','application',NULL,NULL,NULL,'','','','',0,0,'','','__transactionLog',1033,NULL,NULL),(4151,'User','user','selector','','','','0','','__transactionLog',20,120,0,'','','','','userID','__users','name','id','','','','',0,0,'','','__transactionLog',1034,NULL,NULL),(4152,'IP address','ipAddress','text','','','','0','','__transactionLog',10,100,0,'','','','','ipAddress','','','','','','','',0,0,'','','__transactionLog',1035,NULL,NULL),(4153,'Method','method','text','','','','0','','__transactionLog',6,100,0,'','','','','method','','','','','','','',0,0,'','','__transactionLog',1036,NULL,NULL),(4154,'Tab','tab','text','','','','0','','__transactionLog',6,120,0,'','','','','tab','','','','','','value','',0,0,'','','__transactionLog',1037,NULL,NULL),(4155,'Field','field','text','','','','0','','__transactionLog',6,100,0,'','','','','field','','','','','','','',0,0,'','','__transactionLog',1038,NULL,NULL),(4156,'Item ID','itemID','text','','','','0','','__transactionLog',4,50,0,'','','','','itemID','','','','','','','',0,0,'','','__transactionLog',1039,NULL,NULL),(4157,'Date time','dateTime','text','','','','0','','__transactionLog',10,120,0,'','','','','dateTime','','','','','','','',0,0,'','','__transactionLog',1040,NULL,NULL),(4160,'Name','name','text','','','','','','__applications',10,70,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__applications',6,NULL,NULL),(4161,'Label','label','text','','','','','','__applications',10,150,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__applications',4,NULL,NULL),(4163,'UserID','userID','text','','','','','','__usersInApplications',10,150,NULL,'','','','','userID',NULL,NULL,NULL,'','','','',0,0,'','','__usersInApplications',2,NULL,NULL),(4164,'ApplicationID','applicationID','text','','','','','','__usersInApplications',10,150,NULL,'','','','','applicationID',NULL,NULL,NULL,'','','','',0,0,'','','__usersInApplications',4,NULL,NULL),(4165,'Order','order','text','','','','','','__usersInApplications',10,150,NULL,'','','','','order',NULL,NULL,NULL,'','','','',0,0,'','','__usersInApplications',6,NULL,NULL),(4166,'Id','id','text','','','','','','__usersInApplications',10,150,NULL,'','','','','id',NULL,NULL,NULL,'','','','',0,0,'','','__usersInApplications',8,NULL,NULL),(4167,'GroupID','groupID','text','','','','','','__groupsInApplications',10,150,NULL,'','','','','groupID',NULL,NULL,NULL,'','','','',0,0,'','','__groupsInApplications',2,NULL,NULL),(4168,'ApplicationID','applicationID','text','','','','','','__groupsInApplications',10,150,NULL,'','','','','applicationID',NULL,NULL,NULL,'','','','',0,0,'','','__groupsInApplications',4,NULL,NULL),(4169,'Order','order','text','','','','','','__groupsInApplications',10,150,NULL,'','','','','order',NULL,NULL,NULL,'','','','',0,0,'','','__groupsInApplications',6,NULL,NULL),(4170,'Id','id','text','','','','','','__groupsInApplications',10,150,NULL,'','','','','id',NULL,NULL,NULL,'','','','',0,0,'','','__groupsInApplications',8,NULL,NULL),(4338,'User group','userGroup','selector','','','','','','__users',0,120,0,'','','','','userGroup','__userGroups','title','id','0','','','',0,0,'','','__users',595,NULL,NULL),(4177,'Export options','exportOptions','text','','','','','','__tables',10,200,1,'','','','','exportOptions','','0','0','0','','','',0,0,'','','__tables',1047,NULL,NULL),(4314,'Application','application','text','','','','0','','__transactionLog',4,50,0,'','','','','application','','','','','','','',0,0,'','','dtgtm_transactionLog',1088,NULL,NULL),(4315,'User','user','selector','','','','0','','__transactionLog',20,120,0,'','','','','userID','__users','name','id','','','','',0,0,'','','dtgtm_transactionLog',1089,NULL,NULL),(4316,'IP address','ipAddress','text','','','','0','','__transactionLog',10,100,0,'','','','','ipAddress','','','','','','','',0,0,'','','dtgtm_transactionLog',1090,NULL,NULL),(4317,'Method','method','text','','','','0','','__transactionLog',6,100,0,'','','','','method','','','','','','','',0,0,'','','dtgtm_transactionLog',1091,NULL,NULL),(4318,'Tab','tab','text','','','','0','','__transactionLog',6,120,0,'','','','','tab','','','','','','value','dtgtm',0,0,'','','dtgtm_transactionLog',1092,NULL,NULL),(4319,'Field','field','text','','','','0','','__transactionLog',6,100,0,'','','','','field','','','','','','','',0,0,'','','dtgtm_transactionLog',1093,NULL,NULL),(4320,'Item ID','itemID','text','','','','0','','__transactionLog',4,50,0,'','','','','itemID','','','','','','','',0,0,'','','dtgtm_transactionLog',1094,NULL,NULL),(4321,'Date time','dateTime','text','','','','0','','__transactionLog',10,120,0,'','','','','dateTime','','','','','','','',0,0,'','','dtgtm_transactionLog',1095,NULL,NULL),(4322,'Application','application','text','','','','0','','__transactionLog',4,50,0,'','hide','','','application','','','','','','','',0,0,'','','dtgtm_testCaseListTransactionLog',1096,NULL,NULL),(4323,'User','user','selector','','','','0','','__transactionLog',20,120,0,'','','','','userID','__users','name','id','','','','',0,0,'','','dtgtm_testCaseListTransactionLog',1097,NULL,NULL),(4324,'IP address','ipAddress','text','','','','0','','__transactionLog',10,100,0,'','hide','','','ipAddress','','','','','','','',0,0,'','','dtgtm_testCaseListTransactionLog',1098,NULL,NULL),(4325,'Method','method','text','','','','0','','__transactionLog',6,100,0,'','','','','method','','','','','','','',0,0,'','','dtgtm_testCaseListTransactionLog',1099,NULL,NULL),(4326,'Tab','tab','text','','','','0','','__transactionLog',6,120,0,'','show','','','tab','','','','','','value','dtgtm_testCaseList',0,0,'','','dtgtm_testCaseListTransactionLog',1100,NULL,NULL),(4327,'Field','field','text','','','','0','','__transactionLog',6,100,0,'','','','','field','','','','','','','',0,0,'','','dtgtm_testCaseListTransactionLog',1101,NULL,NULL),(4328,'Item ID','itemID','text','','','','0','','__transactionLog',4,50,0,'','hide','','','itemID','','','','','','','',0,0,'','','dtgtm_testCaseListTransactionLog',1102,NULL,NULL),(4329,'Date time','dateTime','text','','','','0','','__transactionLog',10,120,0,'','','','','dateTime','','','','','','','',0,0,'','','dtgtm_testCaseListTransactionLog',1103,NULL,NULL),(4340,'Application','application','text','','','','','','__tables',10,200,1,'','','','','application','','0','0','0','','','',0,0,'','','__tables',1108,NULL,NULL),(4351,'Name','name','text','','','','','','__userGroups',10,120,0,'','hide','','','name','','','','','','','',0,0,'','','__userGroupsForTestSuiteVersions',1115,NULL,NULL),(4352,'Title','title','text','','','','','','__userGroups',10,120,0,'','','','','title','','','','','','','',0,0,'','','__userGroupsForTestSuiteVersions',1116,NULL,NULL),(4357,'Source','source','text','','','','','','__tables',10,200,1,'','','','','source','','0','0','0','','','',0,0,'','','__tables',1121,NULL,NULL),(4367,'IpAddress','ipAddress','text','','','','','','__sessions',10,150,NULL,'','','','','ipAddress',NULL,NULL,NULL,'','','','',0,0,'','','__sessions',8,NULL,NULL),(4368,'UserID','userID','text','','','','','','__sessions',10,150,NULL,'','','','','userID',NULL,NULL,NULL,'','','','',0,0,'','','__sessions',10,NULL,NULL),(4369,'UserType','userType','text','','','','','','__sessions',10,150,NULL,'','','','','userType',NULL,NULL,NULL,'','','','',0,0,'','','__sessions',12,NULL,NULL),(4371,'LoggedIn','loggedIn','text','','','','','','__sessions',10,150,NULL,'','','','','loggedIn',NULL,NULL,NULL,'','','','',0,0,'','','__sessions',16,NULL,NULL),(4372,'LoginTime','loginTime','text','','','','','','__sessions',10,150,NULL,'','','','','loginTime',NULL,NULL,NULL,'','','','',0,0,'','','__sessions',18,NULL,NULL),(4373,'LastCommandTime','lastCommandTime','text','','','','','','__sessions',10,150,NULL,'','','','','lastCommandTime',NULL,NULL,NULL,'','','','',0,0,'','','__sessions',20,NULL,NULL),(4861,'Label','label','text','','','','','','__apiMethods',10,250,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__apiMethods',6,NULL,NULL),(4862,'Name','name','text','','','','','','__apiMethods',10,170,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__apiMethods',4,NULL,NULL),(4864,'ResponseType','responseType','text','','','','','','__apiMethods',10,75,NULL,'','hide','','','responseType',NULL,NULL,NULL,'','','','',0,0,'','','__apiMethods',10,NULL,NULL),(4892,'Test value','testValue','text','','','','','','__apiParameters',10,150,NULL,'','','','','testValue',NULL,NULL,NULL,'','','','',0,0,'','','__apiParameters',1261,NULL,NULL),(4886,'Label','label','text','','','','','','__apiParameters',10,150,NULL,'','','','','label',NULL,NULL,NULL,'','','','',0,0,'','','__apiParameters',4,NULL,NULL),(4887,'Name','name','text','','','','','','__apiParameters',10,150,NULL,'','','','','name',NULL,NULL,NULL,'','','','',0,0,'','','__apiParameters',6,NULL,NULL);




--
-- Dumping data for table `__subTabHeadingFields`
--
-- WHERE:  __subTabHeadingFields.table regexp '__'





--
-- Dumping data for table `__subTabs`
--
-- WHERE:  __subTabs.tab regexp '__'

INSERT INTO `__subTabs` (`id`, `tab`, `table`, `type`, `operator`, `showSearch`, `useCustomHeadings`, `tabRelationField`, `tabFilterField1`, `tabFilterField2`, `tabFilterField3`, `tabFilterField4`, `wsNodeField`, `subTabRelationField`, `linkTable`, `linkField1`, `linkField2`, `subTab`, `allowInList`, `flags`, `selectedHeadingField`, `defaultFields`, `jsonStoreField`, `order`, `__groupID`, `__ownerID`) VALUES (18,'__tabs','__subTabs','list','',1,0,'name','','','','','','tab',NULL,NULL,NULL,'__subTabs','','useSeparateRelationQueries,deleteSubTabItems','','','',18,NULL,NULL),(20,'__tabs','__fields','list','',1,0,'name','','','','','','tab',NULL,NULL,NULL,'__fields','','useSeparateRelationQueries,deleteSubTabItems','','','',20,NULL,NULL),(21,'__tabs','__headingFields','list','',1,0,'name','','','','','','tab',NULL,NULL,NULL,'__headingFields','','useSeparateRelationQueries,deleteSubTabItems','','','',21,NULL,NULL),(22,'__subTabs','__subTabHeadingFields','list','',1,0,'subTab','','','','','','tab','0','0','0','__subTabHeadingFields','delete,reorder','','','','',21,NULL,NULL),(54,'__users','','linkList','',1,0,'id','','','','','','id','__usersInGroups','userID','groupID','__userGroups','delete','useSeparateRelationQueries,deleteSubTabItems,duplicateSubTabItems','','','',47,NULL,NULL),(56,'__tabs','','list','',1,0,'name','','','','','','tab','','','','__tabActions','','useSeparateRelationQueries,deleteSubTabItems','','','',49,NULL,NULL),(114,'__tables','','list','',0,0,'name','','','','','','table','','0','0','__databaseFields','','','','','',83,NULL,NULL),(166,'__userGroups','','linkList','',0,0,'id','','','','','','id','dtgtm_testSuiteVersionsForClients','groupID','testSuiteVersionID','dtgtm_testSuiteVersions','','useSeparateRelationQueries','','','',1,NULL,NULL),(167,'__userGroupsForTestSuites','','linkList','',0,0,'id','','','','','','id','dtgtm_testSuitesForClients','groupID','testSuiteID','dtgtm_testSuiteSelector','filterByGroup','useSeparateRelationQueries','','','',1,NULL,NULL),(175,'__applications','','linkList','',0,0,'id','','','','','','id','__groupsInApplications','applicationID','groupID','__userGroups','','','','','',1,NULL,NULL),(193,'__userGroupsForTestSuiteVersions','','linkList','',0,0,'id','','','','','','id','dtgtm_testSuiteVersionsForClients','groupID','testSuiteVersionID','dtgtm_testSuiteVersionSelector','filterByGroup','useSeparateRelationQueries,deleteSubTabItems,duplicateSubTabItems','','','',1,NULL,NULL),(245,'__apiMethods','','list','',0,0,'id','','','','','','parentID','0',NULL,NULL,'__apiParameters','','useSeparateRelationQueries,deleteSubTabItems,duplicateSubTabItems','','','',1,NULL,NULL);




--
-- Dumping data for table `__tables`
--
-- WHERE:  __tables.name regexp '__'

INSERT INTO `__tables` (`id`, `name`, `application`, `source`, `wsAddress`, `wsType`, `idField`, `exportOptions`, `order`, `__groupID`, `__ownerID`) VALUES (1,'__fieldLabels','dm','','','','','',1,NULL,NULL),(2,'__fields','dm','','','','','',2,NULL,NULL),(3,'__headingFields','dm','','','','','',3,NULL,NULL),(4,'__subTabHeadingFields','dm','','','','','',4,NULL,NULL),(5,'__subTabs','dm','','','','','',5,NULL,NULL),(6,'__tables','dm','','','','','',6,NULL,NULL),(7,'__tabs','dm','','','','','',7,NULL,NULL),(20,'__users','dm','','','','','',20,NULL,NULL),(28,'__sessions','dm','','','','','',28,NULL,NULL),(32,'__userTypes','dm','','','','','',32,NULL,NULL),(33,'__databaseFields','dm','','','','','',1,NULL,NULL),(44,'__databasefields','dm','','','','','',1,NULL,NULL),(45,'__fieldlabels','','','','','','',2,NULL,NULL),(46,'__headingfields','','','','','','',3,NULL,NULL),(47,'__subtabheadingfields','','','','','','',4,NULL,NULL),(48,'__subtabs','','','','','','',5,NULL,NULL),(115,'__usersInGroups','','','','','','',70,NULL,NULL),(113,'__wsNodes','','','','','name','',68,NULL,NULL),(114,'__userGroups','','database','','','','',69,NULL,NULL),(108,'__wsTypes','','database','','','','',63,NULL,NULL),(109,'__wsEndpoints','','','','','','',64,NULL,NULL),(116,'__tabActions','','','','','','',71,NULL,NULL),(121,'__headingFieldLabels','','','','','','',73,NULL,NULL),(122,'__applications','','database','','','','',74,NULL,NULL),(123,'__apnsRegistrations','','','','','','',1,NULL,NULL),(124,'__columnTypes','','','','','','',2,NULL,NULL),(125,'__fieldOptions','','','','','','',3,NULL,NULL),(126,'__fieldTypes','','','','','','',4,NULL,NULL),(127,'__locationEvents','','','','','','',5,NULL,NULL),(1157,'__countries','','','','','','',1,NULL,NULL),(1158,'__fieldTypesAndColumnTypes','','','','','','',2,NULL,NULL),(1159,'__languages','','','','','','',3,NULL,NULL),(1238,'__publicSessions','','','','','','',1,NULL,NULL),(1239,'__publicUserCookies','','','','','','',2,NULL,NULL),(1240,'__publicUsers','','','','','','',3,NULL,NULL),(1313,'__messageLog','','','','','','',1,NULL,NULL),(1323,'__transactionLog','','','','','','',1,NULL,NULL),(1324,'__usersInApplications','','database','','','','',96,NULL,NULL),(1325,'__groupsInApplications','dm','','','','','structure',1,NULL,NULL),(1354,'__postCodeSectors','','','','','','',1,NULL,NULL),(1392,'__apiMethods','dm','','','','','structureAndData',1,NULL,NULL),(1393,'__apiParameters','','','','','','',1,NULL,NULL);




--
-- Dumping data for table `__tabs`
--
-- WHERE:  __tabs.name regexp '__'

INSERT INTO `__tabs` (`id`, `name`, `application`, `title`, `description`, `label`, `pluralLabel`, `capitalLabel`, `pluralCapitalLabel`, `table`, `cacheTTL`, `display`, `useTable`, `titleField`, `listTitleField`, `listDescriptionField`, `listImageField`, `selectedHeadingField`, `listIntroText`, `detailsIntroText`, `orderBy`, `groupBy`, `visualGroup`, `allowInList`, `flags`, `visualLocationXField`, `visualLocationYField`, `visualLocationField`, `ownerID`, `groupID`, `ownerAccess`, `groupAccess`, `worldAccess`, `transactionLogging`, `order`, `__groupID`, `__ownerID`) VALUES (11,'__fields','dm','','','field','fields','Field','Fields','__fields','',1,'config','label','','','','','','','','','','delete,reorder,new,title,headings,duplicate,filters,itemCount','useSeparateRelationQueries,removeDuplicateRelationships','','','',0,0,'','','','createTabItems,deleteTabItems,updateTabItems',0,NULL,NULL),(9,'__tabs','dm','','','tab','tabs','Tab','Tabs','__tabs','',1,'config','name','','','','','','','','','','delete,reorder,new,headings,filters','useSeparateRelationQueries','','','',0,0,'','','','createTabItems,deleteTabItems,updateTabItems',0,NULL,NULL),(19,'__fieldLabels','dm','','','field label (system)','field labels (system)','Field label (system)','Field labels (system)','__fieldLabels','',1,'config','','','','','','','','','','','delete,reorder,new,headings,duplicate,filters','','','','',0,0,'','','','createTabItems,deleteTabItems,updateTabItems',19,NULL,NULL),(20,'__subTabs','dm','','','sub tab','sub tabs','Sub tab','Sub tabs','__subTabs','',0,'config','','','','','','','','','','','delete,reorder,new,headings','useSeparateRelationQueries','','','',0,0,'','','','createTabItems,deleteTabItems,updateTabItems',20,NULL,NULL),(21,'__headingFields','dm','','','heading field','heading fields','Heading field','Heading fields','__headingFields','',2,'config','label','','','','','','','','','','delete,reorder,new,headings,duplicate,filters,itemCount','useSeparateRelationQueries,removeDuplicateRelationships','','','',0,0,'','','','createTabItems,deleteTabItems,updateTabItems',21,NULL,NULL),(22,'__subTabHeadingFields','dm','','','Sub tab heading field','sub tab heading fields','Sub tab heading field','Sub tab heading fields','__subTabHeadingFields','',2,'config','','','','','','','','','','','delete,reorder','','','','',0,0,'','','','',0,NULL,NULL),(23,'__tables','dm','','','table','tables','Table','Tables','__tables','',2,'config','name','','','','','','','','','','delete,new,headings,filters','','','','',0,0,'','','','createTabItems,deleteTabItems,updateTabItems',0,NULL,NULL),(24,'__databaseFields','dm','','','database field','database fields','Database field','Database fields','__databaseFields','',2,'config','name','','','','','','','','','','delete,reorder,new,headings,filters','','','','',0,0,'','','','createTabItems,deleteTabItems,updateTabItems',24,NULL,NULL),(48,'__sessions','dm','Sessions','','session','sessions','Session','Sessions','__sessions','',2,'','','','','','','','','','','','','','','','',0,0,'','','','',43,NULL,NULL),(52,'__userTypes','dm','','','user type','user types','User type','User types','__userTypes','',2,'config','','','','','','','','','','','delete,reorder,new','','','','',0,0,'','','','',47,NULL,NULL),(66,'__users','dm','','','user','users','User','Users','__users','',2,'config','','','','','','','','','','','delete,new,headings,duplicate,filters','','','','',0,0,'','','','',59,NULL,NULL),(132,'__userGroups','dm','','','user group','user groups','User group','User groups','__userGroups','',0,'config','','','','','','','','','','','delete,reorder,new,headings,duplicate','useSeparateRelationQueries','','','',0,0,'','','','',120,NULL,NULL),(133,'__usersInGroups','dm','','','user in group','users in groups','User in group','Users in groups','__usersInGroups','',0,'','','','','','','','','','','','','','','','',0,0,'','','','',121,NULL,NULL),(134,'__tabActions','dm','','Actions attached to tab views','tab action','tab actions','Tab action','Tab actions','__tabActions','',0,'config','','','','','','','','','','','delete,reorder,new,title,headings,duplicate,filters','useSeparateRelationQueries','','','',0,0,'','','','createTabItems,deleteTabItems,updateTabItems',122,NULL,NULL),(136,'__headingFieldLabels','dm','Heading field labels (system)','','heading field label (system)','heading field labels (system)','Heading field label (system)','Heading field labels (system)','__headingFieldLabels','',0,'config','','','','','','','','','','','delete,reorder,new,headings,duplicate','','','','',0,0,'','','','createTabItems,deleteTabItems,updateTabItems',1,NULL,NULL),(1155,'__columnTypes','dm','Column types','','column type','column types','Column type','Column types','__columnTypes','',0,'config','','','','','','','','','','','delete,reorder,new,duplicate,filters','','','','',0,0,'','','','',134,NULL,NULL),(1154,'__fieldTypes','dm','Field types','','field type','field types','Field type','Field types','__fieldTypes','',0,'config','label','','','','','','','','','','delete,reorder,new,title,duplicate,filters','','','','',0,0,'','','','',133,NULL,NULL),(1185,'__fieldOptions','dm','Field options','','field option','field options','Field option','Field options','__fieldOptions','',0,'config','label','','','','label','','','','','','delete,reorder,new,headings,filters','useSeparateRelationQueries','','','',0,0,'','','','',140,NULL,NULL),(1187,'__countries','dm','countries','','country','countries','Country','Countries','__countries','',0,'config','name','name','','','','','','','','','delete,reorder,new,title,headings,duplicate','useSeparateRelationQueries','','','',0,0,'','','','',141,NULL,NULL),(1188,'__languages','dm','languages','','language','languages','Language','Languages','__languages','',0,'config','name_en','','','','name_en','','','','','','delete,reorder,new,title,headings,duplicate,filters','useSeparateRelationQueries','','','',0,0,'','','','',142,NULL,NULL),(1325,'__ messageLog','','','','message log entry','message log entries','Message log entry','Message log entries','messageLog','',0,'manage','','','','','','','','','','','','','','','',0,0,'','','','',83,NULL,NULL),(1326,'__messageLog','dm','','','message log entry','message log entries','Message log entry','Message log entries','__messageLog','',0,'manage','','','','','','','','','','','','','','','',0,0,'','','','',83,NULL,NULL),(1334,'__userGroupsForTestSuites','dm','','','test suite','test suites','Test suite','Test suites','__userGroups','',0,'config','title','','','','','<p>To create a Test Plan first select a Test Suite from the list below.</p><p>If the Test Suite you require isn\'t shown then please <a href=\"mailto:customerservices@dtg.org.uk?subject=DTG Test Suite availability\">contact DTG Customer Services</a>.</p>','','','','','delete,reorder,new,headings,duplicate','useSeparateRelationQueries,removeDuplicateRelationships','','','',0,0,'','','','',120,NULL,NULL),(1344,'__transactionLog','dm','','','transaction log entry','transaction log entries','Transaction log entry','Transaction log entries','__transactionLog','',0,'manage','','','','','','','','','','','headings,filters,itemCount','useSeparateRelationQueries','','','',0,0,'','','','',154,NULL,NULL),(1345,'__applications','dm','Applications','','application','applications','Application','Applications','__applications','',0,'','','','','','','','','','','','delete,reorder,new,headings,duplicate,itemCount','useSeparateRelationQueries,removeDuplicateRelationships','','','',0,0,'','','','',155,NULL,NULL),(1346,'__usersInApplications','dm','Users in applications','','user in application','users in applications','User in application','Users in applications','__usersInApplications','',0,'','','','','','','','','','','','','useSeparateRelationQueries,removeDuplicateRelationships','','','',0,0,'','','','',156,NULL,NULL),(1347,'__groupsInApplications','dm','','','group in application','groups in applications','Group in application','Groups in applications','__groupsInApplications','',0,'','','','','','','','','','','','','useSeparateRelationQueries,removeDuplicateRelationships','','','',0,0,'','','','',157,NULL,NULL),(1370,'__userGroupsForTestSuiteVersions','dm','','','test suite','test suites','Test suite','Test suites','__userGroups','',0,'config','title','','','','','<p>To create a Test Plan first select a Test Suite from the list below.</p><p>If the Test Suite you require isn\\\'t shown then please <a href=\\\"mailto:customerservices@dtg.org.uk?subject=DTG Test Suite availability\\\">contact DTG Customer Services</a>.</p>','','','','','delete,reorder,new,headings,duplicate','useSeparateRelationQueries,removeDuplicateRelationships','','','',0,0,'','','','',120,NULL,NULL),(1421,'__apiMethods','dm','API methods','','API Method','API methods','API method','API methods','__apiMethods','',2,'','','','','','','','','','','','delete,reorder,new,headings,duplicate,itemCount','','','','',0,0,'','','','',1,NULL,NULL),(1422,'__apiParameters','dm','API Parameters','','API parameter','API parameters','API parameter','API parameters','__apiParameters','',0,'','','','','','','','','','','','delete,reorder,new,headings,duplicate','','','','',0,0,'','','','',158,NULL,NULL);




--
-- Dumping data for table `__tabActions`
--
-- WHERE:  __tabActions.tab regexp '__'

INSERT INTO `__tabActions` (`id`, `label`, `tab`, `subTab`, `field`, `type`, `selector`, `iOSSelector`, `logic`, `enabled`, `legend`, `altLegend`, `webIcon`, `altWebIcon`, `iOSIcon`, `iOSSystemItem`, `prompt`, `style`, `order`, `__groupID`, `__ownerID`) VALUES (4,'','__users','siteInfo','','list','','','','enabled','User/site info','','','','','','','',2,NULL,NULL),(6,'','__users','','','details','dmActivateUser','','momentary','enabled','Activate','','','','','','Activate or reset this user\'s account on the Data Management system.','',4,NULL,NULL),(17,'','__tabs','','','details','duplicateTab','','momentary','enabled','Duplicate','','','','','','','',1,NULL,NULL),(47,'','__tables','','','list','createTable','','','','Create table','','','','','','','',36,NULL,NULL),(50,'','__applications','','','details','exportApplicationStructure','','','','Export application','','','','','','Export the structure and fixed data of this application','',39,NULL,NULL),(51,'','__applications','','','details','exportApplicationData','','','','Export application data','','','','','','Export data of this application','',40,NULL,NULL),(52,'','__applications','','','list','exportDMCore','','','','Export DM Core','','','','','','','',41,NULL,NULL),(53,'','__applications','','','list','exportDatabase','','','','Export whole database','','','','','','','',42,NULL,NULL),(59,'','__applications','','','list','exportDMUsers','','','','Export DM users','','','','','','','',47,NULL,NULL),(60,'','__users','','','details','dmActivateUserForDTGTPortal','','momentary','enabled','Activate for Portal','','','','','','Activate or reset this user\\\'s account on the DTG Test Portal.','',48,NULL,NULL);



-- --------------------------------------------------------------------------------------------------------------------
-- ==============================================================================

