X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=041bced2cd601abdc0ff1dd95cca7cad6122d65b;hb=70c2dbcf463a5d500d15b8510c7f45e527a7fa53;hp=078442bcdb3b0d8fad0a78b9029299dff24a7d12;hpb=b9185a0190595e671a9750eb4e9f8e0bd6c713f9;p=fa-stable.git diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 078442bc..041bced2 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -613,8 +613,8 @@ CREATE TABLE IF NOT EXISTS `0_debtors_master` ( `notes` tinytext NOT NULL, `inactive` tinyint(1) NOT NULL default '0', PRIMARY KEY (`debtor_no`), - UNIQUE KEY `name` (`name`), - KEY `debtor_ref` (`debtor_ref`) + KEY `name` (`name`), + UNIQUE KEY `debtor_ref` (`debtor_ref`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- @@ -1045,7 +1045,7 @@ CREATE TABLE IF NOT EXISTS `0_payment_terms` ( INSERT INTO `0_payment_terms` VALUES(1, 'Due 15th Of the Following Month', 0, 17, 0); INSERT INTO `0_payment_terms` VALUES(2, 'Due By End Of The Following Month', 0, 30, 0); INSERT INTO `0_payment_terms` VALUES(3, 'Payment due within 10 days', 10, 0, 0); -INSERT INTO `0_payment_terms` VALUES(4, 'Cash Only', 1, 0, 0); +INSERT INTO `0_payment_terms` VALUES(4, 'Cash Only', 0, 0, 0); -- -------------------------------------------------------- @@ -1822,7 +1822,7 @@ INSERT INTO `0_sys_prefs` VALUES('default_adj_act', 'glsetup.items', 'varchar', INSERT INTO `0_sys_prefs` VALUES('default_inv_sales_act', 'glsetup.items', 'varchar', 15, '4010'); INSERT INTO `0_sys_prefs` VALUES('default_assembly_act', 'glsetup.items', 'varchar', 15, '1530'); INSERT INTO `0_sys_prefs` VALUES('default_workorder_required', 'glsetup.manuf', 'int', 11, '20'); -INSERT INTO `0_sys_prefs` VALUES('version_id', 'system', 'varchar', 11, '2.3'); +INSERT INTO `0_sys_prefs` VALUES('version_id', 'system', 'varchar', 11, '2.3rc'); INSERT INTO `0_sys_prefs` VALUES('auto_curr_reval', 'setup.company', 'smallint', 6, '1'); -- --------------------------------------------------------