Changeset 967 for trunk/Application
- Timestamp:
- Mar 6, 2024, 11:47:49 PM (8 months ago)
- Location:
- trunk/Application
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Application/UpdateTrace.php
r957 r967 619 619 $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD `Contract` INT NULL , 620 620 ADD INDEX ( `Contract` ) ;'); 621 $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD FOREIGN KEY ( `Contract` ) REFERENCES `Contract` (621 $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD FOREIGN KEY ( `Contract` ) REFERENCES `Contract` ( 622 622 `Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;'); 623 623 $Manager->Execute("INSERT INTO `Action` ( … … 2242 2242 { 2243 2243 $Manager->Execute('ALTER TABLE `Log` ADD `URL` VARCHAR(255) NOT NULL AFTER `IPAddress`;'); 2244 } 2245 2246 function UpdateTo967(UpdateManager $Manager): void 2247 { 2248 $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Roční výkazy"'); 2249 if ($DbResult->num_rows > 0) 2250 { 2251 $DbRow = $DbResult->fetch_assoc(); 2252 2253 $Manager->Execute("INSERT INTO `Action` ( 2254 `Id` ,`Name` ,`Title` ,`Type` ,`URL` ,`Group` ,`Icon` ,`PermissionOperation` , 2255 `Enable`) VALUES (NULL , '', 'Měsíční přehled', '1', '/is/?t=FinanceMonthReport&a=list', NULL , NULL , NULL , '1' 2256 );"); 2257 $ActionId = $Manager->Database->insert_id; 2258 $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ". 2259 "VALUES (NULL , 'Měsíční přehled', '".$DbRow['Id']."', '".$ActionId."', '1');"); 2260 } 2244 2261 } 2245 2262 … … 2357 2374 948 => array('Revision' => 953, 'Function' => 'UpdateTo953'), 2358 2375 953 => array('Revision' => 957, 'Function' => 'UpdateTo957'), 2376 957 => array('Revision' => 967, 'Function' => 'UpdateTo967'), 2359 2377 ); 2360 2378 } -
trunk/Application/Version.php
r964 r967 1 1 <?php 2 2 3 $Revision = 96 4; // Subversion revision4 $DatabaseRevision = 9 57; // SQL structure revision5 $ReleaseTime = strtotime('2024-0 2-03');3 $Revision = 967; // Subversion revision 4 $DatabaseRevision = 967; // SQL structure revision 5 $ReleaseTime = strtotime('2024-03-06');
Note:
See TracChangeset
for help on using the changeset viewer.