CREATE TABLE `psi_trainings` (
  `tr_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tr_title` text COLLATE utf8mb4_unicode_ci,
  `tr_start` date DEFAULT NULL,
  `tr_end` date DEFAULT NULL,
  `tr_duration` double unsigned DEFAULT '0',
  `tr_location` text COLLATE utf8mb4_unicode_ci,
  `tr_longitude` double unsigned DEFAULT '0',
  `tr_latitude` double unsigned DEFAULT '0',
  `tr_elevation` double unsigned DEFAULT '0',
  `tr_cost` double unsigned DEFAULT '0',
  `tr_csf` double unsigned DEFAULT '0',
  `tr_no_feminine` int(10) unsigned DEFAULT '0',
  `tr_no_musculine` int(10) unsigned DEFAULT '0',
  `tr_no_pwd` int(10) unsigned DEFAULT '0',
  `tr_no_seniors` int(10) unsigned DEFAULT '0',
  `tr_no_firms` int(10) unsigned DEFAULT '0',
  `tr_no_participants` int(10) unsigned DEFAULT '0',
  `tr_type_id` bigint(20) unsigned DEFAULT '0',
  `prj_id` bigint(20) unsigned DEFAULT '0',
  `ug_id` bigint(20) unsigned DEFAULT '0',
  `sp_id` bigint(20) unsigned DEFAULT '0',
  `encoder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `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 (`tr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_trainings (tr_id, tr_title, tr_start, tr_end, tr_duration, tr_location, tr_longitude, tr_latitude, tr_elevation, tr_cost, tr_csf, tr_no_feminine, tr_no_musculine, tr_no_pwd, tr_no_seniors, tr_no_firms, tr_no_participants, tr_type_id, prj_id, ug_id, sp_id, encoder, date_encoded, updater, last_updated, region_id, synched, sync_date) VALUES
(17, 'qweqweqwe', '2015-05-08', '2015-05-08', 150, 'asdas dasd as dasd as dasd a sdasd', 0, 0, 0, 0, 0, 123, 456, 0, 0, 0, 0, 0, 13, 2, 9, 'Admin Is Traytor', '2015-05-08 09:49:27', 'Admin Is Traytor', '2015-05-08 09:49:50', 6, 0, NULL),
(18, 'sadfsadf', '2015-05-08', '2015-05-08', 7, 'gtrhydfhdfh', 0, 0, 0, 0, 0, 6, 7, 0, 0, 0, 0, 0, 14, 2, 9, 'Devlin L De Falco', '2015-05-08 14:07:42', 'Devlin L De Falco', '2015-05-08 14:07:42', 6, 0, NULL),
(19, 'smaw training', '2015-07-06', '2015-07-08', 0, 'cainta rizal', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 108, 16, 9, 'pstc - rizal', '2015-11-04 11:30:16', 'pstc - rizal', '2015-11-04 11:30:16', 6, 0, NULL),
(20, 'Oyster Mushroom Propagation and Cultivation', '2016-03-16', '2016-03-18', 24, 'CCSST, Jimenez Compound, Brgy. Cuyambay, Tanay, Rizal', 0, 0, 0, 24000, 4.4, 24, 15, 3, 4, 39, 0, 0, 209, 16, 9, 'Mhelice L. Talavera', '2016-05-16 17:21:29', 'Mhelice L. Talavera', '2016-05-17 11:08:27', 6, 0, NULL);
