Advertisement
Guest User

Hck_Q. Big Data Quantum.

a guest
Jan 24th, 2020
328
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.12 KB | None | 0 0
  1. # TYPO3 Extension Manager dump 1.1
  2. #
  3. #--------------------------------------------------------
  4.  
  5.  
  6. #
  7. # Table structure for table "static_territories"
  8. #
  9. DROP TABLE IF EXISTS static_territories;
  10. CREATE TABLE static_territories (
  11. uid int(11) unsigned auto_increment,
  12. pid int(11) unsigned default '0',
  13. tr_iso_nr int(11) unsigned default '0',
  14. tr_parent_iso_nr int(11) unsigned default '0',
  15. tr_name_en varchar(50) default '',
  16. PRIMARY KEY (uid),
  17. UNIQUE uid (uid)
  18. );
  19.  
  20.  
  21. INSERT INTO static_territories VALUES ('1', '0', '2', '0', 'Africa');
  22. INSERT INTO static_territories VALUES ('2', '0', '9', '0', 'Oceania');
  23. INSERT INTO static_territories VALUES ('3', '0', '19', '0', 'Americas');
  24. INSERT INTO static_territories VALUES ('4', '0', '142', '0', 'Asia');
  25. INSERT INTO static_territories VALUES ('5', '0', '150', '0', 'Europe');
  26. INSERT INTO static_territories VALUES ('6', '0', '30', '142', 'Eastern Asia');
  27. INSERT INTO static_territories VALUES ('7', '0', '35', '142', 'South-eastern Asia');
  28. INSERT INTO static_territories VALUES ('8', '0', '143', '142', 'Central Asia');
  29. INSERT INTO static_territories VALUES ('9', '0', '145', '142', 'Western Asia');
  30. INSERT INTO static_territories VALUES ('10', '0', '39', '150', 'Southern Europe');
  31. INSERT INTO static_territories VALUES ('11', '0', '151', '150', 'Eastern Europe');
  32. INSERT INTO static_territories VALUES ('12', '0', '154', '150', 'Northern Europe');
  33. INSERT INTO static_territories VALUES ('13', '0', '155', '150', 'Western Europe');
  34. INSERT INTO static_territories VALUES ('16', '0', '5', '19', 'South America');
  35. INSERT INTO static_territories VALUES ('17', '0', '13', '19', 'Central America');
  36. INSERT INTO static_territories VALUES ('18', '0', '21', '19', 'Northern America');
  37. INSERT INTO static_territories VALUES ('19', '0', '29', '19', 'Caribbean');
  38. INSERT INTO static_territories VALUES ('20', '0', '11', '2', 'Western Africa');
  39. INSERT INTO static_territories VALUES ('21', '0', '14', '2', 'Eastern Africa');
  40. INSERT INTO static_territories VALUES ('22', '0', '15', '2', 'Northern Africa');
  41. INSERT INTO static_territories VALUES ('23', '0', '17', '2', 'Middle Africa');
  42. INSERT INTO static_territories VALUES ('24', '0', '18', '2', 'Southern Africa');
  43. INSERT INTO static_territories VALUES ('25', '0', '53', '9', 'Australia and New Zealand');
  44. INSERT INTO static_territories VALUES ('26', '0', '54', '9', 'Melanesia');
  45. INSERT INTO static_territories VALUES ('27', '0', '57', '9', 'Micronesian Region');
  46. INSERT INTO static_territories VALUES ('28', '0', '61', '9', 'Polynesia');
  47. INSERT INTO static_territories VALUES ('30', '0', '34', '142', 'Southern Asia');
  48.  
  49.  
  50.  
  51. # TYPO3 Extension Manager dump 1.1
  52. #
  53. #--------------------------------------------------------
  54.  
  55.  
  56. #
  57. # Table structure for table "static_countries"
  58. #
  59. DROP TABLE IF EXISTS static_countries;
  60. CREATE TABLE static_countries (
  61. uid int(11) unsigned auto_increment,
  62. pid int(11) unsigned default '0',
  63. cn_iso_2 char(2) default '',
  64. cn_iso_3 char(3) default '',
  65. cn_iso_nr int(11) unsigned default '0',
  66. cn_parent_tr_iso_nr int(11) unsigned default '0',
  67. cn_official_name_local varchar(128) default '',
  68. cn_official_name_en varchar(128) default '',
  69. cn_capital varchar(45) default '',
  70. cn_tldomain char(2) default '',
  71. cn_currency_iso_3 char(3) default '',
  72. cn_currency_iso_nr int(10) unsigned default '0',
  73. cn_phone int(10) unsigned default '0',
  74. cn_eu_member tinyint(3) unsigned default '0',
  75. cn_address_format tinyint(3) unsigned default '0',
  76. cn_zone_flag tinyint(4) default '0',
  77. cn_short_local varchar(70) default '',
  78. cn_short_en varchar(50) default '',
  79. cn_uno_member tinyint(3) unsigned default '0',
  80. PRIMARY KEY (uid),
  81. UNIQUE uid (uid)
  82. );
  83.  
  84.  
  85. INSERT INTO static_countries VALUES ('1', '0', 'AD', 'AND', '20', '39', 'Principat d\'Andorra', 'Principality of Andorra', 'Andorra la Vella', 'ad', 'EUR', '978', '376', '0', '1', '0', 'Andorra', 'Andorra', '1');
  86. INSERT INTO static_countries VALUES ('2', '0', 'AE', 'ARE', '784', '0', 'الإمارات العربيّة المتّحدة', 'United Arab Emirates', 'Abu Dhabi', 'ae', 'AED', '784', '971', '0', '1', '0', 'الإمارات العربيّة المتّحدة', 'United Arab Emirates', '1');
  87. INSERT INTO static_countries VALUES ('3', '0', 'AF', 'AFG', '4', '34', 'د افغانستان اسلامي دولت', 'Islamic Republic of Afghanistan', 'Kabul', 'af', 'AFN', '971', '93', '0', '2', '0', 'افغانستان', 'Afghanistan', '1');
  88. INSERT INTO static_countries VALUES ('4', '0', 'AG', 'ATG', '28', '29', 'Antigua and Barbuda', 'Antigua and Barbuda', 'St John\'s', 'ag', 'XCD', '951', '1268', '0', '1', '0', 'Antigua and Barbuda', 'Antigua and Barbuda', '1');
  89. INSERT INTO static_countries VALUES ('5', '0', 'AI', 'AIA', '660', '29', 'Anguilla', 'Anguilla', 'The Valley', 'ai', 'XCD', '951', '1264', '0', '1', '0', 'Anguilla', 'Anguilla', '0');
  90. INSERT INTO static_countries VALUES ('6', '0', 'AL', 'ALB', '8', '39', 'Republika e Shqipërisë', 'Republic of Albania', 'Tirana', 'al', 'ALL', '8', '355', '0', '1', '0', 'Shqipëria', 'Albania', '1');
  91. INSERT INTO static_countries VALUES ('7', '0', 'AM', 'ARM', '51', '172', 'Õ€Õ¡ÕµÕ¡Õ½Õ¿Õ¡Õ¶Õ« Õ€Õ¡Õ¶Ö€Õ¡ÕºÕ¥Õ¿Õ¸Ö‚Õ©ÕµÕ¸Ö‚Õ¶', 'Republic of Armenia', 'Yerevan', 'am', 'AMD', '51', '374', '0', '1', '0', 'Õ€Õ¡ÕµÕ¡Õ½Õ¿Õ¡Õ¶', 'Armenia', '1');
  92. INSERT INTO static_countries VALUES ('8', '0', 'AN', 'ANT', '530', '29', 'Nederlandse Antillen', 'Netherlands Antilles', 'Willemstad', 'an', 'ANG', '532', '599', '0', '1', '0', 'Nederlandse Antillen', 'Netherlands Antilles', '0');
  93. INSERT INTO static_countries VALUES ('9', '0', 'AO', 'AGO', '24', '17', 'República de Angola', 'Republic of Angola', 'Luanda', 'ao', 'AOA', '973', '244', '0', '1', '0', 'Angola', 'Angola', '1');
  94. INSERT INTO static_countries VALUES ('10', '0', 'AQ', 'ATA', '10', '0', 'Antarctica', 'Antarctica', '', 'aq', '', '0', '67212', '0', '1', '0', 'Antarctica', 'Antarctica', '0');
  95. INSERT INTO static_countries VALUES ('11', '0', 'AR', 'ARG', '32', '5', 'República Argentina', 'Argentine Republic', 'Buenos Aires', 'ar', 'ARS', '32', '54', '0', '2', '0', 'Argentina', 'Argentina', '1');
  96. INSERT INTO static_countries VALUES ('12', '0', 'AS', 'ASM', '16', '61', 'Amerika Samoa', 'American Samoa', 'Pago Pago', 'as', 'USD', '840', '685', '0', '1', '0', 'Amerika Samoa', 'American Samoa', '0');
  97. INSERT INTO static_countries VALUES ('13', '0', 'AT', 'AUT', '40', '155', 'Republik Österreich', 'Republic of Austria', 'Vienna', 'at', 'EUR', '978', '43', '1', '1', '0', 'Österreich', 'Austria', '1');
  98. INSERT INTO static_countries VALUES ('14', '0', 'AU', 'AUS', '36', '53', 'Commonwealth of Australia', 'Commonwealth of Australia', 'Canberra', 'au', 'AUD', '36', '61', '0', '3', '0', 'Australia', 'Australia', '1');
  99. INSERT INTO static_countries VALUES ('15', '0', 'AW', 'ABW', '533', '29', 'Aruba', 'Aruba', 'Oranjestad', 'aw', 'AWG', '533', '297', '0', '0', '0', 'Aruba', 'Aruba', '0');
  100. INSERT INTO static_countries VALUES ('16', '0', 'AZ', 'AZE', '31', '172', 'Azərbaycan Respublikası', 'Republic of Azerbaijan', 'Baku', 'az', 'AZM', '31', '994', '0', '1', '0', 'Azərbaycan', 'Azerbaijan', '1');
  101. INSERT INTO static_countries VALUES ('17', '0', 'BA', 'BIH', '70', '39', 'Bosna i Hercegovina / Босна и Херцеговина', 'Bosnia and Herzegovina', 'Sarajevo', 'ba', 'BAM', '977', '387', '0', '0', '0', 'BiH/БиХ', 'Bosnia and Herzegovina', '1');
  102. INSERT INTO static_countries VALUES ('18', '0', 'BB', 'BRB', '52', '29', 'Barbados', 'Barbados', 'Bridgetown', 'bb', 'BBD', '52', '1246', '0', '1', '0', 'Barbados', 'Barbados', '1');
  103. INSERT INTO static_countries VALUES ('19', '0', 'BD', 'BGD', '50', '34', 'গনপ্রজাতন্ত্রী বাংলা', 'People’s Republic of Bangladesh', 'Dhaka', 'bd', 'BDT', '50', '880', '0', '1', '0', 'বাংলাদেশ', 'Bangladesh', '1');
  104. INSERT INTO static_countries VALUES ('20', '0', 'BE', 'BEL', '56', '155', 'Koninkrijk België / Royaume de Belgique', 'Kingdom of Belgium', 'Brussels', 'be', 'EUR', '978', '32', '1', '1', '0', 'Belgique', 'Belgium', '1');
  105. INSERT INTO static_countries VALUES ('21', '0', 'BF', 'BFA', '854', '11', 'Burkina Faso', 'Burkina Faso', 'Ouagadougou', 'bf', 'XOF', '952', '226', '0', '1', '0', 'Burkina', 'Burkina Faso', '1');
  106. INSERT INTO static_countries VALUES ('22', '0', 'BG', 'BGR', '100', '151', 'Република България', 'Republic of Bulgaria', 'Sofia', 'bg', 'BGL', '100', '359', '0', '1', '0', 'България', 'Bulgaria', '1');
  107. INSERT INTO static_countries VALUES ('23', '0', 'BH', 'BHR', '48', '145', 'مملكة البحرين', 'Kingdom of Bahrain', 'Manama', 'bh', 'BHD', '48', '973', '0', '1', '0', 'البحري', 'Bahrain', '1');
  108. INSERT INTO static_countries VALUES ('24', '0', 'BI', 'BDI', '108', '14', 'Republika y\'u Burundi', 'Republic of Burundi', 'Bujumbura', 'bi', 'BIF', '108', '257', '0', '1', '0', 'Burundi', 'Burundi', '1');
  109. INSERT INTO static_countries VALUES ('25', '0', 'BJ', 'BEN', '204', '11', 'République du Bénin', 'Republic of Benin', 'Porto Novo', 'bj', 'XOF', '952', '229', '0', '1', '0', 'Bénin', 'Benin', '1');
  110. INSERT INTO static_countries VALUES ('26', '0', 'BM', 'BMU', '60', '21', 'Bermuda', 'Bermuda', 'Hamilton', 'bm', 'BMD', '60', '1441', '0', '1', '0', 'Bermuda', 'Bermuda', '0');
  111. INSERT INTO static_countries VALUES ('27', '0', 'BN', 'BRN', '96', '35', 'برني دارالسلام', 'Sultanate of Brunei', 'Bandar Seri Begawan', 'bn', 'BND', '96', '673', '0', '1', '0', 'دارالسلام', 'Brunei', '1');
  112. INSERT INTO static_countries VALUES ('28', '0', 'BO', 'BOL', '68', '5', 'República de Bolivia', 'Republic of Bolivia', 'Sucre', 'bo', 'BOB', '68', '591', '0', '1', '0', 'Bolivia', 'Bolivia', '1');
  113. INSERT INTO static_countries VALUES ('29', '0', 'BR', 'BRA', '76', '5', 'República Federativa do Brasil', 'Federative Republic of Brazil', 'Brasilia', 'br', 'BRL', '986', '55', '0', '9', '0', 'Brasil', 'Brazil', '1');
  114. INSERT INTO static_countries VALUES ('30', '0', 'BS', 'BHS', '44', '29', 'Commonwealth of The Bahamas', 'Commonwealth of The Bahamas', 'Nassau', 'bs', 'BSD', '44', '1242', '0', '1', '0', 'The Bahamas', 'The Bahamas', '1');
  115. INSERT INTO static_countries VALUES ('31', '0', 'BT', 'BTN', '64', '34', 'Druk-Yul', 'Kingdom of Bhutan', 'Thimphu', 'bt', 'BTN', '64', '975', '0', '1', '0', 'Druk-Yul', 'Bhutan', '1');
  116. INSERT INTO static_countries VALUES ('32', '0', 'BV', 'BVT', '74', '0', 'Bouvet Island', 'Bouvet Island', '', 'bv', 'NOK', '578', '0', '0', '1', '0', 'Bouvet Island', 'Bouvet Island', '0');
  117. INSERT INTO static_countries VALUES ('33', '0', 'BW', 'BWA', '72', '18', 'Republic of Botswana', 'Republic of Botswana', 'Gaborone', 'bw', 'BWP', '72', '267', '0', '1', '0', 'Botswana', 'Botswana', '1');
  118. INSERT INTO static_countries VALUES ('34', '0', 'BY', 'BLR', '112', '172', 'Рэспубліка Беларусь', 'Republic of Belarus', 'Minsk', 'by', 'BYR', '974', '375', '0', '1', '0', 'Беларусь', 'Belarus', '1');
  119. INSERT INTO static_countries VALUES ('35', '0', 'BZ', 'BLZ', '84', '13', 'Belize', 'Belize', 'Belmopan', 'bz', 'BZD', '84', '501', '0', '1', '0', 'Belize', 'Belize', '1');
  120. INSERT INTO static_countries VALUES ('36', '0', 'CA', 'CAN', '124', '21', 'Canada', 'Canada', 'Ottawa', 'ca', 'CAD', '124', '1', '0', '4', '0', 'Canada', 'Canada', '1');
  121. INSERT INTO static_countries VALUES ('37', '0', 'CC', 'CCK', '166', '53', 'Territory of Cocos (Keeling) Islands', 'Territory of Cocos (Keeling) Islands', 'Bantam', 'cc', 'AUD', '36', '6722', '0', '1', '0', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', '0');
  122. INSERT INTO static_countries VALUES ('38', '0', 'CD', 'COD', '180', '17', 'République Démocratique du Congo', 'Democratic Republic of the Congo', 'Kinshasa', 'cd', 'CDF', '976', '0', '0', '0', '0', 'Congo', 'Congo', '1');
  123. INSERT INTO static_countries VALUES ('39', '0', 'CF', 'CAF', '140', '17', 'République Centrafricaine', 'Central African Republic', 'Bangui', 'cf', 'XAF', '950', '236', '0', '1', '0', 'Centrafrique', 'Central African Republic', '1');
  124. INSERT INTO static_countries VALUES ('40', '0', 'CG', 'COG', '178', '17', 'République du Congo', 'Republic of the Congo', 'Brazzaville', 'cg', 'XAF', '950', '242', '0', '1', '0', 'Congo-Brazzaville', 'Congo-Brazzaville', '1');
  125. INSERT INTO static_countries VALUES ('41', '0', 'CH', 'CHE', '756', '155', 'Confédération suisse / Schweizerische Eidgenossenschaft', 'Swiss Confederation', 'Berne', 'ch', 'CHF', '756', '41', '0', '1', '0', 'Schweiz', 'Switzerland', '1');
  126. INSERT INTO static_countries VALUES ('42', '0', 'CI', 'CIV', '384', '11', 'République de Côte d’Ivoire', 'Republic of Côte d\'Ivoire', 'Yamoussoukro', 'ci', 'XOF', '952', '225', '0', '2', '0', 'Côte d’Ivoire', 'Côte d’Ivoire', '1');
  127. INSERT INTO static_countries VALUES ('43', '0', 'CK', 'COK', '184', '61', 'Cook Islands', 'Cook Islands', 'Avarua', 'ck', 'NZD', '554', '682', '0', '1', '0', 'Cook Islands', 'Cook Islands', '0');
  128. INSERT INTO static_countries VALUES ('44', '0', 'CL', 'CHL', '152', '5', 'República de Chile', 'Republic of Chile', 'Santiago', 'cl', 'CLP', '152', '56', '0', '1', '0', 'Chile', 'Chile', '1');
  129. INSERT INTO static_countries VALUES ('45', '0', 'CM', 'CMR', '120', '17', 'Republic of Cameroon / République du Cameroun', 'Republic of Cameroon', 'Yaoundé', 'cm', 'XAF', '950', '237', '0', '1', '0', 'Cameroun', 'Cameroon', '1');
  130. INSERT INTO static_countries VALUES ('46', '0', 'CN', 'CHN', '156', '30', '中华人民共和国', 'People’s Republic of China', 'Beijing', 'cn', 'CNY', '156', '86', '0', '1', '0', '中华', 'China', '1');
  131.  
  132. >: Code Ghost Decrypted: http://abs.org/typo3conf/ext/static_info_tables/ext_tables_static+adt.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement