ALTER TABLE `project_certificates` ADD `other_deduction` DOUBLE(10,2) NOT NULL DEFAULT '0' AFTER `representative_2`;
ALTER TABLE `project_certificates` ADD `perform_percent` TINYINT NOT NULL DEFAULT '0' AFTER `other_deduction`, ADD `perform_price` DOUBLE(10,2) NOT NULL DEFAULT '0' AFTER `perform_percent`, ADD `perform_date` DATE NULL AFTER `perform_price`, ADD `waranty_percent` TINYINT NOT NULL DEFAULT '0' AFTER `perform_date`, ADD `waranty_price` DOUBLE(10,2) NOT NULL DEFAULT '0' AFTER `waranty_percent`, ADD `waranty_date` DATE NULL AFTER `waranty_price`;



ALTER TABLE `project_certificates` ADD `compensation_percent` TINYINT NOT NULL DEFAULT '0' AFTER `waranty_date`, ADD `compensation_price` DOUBLE(10,2) NOT NULL DEFAULT '0' AFTER `compensation_percent`;
ALTER TABLE `project_certificates` CHANGE `perform_percent` `perform_percent` DOUBLE(10,2) NOT NULL DEFAULT '0', CHANGE `waranty_percent` `waranty_percent` DOUBLE(10,2) NOT NULL DEFAULT '0', CHANGE `compensation_percent` `compensation_percent` DOUBLE(10,2) NOT NULL DEFAULT '0';