Changeset 800 for trunk/Application
- Timestamp:
- Feb 22, 2016, 11:17:22 PM (9 years ago)
- Location:
- trunk/Application
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Application/UpdateTrace.php
r792 r800 1820 1820 $Manager->Execute('UPDATE `Contract` SET `BillCode`='.$CodeId.' WHERE `Id`='.$DbRow['Id']); 1821 1821 } 1822 //$Manager->Execute('ALTER TABLE `Contract` DROP `BillCodeText`;'); 1822 $Manager->Execute('ALTER TABLE `Contract` DROP `BillCodeText`;'); 1823 $Manager->Execute('ALTER TABLE `StockSerialNumber` DROP `Info`;'); 1824 } 1825 1826 function UpdateTo800($Manager) 1827 { 1828 $Manager->Execute('CREATE TABLE IF NOT EXISTS `StockItemHistory` ( 1829 `Id` int(11) NOT NULL, 1830 `StockSerialNumber` int(11) NOT NULL, 1831 `Time` datetime NOT NULL, 1832 `Text` varchar(255) NOT NULL, 1833 PRIMARY KEY (`Id`), 1834 KEY `StockSerialNumber` (`StockSerialNumber`) 1835 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;'); 1836 $Manager->Execute('ALTER TABLE `StockItemHistory` ADD FOREIGN KEY (`StockSerialNumber`) '. 1837 'REFERENCES `StockSerialNumber`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;'); 1838 $Manager->Execute('INSERT INTO `StockItemHistory` (SELECT NULL AS `Id`, `Id` AS `StockSerialNumber`, '. 1839 '"" AS `Time`, `Info` AS `Text` FROM `StockSerialNumber`)'); 1823 1840 } 1824 1841 … … 1906 1923 785 => array('Revision' => 786, 'Function' => 'UpdateTo786'), 1907 1924 786 => array('Revision' => 792, 'Function' => 'UpdateTo792'), 1925 792 => array('Revision' => 800, 'Function' => 'UpdateTo800'), 1908 1926 )); 1909 1927 } -
trunk/Application/Version.php
r799 r800 1 1 <?php 2 2 3 $Revision = 799; // Subversion revision4 $DatabaseRevision = 792; // SQL structure revision5 $ReleaseTime = strtotime('2016-02- 10');3 $Revision = 800; // Subversion revision 4 $DatabaseRevision = 800; // SQL structure revision 5 $ReleaseTime = strtotime('2016-02-22');
Note:
See TracChangeset
for help on using the changeset viewer.