Changeset 639 for trunk/admin/UpdateTrace.php

Timestamp:

Dec 11, 2013, 10:21:12 PM (11 years ago)

Author:

chronos

Message:

• Added: Make server list more general to cover also non-translated servers.
• Added: Partialy implemented generic view named PageEdit which serve as template to present item lists, add, delete and modify items.

File:

• trunk/admin/UpdateTrace.php (modified) (2 diffs)

trunk/admin/UpdateTrace.php

@@ -2649 +2649 @@
 }
 
+function UpdateTo639($Manager)
+{
+        $Manager->Execute('ALTER TABLE `ServerList` ADD `ClientVersion` INT NOT NULL ,
+ADD INDEX ( `ClientVersion` ) ;');
+  $Manager->Execute('ALTER TABLE `ServerList` ADD FOREIGN KEY ( `ClientVersion` ) REFERENCES `ClientVersion` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
+  $Manager->Execute('RENAME TABLE `ServerList` TO `Server` ;');
+  $Manager->Execute('ALTER TABLE `Server` ADD `Description` TEXT NOT NULL ;');
+  $Manager->Execute('ALTER TABLE `Server` CHANGE `OnlineState` `LastOnlineTime` DATETIME NOT NULL ;');
+  $Manager->Execute('ALTER TABLE `Server` ADD INDEX (`UserCreate`)');
+  $Manager->Execute('ALTER TABLE `Server` ADD FOREIGN KEY ( `UserCreate` ) REFERENCES `User` (
+`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
+  $Manager->Execute('ALTER TABLE `Server` ADD `CheckIP` VARCHAR( 16 ) NOT NULL ,
+ADD `CheckPort` INT NOT NULL ;');   
+}
 
 $Updates = array(
@@ -2664 +2679 @@
         604 => array('Revision' => 609, 'Function' => 'UpdateTo609'),
         609 => array('Revision' => 610, 'Function' => 'UpdateTo610'),
+        610 => array('Revision' => 639, 'Function' => 'UpdateTo639'),
 );