Changeset 816 for trunk/admin/UpdateTrace.php
- Timestamp:
- Feb 22, 2015, 11:20:50 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/UpdateTrace.php
r811 r816 2524 2524 $Manager->Execute('ALTER TABLE `User` ADD INDEX ( `PreferredVersion` )'); 2525 2525 $Manager->Execute('ALTER TABLE `User` ADD FOREIGN KEY ( `PreferredVersion` ) '. 2526 2526 'REFERENCES `ClientVersion` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;'); 2527 2527 $Manager->Execute('ALTER TABLE `User` ADD `Info` TEXT NOT NULL'); 2528 2528 } … … 2571 2571 { 2572 2572 $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPage` ( 2573 2574 2575 2576 2577 2578 2579 2573 `Id` int(11) NOT NULL AUTO_INCREMENT, 2574 `Name` varchar(255) NOT NULL, 2575 `NormalizedName` varchar(255) NOT NULL, 2576 `VisibleInMenu` int(11) NOT NULL, 2577 PRIMARY KEY (`Id`), 2578 UNIQUE KEY `Name` (`Name`), 2579 KEY `VisibleInMenu` (`VisibleInMenu`) 2580 2580 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;'); 2581 2581 2582 2582 $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPageContent` ( 2583 2584 2585 2586 2587 2588 2589 2590 2583 `Id` int(11) NOT NULL AUTO_INCREMENT, 2584 `Page` int(11) NOT NULL, 2585 `Time` datetime NOT NULL, 2586 `Content` text NOT NULL, 2587 `User` int(11) NOT NULL, 2588 PRIMARY KEY (`Id`), 2589 KEY `User` (`User`), 2590 KEY `Page` (`Page`) 2591 2591 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;'); 2592 2592 … … 2611 2611 function UpdateTo600($Manager) 2612 2612 { 2613 2613 $Manager->Execute("INSERT INTO `LogType` (`Id` ,`Name` ,`Color` ,`Description`) 2614 2614 VALUES (NULL , 'Nenalezené', 'teal', 'Nenalezené stránky');"); 2615 2615 } … … 2617 2617 function UpdateTo604($Manager) 2618 2618 { 2619 2619 $Manager->Execute("INSERT INTO `ClientVersion` (`Id` ,`Version` ,`BuildNumber` ,`ReleaseDate` ,`Title` ,`Imported`) 2620 2620 VALUES ( NULL , '5.2.0', '16650', '2013-03-05', 'The Thunder King', 0 2621 2621 ), ( NULL , '5.3.0', '16977', '2013-05-21', 'Escalation', 0 … … 2651 2651 function UpdateTo639($Manager) 2652 2652 { 2653 2653 $Manager->Execute('ALTER TABLE `ServerList` ADD `ClientVersion` INT NOT NULL , 2654 2654 ADD INDEX ( `ClientVersion` ) ;'); 2655 2655 $Manager->Execute('ALTER TABLE `ServerList` ADD FOREIGN KEY ( `ClientVersion` ) REFERENCES `ClientVersion` ( … … 2667 2667 function UpdateTo646($Manager) 2668 2668 { 2669 2669 $Manager->Execute('ALTER TABLE `Export` ADD `AllUsers` TINYINT( 1 ) NOT NULL ;'); 2670 2670 2671 2671 } … … 2673 2673 function UpdateTo666($Manager) 2674 2674 { 2675 2676 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 2681 $Manager->Execute('INSERT INTO `ExportVersion` (`Id` ,`ExportType` ,`ClientVersion`)VALUES (NULL , \'10\', \'11\');'); 2682 2682 } 2683 2683 2684 2684 function UpdateTo695($Manager) 2685 2685 { 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 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 2691 'ADD CONSTRAINT `ExportGroupItem_ibfk_2` FOREIGN KEY (`GroupItem`) REFERENCES `GroupItem` (`Id`);'); … … 2694 2694 function UpdateTo712($Manager) 2695 2695 { 2696 2696 $Manager->Execute('CREATE TABLE IF NOT EXISTS `UserOnline` ( 2697 2697 `Id` int(11) NOT NULL AUTO_INCREMENT, 2698 2698 `User` int(11) DEFAULT NULL, … … 2711 2711 function UpdateTo716($Manager) 2712 2712 { 2713 2713 $Manager->Execute('ALTER TABLE `Export` ADD `Featured` TINYINT NOT NULL'); 2714 2714 } 2715 2715 2716 2716 function UpdateTo725($Manager) 2717 2717 { 2718 2718 $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;'); 2719 2719 } 2720 2720 2721 2721 function UpdateTo731($Manager) 2722 2722 { 2723 2723 $Manager->Execute('ALTER TABLE `ExportTask` ADD `Progress` TINYINT NOT NULL ;'); 2724 2724 } 2725 2725 2726 2726 function UpdateTo732($Manager) 2727 2727 { 2728 2728 $Manager->Execute('ALTER TABLE `ExportTask` CHANGE `Progress` `Progress` DOUBLE( 4, 2 ) NOT NULL ;'); 2729 2729 } 2730 2730 … … 2817 2817 2818 2818 $Updates = array( 2819 2820 2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834 2835 2836 2837 2838 2839 2840 2841 2842 2819 498 => array('Revision' => 506, 'Function' => 'UpdateTo506'), 2820 506 => array('Revision' => 510, 'Function' => 'UpdateTo510'), 2821 510 => array('Revision' => 524, 'Function' => 'UpdateTo524'), 2822 524 => array('Revision' => 537, 'Function' => 'UpdateTo537'), 2823 537 => array('Revision' => 539, 'Function' => 'UpdateTo539'), 2824 539 => array('Revision' => 543, 'Function' => 'UpdateTo543'), 2825 543 => array('Revision' => 567, 'Function' => 'UpdateTo567'), 2826 567 => array('Revision' => 574, 'Function' => 'UpdateTo574'), 2827 574 => array('Revision' => 585, 'Function' => 'UpdateTo585'), 2828 585 => array('Revision' => 600, 'Function' => 'UpdateTo600'), 2829 600 => array('Revision' => 604, 'Function' => 'UpdateTo604'), 2830 604 => array('Revision' => 609, 'Function' => 'UpdateTo609'), 2831 609 => array('Revision' => 610, 'Function' => 'UpdateTo610'), 2832 610 => array('Revision' => 639, 'Function' => 'UpdateTo639'), 2833 639 => array('Revision' => 646, 'Function' => 'UpdateTo646'), 2834 646 => array('Revision' => 666, 'Function' => 'UpdateTo666'), 2835 666 => array('Revision' => 678, 'Function' => 'UpdateTo678'), 2836 678 => array('Revision' => 695, 'Function' => 'UpdateTo695'), 2837 695 => array('Revision' => 712, 'Function' => 'UpdateTo712'), 2838 712 => array('Revision' => 716, 'Function' => 'UpdateTo716'), 2839 716 => array('Revision' => 725, 'Function' => 'UpdateTo725'), 2840 725 => array('Revision' => 731, 'Function' => 'UpdateTo731'), 2841 731 => array('Revision' => 732, 'Function' => 'UpdateTo732'), 2842 732 => array('Revision' => 748, 'Function' => 'UpdateTo748'), 2843 2843 748 => array('Revision' => 787, 'Function' => 'UpdateTo787'), 2844 2844 787 => array('Revision' => 803, 'Function' => 'UpdateTo803'),
Note:
See TracChangeset
for help on using the changeset viewer.