CREATE TABLE `psi_usergroups` (
  `ug_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ug_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `ug_is_admin` tinyint(1) unsigned DEFAULT '0',
  `ug_display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `province_id` bigint(20) unsigned DEFAULT '0',
  `ug_parent_id` bigint(20) unsigned DEFAULT '0',
  `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 '',
  `ug_unit_head` bigint(20) unsigned DEFAULT '0',
  PRIMARY KEY (`ug_id`),
  UNIQUE KEY `ug_id_UNIQUE` (`ug_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_usergroups (ug_id, ug_name, ug_is_admin, ug_display_name, region_id, province_id, ug_parent_id, synched, sync_date, date_encoded, last_updated, encoder, updater, ug_unit_head) VALUES
(1, 'RO-Administrators', 1, 'RO', 6, 29, 24, 0, NULL, NULL, '2019-03-21 21:31:10', '', 'Glenn John M Glenn John', 0),
(2, 'RO-SETUP', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(3, 'RO-Project Coordinators', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(4, 'RO-Scholarship', 0, 'RO', 6, 29, 24, 0, NULL, NULL, '2019-03-21 21:32:38', '', 'Glenn John M Glenn John', 0),
(5, 'RO-RSTL', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(6, 'RO-RML', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(9, 'RO-S &amp; T Promotions', 0, 'RO', 6, 29, 24, 0, NULL, NULL, '2019-04-05 15:12:22', '', 'Treytor Is Admin', 0),
(10, 'RO-Packaging &amp; Labeling', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(11, 'RO-Planning', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(12, 'PSTC-BATANGAS', 0, 'BAT', 6, 27, 0, 0, NULL, NULL, '2019-03-22 23:54:09', '', 'Treytor Is Admin', 0),
(13, 'PSTC-CAVITE', 0, 'CAV', 6, 28, 0, 0, NULL, NULL, '2019-03-22 23:54:19', '', 'Treytor Is Admin', 0),
(14, 'PSTC-LAGUNA', 0, 'LAG', 6, 29, 0, 0, NULL, NULL, '2019-03-22 23:54:27', '', 'Treytor Is Admin', 0),
(15, 'PSTC-QUEZON', 0, 'QUE', 6, 30, 0, 0, NULL, NULL, '2019-03-22 23:54:35', '', 'Treytor Is Admin', 0),
(16, 'PSTC-RIZAL', 0, 'RIZ', 6, 31, 0, 0, NULL, NULL, '2019-03-22 23:54:42', '', 'Treytor Is Admin', 0),
(17, 'RO-Activity Coordinators', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(19, 'RO-Director', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(20, 'RO-ARD', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(22, 'RO-MIS', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(23, 'RO-Accounting', 0, 'RO', 6, 29, 24, 0, NULL, NULL, NULL, '', '', 0),
(24, 'RO', 0, 'RO', 6, 29, 0, 0, NULL, NULL, '2019-03-21 21:29:56', '', 'Glenn John M Glenn John', 0),
(25, 'RO-Viewer', 0, 'RO', 6, 29, 24, 0, NULL, '2019-03-21 21:38:51', '2019-03-21 21:39:08', 'Glenn John M Geronimo', 'Glenn John M Geronimo', 0);
