X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=d8396b07b9972ad1dff90ca329b8fae0bb2641d9;hb=deed05a36c33ecad4dd8528b84c13490bbc042de;hp=1be4f088674e419694924e984b260876adc85b04;hpb=201980c921618256ee14c7bad253ade76d842487;p=fa-stable.git diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 1be4f088..d8396b07 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1037,6 +1037,7 @@ CREATE TABLE `0_quick_entries` ( `description` varchar(60) NOT NULL, `base_amount` double NOT NULL default '0', `base_desc` varchar(60) default NULL, + `bal_type` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `description` (`description`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; @@ -1044,9 +1045,9 @@ CREATE TABLE `0_quick_entries` ( ### Data of table `0_quick_entries` ### -INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount'); -INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount'); -INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount'); +INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount', '0'); +INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount'. '0'); +INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount', '0'); ### Structure of table `0_quick_entry_lines` ###