[Web-erp-svn] SF.net SVN: web-erp:[7071] trunk

[<dai...@us...>]

Revision: 7071
          http://sourceforge.net/p/web-erp/reponame/7071
Author:   daintree
Date:     2015-01-07 06:50:58 +0000 (Wed, 07 Jan 2015)
Log Message:
-----------
Added missing SQL for suppliercontacts and supplierdiscounts and adding the script SalesTopCustomersInquiry to the scripts table

Modified Paths:
--------------
    trunk/doc/Change.log
    trunk/sql/mysql/upgrade4.11-4.12.sql

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2015-01-06 16:33:52 UTC (rev 7070)
+++ trunk/doc/Change.log	2015-01-07 06:50:58 UTC (rev 7071)
@@ -1,10 +1,11 @@
 webERP Change Log
 
+7/1/15 Phil: Added missing SQL for suppliercontacts and supplierdiscounts and adding the script SalesTopCustomersInquiry to the scripts table
 05/01/15 RChacon: Allow turn on/off the dashboard display after login for an specific user. Add comments to code.
 04/01/15 RChacon: In RevisionTranslations.php, add $Id, $ViewTopic, $BookMark and page_title_text. Add info to manual. Add comments to code.
 04/01/15 RChacon: In SystemParameters.php, remove root path to config.php and add comments.
 01/01/15 RChacon: Move default theme from session.inc to config.php. Add the ability to change the default theme in SystemParameters.php.
-01/01/15 Exson: Make StockCategories.php strict sql mode compatible. 
+01/01/15 Exson: Make StockCategories.php strict sql mode compatible.
 28/12/14 RChacon: Standardise labels and texts in Prices_Customer.php SpecialOrder.php and WWW_Access.php. Add $ViewTopic and $BookMark to  WWW_Access.php
 28/12/14 RChacon: Add comments, variables to link to the manual and titles in Z_CurrencyDebtorsBalances.php and Z_CurrencySuppliersBalances.php.
 28/12/14 RChacon: Add comments, variables to link to the manual and titles in Z_Change*.php.

Modified: trunk/sql/mysql/upgrade4.11-4.12.sql
===================================================================
--- trunk/sql/mysql/upgrade4.11-4.12.sql	2015-01-06 16:33:52 UTC (rev 7070)
+++ trunk/sql/mysql/upgrade4.11-4.12.sql	2015-01-07 06:50:58 UTC (rev 7071)
@@ -136,11 +136,11 @@
 ALTER TABLE `stockdescriptiontranslations` ADD `longdescriptiontranslation` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Item''s long description';
 -- Add a field to mark if a description needs revision:
 ALTER TABLE `stockdescriptiontranslations` ADD `needsrevision` TINYINT(1) NOT NULL DEFAULT '0';
--- 
+--
 INSERT INTO `config` (`confname` ,`confvalue`) VALUES ('GoogleTranslatorAPIKey',  '');
 -- Assign a Page Security value to each translation script:
-INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES 
-	('AutomaticTranslationDescriptions.php', '15', 'Translates via Google Translator all empty translated descriptions'), 
+INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES
+	('AutomaticTranslationDescriptions.php', '15', 'Translates via Google Translator all empty translated descriptions'),
 	('RevisionTranslations.php', '15', 'Human revision for automatic descriptions translations');
 
 --
@@ -166,4 +166,21 @@
   KEY `stockid` (`stockid`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
 
+
+CREATE TABLE IF NOT EXISTS `suppliercontacts` (
+  `supplierid` varchar(10) NOT NULL DEFAULT '',
+  `contact` varchar(30) NOT NULL DEFAULT '',
+  `position` varchar(30) NOT NULL DEFAULT '',
+  `tel` varchar(30) NOT NULL DEFAULT '',
+  `fax` varchar(30) NOT NULL DEFAULT '',
+  `mobile` varchar(30) NOT NULL DEFAULT '',
+  `email` varchar(55) NOT NULL DEFAULT '',
+  `ordercontact` tinyint(1) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`supplierid`,`contact`),
+  KEY `Contact` (`contact`),
+  KEY `SupplierID` (`supplierid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+ALTER TABLE `suppliercontacts`
+  ADD CONSTRAINT `suppliercontacts_ibfk_1` FOREIGN KEY (`supplierid`) REFERENCES `suppliers` (`supplierid`);
 UPDATE config SET confvalue='4.12' WHERE confname='VersionNumber';