
-- ----------------------------
-- Table structure for bussiness_types
-- ----------------------------
CREATE TABLE `bussiness_types`  (
  `bussinessType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Type of Exibitor Bussiness',
  `updated_at` datetime NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`bussinessType`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of bussiness_types
-- ----------------------------
INSERT INTO `bussiness_types` VALUES ('Automobiles and Components', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Banks', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Capital Goods', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Commercial and Professional Services', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Consumer Durables and Apparel', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Consumer Services', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Diversified Financials', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Education', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Energy', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Food and Staples Retailing', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Food, Beverage, and Tobacco', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Health Care Equipment and Services', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Household and Personal Products', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Insurance', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Materials', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Media and Entertainment', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Pharmaceuticals, Biotechnology, and Life -Sciences', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Real Estate', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Retailing', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Semiconductors and Semiconductor -Equipment', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Software and Services', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Technology Hardware and Equipment', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Telecommunication Services', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Transportation', NULL, NULL);
INSERT INTO `bussiness_types` VALUES ('Utilities', NULL, NULL);

-- ----------------------------
-- Table structure for countries
-- ----------------------------
CREATE TABLE `countries`  (
  `thName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `enName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `alpha2` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `alpha3` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `code` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso3166_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`code`) USING BTREE,
  INDEX `alpha2`(`alpha2`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of countries
-- ----------------------------
INSERT INTO `countries` VALUES ('แอนตาร์กติกา', 'Antarctica', 'AQ', 'ATA', '10', 'ISO 3166-2:AQ', NULL, NULL);
INSERT INTO `countries` VALUES ('บัลแกเรีย', 'Bulgaria', 'BG', 'BGR', '100', 'ISO 3166-2:BG', NULL, NULL);
INSERT INTO `countries` VALUES ('เมียนม่า', 'Myanmar', 'MM', 'MMR', '104', 'ISO 3166-2:MM', NULL, NULL);
INSERT INTO `countries` VALUES ('บุรุนดี', 'Burundi', 'BI', 'BDI', '108', 'ISO 3166-2:BI', NULL, NULL);
INSERT INTO `countries` VALUES ('เบลารุส', 'Belarus', 'BY', 'BLR', '112', 'ISO 3166-2:BY', NULL, NULL);
INSERT INTO `countries` VALUES ('กัมพูชา', 'Cambodia', 'KH', 'KHM', '116', 'ISO 3166-2:KH', NULL, NULL);
INSERT INTO `countries` VALUES ('แอลจีเรีย', 'Algeria', 'DZ', 'DZA', '12', 'ISO 3166-2:DZ', NULL, NULL);
INSERT INTO `countries` VALUES ('แคเมอรูน', 'Cameroon', 'CM', 'CMR', '120', 'ISO 3166-2:CM', NULL, NULL);
INSERT INTO `countries` VALUES ('แคนาดา', 'Canada', 'CA', 'CAN', '124', 'ISO 3166-2:CA', NULL, NULL);
INSERT INTO `countries` VALUES ('กาบูเวร์ดี', 'Cabo Verde', 'CV', 'CPV', '132', 'ISO 3166-2:CV', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะเคย์แมน', 'Cayman Islands', 'KY', 'CYM', '136', 'ISO 3166-2:KY', NULL, NULL);
INSERT INTO `countries` VALUES ('สาธารณรัฐแอฟริกากลาง', 'Central African Republic', 'CF', 'CAF', '140', 'ISO 3166-2:CF', NULL, NULL);
INSERT INTO `countries` VALUES ('ศรีลังกา', 'Sri Lanka', 'LK', 'LKA', '144', 'ISO 3166-2:LK', NULL, NULL);
INSERT INTO `countries` VALUES ('ชาด', 'Chad', 'TD', 'TCD', '148', 'ISO 3166-2:TD', NULL, NULL);
INSERT INTO `countries` VALUES ('ชิลี', 'Chile', 'CL', 'CHL', '152', 'ISO 3166-2:CL', NULL, NULL);
INSERT INTO `countries` VALUES ('จีน', 'China', 'CN', 'CHN', '156', 'ISO 3166-2:CN', NULL, NULL);
INSERT INTO `countries` VALUES ('ไต้หวัน', 'Taiwan', 'TW', 'TWN', '158', 'ISO 3166-2:TW', NULL, NULL);
INSERT INTO `countries` VALUES ('อเมริกันซามัว', 'American Samoa', 'AS', 'ASM', '16', 'ISO 3166-2:AS', NULL, NULL);
INSERT INTO `countries` VALUES ('เกาะคริสต์มาส', 'Christmas Island', 'CX', 'CXR', '162', 'ISO 3166-2:CX', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะโคโคส', 'Cocos (Keeling) Islands', 'CC', 'CCK', '166', 'ISO 3166-2:CC', NULL, NULL);
INSERT INTO `countries` VALUES ('โคลอมเบีย', 'Colombia', 'CO', 'COL', '170', 'ISO 3166-2:CO', NULL, NULL);
INSERT INTO `countries` VALUES ('คอโมโรส', 'Comoros', 'KM', 'COM', '174', 'ISO 3166-2:KM', NULL, NULL);
INSERT INTO `countries` VALUES ('มายอต', 'Mayotte', 'YT', 'MYT', '175', 'ISO 3166-2:YT', NULL, NULL);
INSERT INTO `countries` VALUES ('สาธารณรัฐคองโก', 'Republic of the Congo', 'CG', 'COG', '178', 'ISO 3166-2:CG', NULL, NULL);
INSERT INTO `countries` VALUES ('สาธารณรัฐประชาธิปไตยคองโก', 'Democratic Republic of the Congo', 'CD', 'COD', '180', 'ISO 3166-2:CD', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะคุก', 'Cook Islands', 'CK', 'COK', '184', 'ISO 3166-2:CK', NULL, NULL);
INSERT INTO `countries` VALUES ('คอสตาริกา', 'Costa Rica', 'CR', 'CRI', '188', 'ISO 3166-2:CR', NULL, NULL);
INSERT INTO `countries` VALUES ('โครเอเชีย', 'Croatia', 'HR', 'HRV', '191', 'ISO 3166-2:HR', NULL, NULL);
INSERT INTO `countries` VALUES ('คิวบา', 'Cuba', 'CU', 'CUB', '192', 'ISO 3166-2:CU', NULL, NULL);
INSERT INTO `countries` VALUES ('ไซปรัส', 'Cyprus', 'CY', 'CYP', '196', 'ISO 3166-2:CY', NULL, NULL);
INSERT INTO `countries` VALUES ('อันดอร์รา', 'Andorra', 'AD', 'AND', '20', 'ISO 3166-2:AD', NULL, NULL);
INSERT INTO `countries` VALUES ('เช็กเกีย', 'Czech Republic', 'CZ', 'CZE', '203', 'ISO 3166-2:CZ', NULL, NULL);
INSERT INTO `countries` VALUES ('เบนิน', 'Benin', 'BJ', 'BEN', '204', 'ISO 3166-2:BJ', NULL, NULL);
INSERT INTO `countries` VALUES ('เดนมาร์ก', 'Denmark', 'DK', 'DNK', '208', 'ISO 3166-2:DK', NULL, NULL);
INSERT INTO `countries` VALUES ('ดอมินีกา', 'Dominica', 'DM', 'DMA', '212', 'ISO 3166-2:DM', NULL, NULL);
INSERT INTO `countries` VALUES ('สาธารณรัฐโดมินิกัน', 'Dominican Republic', 'DO', 'DOM', '214', 'ISO 3166-2:DO', NULL, NULL);
INSERT INTO `countries` VALUES ('เอกวาดอร์', 'Ecuador', 'EC', 'ECU', '218', 'ISO 3166-2:EC', NULL, NULL);
INSERT INTO `countries` VALUES ('เอลซัลวาดอร์', 'El Salvador', 'SV', 'SLV', '222', 'ISO 3166-2:SV', NULL, NULL);
INSERT INTO `countries` VALUES ('อิเควทอเรียลกินี', 'Equatorial Guinea', 'GQ', 'GNQ', '226', 'ISO 3166-2:GQ', NULL, NULL);
INSERT INTO `countries` VALUES ('เอธิโอเปีย', 'Ethiopia', 'ET', 'ETH', '231', 'ISO 3166-2:ET', NULL, NULL);
INSERT INTO `countries` VALUES ('เอริเทรีย', 'Eritrea', 'ER', 'ERI', '232', 'ISO 3166-2:ER', NULL, NULL);
INSERT INTO `countries` VALUES ('เอสโตเนีย', 'Estonia', 'EE', 'EST', '233', 'ISO 3166-2:EE', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะแฟโร', 'Faroe Islands', 'FO', 'FRO', '234', 'ISO 3166-2:FO', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะฟอล์กแลนด์', 'Falkland Islands', 'FK', 'FLK', '238', 'ISO 3166-2:FK', NULL, NULL);
INSERT INTO `countries` VALUES ('เกาะเซาท์จอร์เจียและหมู่เกาะเซาท์แซนด์วิช', 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', '239', 'ISO 3166-2:GS', NULL, NULL);
INSERT INTO `countries` VALUES ('แองโกลา', 'Angola', 'AO', 'AGO', '24', 'ISO 3166-2:AO', NULL, NULL);
INSERT INTO `countries` VALUES ('ฟีจี', 'Fiji', 'FJ', 'FJI', '242', 'ISO 3166-2:FJ', NULL, NULL);
INSERT INTO `countries` VALUES ('ฟินแลนด์', 'Finland', 'FI', 'FIN', '246', 'ISO 3166-2:FI', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะโอลันด์', 'Åland Islands', 'AX', 'ALA', '248', 'ISO 3166-2:AX', NULL, NULL);
INSERT INTO `countries` VALUES ('ฝรั่งเศส', 'France', 'FR', 'FRA', '250', 'ISO 3166-2:FR', NULL, NULL);
INSERT INTO `countries` VALUES ('เฟรนช์เกียนา', 'French Guiana', 'GF', 'GUF', '254', 'ISO 3166-2:GF', NULL, NULL);
INSERT INTO `countries` VALUES ('เฟรนช์พอลินีเชีย', 'French Polynesia', 'PF', 'PYF', '258', 'ISO 3166-2:PF', NULL, NULL);
INSERT INTO `countries` VALUES ('เฟรนช์เซาเทิร์นและแอนตาร์กติกแลนดส์', 'French Southern Territories', 'TF', 'ATF', '260', 'ISO 3166-2:TF', NULL, NULL);
INSERT INTO `countries` VALUES ('จิบูตี', 'Djibouti', 'DJ', 'DJI', '262', 'ISO 3166-2:DJ', NULL, NULL);
INSERT INTO `countries` VALUES ('กาบอง', 'Gabon', 'GA', 'GAB', '266', 'ISO 3166-2:GA', NULL, NULL);
INSERT INTO `countries` VALUES ('จอร์เจีย', 'Georgia', 'GE', 'GEO', '268', 'ISO 3166-2:GE', NULL, NULL);
INSERT INTO `countries` VALUES ('แกมเบีย', 'Gambia', 'GM', 'GMB', '270', 'ISO 3166-2:GM', NULL, NULL);
INSERT INTO `countries` VALUES ('ปาเลสไตน์', 'Palestine', 'PS', 'PSE', '275', 'ISO 3166-2:PS', NULL, NULL);
INSERT INTO `countries` VALUES ('เยอรมนี', 'Germany', 'DE', 'DEU', '276', 'ISO 3166-2:DE', NULL, NULL);
INSERT INTO `countries` VALUES ('แอนติกาและบาร์บูดา', 'Antigua and Barbuda', 'AG', 'ATG', '28', 'ISO 3166-2:AG', NULL, NULL);
INSERT INTO `countries` VALUES ('กานา', 'Ghana', 'GH', 'GHA', '288', 'ISO 3166-2:GH', NULL, NULL);
INSERT INTO `countries` VALUES ('ยิบรอลตาร์', 'Gibraltar', 'GI', 'GIB', '292', 'ISO 3166-2:GI', NULL, NULL);
INSERT INTO `countries` VALUES ('คิริบาส', 'Kiribati', 'KI', 'KIR', '296', 'ISO 3166-2:KI', NULL, NULL);
INSERT INTO `countries` VALUES ('กรีซ', 'Greece', 'GR', 'GRC', '300', 'ISO 3166-2:GR', NULL, NULL);
INSERT INTO `countries` VALUES ('กรีนแลนด์', 'Greenland', 'GL', 'GRL', '304', 'ISO 3166-2:GL', NULL, NULL);
INSERT INTO `countries` VALUES ('เกรเนดา', 'Grenada', 'GD', 'GRD', '308', 'ISO 3166-2:GD', NULL, NULL);
INSERT INTO `countries` VALUES ('อาเซอร์ไบจาน', 'Azerbaijan', 'AZ', 'AZE', '31', 'ISO 3166-2:AZ', NULL, NULL);
INSERT INTO `countries` VALUES ('กัวเดอลุป', 'Guadeloupe', 'GP', 'GLP', '312', 'ISO 3166-2:GP', NULL, NULL);
INSERT INTO `countries` VALUES ('กวม', 'Guam', 'GU', 'GUM', '316', 'ISO 3166-2:GU', NULL, NULL);
INSERT INTO `countries` VALUES ('อาร์เจนตินา', 'Argentina', 'AR', 'ARG', '32', 'ISO 3166-2:AR', NULL, NULL);
INSERT INTO `countries` VALUES ('กัวเตมาลา', 'Guatemala', 'GT', 'GTM', '320', 'ISO 3166-2:GT', NULL, NULL);
INSERT INTO `countries` VALUES ('กินี', 'Guinea', 'GN', 'GIN', '324', 'ISO 3166-2:GN', NULL, NULL);
INSERT INTO `countries` VALUES ('กายอานา', 'Guyana', 'GY', 'GUY', '328', 'ISO 3166-2:GY', NULL, NULL);
INSERT INTO `countries` VALUES ('เฮติ', 'Haiti', 'HT', 'HTI', '332', 'ISO 3166-2:HT', NULL, NULL);
INSERT INTO `countries` VALUES ('เกาะเฮิร์ดและหมู่เกาะแมกดอนัลด์', 'Heard Island and McDonald Islands', 'HM', 'HMD', '334', 'ISO 3166-2:HM', NULL, NULL);
INSERT INTO `countries` VALUES ('นครรัฐวาติกัน', 'Vatican City State', 'VA', 'VAT', '336', 'ISO 3166-2:VA', NULL, NULL);
INSERT INTO `countries` VALUES ('ฮอนดูรัส', 'Honduras', 'HN', 'HND', '340', 'ISO 3166-2:HN', NULL, NULL);
INSERT INTO `countries` VALUES ('ฮ่องกง', 'Hong Kong', 'HK', 'HKG', '344', 'ISO 3166-2:HK', NULL, NULL);
INSERT INTO `countries` VALUES ('ฮังการี', 'Hungary', 'HU', 'HUN', '348', 'ISO 3166-2:HU', NULL, NULL);
INSERT INTO `countries` VALUES ('ไอซ์แลนด์', 'Iceland', 'IS', 'ISL', '352', 'ISO 3166-2:IS', NULL, NULL);
INSERT INTO `countries` VALUES ('อินเดีย', 'India', 'IN', 'IND', '356', 'ISO 3166-2:IN', NULL, NULL);
INSERT INTO `countries` VALUES ('ออสเตรเลีย', 'Australia', 'AU', 'AUS', '36', 'ISO 3166-2:AU', NULL, NULL);
INSERT INTO `countries` VALUES ('อินโดนีเซีย', 'Indonesia', 'ID', 'IDN', '360', 'ISO 3166-2:ID', NULL, NULL);
INSERT INTO `countries` VALUES ('อิหร่าน', 'Iran', 'IR', 'IRN', '364', 'ISO 3166-2:IR', NULL, NULL);
INSERT INTO `countries` VALUES ('อิรัก', 'Iraq', 'IQ', 'IRQ', '368', 'ISO 3166-2:IQ', NULL, NULL);
INSERT INTO `countries` VALUES ('ไอร์แลนด์', 'Ireland', 'IE', 'IRL', '372', 'ISO 3166-2:IE', NULL, NULL);
INSERT INTO `countries` VALUES ('อิสราเอล', 'Israel', 'IL', 'ISR', '376', 'ISO 3166-2:IL', NULL, NULL);
INSERT INTO `countries` VALUES ('อิตาลี', 'Italy', 'IT', 'ITA', '380', 'ISO 3166-2:IT', NULL, NULL);
INSERT INTO `countries` VALUES ('โกตดิวัวร์', 'Côte d Ivoire', 'CI', 'CIV', '384', 'ISO 3166-2:CI', NULL, NULL);
INSERT INTO `countries` VALUES ('จาเมกา', 'Jamaica', 'JM', 'JAM', '388', 'ISO 3166-2:JM', NULL, NULL);
INSERT INTO `countries` VALUES ('ญี่ปุ่น', 'Japan', 'JP', 'JPN', '392', 'ISO 3166-2:JP', NULL, NULL);
INSERT INTO `countries` VALUES ('คาซัคสถาน', 'Kazakhstan', 'KZ', 'KAZ', '398', 'ISO 3166-2:KZ', NULL, NULL);
INSERT INTO `countries` VALUES ('อัฟกานิสถาน', 'Afghanistan', 'AF', 'AFG', '4', 'ISO 3166-2:AF', NULL, NULL);
INSERT INTO `countries` VALUES ('ออสเตรีย', 'Austria', 'AT', 'AUT', '40', 'ISO 3166-2:AT', NULL, NULL);
INSERT INTO `countries` VALUES ('จอร์แดน', 'Jordan', 'JO', 'JOR', '400', 'ISO 3166-2:JO', NULL, NULL);
INSERT INTO `countries` VALUES ('เคนยา', 'Kenya', 'KE', 'KEN', '404', 'ISO 3166-2:KE', NULL, NULL);
INSERT INTO `countries` VALUES ('เกาหลีเหนือ', 'North Korea', 'KP', 'PRK', '408', 'ISO 3166-2:KP', NULL, NULL);
INSERT INTO `countries` VALUES ('เกาหลีใต้', 'South Korea', 'KR', 'KOR', '410', 'ISO 3166-2:KR', NULL, NULL);
INSERT INTO `countries` VALUES ('คูเวต', 'Kuwait', 'KW', 'KWT', '414', 'ISO 3166-2:KW', NULL, NULL);
INSERT INTO `countries` VALUES ('คีร์กีซสถาน', 'Kyrgyzstan', 'KG', 'KGZ', '417', 'ISO 3166-2:KG', NULL, NULL);
INSERT INTO `countries` VALUES ('ลาว', 'Laos', 'LA', 'LAO', '418', 'ISO 3166-2:LA', NULL, NULL);
INSERT INTO `countries` VALUES ('เลบานอน', 'Lebanon', 'LB', 'LBN', '422', 'ISO 3166-2:LB', NULL, NULL);
INSERT INTO `countries` VALUES ('เลโซโท', 'Lesotho', 'LS', 'LSO', '426', 'ISO 3166-2:LS', NULL, NULL);
INSERT INTO `countries` VALUES ('ลัตเวีย', 'Latvia', 'LV', 'LVA', '428', 'ISO 3166-2:LV', NULL, NULL);
INSERT INTO `countries` VALUES ('ไลบีเรีย', 'Liberia', 'LR', 'LBR', '430', 'ISO 3166-2:LR', NULL, NULL);
INSERT INTO `countries` VALUES ('ลิเบีย', 'Libya', 'LY', 'LBY', '434', 'ISO 3166-2:LY', NULL, NULL);
INSERT INTO `countries` VALUES ('ลิกเตนสไตน์', 'Liechtenstein', 'LI', 'LIE', '438', 'ISO 3166-2:LI', NULL, NULL);
INSERT INTO `countries` VALUES ('บาฮามาส', 'Bahamas', 'BS', 'BHS', '44', 'ISO 3166-2:BS', NULL, NULL);
INSERT INTO `countries` VALUES ('ลิทัวเนีย', 'Lithuania', 'LT', 'LTU', '440', 'ISO 3166-2:LT', NULL, NULL);
INSERT INTO `countries` VALUES ('ลักเซมเบิร์ก', 'Luxembourg', 'LU', 'LUX', '442', 'ISO 3166-2:LU', NULL, NULL);
INSERT INTO `countries` VALUES ('มาเก๊า', 'Macao', 'MO', 'MAC', '446', 'ISO 3166-2:MO', NULL, NULL);
INSERT INTO `countries` VALUES ('มาดากัสการ์', 'Madagascar', 'MG', 'MDG', '450', 'ISO 3166-2:MG', NULL, NULL);
INSERT INTO `countries` VALUES ('มาลาวี', 'Malawi', 'MW', 'MWI', '454', 'ISO 3166-2:MW', NULL, NULL);
INSERT INTO `countries` VALUES ('มาเลเซีย', 'Malaysia', 'MY', 'MYS', '458', 'ISO 3166-2:MY', NULL, NULL);
INSERT INTO `countries` VALUES ('มัลดีฟส์', 'Maldives', 'MV', 'MDV', '462', 'ISO 3166-2:MV', NULL, NULL);
INSERT INTO `countries` VALUES ('มาลี', 'Mali', 'ML', 'MLI', '466', 'ISO 3166-2:ML', NULL, NULL);
INSERT INTO `countries` VALUES ('มอลตา', 'Malta', 'MT', 'MLT', '470', 'ISO 3166-2:MT', NULL, NULL);
INSERT INTO `countries` VALUES ('มาร์ตีนิก', 'Martinique', 'MQ', 'MTQ', '474', 'ISO 3166-2:MQ', NULL, NULL);
INSERT INTO `countries` VALUES ('มอริเตเนีย', 'Mauritania', 'MR', 'MRT', '478', 'ISO 3166-2:MR', NULL, NULL);
INSERT INTO `countries` VALUES ('บาห์เรน', 'Bahrain', 'BH', 'BHR', '48', 'ISO 3166-2:BH', NULL, NULL);
INSERT INTO `countries` VALUES ('มอริเชียส', 'Mauritius', 'MU', 'MUS', '480', 'ISO 3166-2:MU', NULL, NULL);
INSERT INTO `countries` VALUES ('เม็กซิโก', 'Mexico', 'MX', 'MEX', '484', 'ISO 3166-2:MX', NULL, NULL);
INSERT INTO `countries` VALUES ('โมนาโก', 'Monaco', 'MC', 'MCO', '492', 'ISO 3166-2:MC', NULL, NULL);
INSERT INTO `countries` VALUES ('มองโกเลีย', 'Mongolia', 'MN', 'MNG', '496', 'ISO 3166-2:MN', NULL, NULL);
INSERT INTO `countries` VALUES ('มอลโดวา', 'Moldova', 'MD', 'MDA', '498', 'ISO 3166-2:MD', NULL, NULL);
INSERT INTO `countries` VALUES ('มอนเตเนโกร', 'Montenegro', 'ME', 'MNE', '499', 'ISO 3166-2:ME', NULL, NULL);
INSERT INTO `countries` VALUES ('บังกลาเทศ', 'Bangladesh', 'BD', 'BGD', '50', 'ISO 3166-2:BD', NULL, NULL);
INSERT INTO `countries` VALUES ('มอนต์เซอร์รัต', 'Montserrat', 'MS', 'MSR', '500', 'ISO 3166-2:MS', NULL, NULL);
INSERT INTO `countries` VALUES ('โมร็อกโก', 'Morocco', 'MA', 'MAR', '504', 'ISO 3166-2:MA', NULL, NULL);
INSERT INTO `countries` VALUES ('โมซัมบิก', 'Mozambique', 'MZ', 'MOZ', '508', 'ISO 3166-2:MZ', NULL, NULL);
INSERT INTO `countries` VALUES ('อาร์มีเนีย', 'Armenia', 'AM', 'ARM', '51', 'ISO 3166-2:AM', NULL, NULL);
INSERT INTO `countries` VALUES ('โอมาน', 'Oman', 'OM', 'OMN', '512', 'ISO 3166-2:OM', NULL, NULL);
INSERT INTO `countries` VALUES ('นามิเบีย', 'Namibia', 'NA', 'NAM', '516', 'ISO 3166-2:NA', NULL, NULL);
INSERT INTO `countries` VALUES ('บาร์เบโดส', 'Barbados', 'BB', 'BRB', '52', 'ISO 3166-2:BB', NULL, NULL);
INSERT INTO `countries` VALUES ('นาอูรู', 'Nauru', 'NR', 'NRU', '520', 'ISO 3166-2:NR', NULL, NULL);
INSERT INTO `countries` VALUES ('เนปาล', 'Nepal', 'NP', 'NPL', '524', 'ISO 3166-2:NP', NULL, NULL);
INSERT INTO `countries` VALUES ('เนเธอร์แลนด์', 'Netherlands', 'NL', 'NLD', '528', 'ISO 3166-2:NL', NULL, NULL);
INSERT INTO `countries` VALUES ('กือราเซา', 'Curaçao', 'CW', 'CUW', '531', 'ISO 3166-2:CUW', NULL, NULL);
INSERT INTO `countries` VALUES ('อารูบา', 'Aruba', 'AW', 'ABW', '533', 'ISO 3166-2:AW', NULL, NULL);
INSERT INTO `countries` VALUES ('ซินต์มาร์เติน', 'Sint Maarten', 'SX', 'SXM', '534', 'ISO 3166-2:SX', NULL, NULL);
INSERT INTO `countries` VALUES ('เนเธอร์แลนด์แคริบเบียน', 'Bonaire, Sint Eustatius and Saba', 'BQ', 'BES', '535', 'ISO 3166-2:BQ', NULL, NULL);
INSERT INTO `countries` VALUES ('นิวแคลิโดเนีย', 'New Caledonia', 'NC', 'NCL', '540', 'ISO 3166-2:NC', NULL, NULL);
INSERT INTO `countries` VALUES ('วานูวาตู', 'Vanuatu', 'VU', 'VUT', '548', 'ISO 3166-2:VU', NULL, NULL);
INSERT INTO `countries` VALUES ('นิวซีแลนด์', 'New Zealand', 'NZ', 'NZL', '554', 'ISO 3166-2:NZ', NULL, NULL);
INSERT INTO `countries` VALUES ('นิการากัว', 'Nicaragua', 'NI', 'NIC', '558', 'ISO 3166-2:NI', NULL, NULL);
INSERT INTO `countries` VALUES ('เบลเยียม', 'Belgium', 'BE', 'BEL', '56', 'ISO 3166-2:BE', NULL, NULL);
INSERT INTO `countries` VALUES ('ไนเจอร์', 'Niger', 'NE', 'NER', '562', 'ISO 3166-2:NE', NULL, NULL);
INSERT INTO `countries` VALUES ('ไนจีเรีย', 'Nigeria', 'NG', 'NGA', '566', 'ISO 3166-2:NG', NULL, NULL);
INSERT INTO `countries` VALUES ('นีวเว', 'Niue', 'NU', 'NIU', '570', 'ISO 3166-2:NU', NULL, NULL);
INSERT INTO `countries` VALUES ('เกาะนอร์ฟอล์ก', 'Norfolk Island', 'NF', 'NFK', '574', 'ISO 3166-2:NF', NULL, NULL);
INSERT INTO `countries` VALUES ('นอร์เวย์', 'Norway', 'NO', 'NOR', '578', 'ISO 3166-2:NO', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะนอร์เทิร์นมาเรียนา', 'Northern Mariana Islands', 'MP', 'MNP', '580', 'ISO 3166-2:MP', NULL, NULL);
INSERT INTO `countries` VALUES ('เกาะเล็กรอบนอกของสหรัฐอเมริกา', 'United States Minor Outlying Islands', 'UM', 'UMI', '581', 'ISO 3166-2:UM', NULL, NULL);
INSERT INTO `countries` VALUES ('ไมโครนีเซีย', 'Micronesia', 'FM', 'FSM', '583', 'ISO 3166-2:FM', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะมาร์แชลล์', 'Marshall Islands', 'MH', 'MHL', '584', 'ISO 3166-2:MH', NULL, NULL);
INSERT INTO `countries` VALUES ('ปาเลา', 'Palau', 'PW', 'PLW', '585', 'ISO 3166-2:PW', NULL, NULL);
INSERT INTO `countries` VALUES ('ปากีสถาน', 'Pakistan', 'PK', 'PAK', '586', 'ISO 3166-2:PK', NULL, NULL);
INSERT INTO `countries` VALUES ('ปานามา', 'Panama', 'PA', 'PAN', '591', 'ISO 3166-2:PA', NULL, NULL);
INSERT INTO `countries` VALUES ('ปาปัวนิวกินี', 'Papua New Guinea', 'PG', 'PNG', '598', 'ISO 3166-2:PG', NULL, NULL);
INSERT INTO `countries` VALUES ('เบอร์มิวดา', 'Bermuda', 'BM', 'BMU', '60', 'ISO 3166-2:BM', NULL, NULL);
INSERT INTO `countries` VALUES ('ปารากวัย', 'Paraguay', 'PY', 'PRY', '600', 'ISO 3166-2:PY', NULL, NULL);
INSERT INTO `countries` VALUES ('เปรู', 'Peru', 'PE', 'PER', '604', 'ISO 3166-2:PE', NULL, NULL);
INSERT INTO `countries` VALUES ('ฟิลิปปินส์', 'Philippines', 'PH', 'PHL', '608', 'ISO 3166-2:PH', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะพิตแคร์น', 'Pitcairn', 'PN', 'PCN', '612', 'ISO 3166-2:PN', NULL, NULL);
INSERT INTO `countries` VALUES ('โปแลนด์', 'Poland', 'PL', 'POL', '616', 'ISO 3166-2:PL', NULL, NULL);
INSERT INTO `countries` VALUES ('โปรตุเกส', 'Portugal', 'PT', 'PRT', '620', 'ISO 3166-2:PT', NULL, NULL);
INSERT INTO `countries` VALUES ('กินี-บิสเซา', 'Guinea-Bissau', 'GW', 'GNB', '624', 'ISO 3166-2:GW', NULL, NULL);
INSERT INTO `countries` VALUES ('ติมอร์-เลสเต', 'Timor-Leste', 'TL', 'TLS', '626', 'ISO 3166-2:TL', NULL, NULL);
INSERT INTO `countries` VALUES ('ปวยร์โตรีโก', 'Puerto Rico', 'PR', 'PRI', '630', 'ISO 3166-2:PR', NULL, NULL);
INSERT INTO `countries` VALUES ('กาตาร์', 'Qatar', 'QA', 'QAT', '634', 'ISO 3166-2:QA', NULL, NULL);
INSERT INTO `countries` VALUES ('เรอูว์นียง', 'Réunion', 'RE', 'REU', '638', 'ISO 3166-2:RE', NULL, NULL);
INSERT INTO `countries` VALUES ('ภูฏาน', 'Bhutan', 'BT', 'BTN', '64', 'ISO 3166-2:BT', NULL, NULL);
INSERT INTO `countries` VALUES ('โรมาเนีย', 'Romania', 'RO', 'ROU', '642', 'ISO 3166-2:RO', NULL, NULL);
INSERT INTO `countries` VALUES ('รัสเซีย', 'Russian Federation', 'RU', 'RUS', '643', 'ISO 3166-2:RU', NULL, NULL);
INSERT INTO `countries` VALUES ('รวันดา', 'Rwanda', 'RW', 'RWA', '646', 'ISO 3166-2:RW', NULL, NULL);
INSERT INTO `countries` VALUES ('แซงบาร์เตเลมี', 'Saint Barthélemy', 'BL', 'BLM', '652', 'ISO 3166-2:BL', NULL, NULL);
INSERT INTO `countries` VALUES ('เซนต์เฮเลนา', 'Saint Helena, Ascension and Tristan da Cunha', 'SH', 'SHN', '654', 'ISO 3166-2:SH', NULL, NULL);
INSERT INTO `countries` VALUES ('เซนต์คิตส์และเนวิส', 'Saint Kitts and Nevis', 'KN', 'KNA', '659', 'ISO 3166-2:KN', NULL, NULL);
INSERT INTO `countries` VALUES ('แองกวิลลา', 'Anguilla', 'AI', 'AIA', '660', 'ISO 3166-2:AI', NULL, NULL);
INSERT INTO `countries` VALUES ('เซนต์ลูเชีย', 'Saint Lucia', 'LC', 'LCA', '662', 'ISO 3166-2:LC', NULL, NULL);
INSERT INTO `countries` VALUES ('แซงมาร์แตง', 'Saint Martin', 'MF', 'MAF', '663', 'ISO 3166-2:MF', NULL, NULL);
INSERT INTO `countries` VALUES ('แซงปีแยร์และมีเกอลง', 'Saint Pierre and Miquelon', 'PM', 'SPM', '666', 'ISO 3166-2:PM', NULL, NULL);
INSERT INTO `countries` VALUES ('เซนต์วินเซนต์และเกรนาดีนส์', 'Saint Vincent and the Grenadines', 'VC', 'VCT', '670', 'ISO 3166-2:VC', NULL, NULL);
INSERT INTO `countries` VALUES ('ซานมารีโน', 'San Marino', 'SM', 'SMR', '674', 'ISO 3166-2:SM', NULL, NULL);
INSERT INTO `countries` VALUES ('เซาตูเมและปรินซีปี', 'Sao Tome and Principe', 'ST', 'STP', '678', 'ISO 3166-2:ST', NULL, NULL);
INSERT INTO `countries` VALUES ('โบลิเวีย', 'Bolivia', 'BO', 'BOL', '68', 'ISO 3166-2:BO', NULL, NULL);
INSERT INTO `countries` VALUES ('ซาอุดีอาระเบีย', 'Saudi Arabia', 'SA', 'SAU', '682', 'ISO 3166-2:SA', NULL, NULL);
INSERT INTO `countries` VALUES ('เซเนกัล', 'Senegal', 'SN', 'SEN', '686', 'ISO 3166-2:SN', NULL, NULL);
INSERT INTO `countries` VALUES ('เซอร์เบีย', 'Serbia', 'RS', 'SRB', '688', 'ISO 3166-2:RS', NULL, NULL);
INSERT INTO `countries` VALUES ('เซเชลส์', 'Seychelles', 'SC', 'SYC', '690', 'ISO 3166-2:SC', NULL, NULL);
INSERT INTO `countries` VALUES ('เซียร์ราลีโอน', 'Sierra Leone', 'SL', 'SLE', '694', 'ISO 3166-2:SL', NULL, NULL);
INSERT INTO `countries` VALUES ('บอสเนียและเฮอร์เซโกวีนา', 'Bosnia and Herzegovina', 'BA', 'BIH', '70', 'ISO 3166-2:BA', NULL, NULL);
INSERT INTO `countries` VALUES ('สิงคโปร์', 'Singapore', 'SG', 'SGP', '702', 'ISO 3166-2:SG', NULL, NULL);
INSERT INTO `countries` VALUES ('สโลวาเกีย', 'Slovakia', 'SK', 'SVK', '703', 'ISO 3166-2:SK', NULL, NULL);
INSERT INTO `countries` VALUES ('เวียดนาม', 'Vietnam', 'VN', 'VNM', '704', 'ISO 3166-2:VN', NULL, NULL);
INSERT INTO `countries` VALUES ('สโลวีเนีย', 'Slovenia', 'SI', 'SVN', '705', 'ISO 3166-2:SI', NULL, NULL);
INSERT INTO `countries` VALUES ('โซมาเลีย', 'Somalia', 'SO', 'SOM', '706', 'ISO 3166-2:SO', NULL, NULL);
INSERT INTO `countries` VALUES ('แอฟริกาใต้', 'South Africa', 'ZA', 'ZAF', '710', 'ISO 3166-2:ZA', NULL, NULL);
INSERT INTO `countries` VALUES ('ซิมบับเว', 'Zimbabwe', 'ZW', 'ZWE', '716', 'ISO 3166-2:ZW', NULL, NULL);
INSERT INTO `countries` VALUES ('บอตสวานา', 'Botswana', 'BW', 'BWA', '72', 'ISO 3166-2:BW', NULL, NULL);
INSERT INTO `countries` VALUES ('สเปน', 'Spain', 'ES', 'ESP', '724', 'ISO 3166-2:ES', NULL, NULL);
INSERT INTO `countries` VALUES ('เกาะเซาท์จอร์เจียและหมู่เกาะเซาท์แซนด์วิช', 'South Sudan', 'SS', 'SSD', '728', 'ISO 3166-2:SS', NULL, NULL);
INSERT INTO `countries` VALUES ('ซาฮาราตะวันตก', 'Western Sahara', 'EH', 'ESH', '732', 'ISO 3166-2:EH', NULL, NULL);
INSERT INTO `countries` VALUES ('ซูดาน', 'Sudan', 'SD', 'SDN', '736', 'ISO 3166-2:SD', NULL, NULL);
INSERT INTO `countries` VALUES ('เกาะบูเวต์', 'Bouvet Island', 'BV', 'BVT', '74', 'ISO 3166-2:BV', NULL, NULL);
INSERT INTO `countries` VALUES ('ซูรินาม', 'Suriname', 'SR', 'SUR', '740', 'ISO 3166-2:SR', NULL, NULL);
INSERT INTO `countries` VALUES ('สฟาลบาร์และยานไมเอน', 'Svalbard and Jan Mayen', 'SJ', 'SJM', '744', 'ISO 3166-2:SJ', NULL, NULL);
INSERT INTO `countries` VALUES ('สวาซิแลนด์', 'Swaziland', 'SZ', 'SWZ', '748', 'ISO 3166-2:SZ', NULL, NULL);
INSERT INTO `countries` VALUES ('สวีเดน', 'Sweden', 'SE', 'SWE', '752', 'ISO 3166-2:SE', NULL, NULL);
INSERT INTO `countries` VALUES ('สวิตเซอร์แลนด์', 'Switzerland', 'CH', 'CHE', '756', 'ISO 3166-2:CH', NULL, NULL);
INSERT INTO `countries` VALUES ('บราซิล', 'Brazil', 'BR', 'BRA', '76', 'ISO 3166-2:BR', NULL, NULL);
INSERT INTO `countries` VALUES ('ซีเรีย', 'Syrian Arab Republic', 'SY', 'SYR', '760', 'ISO 3166-2:SY', NULL, NULL);
INSERT INTO `countries` VALUES ('ทาจิกิสถาน', 'Tajikistan', 'TJ', 'TJK', '762', 'ISO 3166-2:TJ', NULL, NULL);
INSERT INTO `countries` VALUES ('ไทย', 'Thailand', 'TH', 'THA', '764', 'ISO 3166-2:TH', NULL, NULL);
INSERT INTO `countries` VALUES ('โตโก', 'Togo', 'TG', 'TGO', '768', 'ISO 3166-2:TG', NULL, NULL);
INSERT INTO `countries` VALUES ('โทเคอเลา', 'Tokelau', 'TK', 'TKL', '772', 'ISO 3166-2:TK', NULL, NULL);
INSERT INTO `countries` VALUES ('ตองงา', 'Tonga', 'TO', 'TON', '776', 'ISO 3166-2:TO', NULL, NULL);
INSERT INTO `countries` VALUES ('ตรินิแดดและโตเบโก', 'Trinidad and Tobago', 'TT', 'TTO', '780', 'ISO 3166-2:TT', NULL, NULL);
INSERT INTO `countries` VALUES ('สหรัฐอาหรับเอมิเรตส์', 'United Arab Emirates', 'AE', 'ARE', '784', 'ISO 3166-2:AE', NULL, NULL);
INSERT INTO `countries` VALUES ('ตูนิเซีย', 'Tunisia', 'TN', 'TUN', '788', 'ISO 3166-2:TN', NULL, NULL);
INSERT INTO `countries` VALUES ('ตุรกี', 'Turkey', 'TR', 'TUR', '792', 'ISO 3166-2:TR', NULL, NULL);
INSERT INTO `countries` VALUES ('เติร์กเมนิสถาน', 'Turkmenistan', 'TM', 'TKM', '795', 'ISO 3166-2:TM', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะเติกส์และเคคอส', 'Turks and Caicos Islands', 'TC', 'TCA', '796', 'ISO 3166-2:TC', NULL, NULL);
INSERT INTO `countries` VALUES ('ตูวาลู', 'Tuvalu', 'TV', 'TUV', '798', 'ISO 3166-2:TV', NULL, NULL);
INSERT INTO `countries` VALUES ('แอลเบเนีย', 'Albania', 'AL', 'ALB', '8', 'ISO 3166-2:AL', NULL, NULL);
INSERT INTO `countries` VALUES ('ยูกันดา', 'Uganda', 'UG', 'UGA', '800', 'ISO 3166-2:UG', NULL, NULL);
INSERT INTO `countries` VALUES ('ยูเครน', 'Ukraine', 'UA', 'UKR', '804', 'ISO 3166-2:UA', NULL, NULL);
INSERT INTO `countries` VALUES ('นอร์ทมาซิโดเนีย', 'North Macedonia', 'MK', 'MKD', '807', 'ISO 3166-2:MK', NULL, NULL);
INSERT INTO `countries` VALUES ('อียิปต์', 'Egypt', 'EG', 'EGY', '818', 'ISO 3166-2:EG', NULL, NULL);
INSERT INTO `countries` VALUES ('สหราชอาณาจักร', 'United Kingdom of Great Britain and Northern Ireland', 'GB', 'GBR', '826', 'ISO 3166-2:GB', NULL, NULL);
INSERT INTO `countries` VALUES ('เกิร์นซีย์', 'Guernsey', 'GG', 'GGY', '831', 'ISO 3166-2:GG', NULL, NULL);
INSERT INTO `countries` VALUES ('เจอร์ซีย์', 'Jersey', 'JE', 'JEY', '832', 'ISO 3166-2:JE', NULL, NULL);
INSERT INTO `countries` VALUES ('ไอล์ออฟแมน', 'Isle of Man', 'IM', 'IMN', '833', 'ISO 3166-2:IM', NULL, NULL);
INSERT INTO `countries` VALUES ('แทนซาเนีย', 'Tanzania', 'TZ', 'TZA', '834', 'ISO 3166-2:TZ', NULL, NULL);
INSERT INTO `countries` VALUES ('เบลีซ', 'Belize', 'BZ', 'BLZ', '84', 'ISO 3166-2:BZ', NULL, NULL);
INSERT INTO `countries` VALUES ('สหรัฐ', 'United States of America', 'US', 'USA', '840', 'ISO 3166-2:US', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะเวอร์จินของสหรัฐอเมริกา', 'United States Virgin Islands', 'VI', 'VIR', '850', 'ISO 3166-2:VI', NULL, NULL);
INSERT INTO `countries` VALUES ('บูร์กินาฟาโซ', 'Burkina Faso', 'BF', 'BFA', '854', 'ISO 3166-2:BF', NULL, NULL);
INSERT INTO `countries` VALUES ('อุรุกวัย', 'Uruguay', 'UY', 'URY', '858', 'ISO 3166-2:UY', NULL, NULL);
INSERT INTO `countries` VALUES ('บริติชอินเดียนโอเชียนเทร์ริทอรี', 'British Indian Ocean Territory', 'IO', 'IOT', '86', 'ISO 3166-2:IO', NULL, NULL);
INSERT INTO `countries` VALUES ('อุซเบกิสถาน', 'Uzbekistan', 'UZ', 'UZB', '860', 'ISO 3166-2:UZ', NULL, NULL);
INSERT INTO `countries` VALUES ('เวเนซุเอลา', 'Venezuela', 'VE', 'VEN', '862', 'ISO 3166-2:VE', NULL, NULL);
INSERT INTO `countries` VALUES ('วาลิสและฟูตูนา', 'Wallis and Futuna', 'WF', 'WLF', '876', 'ISO 3166-2:WF', NULL, NULL);
INSERT INTO `countries` VALUES ('ซามัว', 'Samoa', 'WS', 'WSM', '882', 'ISO 3166-2:WS', NULL, NULL);
INSERT INTO `countries` VALUES ('เยเมน', 'Yemen', 'YE', 'YEM', '887', 'ISO 3166-2:YE', NULL, NULL);
INSERT INTO `countries` VALUES ('แซมเบีย', 'Zambia', 'ZM', 'ZMB', '894', 'ISO 3166-2:ZM', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะโซโลมอน', 'Solomon Islands', 'SB', 'SLB', '90', 'ISO 3166-2:SB', NULL, NULL);
INSERT INTO `countries` VALUES ('หมู่เกาะบริติชเวอร์จิน', 'British Virgin Islands', 'VG', 'VGB', '92', 'ISO 3166-2:VG', NULL, NULL);
INSERT INTO `countries` VALUES ('บรูไน', 'Brunei Darussalam', 'BN', 'BRN', '96', 'ISO 3166-2:BN', NULL, NULL);

-- ----------------------------
-- Table structure for exibit_map
-- ----------------------------
CREATE TABLE `exibit_map`  (
  `package_id` int NOT NULL,
  `template_id` int NOT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`package_id`, `template_id`) USING BTREE,
  INDEX `template_id`(`template_id`) USING BTREE,
  CONSTRAINT `exibit_map_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `exibit_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `exibit_map_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `exibit_packages` (`package_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of exibit_map
-- ----------------------------
INSERT INTO `exibit_map` VALUES (1, 1, NULL, NULL);

-- ----------------------------
-- Table structure for exibit_packages
-- ----------------------------
CREATE TABLE `exibit_packages`  (
  `package_id` int NOT NULL AUTO_INCREMENT,
  `package_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('online','hybrid','onsite','other') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double NOT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`package_id`) USING BTREE,
  INDEX `exibit_type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of exibit_packages
-- ----------------------------
INSERT INTO `exibit_packages` VALUES (1, 'Meta EX', 'online', 'Meta EX', 0, NULL, NULL);

-- ----------------------------
-- Table structure for exibit_templates
-- ----------------------------
CREATE TABLE `exibit_templates`  (
  `template_id` int NOT NULL AUTO_INCREMENT,
  `template_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `asset_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`template_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of exibit_templates
-- ----------------------------
INSERT INTO `exibit_templates` VALUES (1, 'Meta EX', 'Meta EX', 'metaex/', NULL, NULL);

-- ----------------------------
-- Table structure for exibitor_3d_booth
-- ----------------------------
CREATE TABLE `exibitor_3d_booth`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `exibitor_id` int NOT NULL,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`, `exibitor_id`) USING BTREE,
  INDEX `exibitor`(`exibitor_id`) USING BTREE,
  CONSTRAINT `exibitor` FOREIGN KEY (`exibitor_id`) REFERENCES `exibitor_users` (`exibitor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 291 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for exibitor_booth
-- ----------------------------
CREATE TABLE `exibitor_booth`  (
  `exibitor_id` int NOT NULL,
  `meeting_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `emarket_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `colorChangeDetail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `colorChangeRef` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  `chat_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `any_link` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`exibitor_id`) USING BTREE,
  CONSTRAINT `exibitor_booth_ibfk_1` FOREIGN KEY (`exibitor_id`) REFERENCES `exibitor_users` (`exibitor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for exibitor_meeting
-- ----------------------------
CREATE TABLE `exibitor_meeting`  (
  `exibitor_id` int NOT NULL,
  `start_date` date NULL DEFAULT NULL,
  `end_date` date NULL DEFAULT NULL,
  `avaliable_times` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `avaliable_days` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `slot_lenght` int NOT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`exibitor_id`) USING BTREE,
  CONSTRAINT `exibitor_meeting_ibfk_1` FOREIGN KEY (`exibitor_id`) REFERENCES `exibitor_users` (`exibitor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for exibitor_meeting_schedule
-- ----------------------------
CREATE TABLE `exibitor_meeting_schedule`  (
  `meeting_id` int NOT NULL AUTO_INCREMENT,
  `exibitor_id` int NOT NULL,
  `visitor_id` int NOT NULL,
  `start_time` timestamp NOT NULL DEFAULT current_timestamp ON UPDATE CURRENT_TIMESTAMP,
  `lenght` int NOT NULL,
  `meeting_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`meeting_id`) USING BTREE,
  INDEX `exibitor_id`(`exibitor_id`) USING BTREE,
  INDEX `visitor_id`(`visitor_id`) USING BTREE,
  CONSTRAINT `exibitor_meeting_schedule_ibfk_1` FOREIGN KEY (`visitor_id`) REFERENCES `visitor_users` (`visitor_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `exibitor_meeting_schedule_ibfk_2` FOREIGN KEY (`exibitor_id`) REFERENCES `exibitor_profiles` (`exibitor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 193 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for exibitor_profiles
-- ----------------------------
CREATE TABLE `exibitor_profiles`  (
  `exibitor_id` int NOT NULL,
  `package_id` int NOT NULL,
  `template_id` int NOT NULL,
  `contact_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `business_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `postcode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `contract_phone_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_phone_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `line_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `terms_agreed` tinyint(1) NOT NULL,
  `subscription` tinyint(1) NOT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  `meeting_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `hall` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `corporateVDOLink` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `companyIntrocutionTH` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `companyIntrocutionEN` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `productTH` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `productEN` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`exibitor_id`) USING BTREE,
  INDEX `exibitor_profiles_ibfk_2`(`package_id`, `template_id`) USING BTREE,
  INDEX `contry`(`country`) USING BTREE,
  INDEX `hall`(`hall`) USING BTREE,
  CONSTRAINT `country` FOREIGN KEY (`country`) REFERENCES `countries` (`alpha2`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `exibitor_profiles_ibfk_1` FOREIGN KEY (`exibitor_id`) REFERENCES `exibitor_users` (`exibitor_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `exibitor_profiles_ibfk_2` FOREIGN KEY (`package_id`, `template_id`) REFERENCES `exibit_map` (`package_id`, `template_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `hall` FOREIGN KEY (`hall`) REFERENCES `hall` (`hall`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for hall
-- ----------------------------
CREATE TABLE `hall`  (
  `hall` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`hall`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hall
-- ----------------------------
INSERT INTO `hall` VALUES ('Meta EX', NULL, NULL);

-- ----------------------------
-- Table structure for view_records
-- ----------------------------
CREATE TABLE `view_records`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `exhibit_id` int NOT NULL,
  `viewer` int NOT NULL,
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `view_date` date NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `exhibitors_views_record`(`exhibit_id`) USING BTREE,
  CONSTRAINT `exhibitors_views_record` FOREIGN KEY (`exhibit_id`) REFERENCES `exibitor_users` (`exibitor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 5687 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for visitor_views
-- ----------------------------
CREATE TABLE `visitor_views`  (
  `visitor_id` int NOT NULL,
  `exibitor_id` int NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`visitor_id`, `exibitor_id`) USING BTREE,
  INDEX `exhibitor`(`exibitor_id`) USING BTREE,
  CONSTRAINT `exhibitor` FOREIGN KEY (`exibitor_id`) REFERENCES `exibitor_users` (`exibitor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of visitor_views
-- ----------------------------

-- ----------------------------
-- View structure for exhibitorsWithInactiveUser
-- ----------------------------
DROP VIEW IF EXISTS `exhibitorsWithInactiveUser`;

-- ----------------------------
-- View structure for exhibitor_view_daily
-- ----------------------------
DROP VIEW IF EXISTS `exhibitor_view_daily`;

-- ----------------------------
-- View structure for exibitors
-- ----------------------------
DROP VIEW IF EXISTS `exibitors`;

-- ----------------------------
-- View structure for packages
-- ----------------------------
DROP VIEW IF EXISTS `packages`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `packages` AS select `exibit_packages`.`package_name` AS `package_name`,`exibit_packages`.`package_id` AS `package_id`,`exibit_packages`.`type` AS `type`,`exibit_packages`.`detail` AS `detail`,`exibit_packages`.`price` AS `price`,`exibit_templates`.`template_id` AS `template_id`,`exibit_templates`.`template_name` AS `template_name`,`exibit_templates`.`detail` AS `template_detail`,`exibit_templates`.`asset_path` AS `asset_path` from ((`exibit_map` join `exibit_packages` on(`exibit_map`.`package_id` = `exibit_packages`.`package_id`)) join `exibit_templates` on(`exibit_map`.`template_id` = `exibit_templates`.`template_id`));

-- ----------------------------
-- View structure for schedules
-- ----------------------------
DROP VIEW IF EXISTS `schedules`;

-- ----------------------------
-- View structure for visitors
-- ----------------------------
DROP VIEW IF EXISTS `visitors`;

-- ----------------------------
-- View structure for visitor_views_alltime
-- ----------------------------
DROP VIEW IF EXISTS `visitor_views_alltime`;

-- ----------------------------
-- View structure for visitor_views_eachday
-- ----------------------------
DROP VIEW IF EXISTS `visitor_views_eachday`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `visitor_views_eachday` AS select `view_records`.`view_date` AS `view_date`,count(distinct `view_records`.`view_date`,`view_records`.`role`,`view_records`.`viewer`) AS `viewer` from `view_records` group by `view_records`.`view_date` order by `view_records`.`view_date` desc;

-- ----------------------------
-- View structure for visitor_views_statistics
-- ----------------------------
DROP VIEW IF EXISTS `visitor_views_statistics`;

