CREATE TABLE `psi_rnd_sectors` (
  `rndsec_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `rndsec_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 (`rndsec_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_rnd_sectors (rndsec_id, rndsec_name, region_id, synched, sync_date, date_encoded, last_updated, encoder, updater) VALUES
(1, 'Agriculture', 6, 0, NULL, NULL, NULL, '', ''),
(2, 'Aquatic & Marine', 6, 0, NULL, NULL, NULL, '', ''),
(3, 'Health', 6, 0, NULL, NULL, NULL, '', ''),
(4, 'Industry', 6, 0, NULL, NULL, NULL, '', ''),
(5, 'Energy', 6, 0, NULL, NULL, NULL, '', ''),
(6, 'DRRM', 6, 0, NULL, NULL, NULL, '', ''),
(7, 'Others', 6, 0, NULL, NULL, NULL, '', '');
