Menu
▾
▴
web-erp-svn
|
From: <ex...@us...> - 2015-09-23 13:53:28
|
Revision: 7359
http://sourceforge.net/p/web-erp/reponame/7359
Author: exsonqu
Date: 2015-09-23 13:53:26 +0000 (Wed, 23 Sep 2015)
Log Message:
-----------
23/09/2015 Tim: ADD invoice to grns mapping data in SupplierInvoice.php.
Modified Paths:
--------------
trunk/sql/mysql/upgrade4.12.3-4.13.sql
Modified: trunk/sql/mysql/upgrade4.12.3-4.13.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.3-4.13.sql 2015-09-23 13:53:01 UTC (rev 7358)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql 2015-09-23 13:53:26 UTC (rev 7359)
@@ -12,6 +12,16 @@
('AnalysisHorizontalIncome.php', '8', 'Shows the horizontal analysis of the statement of comprehensive income'),
('AnalysisHorizontalPosition.php', '8', 'Shows the horizontal analysis of the statement of financial position');
+CREATE TABLE `suppinvstogrn` (
+ `suppinv` int(11) NOT NULL,
+ `grnno` int(11) NOT NULL,
+ PRIMARY KEY (`suppinv`,`grnno`),
+ KEY `suppinvstogrn_ibfk_2` (`grnno`),
+ CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN KEY (`suppinv`) REFERENCES
+`supptrans` (`id`),
+ CONSTRAINT `suppinvstogrn_ibfk_2` FOREIGN KEY (`grnno`) REFERENCES
+`grns` (`grnno`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Update version number:
UPDATE config SET confvalue='4.13' WHERE confname='VersionNumber';
|
|
From: <ex...@us...> - 2015-10-06 12:36:59
|
Revision: 7366
http://sourceforge.net/p/web-erp/reponame/7366
Author: exsonqu
Date: 2015-10-06 12:36:57 +0000 (Tue, 06 Oct 2015)
Log Message:
-----------
06/10/15 UK-Steven: Contribute email customer statements feature scripts.
Modified Paths:
--------------
trunk/sql/mysql/upgrade4.12.3-4.13.sql
Modified: trunk/sql/mysql/upgrade4.12.3-4.13.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.3-4.13.sql 2015-10-06 12:36:27 UTC (rev 7365)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql 2015-10-06 12:36:57 UTC (rev 7366)
@@ -22,6 +22,6 @@
CONSTRAINT `suppinvstogrn_ibfk_2` FOREIGN KEY (`grnno`) REFERENCES
`grns` (`grnno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
+INSERT INTO scripts VALUES('EmailCustStatements.php','3','Email customer statement to customer');
-- Update version number:
UPDATE config SET confvalue='4.13' WHERE confname='VersionNumber';
|
|
From: <ex...@us...> - 2015-11-30 22:51:06
|
Revision: 7404
http://sourceforge.net/p/web-erp/reponame/7404
Author: exsonqu
Date: 2015-11-30 22:51:04 +0000 (Mon, 30 Nov 2015)
Log Message:
-----------
01/12/15 Exson: Remove the wrong foreign key in suppinvstogrn. Reported by rafael.
Modified Paths:
--------------
trunk/sql/mysql/upgrade4.12.3-4.13.sql
Modified: trunk/sql/mysql/upgrade4.12.3-4.13.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.3-4.13.sql 2015-11-30 01:26:16 UTC (rev 7403)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql 2015-11-30 22:51:04 UTC (rev 7404)
@@ -52,6 +52,7 @@
ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_4`;
INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES ('UserBankAccounts.php', '15', 'Maintains table bankaccountusers (Authorized users to work with a bank account in webERP)');
+ALTER table suppinvstogrn DROP FOREIGN KEY `suppinvstogrn_ibfk_1`;
-- Update version number:
UPDATE config SET confvalue='4.13' WHERE confname='VersionNumber';
|
|
From: <rc...@us...> - 2015-12-01 15:08:48
|
Revision: 7406
http://sourceforge.net/p/web-erp/reponame/7406
Author: rchacon
Date: 2015-12-01 15:08:45 +0000 (Tue, 01 Dec 2015)
Log Message:
-----------
Minor changes: regroup MySql commands.
Modified Paths:
--------------
trunk/sql/mysql/upgrade4.12.3-4.13.sql
Modified: trunk/sql/mysql/upgrade4.12.3-4.13.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.3-4.13.sql 2015-11-30 22:52:00 UTC (rev 7405)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql 2015-12-01 15:08:45 UTC (rev 7406)
@@ -1,4 +1,4 @@
-CREATE TABLE `loctransfercancellations` (
+CREATE TABLE IF NOT EXISTS `loctransfercancellations` (
`reference` INT(11) NOT NULL ,
`stockid` VARCHAR(20) NOT NULL ,
`cancelqty` DOUBLE NOT NULL ,
@@ -10,20 +10,21 @@
-- Add new scripts:
INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES
('AnalysisHorizontalIncome.php', '8', 'Shows the horizontal analysis of the statement of comprehensive income'),
- ('AnalysisHorizontalPosition.php', '8', 'Shows the horizontal analysis of the statement of financial position');
+ ('AnalysisHorizontalPosition.php', '8', 'Shows the horizontal analysis of the statement of financial position'),
+ ('EmailCustStatements.php','3','Email customer statement to customer'),
+ ('GLAccountUsers.php', '15', 'Maintenance of users allowed to a GL Account'),
+ ('SupplierGRNAndInvoiceInquiry.php',5,'Supplier\'s delivery note and grn relationship inquiry'),
+ ('UserBankAccounts.php', '15', 'Maintains table bankaccountusers (Authorized users to work with a bank account in webERP)')
+ ('UserGLAccounts.php', '15', 'Maintenance of GL Accounts allowed for a user');
-CREATE TABLE `suppinvstogrn` (
- `suppinv` int(11) NOT NULL,
- `grnno` int(11) NOT NULL,
+CREATE TABLE IF NOT EXISTS `suppinvstogrn` (
+ `suppinv` int(11) NOT NULL,
+ `grnno` int(11) NOT NULL,
PRIMARY KEY (`suppinv`,`grnno`),
- KEY `suppinvstogrn_ibfk_2` (`grnno`),
- CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN KEY (`suppinv`) REFERENCES
-`supptrans` (`id`),
- CONSTRAINT `suppinvstogrn_ibfk_2` FOREIGN KEY (`grnno`) REFERENCES
-`grns` (`grnno`)
+ KEY `suppinvstogrn_ibfk_1` (`grnno`),
+ CONSTRAINT `suppinvstogrn_ibfk_1` FOREIGN KEY (`grnno`) REFERENCES `grns` (`grnno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-INSERT INTO scripts VALUES('EmailCustStatements.php','3','Email customer statement to customer');
-INSERT INTO scripts VALUES('SupplierGRNAndInvoiceInquiry.php',5,'Supplier\'s delivery note and grn relationship inquiry');
+
ALTER table grns ADD supplierref varchar(30) NOT NULL DEFAULT '';
CREATE TABLE IF NOT EXISTS `glaccountusers` (
@@ -45,14 +46,9 @@
AND chartmaster.accountcode = glaccountusers.accountcode
WHERE glaccountusers.userid IS NULL;
-INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES
-('GLAccountUsers.php', '15', 'Maintenance of users allowed to a GL Account'),
-('UserGLAccounts.php', '15', 'Maintenance of GL Accounts allowed for a user');
ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_3`;
ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_4`;
-INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES ('UserBankAccounts.php', '15', 'Maintains table bankaccountusers (Authorized users to work with a bank account in webERP)');
-ALTER table suppinvstogrn DROP FOREIGN KEY `suppinvstogrn_ibfk_1`;
-- Update version number:
UPDATE config SET confvalue='4.13' WHERE confname='VersionNumber';
|
|
From: <ex...@us...> - 2016-02-20 08:00:34
|
Revision: 7460
http://sourceforge.net/p/web-erp/reponame/7460
Author: exsonqu
Date: 2016-02-20 08:00:32 +0000 (Sat, 20 Feb 2016)
Log Message:
-----------
20/02/16 Janb,Tim Fixed typo in the upgrade4.12.3-4.13.sql.
Modified Paths:
--------------
trunk/sql/mysql/upgrade4.12.3-4.13.sql
Modified: trunk/sql/mysql/upgrade4.12.3-4.13.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.3-4.13.sql 2016-02-19 10:43:20 UTC (rev 7459)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql 2016-02-20 08:00:32 UTC (rev 7460)
@@ -14,7 +14,7 @@
('EmailCustStatements.php','3','Email customer statement to customer'),
('GLAccountUsers.php', '15', 'Maintenance of users allowed to a GL Account'),
('SupplierGRNAndInvoiceInquiry.php',5,'Supplier\'s delivery note and grn relationship inquiry'),
- ('UserBankAccounts.php', '15', 'Maintains table bankaccountusers (Authorized users to work with a bank account in webERP)')
+ ('UserBankAccounts.php', '15', 'Maintains table bankaccountusers (Authorized users to work with a bank account in webERP)'),
('UserGLAccounts.php', '15', 'Maintenance of GL Accounts allowed for a user');
CREATE TABLE IF NOT EXISTS `suppinvstogrn` (
@@ -49,7 +49,7 @@
ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_3`;
ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_4`;
INSERT INTO scripts VALUES('CollectiveWorkOrderCost.php',2,'Multiple work orders cost review');
-ALTER table BOM ADD remark varchar(500) NOT NULL DEFAULT '';
+ALTER table bom ADD remark varchar(500) NOT NULL DEFAULT '';
INSERT INTO scripts VALUES ('SuppWhereAlloc.php',3,'Suppliers Where allocated');
|
|
From: <ex...@us...> - 2016-04-07 06:41:00
|
Revision: 7486
http://sourceforge.net/p/web-erp/reponame/7486
Author: exsonqu
Date: 2016-04-07 06:40:58 +0000 (Thu, 07 Apr 2016)
Log Message:
-----------
07/04/16 Exson: add sql of multiple assigner and authority of Pc module.
Modified Paths:
--------------
trunk/sql/mysql/upgrade4.12.3-4.13.sql
Modified: trunk/sql/mysql/upgrade4.12.3-4.13.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.3-4.13.sql 2016-04-07 06:35:44 UTC (rev 7485)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql 2016-04-07 06:40:58 UTC (rev 7486)
@@ -51,7 +51,9 @@
INSERT INTO scripts VALUES('CollectiveWorkOrderCost.php',2,'Multiple work orders cost review');
ALTER table bom ADD remark varchar(500) NOT NULL DEFAULT '';
INSERT INTO scripts VALUES ('SuppWhereAlloc.php',3,'Suppliers Where allocated');
+ALTER table pctabs DROP FOREIGN KEY `pctabs_ibfk_4`;
+ALTER table pctabs CHANGE authorizer authorizer varchar(100);
+ALTER table pctabs CHANGE assigner assigner varchar(100);
-
-- Update version number:
UPDATE config SET confvalue='4.13' WHERE confname='VersionNumber';
|
|
From: <ex...@us...> - 2016-05-16 01:36:43
|
Revision: 7529
http://sourceforge.net/p/web-erp/reponame/7529
Author: exsonqu
Date: 2016-05-16 01:36:41 +0000 (Mon, 16 May 2016)
Log Message:
-----------
16/05/16 Exson: removed sql which script is not ready.
Modified Paths:
--------------
trunk/sql/mysql/upgrade4.12.3-4.13.sql
Modified: trunk/sql/mysql/upgrade4.12.3-4.13.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.3-4.13.sql 2016-05-16 00:29:16 UTC (rev 7528)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql 2016-05-16 01:36:41 UTC (rev 7529)
@@ -56,24 +56,6 @@
ALTER table pctabs CHANGE assigner assigner varchar(100);
INSERT INTO securitytokens VALUES(18,'Cost authority');
ALTER table BOM ADD digitals int(11) NOT NULL DEFAULT 0;
-INSERT INTO scripts VALUES('StockIntransitStatus.php',1,'Inventory transaction status');
-INSERT INTO scripts VALUES ('StockTransferControlledDispatched.php',11,'Inventory controlled input');
-ALTER table loctransfers ADD closed tinyint(1) not null default '0';
-CREATE table trfserialno (trfno int(11) NOT NULL AUTO_INCREMENT,
- trfref int(11) NOT NUll DEFAULT '0',
- stkcode varchar(20) NOT NULL DEFAULT '0',
- serialno varchar(20) NOT NULL DEFAULT '0',
- trfqty double NOT NULL DEFAULT '0',
- loccode varchar(5) NOT NULL DEFAULT '',
- recqty double NOT NULL DEFAULT '0',
- PRIMARY KEY (`trfno`),
- KEY (`trfref`),
- KEY (`stkcode`,`serialno`),
- KEY (`serialno`),
- KEY (`stkcode`),
- KEY (`stkcode`,`serialno`,`loccode`),
- CONSTRAINT FOREIGN KEY (`trfref`) REFERENCES `loctransfers`(`reference`),
- CONSTRAINT FOREIGN KEY (`stkcode`,`serialno`,`loccode`) REFERENCES `stockserialitems`(`stockid`,`serialno`,`loccode`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- Update version number:
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X