CREATE TABLE `psi_scholarship_programs` (
  `scholar_prog_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `scholar_prog_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `scholar_prog_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `region_id` bigint(20) unsigned DEFAULT '6',
  `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 '',
  PRIMARY KEY (`scholar_prog_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_scholarship_programs (scholar_prog_id, scholar_prog_name, scholar_prog_desc, region_id, synched, sync_date, date_encoded, last_updated, encoder, updater) VALUES
(1, 'Proj. 5801', 'Project 5801', 6, 0, NULL, NULL, NULL, '', ''),
(2, 'R.A. 7687', 'Republic Act No. 7687', 6, 0, NULL, NULL, NULL, '', ''),
(3, 'Merit', 'Merit', 6, 0, NULL, NULL, NULL, '', ''),
(4, 'JLAP - RA 7687', 'Junior Level Assistance Program - RA', 6, 0, NULL, NULL, NULL, '', ''),
(5, 'JLAP - Merit', 'Junior Level Assistance Program - Merit', 6, 0, NULL, NULL, NULL, '', ''),
(6, 'JLSS - Project GIFTS', 'Junior Level Science Scholarship - Project GIFTS for the Disadvantaged', 6, 0, NULL, NULL, NULL, '', ''),
(7, 'JLSS - Merit', 'Junior Level Science Scholarship - Merit', 6, 0, NULL, NULL, NULL, '', ''),
(8, 'S&TSSCS - RA 7687', 'S&T Scholarhsips for Sophomore College Students - RA', 6, 0, NULL, NULL, NULL, '', ''),
(9, 'S&TSSCS - Merit', 'S&T Scholarhsips for Sophomore College Students - Merit', 6, 0, NULL, NULL, NULL, '', ''),
(12, 'JLSS - R.A 7687', 'Junior Level Science Scholarship R.A 7687', 6, 0, NULL, NULL, NULL, '', ''),
(13, 'JLSS - R.A 10612', 'Junior Level Science Scholarship R.A 10612', 6, 0, NULL, NULL, NULL, '', '');
