CREATE TABLE `psi_business_activities` (
  `ba_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ba_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  `date_encoded` datetime DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`ba_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_business_activities (ba_id, ba_name, region_id, synched, sync_date, date_encoded, last_updated, encoder, updater) VALUES
(1, 'Food Processing', 6, 0, NULL, NULL, NULL, '', ''),
(2, 'Furniture', 6, 0, NULL, NULL, NULL, '', ''),
(3, 'Natural Fibers, GHD & Fashion Accessories', 6, 0, NULL, NULL, NULL, '', ''),
(4, 'Metals & Engineering', 6, 0, NULL, NULL, NULL, '', ''),
(5, 'Aquatic & Marine', 6, 0, NULL, NULL, NULL, '', ''),
(6, 'Horticulture & Agriculture', 6, 0, NULL, NULL, NULL, '', ''),
(7, 'Health Products/Services/Pharmaceuticals', 6, 0, NULL, NULL, NULL, '', ''),
(8, 'Electronics & ICT', 6, 0, NULL, NULL, NULL, '', ''),
(9, 'Others', 6, 0, NULL, NULL, NULL, '', '');
