X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.1.sql;h=80f7de1975916a0afa6796714f89e1d726b5968e;hb=12e17bf9bcf8e8f56d72aeeb6dde817d1d921615;hp=d29d00c076fe794b1c7ca413a81a187a17c2dc9c;hpb=c67f9fd41437917b5032c0396ab42704d0870064;p=fa-stable.git diff --git a/sql/alter2.1.sql b/sql/alter2.1.sql index d29d00c0..80f7de19 100644 --- a/sql/alter2.1.sql +++ b/sql/alter2.1.sql @@ -187,6 +187,12 @@ CREATE TABLE `0_item_codes` ( ALTER TABLE `0_company` DROP COLUMN `foreign_codes`; ALTER TABLE `0_company` ADD `foreign_codes` TINYINT(1) NOT NULL DEFAULT '0'; +ALTER TABLE `0_company` DROP COLUMN `accumulate_shipping`; +ALTER TABLE `0_company` ADD `accumulate_shipping` TINYINT(1) NOT NULL DEFAULT '0'; + +ALTER TABLE `0_company` DROP COLUMN `legal_text`; +ALTER TABLE `0_company` ADD `legal_text` tinytext NOT NULL DEFAULT ''; + ALTER TABLE `0_suppliers` DROP COLUMN `supp_address`; ALTER TABLE `0_suppliers` ADD `supp_address` tinytext NOT NULL DEFAULT '' AFTER `address`;