CREATE TABLE `0_notification_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `notification` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` varchar(3000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fields` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
  `active` varchar(1) CHARACTER SET utf8 DEFAULT '1',
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `0_notification_templates` VALUES 
(1,'sms','30','ORDER RECEIVED','Dear {custname} your order has been received','{customername}','1','2018-05-04 15:46:30'),
(2,'sms','10','INVOICE CREATED','Dear {custname} an INVOICE has been crated','{customername}','1','2018-05-04 15:46:30'),
(3,'sms','13','DELIVERY NOTE','Dear {custname} delivery made','{customername}','1','2018-05-04 15:46:30'),
(4,'sms','19','PAYMENT RECEIVED','Dear {custname} payment received','{customername}','1','2018-05-04 15:46:30'),
(5,'sms','11','CREDIT NOTE','Dear {custname} credite note created','{customername}','1','2018-05-04 15:46:30');

ALTER TABLE `0_prices` 
ADD COLUMN `lower_qty` DOUBLE NULL AFTER `price`,
ADD COLUMN `upper_qty` DOUBLE NULL AFTER `lower_qty`;

ALTER TABLE `0_debtors_master` 
ADD COLUMN `incorporation_no` VARCHAR(55) NULL AFTER `inactive`;