spc migration version 2

UPDATE app_modules SET mnu_link = '../../registrar_spc/admin/registration.php?statpos=new_assessment' WHERE mnu_name LIKE '%assessment%' AND mnu_id = '179';



UPDATE app_modules SET mnu_link = '../../registrar_spc/admin/registration.php?statpos=new_assessment' WHERE mnu_id = '24';

-- Adminer 4.3.1 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

USE dps_registrar_db;

CREATE TABLE file_id_template_axis (
  fita_id int(11) NOT NULL AUTO_INCREMENT,
  fita_name varchar(255) DEFAULT NULL,
  fita_desc varchar(255) DEFAULT NULL,
  is_active int(11) NOT NULL DEFAULT '1',
  id_orientation varchar(255) NOT NULL DEFAULT 'L',
  temp_order int(11) NOT NULL,
  PRIMARY KEY (fita_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO file_id_template_axis (fita_id, fita_name, fita_desc, is_active, id_orientation, temp_order) VALUES
(1, 'College Template', 'College Template', 1,  'L',    5),
(2, 'High School Template', 'High School Template', 0,  'L',    0),
(4, 'Employee Template',    'Employee Template',    0,  'L',    0),
(3, 'Elementary Template',  'Elementary Template',  1,  'L',    1),
(5, 'JHS ESC',  'Junior High School - ESC', 1,  'L',    2),
(6, 'JHS Non-ESC',  'Junior High School - Non-ESC', 1,  'L',    3),
(7, 'Senior High School',   'Senior High School',   1,  'L',    4),
(8, 'Masteral', 'Masteral', 1,  'L',    6);

-- 2018-05-30 05:28:51


ALTER TABLE file_id_template_images
ADD fita_id int(11) NULL;


use dps_registrar_db;
INSERT INTO file_department_type (depttype_name)
VALUES ('Graduate School');
UPDATE file_department SET depttype_id = '10' WHERE dept_id = '12';

UPDATE file_gradeyearlevel_2018_2019 SET dept_id = '0' WHERE yl_id = '19';
UPDATE file_gradeyearlevel_2018_2019 SET dept_id = '0' WHERE yl_id = '20';
UPDATE file_gradeyearlevel_2018_2019 SET dept_id = '0' WHERE yl_id = '21';
UPDATE file_gradeyearlevel_2018_2019 SET dept_id = '0' WHERE yl_id = '22';
UPDATE file_gradeyearlevel_2018_2019 SET dept_id = '0' WHERE yl_id = '23';

UPDATE file_gradeyearlevel_2017_2018 SET dept_id = '0' WHERE yl_id = '19';
UPDATE file_gradeyearlevel_2017_2018 SET dept_id = '0' WHERE yl_id = '20';
UPDATE file_gradeyearlevel_2017_2018 SET dept_id = '0' WHERE yl_id = '21';
UPDATE file_gradeyearlevel_2017_2018 SET dept_id = '0' WHERE yl_id = '22';
UPDATE file_gradeyearlevel_2017_2018 SET dept_id = '0' WHERE yl_id = '23';

-- Adminer 4.3.1 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

USE `dps_registrar_db`;

CREATE TABLE `college_laboratory_type` (
  `lab_type_id` int(10) NOT NULL AUTO_INCREMENT,
  `lab_type_name` varchar(255) NOT NULL,
  PRIMARY KEY (`lab_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


-- 2018-05-31 03:41:06

ALTER TABLE college_course_curriculum_2018_2019
ADD ccc_status int(10) NOT NULL DEFAULT '1';

UPDATE `app_modules` SET `mnu_link` = '../../registrar_spc/admin/setup.php?statpos=payment_details' WHERE `mnu_name` LIKE '%payment%' AND `mnu_id` = '177';