Changeset 803 for trunk/admin
- Timestamp:
- Apr 14, 2014, 8:29:20 PM (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/UpdateTrace.php
r795 r803 2347 2347 ADD CONSTRAINT `User_ibfk_1` FOREIGN KEY (`Language`) REFERENCES `Language` (`Id`), 2348 2348 ADD CONSTRAINT `User_ibfk_2` FOREIGN KEY (`Team`) REFERENCES `Team` (`Id`);"); 2349 2349 2350 2350 $Manager->Execute('INSERT INTO `DbVersion` (`Id` ,`Revision`) VALUES ("1", "498")'); 2351 2351 $Manager->Execute('INSERT INTO `Language` (`Id` ,`Name` ,`Enabled`)VALUES (NULL , "Angličtina", 0);'); … … 2479 2479 2480 2480 function UpdateTo506($Manager) 2481 { 2481 { 2482 2482 global $System; 2483 2483 2484 2484 $DbResult = $System->Database->query('SELECT `TablePrefix` FROM `Group`'); 2485 2485 while($Group = $DbResult->fetch_assoc()) … … 2514 2514 2515 2515 function UpdateTo510($Manager) 2516 { 2516 { 2517 2517 $Manager->Execute('ALTER TABLE `News` ADD `Title` VARCHAR( 255 ) NOT NULL AFTER `Time`'); 2518 2518 $Manager->Execute('UPDATE `News` SET `Title` = (SELECT `Name` FROM `User` AS `T` WHERE `T`.`ID` = `User`)'); … … 2520 2520 2521 2521 function UpdateTo524($Manager) 2522 { 2522 { 2523 2523 $Manager->Execute('ALTER TABLE `User` ADD `PreferredVersion` INT NULL DEFAULT NULL'); 2524 2524 $Manager->Execute('ALTER TABLE `User` ADD INDEX ( `PreferredVersion` )'); … … 2534 2534 while($DbRow = $DbResult->fetch_row()) 2535 2535 { 2536 $Manager->Execute("ALTER TABLE `".$DbRow[0]."` CONVERT TO CHARACTER SET utf8"); 2537 } 2536 $Manager->Execute("ALTER TABLE `".$DbRow[0]."` CONVERT TO CHARACTER SET utf8"); 2537 } 2538 2538 } 2539 2539 … … 2559 2559 2560 2560 function UpdateTo543($Manager) 2561 { 2561 { 2562 2562 $Manager->Execute('ALTER TABLE `Group` ADD INDEX ( `Name` )'); 2563 2563 } 2564 2564 2565 2565 function UpdateTo567($Manager) 2566 { 2566 { 2567 2567 $Manager->Execute('ALTER TABLE `Log` ADD `URL` VARCHAR( 255 ) NOT NULL ;'); 2568 2568 } 2569 2569 2570 2570 function UpdateTo574($Manager) 2571 { 2571 { 2572 2572 $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPage` ( 2573 2573 `Id` int(11) NOT NULL AUTO_INCREMENT, … … 2597 2597 2598 2598 function UpdateTo585($Manager) 2599 { 2599 { 2600 2600 $Manager->Execute('CREATE TABLE IF NOT EXISTS `APIToken` ( 2601 2601 `Id` int(11) NOT NULL AUTO_INCREMENT, … … 2613 2613 $Manager->Execute("INSERT INTO `LogType` (`Id` ,`Name` ,`Color` ,`Description`) 2614 2614 VALUES (NULL , 'Nenalezené', 'teal', 'Nenalezené stránky');"); 2615 } 2615 } 2616 2616 2617 2617 function UpdateTo604($Manager) … … 2646 2646 `Code` = "en" WHERE `Language`.`Name` ="Angličitna";'); 2647 2647 $Manager->Execute('UPDATE `Language` SET `Code` = "cs" WHERE `Language`.`Name` ="Čeština";'); 2648 $Manager->Execute('UPDATE `Language` SET `Code` = "sk" WHERE `Language`.`Name` ="Slovenština";'); 2648 $Manager->Execute('UPDATE `Language` SET `Code` = "sk" WHERE `Language`.`Name` ="Slovenština";'); 2649 2649 } 2650 2650 … … 2662 2662 `ID`) ON DELETE RESTRICT ON UPDATE RESTRICT ;'); 2663 2663 $Manager->Execute('ALTER TABLE `Server` ADD `CheckIP` VARCHAR( 16 ) NOT NULL , 2664 ADD `CheckPort` INT NOT NULL ;'); 2664 ADD `CheckPort` INT NOT NULL ;'); 2665 2665 } 2666 2666 … … 2673 2673 function UpdateTo666($Manager) 2674 2674 { 2675 $Manager->Execute('INSERT INTO `ExportOutputType` (`Id` ,`Name`) VALUES (\'10\' , \'Instalace - Instalační soubor pro klienta\');'); 2676 $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL , \'10\', \'84\');'); 2675 $Manager->Execute('INSERT INTO `ExportOutputType` (`Id` ,`Name`) VALUES (\'10\' , \'Instalace - Instalační soubor pro klienta\');'); 2676 $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL , \'10\', \'84\');'); 2677 2677 } 2678 2678 2679 2679 function UpdateTo678($Manager) 2680 2680 { 2681 $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL , \'10\', \'11\');'); 2681 $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL , \'10\', \'11\');'); 2682 2682 } 2683 2683 … … 2686 2686 $Manager->Execute('CREATE TABLE IF NOT EXISTS `ExportGroupItem` (`Id` int(11) NOT NULL AUTO_INCREMENT,'. 2687 2687 '`Export` int(11) NOT NULL,`GroupItem` int(11) NOT NULL, PRIMARY KEY (`Id`), KEY `Export` (`Export`),'. 2688 ' KEY `GroupItem` (`GroupItem`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;'); 2688 ' KEY `GroupItem` (`GroupItem`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;'); 2689 2689 $Manager->Execute('ALTER TABLE `ExportGroupItem`'. 2690 2690 'ADD CONSTRAINT `ExportGroupItem_ibfk_1` FOREIGN KEY (`Export`) REFERENCES `Export` (`Id`),'. 2691 'ADD CONSTRAINT `ExportGroupItem_ibfk_2` FOREIGN KEY (`GroupItem`) REFERENCES `GroupItem` (`Id`);'); 2691 'ADD CONSTRAINT `ExportGroupItem_ibfk_2` FOREIGN KEY (`GroupItem`) REFERENCES `GroupItem` (`Id`);'); 2692 2692 } 2693 2693 … … 2711 2711 function UpdateTo716($Manager) 2712 2712 { 2713 $Manager->Execute('ALTER TABLE `Export` ADD `Featured` TINYINT NOT NULL'); 2713 $Manager->Execute('ALTER TABLE `Export` ADD `Featured` TINYINT NOT NULL'); 2714 2714 } 2715 2715 2716 2716 function UpdateTo725($Manager) 2717 2717 { 2718 $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;'); 2718 $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;'); 2719 2719 } 2720 2720 2721 2721 function UpdateTo731($Manager) 2722 2722 { 2723 $Manager->Execute('ALTER TABLE `ExportTask` ADD `Progress` TINYINT NOT NULL ;'); 2723 $Manager->Execute('ALTER TABLE `ExportTask` ADD `Progress` TINYINT NOT NULL ;'); 2724 2724 } 2725 2725 2726 2726 function UpdateTo732($Manager) 2727 2727 { 2728 $Manager->Execute('ALTER TABLE `ExportTask` CHANGE `Progress` `Progress` DOUBLE( 4, 2 ) NOT NULL ;'); 2728 $Manager->Execute('ALTER TABLE `ExportTask` CHANGE `Progress` `Progress` DOUBLE( 4, 2 ) NOT NULL ;'); 2729 2729 } 2730 2730 … … 2800 2800 } 2801 2801 2802 function UpdateTo803($Manager) 2803 { 2804 $Manager->Execute('ALTER TABLE `Referrer` CHANGE `Show` `Visible` INT( 11 ) NOT NULL DEFAULT "1";'); 2805 $Manager->Execute('ALTER TABLE `Referrer` ADD `LastIP` VARCHAR( 16 ) NOT NULL ;'); 2806 } 2807 2802 2808 $Updates = array( 2803 2809 498 => array('Revision' => 506, 'Function' => 'UpdateTo506'), … … 2815 2821 609 => array('Revision' => 610, 'Function' => 'UpdateTo610'), 2816 2822 610 => array('Revision' => 639, 'Function' => 'UpdateTo639'), 2817 639 => array('Revision' => 646 , 'Function' => 'UpdateTo646'), 2818 646 => array('Revision' => 666 , 'Function' => 'UpdateTo666'), 2819 666 => array('Revision' => 678 , 'Function' => 'UpdateTo678'), 2820 678 => array('Revision' => 695 , 'Function' => 'UpdateTo695'), 2821 695 => array('Revision' => 712 , 'Function' => 'UpdateTo712'), 2822 712 => array('Revision' => 716 , 'Function' => 'UpdateTo716'), 2823 716 => array('Revision' => 725 , 'Function' => 'UpdateTo725'), 2824 725 => array('Revision' => 731 , 'Function' => 'UpdateTo731'), 2825 731 => array('Revision' => 732 , 'Function' => 'UpdateTo732'), 2826 732 => array('Revision' => 748 , 'Function' => 'UpdateTo748'), 2827 748 => array('Revision' => 787 , 'Function' => 'UpdateTo787'), 2823 639 => array('Revision' => 646, 'Function' => 'UpdateTo646'), 2824 646 => array('Revision' => 666, 'Function' => 'UpdateTo666'), 2825 666 => array('Revision' => 678, 'Function' => 'UpdateTo678'), 2826 678 => array('Revision' => 695, 'Function' => 'UpdateTo695'), 2827 695 => array('Revision' => 712, 'Function' => 'UpdateTo712'), 2828 712 => array('Revision' => 716, 'Function' => 'UpdateTo716'), 2829 716 => array('Revision' => 725, 'Function' => 'UpdateTo725'), 2830 725 => array('Revision' => 731, 'Function' => 'UpdateTo731'), 2831 731 => array('Revision' => 732, 'Function' => 'UpdateTo732'), 2832 732 => array('Revision' => 748, 'Function' => 'UpdateTo748'), 2833 748 => array('Revision' => 787, 'Function' => 'UpdateTo787'), 2834 787 => array('Revision' => 803, 'Function' => 'UpdateTo803'), 2828 2835 );
Note:
See TracChangeset
for help on using the changeset viewer.