CREATE TABLE `psi_rndprj` (
  `rndprj_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `rndprj_date` date DEFAULT NULL,
  `rndprj_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `rndprj_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rndprj_evaluated` tinyint(1) unsigned DEFAULT '0',
  `rndprj_endorsed` tinyint(1) unsigned DEFAULT '0',
  `rndprj_inhouse` tinyint(1) unsigned DEFAULT '0',
  `rndprj_implemented` tinyint(1) unsigned DEFAULT '0',
  `rndprj_colaborative` tinyint(1) unsigned DEFAULT '0',
  `rndprj_colaborators` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rndprj_remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rndsec_id` bigint(20) unsigned DEFAULT '0',
  `ug_id` bigint(20) unsigned DEFAULT '0',
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`rndprj_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

