Changeset 887 for trunk/Application/UpdateTrace.php
- Timestamp:
- Nov 20, 2020, 12:08:12 AM (4 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Application/UpdateTrace.php
r885 r887 1 1 <?php 2 2 3 function UpdateTo493( $Manager)3 function UpdateTo493(UpdateManager $Manager): void 4 4 { 5 5 $Manager->Execute("ALTER TABLE `UserOnline` CHANGE `User` `User` INT( 11 ) NULL DEFAULT NULL COMMENT 'User.Id'"); 6 6 } 7 7 8 function UpdateTo494( $Manager)8 function UpdateTo494(UpdateManager $Manager): void 9 9 { 10 10 $Manager->Execute("ALTER TABLE `FinanceOperation` DROP FOREIGN KEY `FinanceOperation_ibfk_2` ;\n". … … 13 13 } 14 14 15 function UpdateTo495( $Manager)15 function UpdateTo495(UpdateManager $Manager): void 16 16 { 17 17 $Manager->Execute("INSERT INTO `MapPosition` (SELECT NULL AS `Id`, `Name`, `MapPositionX` AS `Latitude`, `MapPositionY` AS `Longitude` FROM `Subject`)"); … … 24 24 } 25 25 26 function UpdateTo497( $Manager)26 function UpdateTo497(UpdateManager $Manager): void 27 27 { 28 28 $Manager->Execute("ALTER TABLE `FinanceCharge` ADD `Id` INT NOT NULL AUTO_INCREMENT FIRST , ADD PRIMARY KEY ( `Id` ) "); … … 52 52 } 53 53 54 function UpdateTo498( $Manager)54 function UpdateTo498(UpdateManager $Manager): void 55 55 { 56 56 $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ". … … 76 76 } 77 77 78 function UpdateTo499( $Manager)78 function UpdateTo499(UpdateManager $Manager): void 79 79 { 80 80 $Manager->Execute("CREATE TABLE IF NOT EXISTS `Currency` ( … … 121 121 } 122 122 123 function UpdateTo500( $Manager)123 function UpdateTo500(UpdateManager $Manager): void 124 124 { 125 125 $Manager->Execute("CREATE TABLE IF NOT EXISTS `FinanceBank` ( … … 145 145 } 146 146 147 function UpdateTo502( $Manager)147 function UpdateTo502(UpdateManager $Manager): void 148 148 { 149 149 $Manager->Execute("ALTER TABLE `FinanceBankAccount` ADD `LoginName` VARCHAR( 255 ) NOT NULL "); … … 159 159 } 160 160 161 function UpdateTo505( $Manager)161 function UpdateTo505(UpdateManager $Manager): void 162 162 { 163 163 $Manager->Execute("UPDATE `ISMenuItem` SET `Name` = 'Služby', `Table` = 'Service' WHERE `ISMenuItem`.`Name` ='Tarify';"); … … 186 186 } 187 187 188 function UpdateTo507( $Manager)188 function UpdateTo507(UpdateManager $Manager): void 189 189 { 190 190 $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ". … … 229 229 } 230 230 231 function UpdateTo515( $Manager)231 function UpdateTo515(UpdateManager $Manager): void 232 232 { 233 233 $Manager->Execute("ALTER TABLE `PermissionUserAssignment` CHANGE `User` `User` INT( 11 ) NULL"); 234 234 } 235 235 236 function UpdateTo517( $Manager)236 function UpdateTo517(UpdateManager $Manager): void 237 237 { 238 238 $Manager->Execute("ALTER TABLE `Log` ADD `IPAddress` VARCHAR( 16 ) NOT NULL"); 239 239 } 240 240 241 function UpdateTo526( $Manager)241 function UpdateTo526(UpdateManager $Manager): void 242 242 { 243 243 $Manager->Execute("ALTER TABLE `Hyperlink` CHANGE `Name` `Title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL"); … … 276 276 } 277 277 278 function UpdateTo527( $Manager)278 function UpdateTo527(UpdateManager $Manager): void 279 279 { 280 280 $Manager->Execute("RENAME TABLE `ISMenuItem` TO `MenuItem` ;"); … … 304 304 } 305 305 306 function UpdateTo535( $Manager)306 function UpdateTo535(UpdateManager $Manager): void 307 307 { 308 308 // Set all string collation to utf8 general … … 314 314 } 315 315 316 function UpdateTo549( $Manager)316 function UpdateTo549(UpdateManager $Manager): void 317 317 { 318 318 $Manager->Execute("ALTER TABLE `FinanceOperation` ADD `Generate` INT NOT NULL DEFAULT '0', … … 322 322 } 323 323 324 function UpdateTo550( $Manager)324 function UpdateTo550(UpdateManager $Manager): void 325 325 { 326 326 $Manager->Execute('ALTER TABLE `FinanceBankAccount` ADD `LastImportId` VARCHAR( 255 ) NOT NULL ;'); … … 329 329 } 330 330 331 function UpdateTo551( $Manager)331 function UpdateTo551(UpdateManager $Manager): void 332 332 { 333 333 $Manager->Execute('ALTER TABLE `FinanceOperation` ADD `DocumentLine` INT NULL AFTER `Value` , … … 343 343 } 344 344 345 function UpdateTo565( $Manager)345 function UpdateTo565(UpdateManager $Manager): void 346 346 { 347 347 $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPage` ( … … 369 369 } 370 370 371 function UpdateTo571( $Manager)371 function UpdateTo571(UpdateManager $Manager): void 372 372 { 373 373 $Manager->Execute('ALTER TABLE `NetworkDevice` ADD `LoginName` VARCHAR( 255 ) NOT NULL , … … 375 375 } 376 376 377 function UpdateTo574( $Manager)377 function UpdateTo574(UpdateManager $Manager): void 378 378 { 379 379 $Manager->Execute('ALTER TABLE `MapPosition` ADD `Pos` VARCHAR( 255 ) NOT NULL ;'); … … 383 383 } 384 384 385 function UpdateTo584( $Manager)385 function UpdateTo584(UpdateManager $Manager): void 386 386 { 387 387 $Manager->Execute("CREATE TABLE IF NOT EXISTS `Module` ( … … 441 441 } 442 442 443 function UpdateTo591( $Manager)443 function UpdateTo591(UpdateManager $Manager): void 444 444 { 445 445 $Manager->Execute('ALTER TABLE `StockItem` ADD `Esemble` INT NULL , … … 449 449 } 450 450 451 function UpdateTo597( $Manager)451 function UpdateTo597(UpdateManager $Manager): void 452 452 { 453 453 $Manager->Execute('CREATE TABLE IF NOT EXISTS `Model` ( … … 463 463 } 464 464 465 function UpdateTo601( $Manager)465 function UpdateTo601(UpdateManager $Manager): void 466 466 { 467 467 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkInterfaceWireless` ( … … 489 489 } 490 490 491 function UpdateTo615( $Manager)491 function UpdateTo615(UpdateManager $Manager): void 492 492 { 493 493 $Manager->Execute('ALTER TABLE `NetworkInterfaceWireless` ADD `AntennaPolarity` INT NOT NULL , … … 523 523 } 524 524 525 function UpdateTo619( $Manager)525 function UpdateTo619(UpdateManager $Manager): void 526 526 { 527 527 $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLogged` INT NOT NULL ;'); 528 528 } 529 529 530 function UpdateTo620( $Manager)530 function UpdateTo620(UpdateManager $Manager): void 531 531 { 532 532 $Manager->Execute('ALTER TABLE `NetworkInterfaceWireless` ADD `ChannelWidthLower` INT NOT NULL , … … 536 536 } 537 537 538 function UpdateTo627( $Manager)538 function UpdateTo627(UpdateManager $Manager): void 539 539 { 540 540 $Manager->Execute('ALTER TABLE `FinanceInvoice` CHANGE `TimeCreation` `Time` DATETIME NOT NULL DEFAULT "0000-00-00 00:00:00";'); … … 542 542 } 543 543 544 function UpdateTo632( $Manager)544 function UpdateTo632(UpdateManager $Manager): void 545 545 { 546 546 $Manager->Execute('CREATE TABLE IF NOT EXISTS `FinanceInvoiceOperationRel` ( … … 557 557 } 558 558 559 function UpdateTo633( $Manager)559 function UpdateTo633(UpdateManager $Manager): void 560 560 { 561 561 $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;'); 562 562 } 563 563 564 function UpdateTo645( $Manager)564 function UpdateTo645(UpdateManager $Manager): void 565 565 { 566 566 $Manager->Execute('CREATE TABLE IF NOT EXISTS `FinanceVATType` ( … … 576 576 } 577 577 578 function UpdateTo646( $Manager)578 function UpdateTo646(UpdateManager $Manager): void 579 579 { 580 580 $Manager->Execute('CREATE TABLE IF NOT EXISTS `Contract` ( … … 612 612 } 613 613 614 function UpdateTo647( $Manager)614 function UpdateTo647(UpdateManager $Manager): void 615 615 { 616 616 $Manager->Execute('ALTER TABLE `EmployeeSalary` ADD FOREIGN KEY ( `Employee` ) REFERENCES `Employee` ( … … 647 647 } 648 648 649 function UpdateTo656( $Manager)649 function UpdateTo656(UpdateManager $Manager): void 650 650 { 651 651 $Manager->Execute('CREATE TABLE IF NOT EXISTS `Measure` ( … … 706 706 } 707 707 708 function UpdateTo657( $Manager)708 function UpdateTo657(UpdateManager $Manager): void 709 709 { 710 710 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkInterfaceUpDown` ( … … 727 727 } 728 728 729 function UpdateTo661( $Manager)729 function UpdateTo661(UpdateManager $Manager): void 730 730 { 731 731 $Manager->Execute('CREATE TABLE IF NOT EXISTS `Contact` ( … … 773 773 } 774 774 775 function UpdateTo662( $Manager)775 function UpdateTo662(UpdateManager $Manager): void 776 776 { 777 777 $Manager->Execute('INSERT INTO `Contact` (SELECT NULL AS `Id`, 2 AS `Category`, `ICQ` AS `Value`, NULL AS `Subject`, `Id` AS `User` FROM `User` … … 783 783 } 784 784 785 function UpdateTo668( $Manager)785 function UpdateTo668(UpdateManager $Manager): void 786 786 { 787 787 $Manager->Execute('CREATE TABLE IF NOT EXISTS `APIToken` ( … … 799 799 } 800 800 801 function UpdateTo671( $Manager)801 function UpdateTo671(UpdateManager $Manager): void 802 802 { 803 803 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkSignal` ( … … 834 834 } 835 835 836 function UpdateTo674( $Manager)836 function UpdateTo674(UpdateManager $Manager): void 837 837 { 838 838 $Manager->Execute('ALTER TABLE `NetworkSignal` ADD `RateRx` INT NOT NULL ;'); … … 840 840 } 841 841 842 function UpdateTo676( $Manager)842 function UpdateTo676(UpdateManager $Manager): void 843 843 { 844 844 $Manager->Execute('ALTER TABLE `NetworkSignal` ADD `Device` INT NULL , … … 848 848 } 849 849 850 function UpdateTo678( $Manager)850 function UpdateTo678(UpdateManager $Manager): void 851 851 { 852 852 $Manager->Execute('ALTER TABLE `Contact` ADD `Description` VARCHAR( 255 ) NOT NULL ;'); … … 879 879 } 880 880 881 function UpdateTo679( $Manager)881 function UpdateTo679(UpdateManager $Manager): void 882 882 { 883 883 $Manager->Execute('ALTER TABLE `NetworkDevice` ADD `Product` INT NOT NULL AFTER `Id` , … … 885 885 } 886 886 887 function UpdateTo688( $Manager)887 function UpdateTo688(UpdateManager $Manager): void 888 888 { 889 889 // Convert monthly plus payment for consumption to regular service … … 899 899 } 900 900 901 function UpdateTo692( $Manager)901 function UpdateTo692(UpdateManager $Manager): void 902 902 { 903 903 // Convert user emails to contacts … … 912 912 } 913 913 914 function UpdateTo696( $Manager)914 function UpdateTo696(UpdateManager $Manager): void 915 915 { 916 916 $Manager->Execute('ALTER TABLE `NetworkInterfaceUpDown` ADD `Duration` INT NOT NULL ;'); … … 920 920 } 921 921 922 function UpdateTo697( $Manager)922 function UpdateTo697(UpdateManager $Manager): void 923 923 { 924 924 $Manager->Execute('ALTER TABLE `NetworkInterfaceUpDown` CHANGE `Duration` `Duration` INT( 11 ) NULL ;'); … … 929 929 } 930 930 931 function UpdateTo707( $Manager)931 function UpdateTo707(UpdateManager $Manager): void 932 932 { 933 933 $Manager->Execute('ALTER TABLE `NetworkDevice` CHANGE `Product` `Product` INT(11) NULL;'); 934 934 } 935 935 936 function UpdateTo710( $Manager)936 function UpdateTo710(UpdateManager $Manager): void 937 937 { 938 938 $Manager->Execute('RENAME TABLE `StockItem` TO `StockSerialNumber`;'); … … 995 995 } 996 996 997 function UpdateTo715( $Manager)997 function UpdateTo715(UpdateManager $Manager): void 998 998 { 999 999 $Manager->Execute('ALTER TABLE `StockSerialNumber` DROP FOREIGN KEY `StockSerialNumber_ibfk_6`;'); … … 1005 1005 } 1006 1006 1007 function UpdateTo718( $Manager)1007 function UpdateTo718(UpdateManager $Manager): void 1008 1008 { 1009 1009 $Manager->Execute('CREATE TABLE IF NOT EXISTS `Company` ( … … 1033 1033 } 1034 1034 1035 function UpdateTo719( $Manager)1035 function UpdateTo719(UpdateManager $Manager): void 1036 1036 { 1037 1037 $Manager->Execute('ALTER TABLE `FinanceOperation` ADD `Direction` INT NOT NULL AFTER `Cash`;'); … … 1077 1077 } 1078 1078 1079 function UpdateTo720( $Manager)1079 function UpdateTo720(UpdateManager $Manager): void 1080 1080 { 1081 1081 $Manager->Execute('ALTER TABLE `FinanceInvoice` ADD `Direction` INT NOT NULL AFTER `TimePayment`;'); … … 1108 1108 } 1109 1109 1110 function UpdateTo722( $Manager)1110 function UpdateTo722(UpdateManager $Manager): void 1111 1111 { 1112 1112 $Manager->Execute('ALTER TABLE `Service` DROP `CustomerCount`;'); 1113 1113 } 1114 1114 1115 function UpdateTo725( $Manager)1115 function UpdateTo725(UpdateManager $Manager): void 1116 1116 { 1117 1117 // Text column of invoices is not used. Text from invoice items is taken instead. … … 1149 1149 } 1150 1150 1151 function UpdateTo726( $Manager)1151 function UpdateTo726(UpdateManager $Manager): void 1152 1152 { 1153 1153 $Manager->Execute('ALTER TABLE `ServiceCustomerRel` CHANGE `Action` `ChangeAction` ENUM("add","modify","remove") CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;'); … … 1172 1172 } 1173 1173 1174 function UpdateTo729( $Manager)1174 function UpdateTo729(UpdateManager $Manager): void 1175 1175 { 1176 1176 $Manager->Execute('ALTER TABLE `FinanceBankAccount` ADD `AutoImport` INT NOT NULL ;'); … … 1209 1209 } 1210 1210 1211 function UpdateTo730( $Manager)1211 function UpdateTo730(UpdateManager $Manager): void 1212 1212 { 1213 1213 $Manager->Execute('CREATE TABLE IF NOT EXISTS `SchedulerAction` ( … … 1224 1224 } 1225 1225 1226 function UpdateTo731( $Manager)1226 function UpdateTo731(UpdateManager $Manager): void 1227 1227 { 1228 1228 // NetworkDomain … … 1308 1308 } 1309 1309 1310 function UpdateTo735( $Manager)1310 function UpdateTo735(UpdateManager $Manager): void 1311 1311 { 1312 1312 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkFreeAccess` ( … … 1332 1332 } 1333 1333 1334 function UpdateTo736( $Manager)1334 function UpdateTo736(UpdateManager $Manager): void 1335 1335 { 1336 1336 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkLinkType` ( … … 1345 1345 } 1346 1346 1347 function UpdateTo739( $Manager)1347 function UpdateTo739(UpdateManager $Manager): void 1348 1348 { 1349 1349 $Manager->Execute('ALTER TABLE `NetworkDomain` ADD KEY (`Parent`);'); … … 1364 1364 } 1365 1365 1366 function UpdateTo740( $Manager)1366 function UpdateTo740(UpdateManager $Manager): void 1367 1367 { 1368 1368 $Manager->Execute('CREATE TABLE IF NOT EXISTS `FinanceInvoiceGroup` ( … … 1423 1423 } 1424 1424 1425 function UpdateTo741( $Manager)1425 function UpdateTo741(UpdateManager $Manager): void 1426 1426 { 1427 1427 // Add Direction column … … 1436 1436 } 1437 1437 1438 function UpdateTo742( $Manager)1438 function UpdateTo742(UpdateManager $Manager): void 1439 1439 { 1440 1440 $Manager->Execute('CREATE TABLE IF NOT EXISTS `DocumentLineCode` ( … … 1486 1486 } 1487 1487 1488 function UpdateTo747( $Manager)1488 function UpdateTo747(UpdateManager $Manager): void 1489 1489 { 1490 1490 $Manager->Execute('ALTER TABLE `FinanceOperation` ADD `ValueUser` FLOAT NOT NULL AFTER `Value`;'); … … 1509 1509 } 1510 1510 1511 function UpdateTo748( $Manager)1511 function UpdateTo748(UpdateManager $Manager): void 1512 1512 { 1513 1513 $DbResult = $Manager->Database->query('SELECT * FROM (SELECT `FinanceInvoice`.`Id`, ((SELECT SUM(`Price` * `Quantity`) FROM `FinanceInvoiceItem` WHERE `FinanceInvoiceItem`.`FinanceInvoice`=`FinanceInvoice`.`Id`) * `FinanceInvoiceGroup`.`ValueSign`) AS `Sum`,`FinanceInvoice`.`Value` FROM `FinanceInvoice` LEFT JOIN `FinanceInvoiceGroup` ON `FinanceInvoiceGroup`.`Id`=`FinanceInvoice`.`Group`) AS `T` WHERE `Sum` != `Value`'); … … 1518 1518 } 1519 1519 1520 function UpdateTo752( $Manager)1520 function UpdateTo752(UpdateManager $Manager): void 1521 1521 { 1522 1522 $Manager->Database->query('INSERT INTO `SchedulerAction` (`Id`, `Name`, `Class`) '. … … 1554 1554 } 1555 1555 1556 function UpdateTo755( $Manager)1556 function UpdateTo755(UpdateManager $Manager): void 1557 1557 { 1558 1558 $Manager->Execute("INSERT INTO `FinanceInvoiceGroup` (`Id`, `Name`, `DocumentLine`, `ValueSign`, `Direction`) ". … … 1576 1576 } 1577 1577 1578 function UpdateTo759( $Manager)1578 function UpdateTo759(UpdateManager $Manager): void 1579 1579 { 1580 1580 $Manager->Execute('ALTER TABLE `Scheduler` ADD `Duration` INT NOT NULL AFTER `Period`;'); … … 1582 1582 1583 1583 /* 1584 function UpdateTo761( $Manager)1584 function UpdateTo761(UpdateManager $Manager): void 1585 1585 { 1586 1586 $Manager->Execute('INSERT INTO `MACAddress` (SELECT "" AS `Id`,`MAC` AS `Value` FROM `NetworkSignal` GROUP BY `MAC`)'); … … 1590 1590 */ 1591 1591 1592 function UpdateTo762( $Manager)1592 function UpdateTo762(UpdateManager $Manager): void 1593 1593 { 1594 1594 $Manager->Execute('ALTER TABLE `NetworkDevice` ADD `OnlineNotify` INT NOT NULL AFTER `API`;'); 1595 1595 } 1596 1596 1597 function UpdateTo763( $Manager)1597 function UpdateTo763(UpdateManager $Manager): void 1598 1598 { 1599 1599 $Manager->Execute('ALTER TABLE `NetworkInterface` ADD `OnlineNotify` INT NOT NULL AFTER `LastOnline`;'); … … 1601 1601 } 1602 1602 1603 function UpdateTo765( $Manager)1603 function UpdateTo765(UpdateManager $Manager): void 1604 1604 { 1605 1605 $Manager->Execute('CREATE TABLE IF NOT EXISTS `SupportActivity` ( … … 1632 1632 } 1633 1633 1634 function UpdateTo768( $Manager)1634 function UpdateTo768(UpdateManager $Manager): void 1635 1635 { 1636 1636 $Manager->Execute('ALTER TABLE `NetworkDomainAlias` ADD `Domain` INT NOT NULL AFTER `Comment`;'); … … 1672 1672 } 1673 1673 1674 function UpdateTo770( $Manager)1674 function UpdateTo770(UpdateManager $Manager): void 1675 1675 { 1676 1676 $Manager->Execute("CREATE TABLE IF NOT EXISTS `OS` ( … … 1787 1787 } 1788 1788 1789 function UpdateTo785( $Manager)1789 function UpdateTo785(UpdateManager $Manager): void 1790 1790 { 1791 1791 $Manager->Execute('DROP TABLE `NetworkInterfaceStat`'); 1792 1792 } 1793 1793 1794 function UpdateTo786( $Manager)1794 function UpdateTo786(UpdateManager $Manager): void 1795 1795 { 1796 1796 $Manager->Execute('ALTER TABLE `Member` DROP FOREIGN KEY Member_ibfk_28;'); … … 1803 1803 } 1804 1804 1805 function UpdateTo792( $Manager)1805 function UpdateTo792(UpdateManager $Manager): void 1806 1806 { 1807 1807 // Transform contracts … … 1823 1823 } 1824 1824 1825 function UpdateTo800( $Manager)1825 function UpdateTo800(UpdateManager $Manager): void 1826 1826 { 1827 1827 $Manager->Execute('CREATE TABLE IF NOT EXISTS `StockItemHistory` ( … … 1840 1840 } 1841 1841 1842 function UpdateTo802( $Manager)1842 function UpdateTo802(UpdateManager $Manager): void 1843 1843 { 1844 1844 $Manager->Execute('CREATE TABLE IF NOT EXISTS `StockMoveGroup` ( … … 1889 1889 } 1890 1890 1891 function UpdateTo803( $Manager)1891 function UpdateTo803(UpdateManager $Manager): void 1892 1892 { 1893 1893 $Manager->Execute('CREATE TABLE IF NOT EXISTS `StockMoveItemSerialRel` ( … … 1905 1905 } 1906 1906 1907 function UpdateTo807( $Manager)1907 function UpdateTo807(UpdateManager $Manager): void 1908 1908 { 1909 1909 $Manager->Execute('ALTER TABLE `Product` ADD `StockMinCount` INT NOT NULL AFTER `UnitOfMeasure`;'); 1910 1910 } 1911 1911 1912 function UpdateTo808( $Manager)1912 function UpdateTo808(UpdateManager $Manager): void 1913 1913 { 1914 1914 $Manager->Execute('CREATE TABLE IF NOT EXISTS `FinanceTreasuryCheck` ( … … 1948 1948 } 1949 1949 1950 function UpdateTo814( $Manager)1950 function UpdateTo814(UpdateManager $Manager): void 1951 1951 { 1952 1952 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkPort` ( … … 1972 1972 } 1973 1973 1974 function UpdateTo817( $Manager)1974 function UpdateTo817(UpdateManager $Manager): void 1975 1975 { 1976 1976 $Manager->Execute('ALTER TABLE `NetworkConfiguration` ADD `SysName` VARCHAR(255) NOT NULL FIRST;'); … … 1990 1990 } 1991 1991 1992 function UpdateTo818( $Manager)1992 function UpdateTo818(UpdateManager $Manager): void 1993 1993 { 1994 1994 $Manager->Execute('ALTER TABLE `NetworkPort` ADD `Protocol` INT NOT NULL AFTER `Enabled`;'); … … 2007 2007 } 2008 2008 2009 function UpdateTo824( $Manager)2009 function UpdateTo824(UpdateManager $Manager): void 2010 2010 { 2011 2011 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkInterfaceLatency` ( … … 2021 2021 } 2022 2022 2023 function UpdateTo831( $Manager)2023 function UpdateTo831(UpdateManager $Manager): void 2024 2024 { 2025 2025 $Manager->Execute('ALTER TABLE `NetworkLinkType` '. … … 2033 2033 } 2034 2034 2035 function UpdateTo838( $Manager)2035 function UpdateTo838(UpdateManager $Manager): void 2036 2036 { 2037 2037 $Manager->Execute('ALTER TABLE `News` CHANGE `Date` `Date` DATETIME NULL, CHANGE `TargetDate` `TargetDate` DATETIME NULL;'); 2038 2038 } 2039 2039 2040 function UpdateTo844( $Manager)2040 function UpdateTo844(UpdateManager $Manager): void 2041 2041 { 2042 2042 $Manager->Execute('ALTER TABLE `DocumentLine` ADD `Yearly` BOOLEAN NOT NULL DEFAULT FALSE AFTER `Shortcut`;'); 2043 2043 } 2044 2044 2045 function UpdateTo855( $Manager)2045 function UpdateTo855(UpdateManager $Manager): void 2046 2046 { 2047 2047 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkDeviceLog` ( … … 2058 2058 } 2059 2059 2060 function UpdateTo862( $Manager)2060 function UpdateTo862(UpdateManager $Manager): void 2061 2061 { 2062 2062 $Manager->Execute('ALTER TABLE `NetworkInterfaceUpDown` ADD `Previous` INT NULL AFTER `Duration`'); … … 2065 2065 } 2066 2066 2067 function UpdateTo867( $Manager)2067 function UpdateTo867(UpdateManager $Manager): void 2068 2068 { 2069 2069 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NotifyLog` ( … … 2077 2077 } 2078 2078 2079 function UpdateTo869( $Manager)2079 function UpdateTo869(UpdateManager $Manager): void 2080 2080 { 2081 2081 $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkSpeedLimit` ( … … 2104 2104 } 2105 2105 2106 function UpdateTo870( $Manager)2106 function UpdateTo870(UpdateManager $Manager): void 2107 2107 { 2108 2108 $Manager->Execute('ALTER TABLE `NetworkSubnet`ADD COLUMN `MaskIPv6` INT(11) NOT NULL AFTER `AddressRangeIPv6`;'); … … 2111 2111 } 2112 2112 2113 function UpdateTo878( $Manager)2113 function UpdateTo878(UpdateManager $Manager): void 2114 2114 { 2115 2115 $Manager->Execute('ALTER TABLE `NewsImport` ADD `Method` VARCHAR(255) NOT NULL AFTER `Category`;'); … … 2118 2118 } 2119 2119 2120 function UpdateTo880( $Manager)2120 function UpdateTo880(UpdateManager $Manager): void 2121 2121 { 2122 2122 $Manager->Execute('ALTER TABLE `UserOnline` CHANGE `IpAddress` `IpAddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT "";'); … … 2125 2125 } 2126 2126 2127 function UpdateTo882( $Manager)2127 function UpdateTo882(UpdateManager $Manager): void 2128 2128 { 2129 2129 $Manager->Execute('ALTER TABLE `FinanceMonthlyOverall` CHANGE `Investment` `Investment` INT(11) NOT NULL DEFAULT "0";'); 2130 2130 } 2131 2131 2132 function UpdateTo885( $Manager)2132 function UpdateTo885(UpdateManager $Manager): void 2133 2133 { 2134 2134 $Manager->Execute('ALTER TABLE `FinanceOperation` CHANGE `Value` `Value` FLOAT NOT NULL DEFAULT "0";'); … … 2137 2137 class Updates 2138 2138 { 2139 function Get() 2139 function Get(): array 2140 2140 { 2141 2141 return array(
Note:
See TracChangeset
for help on using the changeset viewer.