X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.2.sql;h=1327bd688b2673b49f05c6c0359b0edda48aaaaa;hb=f58466eea31b624deacaf5e5cd4b9de7995e0373;hp=ff6a0ad1b4717719b2c02fe2e900d2c78bffc5cf;hpb=d3e645c7d68242c2d081760d84b6c7820604be2f;p=fa-stable.git

diff --git a/sql/alter2.2.sql b/sql/alter2.2.sql
index ff6a0ad1..1327bd68 100644
--- a/sql/alter2.2.sql
+++ b/sql/alter2.2.sql
@@ -10,6 +10,8 @@ ALTER TABLE `0_company` ADD COLUMN `version_id` VARCHAR(11) NOT NULL DEFAULT '';
 ALTER TABLE `0_company` DROP COLUMN `purch_exchange_diff_act`;
 ALTER TABLE `0_company` ADD COLUMN`profit_loss_year_act` VARCHAR(11) NOT NULL DEFAULT '' AFTER `exchange_diff_act`;
 ALTER TABLE `0_company` ADD COLUMN `time_zone` TINYINT(1) NOT NULL DEFAULT '0';
+ALTER TABLE `0_company` ADD COLUMN `add_pct` INT(5) NOT NULL DEFAULT '-1';
+ALTER TABLE `0_company` ADD COLUMN `round_to` INT(5) NOT NULL DEFAULT '1';
 ALTER TABLE `0_company` CHANGE `grn_act` `bank_charge_act` VARCHAR(11) NOT NULL DEFAULT '';
 #INSERT INTO `0_chart_master` VALUES ('9990', '', 'Profit and Loss this year', '52', '0');
 UPDATE `0_company` SET `profit_loss_year_act`='9990', `version_id`='2.2' WHERE `coy_code`=1; 
@@ -36,6 +38,7 @@ ALTER TABLE `0_users` ADD COLUMN `sticky_doc_date` TINYINT(1) DEFAULT '0';
 ALTER TABLE `0_debtors_master` MODIFY COLUMN `name` varchar(100) NOT NULL default '';
 ALTER TABLE `0_cust_branch` ADD COLUMN `inactive` tinyint(1) NOT NULL default '0';
 
+ALTER TABLE `0_sys_types` DROP COLUMN `type_name`;
 ALTER TABLE `0_chart_class` DROP COLUMN `sign_convert`;
 ALTER TABLE `0_chart_class` CHANGE `balance_sheet` `ctype` TINYINT(1) NOT NULL DEFAULT '0';