[Web-erp-svn] SF.net SVN: web-erp:[4825] trunk/sql/mysql/upgrade4.06-4.07.sql

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

Revision: 4825
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4825&view=rev
Author:   daintree
Date:     2012-01-20 23:11:00 +0000 (Fri, 20 Jan 2012)
Log Message:
-----------


Added Paths:
-----------
    trunk/sql/mysql/upgrade4.06-4.07.sql

Added: trunk/sql/mysql/upgrade4.06-4.07.sql
===================================================================
--- trunk/sql/mysql/upgrade4.06-4.07.sql	                        (rev 0)
+++ trunk/sql/mysql/upgrade4.06-4.07.sql	2012-01-20 23:11:00 UTC (rev 4825)
@@ -0,0 +1,36 @@
+CREATE TABLE `tenders` (
+  `tenderid` int(11) NOT NULL DEFAULT '0',
+  `location` varchar(5) NOT NULL DEFAULT '',
+  `address1` varchar(40) NOT NULL DEFAULT '',
+  `address2` varchar(40) NOT NULL DEFAULT '',
+  `address3` varchar(40) NOT NULL DEFAULT '',
+  `address4` varchar(40) NOT NULL DEFAULT '',
+  `address5` varchar(20) NOT NULL DEFAULT '',
+  `address6` varchar(15) NOT NULL DEFAULT '',
+  `telephone` varchar(25) NOT NULL DEFAULT '',
+  `closed` int(2) NOT NULL DEFAULT '0',
+  `requiredbydate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  PRIMARY KEY (`tenderid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `tenderitems` (
+  `tenderid` int(11) NOT NULL DEFAULT '0',
+  `stockid` varchar(20) NOT NULL DEFAULT '',
+  `quantity` varchar(40) NOT NULL DEFAULT '',
+  `units` varchar(20) NOT NULL DEFAULT 'each',
+  PRIMARY KEY (`tenderid`,`stockid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `tendersuppliers` (
+  `tenderid` int(11) NOT NULL DEFAULT '0',
+  `supplierid` varchar(10) NOT NULL DEFAULT '',
+  `email` varchar(40) NOT NULL DEFAULT '',
+  `responded` int(2) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`tenderid`,`supplierid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+INSERT INTO `scripts` (`script` ,`pagesecurity` ,`description`) VALUES ('SupplierTenderCreate.php', '4', 'Create or Edit tenders');
+ALTER TABLE `www_users` ADD `cancreatetender` tinyint(1) NOT NULL DEFAULT 0 AFTER `fullaccess`;
+INSERT INTO `systypes` (`typeid`, `typename`, `typeno`) VALUES (37, 'Tenders', 0);
+
+UPDATE config SET confvalue='4.07.0' WHERE confname='VersionNumber';
\ No newline at end of file

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.