grading and cashier migration nov 16 2016

INSERT INTO `file_class_type_2016_2017` (`ct_id`, `ct_name`, `ct_description`, `ct_rank`, `ct_type`, `ct_addwhen`, `ct_addwho`, `ct_updatewhen`, `ct_updatewho`) VALUES
(5, 'Basic Education',  'Basic Education',  2,  20, '2016-08-09 15:13:59',  'System Administrator', NULL,   NULL),
(4, 'STREAM',   '', 3,  30, '2016-10-11 13:04:28',  'System Administrator', NULL,   NULL),
(7, 'Honor Class',  'Honor Class',  1,  10, '2016-11-16 11:30:14',  'System Administrator', NULL,   NULL);




-- Adminer 4.2.5 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_cashier_db;
DROP TABLE IF EXISTS cashier_soa_generated_per_students; CREATE TABLE cashier_soa_generated_per_students ( soa_generated_id int(11) NOT NULL AUTO_INCREMENT, soa_months varchar(255) NOT NULL, soa_remaining_balance varchar(255) NOT NULL, soa_total_payments varchar(255) NOT NULL, soa_tution_for_this_month varchar(255) NOT NULL, soa_months_paid varchar(255) NOT NULL, soa_months_generated varchar(255) NOT NULL, soa_status varchar(255) NOT NULL, stud_applicant_id varchar(255) NOT NULL, soa_all_tution varchar(255) NOT NULL, PRIMARY KEY (soa_generated_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO cashier_soa_generated_per_students (soa_generated_id, soa_months, soa_remaining_balance, soa_total_payments, soa_tution_for_this_month, soa_months_paid, soa_months_generated, soa_status, stud_applicant_id, soa_all_tution) VALUES (53, '0', '20685', '3235.36', '7920.36', '3235.36', '2016-11-12 15:19:32', '10', '246', '23920.36'), (54, '1', '18685', '2000.00', '2000.00', '2000.00', '2016-11-12 15:20:39', '10', '246', '23920.36');
-- 2016-11-14 00:09:08