X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter.sql;h=ab30ca4f8b3bd41a7fd569eccf13f412729be4c3;hb=fed6bc04a7b050a0b69136a332e92ee651812487;hp=c6a3dfcddb578deb64f195a9ee93add9e807f173;hpb=921b0e7df6265ed280080b7810105fa4d93d9aa6;p=fa-stable.git diff --git a/sql/alter.sql b/sql/alter.sql index c6a3dfcd..ab30ca4f 100644 --- a/sql/alter.sql +++ b/sql/alter.sql @@ -16,8 +16,8 @@ -- ALTER TABLE -- +ALTER TABLE `0_company` ADD `base_sales` INT( 11 ) DEFAULT '-1' NOT NULL AFTER `no_supplier_list` ; ALTER TABLE `0_sales_types` ADD `factor` DOUBLE DEFAULT '1' NOT NULL AFTER `tax_included` ; -ALTER TABLE `0_sales_types` ADD `base` TINYINT(1) DEFAULT '0' NOT NULL AFTER `factor` ; DROP TABLE IF EXISTS `0_item_units`; CREATE TABLE IF NOT EXISTS `0_item_units` (