CREATE TABLE `psi_user_rights` (
  `ur_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ur_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,
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`ur_id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_user_rights (ur_id, ur_name, region_id, synched, sync_date, encoder, date_encoded, updater, last_updated) VALUES
(1, 'Projects', 6, 0, NULL, '', NULL, '', NULL),
(2, 'Cooperators', 6, 0, NULL, '', NULL, '', NULL),
(3, 'Service Providers', 6, 0, NULL, '', NULL, '', NULL),
(4, 'Planning', 6, 0, NULL, '', NULL, '', NULL),
(5, 'Consultancies', 6, 0, NULL, '', NULL, '', NULL),
(6, 'Packaging & Labeling', 6, 0, NULL, '', NULL, '', NULL),
(7, 'Packaging & Labeling Designs', 6, 0, NULL, '', NULL, '', NULL),
(8, 'Training', 6, 0, NULL, '', NULL, '', NULL),
(9, 'Training Documents', 6, 0, NULL, '', NULL, '', NULL),
(10, 'Testings & Calibrations', 6, 0, NULL, '', NULL, '', NULL),
(11, 'Scholarships', 6, 0, NULL, '', NULL, '', NULL),
(12, 'Scholarship Monitoring', 6, 0, NULL, '', NULL, '', NULL),
(13, 'S&T Fairs & Promotional Activities', 6, 0, NULL, '', NULL, '', NULL),
(14, 'Library Monitoring', 6, 0, NULL, '', NULL, '', NULL),
(15, 'S&T Activity Categories', 6, 0, NULL, '', NULL, '', NULL),
(16, 'Collaborating Agencies', 6, 0, NULL, '', NULL, '', NULL),
(17, 'Consultancy Categories', 6, 0, NULL, '', NULL, '', NULL),
(18, 'Document Categories', 6, 0, NULL, '', NULL, '', NULL),
(19, 'Equipment Names', 6, 0, NULL, '', NULL, '', NULL),
(20, 'Organization Categories', 6, 0, NULL, '', NULL, '', NULL),
(21, 'Project Categories', 6, 0, NULL, '', NULL, '', NULL),
(22, 'Course Categories', 6, 0, NULL, '', NULL, '', NULL),
(23, 'Courses', 6, 0, NULL, '', NULL, '', NULL),
(24, 'Scholarship Programs', 6, 0, NULL, '', NULL, '', NULL),
(25, 'Schools', 6, 0, NULL, '', NULL, '', NULL),
(26, 'Agency Profile', 6, 0, NULL, '', NULL, '', NULL),
(27, 'Project Monitoring', 6, 0, NULL, '', NULL, '', NULL),
(28, 'Project Documentation', 6, 0, NULL, '', NULL, '', NULL),
(29, 'Project Photos', 6, 0, NULL, '', NULL, '', NULL),
(30, 'Project Consultancies', 6, 0, NULL, '', NULL, '', NULL),
(31, 'Project Fora', 6, 0, NULL, '', NULL, '', NULL),
(32, 'Project Fora Documents', 6, 0, NULL, '', NULL, '', NULL),
(33, 'Project Equipment', 6, 0, NULL, '', NULL, '', NULL),
(34, 'Project Repayment', 6, 0, NULL, '', NULL, '', NULL),
(35, 'Users', 6, 0, NULL, '', NULL, '', NULL),
(36, 'UserGroups', 6, 0, NULL, '', NULL, '', NULL),
(37, 'Project PIS', 6, 0, NULL, '', NULL, '', NULL),
(38, 'Project Packaging & Labeling', 6, 0, NULL, '', NULL, '', NULL),
(39, 'Fora', 6, 0, NULL, '', NULL, '', NULL),
(40, 'Fora Documents', 6, 0, NULL, '', NULL, '', NULL),
(41, 'Consultancy Documents', 6, 0, NULL, '', NULL, '', NULL),
(42, 'Project Consultancy Documents', 6, 0, NULL, '', NULL, '', NULL),
(43, 'Project Packaging & Labeling Designs', 6, 0, NULL, '', NULL, '', NULL),
(44, 'Sectors', 6, 0, NULL, '', NULL, '', NULL),
(45, 'Project Sites', 6, 0, NULL, '', NULL, '', NULL),
(46, 'Location Listings', 6, 0, NULL, '', NULL, '', NULL),
(47, 'Product Units', 6, 0, NULL, '', NULL, '', NULL),
(48, 'Collaborating Agency Categories', 6, 0, NULL, '', NULL, '', NULL),
(49, 'Project Products', 6, 0, NULL, '', NULL, '', NULL),
(50, 'Project Liquidation', 6, 0, NULL, '', NULL, '', NULL),
(51, 'Technology Promotions', 6, 0, NULL, '', NULL, '', NULL),
(52, 'Technology Adoptions', 6, 0, NULL, '', NULL, '', NULL),
(53, 'Technologies', 6, 0, NULL, '', NULL, '', NULL),
(54, 'BSC Customer Perspective', 6, 0, NULL, '', NULL, '', NULL),
(55, 'BSC Financial Perspective', 6, 0, NULL, '', NULL, '', NULL),
(56, 'BSC Internal Process Perspective', 6, 0, NULL, '', NULL, '', NULL),
(57, 'Project Testings & Calibrations', 6, 0, NULL, '', NULL, '', NULL),
(58, 'Technology Adoption Documents', 6, 0, NULL, '', NULL, '', NULL),
(59, 'Project Videos', 6, 0, NULL, '', NULL, '', NULL),
(60, 'S & T Information And Referrals', 6, 0, NULL, '', NULL, '', NULL),
(61, 'SUC Assistance', 6, 0, NULL, '', NULL, '', NULL),
(62, 'ISO Accreditation', 6, 0, NULL, '', NULL, '', NULL),
(63, 'Customer Satisfaction Ratings', 6, 0, NULL, '', NULL, '', NULL),
(64, 'Innovation Hubs', 6, 0, NULL, '', NULL, '', NULL),
(65, 'International Collaborations', 6, 0, NULL, '', NULL, '', NULL),
(66, 'BSC Learning & Growth Perspective', 6, 0, NULL, '', NULL, '', NULL),
(67, 'DRR-CCAM', 6, 0, NULL, '', NULL, '', NULL),
(68, 'R & D Agenda', 6, 0, NULL, '', NULL, '', NULL),
(69, 'R & D Projects', 6, 0, NULL, '', NULL, '', NULL),
(70, 'Regional Communications Plan', 6, 0, NULL, '', NULL, '', NULL),
(71, 'Project S & T Interventions', 6, 0, NULL, '', NULL, '', NULL),
(72, 'BSC Customer Perspective Approval', 6, 0, NULL, '', NULL, '', NULL),
(73, 'BSC Financial Perspective Approval', 6, 0, NULL, '', NULL, '', NULL),
(74, 'BSC Internal Process Perspective Approval', 6, 0, NULL, '', NULL, '', NULL),
(75, 'BSC Learning & Growth Perspective Approval', 6, 0, NULL, '', NULL, '', NULL),
(84, 'User Logs', 6, 0, NULL, '', NULL, '', NULL);
