X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-demo.sql;h=afe2b67e049315ffffcd7766517f866456cf915a;hb=884c36eec7dbaae89e1f5532cc2c2f8033b010fd;hp=a80a7b7e85615b08d69e3eb9f4be68a05dd4d3f8;hpb=1f1b3af2918107e75c39aad5667321ba80d46249;p=fa-stable.git diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index a80a7b7e..afe2b67e 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -651,8 +651,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=4 ; -- @@ -1205,7 +1205,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); -- --------------------------------------------------------