X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=041bced2cd601abdc0ff1dd95cca7cad6122d65b;hb=1d8bbcbf6bf6c663d83283be329758a936f863fa;hp=4ebea90fafbe2633595c7ec391cfc0a0ea79eb05;hpb=39150665d5955716247c6c6e06adbcc2cad037a9;p=fa-stable.git diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 4ebea90f..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); -- --------------------------------------------------------