· 9 years ago · Nov 16, 2016, 03:40 AM
1INSERT 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
2(5, 'Basic Education', 'Basic Education', 2, 20, '2016-08-09 15:13:59', 'System Administrator', NULL, NULL),
3(4, 'STREAM', '', 3, 30, '2016-10-11 13:04:28', 'System Administrator', NULL, NULL),
4(7, 'Honor Class', 'Honor Class', 1, 10, '2016-11-16 11:30:14', 'System Administrator', NULL, NULL);
5
6
7
8
9-- Adminer 4.2.5 MySQL dump
10SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
11USE dps_cashier_db;
12DROP 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;
13INSERT 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');
14-- 2016-11-14 00:09:08