Ignore:
Timestamp:
Feb 22, 2015, 11:20:50 PM (10 years ago)
Author:
chronos
Message:
  • Modified: Tabs converted to spaces.
  • Modified: Remove spaces from end of lines.
  • Added: Code format script.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/UpdateTrace.php

    r811 r816  
    25242524  $Manager->Execute('ALTER TABLE `User` ADD INDEX ( `PreferredVersion` )');
    25252525  $Manager->Execute('ALTER TABLE `User` ADD FOREIGN KEY ( `PreferredVersion` ) '.
    2526         'REFERENCES `ClientVersion` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
     2526    'REFERENCES `ClientVersion` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
    25272527  $Manager->Execute('ALTER TABLE `User` ADD `Info` TEXT NOT NULL');
    25282528}
     
    25712571{
    25722572  $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPage` (
    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`)
     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`)
    25802580) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
    25812581
    25822582  $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPageContent` (
    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`)
     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`)
    25912591) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
    25922592
     
    26112611function UpdateTo600($Manager)
    26122612{
    2613         $Manager->Execute("INSERT INTO `LogType` (`Id` ,`Name` ,`Color` ,`Description`)
     2613  $Manager->Execute("INSERT INTO `LogType` (`Id` ,`Name` ,`Color` ,`Description`)
    26142614VALUES (NULL , 'Nenalezené', 'teal', 'Nenalezené stránky');");
    26152615}
     
    26172617function UpdateTo604($Manager)
    26182618{
    2619         $Manager->Execute("INSERT INTO  `ClientVersion` (`Id` ,`Version` ,`BuildNumber` ,`ReleaseDate` ,`Title` ,`Imported`)
     2619  $Manager->Execute("INSERT INTO  `ClientVersion` (`Id` ,`Version` ,`BuildNumber` ,`ReleaseDate` ,`Title` ,`Imported`)
    26202620VALUES ( NULL ,  '5.2.0',  '16650',  '2013-03-05',  'The Thunder King',  0
    26212621), ( NULL ,  '5.3.0',  '16977',  '2013-05-21',  'Escalation',  0
     
    26512651function UpdateTo639($Manager)
    26522652{
    2653         $Manager->Execute('ALTER TABLE `ServerList` ADD `ClientVersion` INT NOT NULL ,
     2653  $Manager->Execute('ALTER TABLE `ServerList` ADD `ClientVersion` INT NOT NULL ,
    26542654ADD INDEX ( `ClientVersion` ) ;');
    26552655  $Manager->Execute('ALTER TABLE `ServerList` ADD FOREIGN KEY ( `ClientVersion` ) REFERENCES `ClientVersion` (
     
    26672667function UpdateTo646($Manager)
    26682668{
    2669         $Manager->Execute('ALTER TABLE `Export` ADD  `AllUsers` TINYINT( 1 ) NOT NULL ;');
     2669  $Manager->Execute('ALTER TABLE `Export` ADD  `AllUsers` TINYINT( 1 ) NOT NULL ;');
    26702670
    26712671}
     
    26732673function UpdateTo666($Manager)
    26742674{
    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\');');
    26772677}
    26782678
    26792679function UpdateTo678($Manager)
    26802680{
    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\');');
    26822682}
    26832683
    26842684function UpdateTo695($Manager)
    26852685{
    2686         $Manager->Execute('CREATE TABLE IF NOT EXISTS `ExportGroupItem` (`Id` int(11) NOT NULL AUTO_INCREMENT,'.
     2686  $Manager->Execute('CREATE TABLE IF NOT EXISTS `ExportGroupItem` (`Id` int(11) NOT NULL AUTO_INCREMENT,'.
    26872687  '`Export` int(11) NOT NULL,`GroupItem` int(11) NOT NULL, PRIMARY KEY (`Id`), KEY `Export` (`Export`),'.
    26882688  ' KEY `GroupItem` (`GroupItem`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');
    2689         $Manager->Execute('ALTER TABLE `ExportGroupItem`'.
     2689  $Manager->Execute('ALTER TABLE `ExportGroupItem`'.
    26902690  'ADD CONSTRAINT `ExportGroupItem_ibfk_1` FOREIGN KEY (`Export`) REFERENCES `Export` (`Id`),'.
    26912691  'ADD CONSTRAINT `ExportGroupItem_ibfk_2` FOREIGN KEY (`GroupItem`) REFERENCES `GroupItem` (`Id`);');
     
    26942694function UpdateTo712($Manager)
    26952695{
    2696         $Manager->Execute('CREATE TABLE IF NOT EXISTS `UserOnline` (
     2696  $Manager->Execute('CREATE TABLE IF NOT EXISTS `UserOnline` (
    26972697  `Id` int(11) NOT NULL AUTO_INCREMENT,
    26982698  `User` int(11) DEFAULT NULL,
     
    27112711function UpdateTo716($Manager)
    27122712{
    2713         $Manager->Execute('ALTER TABLE  `Export` ADD  `Featured` TINYINT NOT NULL');
     2713  $Manager->Execute('ALTER TABLE  `Export` ADD  `Featured` TINYINT NOT NULL');
    27142714}
    27152715
    27162716function UpdateTo725($Manager)
    27172717{
    2718         $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;');
     2718  $Manager->Execute('ALTER TABLE `UserOnline` ADD `StayLoggedHash` VARCHAR( 40 ) NOT NULL ;');
    27192719}
    27202720
    27212721function UpdateTo731($Manager)
    27222722{
    2723         $Manager->Execute('ALTER TABLE  `ExportTask` ADD  `Progress` TINYINT NOT NULL ;');
     2723  $Manager->Execute('ALTER TABLE  `ExportTask` ADD  `Progress` TINYINT NOT NULL ;');
    27242724}
    27252725
    27262726function UpdateTo732($Manager)
    27272727{
    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 ;');
    27292729}
    27302730
     
    28172817
    28182818$Updates = array(
    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'),
     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'),
    28432843  748 => array('Revision' => 787, 'Function' => 'UpdateTo787'),
    28442844  787 => array('Revision' => 803, 'Function' => 'UpdateTo803'),
Note: See TracChangeset for help on using the changeset viewer.