CREATE TABLE `psi_training_documents` (
  `trdoc_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trdoc_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `trdoc_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `trdoc_remarks` text COLLATE utf8mb4_unicode_ci,
  `tr_id` bigint(20) unsigned DEFAULT '0',
  `encoder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) 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 (`trdoc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_training_documents (trdoc_id, trdoc_file, trdoc_filename, trdoc_remarks, tr_id, encoder, date_encoded, updater, last_updated, region_id, synched, sync_date) VALUES
(11, 'public wifi service-ailmivw-20150508_101559.docx', 'public wifi service', '', 17, 'Admin Is Traytor', '2015-05-08 10:15:59', 'Admin Is Traytor', '2015-05-08 10:15:59', 6, 0, NULL),
(12, 'public wifi service-fuwksfo-20150508_140757.docx', 'public wifi service', '', 18, 'Devlin L De Falco', '2015-05-08 14:07:57', 'Devlin L De Falco', '2015-05-08 14:07:57', 6, 0, NULL),
(13, 'Liquidation Report-Mushroom Training-dyojaam-20160517_152749.xls', 'Liquidation Report-Mushroom Training', '', 20, 'Mhelice L. Talavera', '2016-05-17 15:27:49', 'Mhelice L. Talavera', '2016-05-17 15:27:49', 6, 0, NULL);
