ALTER TABLE  `student_report_card_grades` CHANGE  `grade_percent`  `grade_percent` VARCHAR( 100 ) NULL DEFAULT NULL ;
ALTER TABLE  `billing_payments` CHANGE  `id`  `id` INT NOT NULL AUTO_INCREMENT ;
ALTER TABLE  `billing_payments` DROP PRIMARY KEY ,ADD PRIMARY KEY (  `id` ) ;
ALTER TABLE  `billing_payments` ADD  `issued` VARCHAR( 300 ) NOT NULL ;
ALTER TABLE  `billing_payments` ADD  `amounts_due` VARCHAR( 300 ) NOT NULL ;
ALTER TABLE  `billing_payments` CHANGE  `amount`  `amount` DECIMAL( 10, 2 ) NOT NULL ;
ALTER TABLE  `courses` ADD  `core` VARCHAR( 100 )  NULL ,ADD  `placement` VARCHAR( 100 )  NULL ,ADD  `certificate` VARCHAR( 100 )  NULL;
CREATE TABLE IF NOT EXISTS `interest` (`id` int(8) NOT NULL AUTO_INCREMENT,`title` varchar(300) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `conduct` (`id` int(8) NOT NULL AUTO_INCREMENT,`title` varchar(300) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `aggregates` (`id` int(100) NOT NULL AUTO_INCREMENT,`placement` varchar(100) COLLATE utf8_unicode_ci NOT NULL,`certificate` varchar(100) COLLATE utf8_unicode_ci NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `payment_mode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `syear` varchar(100) NOT NULL,
  `school_id` varchar(100) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  UNIQUE KEY `payment_mode_pkey` (`id`) USING BTREE
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;
ALTER TABLE  `billing_payments` ADD  `mode` VARCHAR( 300 ) NOT NULL ;
ALTER TABLE  `billing_payments` ADD  `category` VARCHAR( 300 ) NOT NULL ;
ALTER TABLE  `schools` CHANGE  `area_code`  `area_code` VARCHAR( 200 ) NULL DEFAULT NULL

Dated 2015

ALTER TABLE  `class_percentages` ADD  `syear` VARCHAR( 300 ) NOT NULL ;
ALTER TABLE  `class_marks` ADD  `syear` VARCHAR( 300 ) NOT NULL ;
ALTER TABLE  `class_works` ADD  `syear` VARCHAR( 300 ) NOT NULL ;
ALTER TABLE  `pass_mark` ADD  `syear` VARCHAR( 300 ) NOT NULL ;
 
Dated 2016

UPDATE `app` SET `value`="3.0" WHERE `name`="version";
UPDATE `app` SET `value`="January 01, 2017" WHERE `name`="date";
UPDATE `app` SET `value`="January 01, 2017" WHERE `name`="last_updated";
ALTER TABLE `billing_fees_components` MODIFY `amount` DECIMAL (10,2);
CREATE TABLE IF NOT EXISTS `billing_bill_notice` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `school_id` int(100) NOT NULL,
  `notice` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

DATED 30 DEC 2016

ALTER TABLE  `billing_fees` ADD  `issued` VARCHAR( 250 ) NULL ;
UPDATE `billing_fees_categories` SET syear=2016 ; (THIS WILL  CHANGE PREVIOUS CATEGORIES TO  2016)

DATED 10 OCT 2017

CREATE TABLE IF NOT EXISTS `attendance` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `title` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;


Dated 2018

ALTER TABLE  `na_attendance` ADD  `staff_id` INT( 100 ) NOT NULL ;
 