CREATE TABLE `psi_project_status` (
  `prj_status_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `prj_status_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 (`prj_status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_project_status (prj_status_id, prj_status_name, region_id, synched, sync_date, date_encoded, last_updated, encoder, updater) VALUES
(1, 'On-going', 6, 0, NULL, NULL, NULL, '', ''),
(3, 'New', 6, 0, NULL, NULL, NULL, '', ''),
(4, 'Graduated', 6, 0, NULL, NULL, NULL, '', ''),
(6, 'Terminated', 6, 0, NULL, NULL, NULL, '', ''),
(7, 'Withdrawn', 6, 0, NULL, NULL, NULL, '', ''),
(8, 'Completed', 6, 0, NULL, NULL, NULL, '', '');
