projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fixed error creating customer credit note: Undefined index: sales_gl_code. @notrinos.
[fa-stable.git]
/
sql
/
alter2.1.sql
diff --git
a/sql/alter2.1.sql
b/sql/alter2.1.sql
index d1cc580715c82324a807e7c961563c03eefbf813..c162462bfae8a5e3020add1144a2ef39688188ff 100644
(file)
--- a/
sql/alter2.1.sql
+++ b/
sql/alter2.1.sql
@@
-68,6
+68,7
@@
ALTER TABLE `0_bank_accounts` ADD `id` SMALLINT(6) AUTO_INCREMENT PRIMARY KEY;
ALTER TABLE `0_bank_accounts` ADD `last_reconciled_date` timestamp NOT NULL default '0000-00-00';
ALTER TABLE `0_bank_accounts` ADD `ending_reconcile_balance` double NOT NULL default '0';
ALTER TABLE `0_bank_accounts` ADD `last_reconciled_date` timestamp NOT NULL default '0000-00-00';
ALTER TABLE `0_bank_accounts` ADD `ending_reconcile_balance` double NOT NULL default '0';
+ALTER TABLE `0_bank_trans` DROP COLUMN `bank_trans_type_id`;
ALTER TABLE `0_bank_trans` ADD `reconciled` date default NULL;
ALTER TABLE `0_users` ADD `query_size` TINYINT(1) DEFAULT '10';
ALTER TABLE `0_bank_trans` ADD `reconciled` date default NULL;
ALTER TABLE `0_users` ADD `query_size` TINYINT(1) DEFAULT '10';
@@
-88,7
+89,8
@@
CREATE TABLE `0_sales_pos` (
UNIQUE KEY(`pos_name`)
) TYPE=MyISAM AUTO_INCREMENT=1;
UNIQUE KEY(`pos_name`)
) TYPE=MyISAM AUTO_INCREMENT=1;
-INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '1', '0');
+# After upgrade default POS cash sale is off. Change in POS setup if you wish.
+INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '0', '1', 'DEF', '1', '0');
ALTER TABLE `0_users` ADD `pos` SMALLINT(6) DEFAULT '1';
ALTER TABLE `0_users` ADD `pos` SMALLINT(6) DEFAULT '1';