Changeset 615 for trunk/Common/Setup/Updates.php

Timestamp:

Dec 20, 2013, 11:57:02 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Další položky do tabulky "Bezdrátové rozhraní".
• Přidáno: Příprava tabulky NewsImport pro zobecnění importu aktualit z jiných webů.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -489 +489 @@
 }
 
+function UpdateTo615($Manager)
+{
+  $Manager->Execute('ALTER TABLE `NetworkInterfaceWireless` ADD `AntennaPolarity` INT NOT NULL ,
+ADD `Description` VARCHAR( 255 ) NOT NULL ;');
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NewsImport` (
+  `Id` int(11) NOT NULL,
+  `Name` varchar(255) NOT NULL,
+  `Enabled` int(11) NOT NULL,
+  `Source` varchar(255) NOT NULL,
+  `Category` int(11) NOT NULL,
+  `BlockStart` varchar(255) NOT NULL,
+  `BlockEnd` varchar(255) NOT NULL,
+  `ItemStart` varchar(255) NOT NULL,
+  `ItemEnd` varchar(255) NOT NULL,
+  `TitleStart` varchar(255) NOT NULL,
+  `TitleEnd` varchar(255) NOT NULL,
+  `ContentStart` varchar(255) NOT NULL,
+  `ContentEnd` varchar(255) NOT NULL,
+  `LinkStart` varchar(255) NOT NULL,
+  `LinkEnd` varchar(255) NOT NULL,
+  `DateStart` varchar(255) NOT NULL,
+  `DateEnd` varchar(255) NOT NULL,
+  KEY `Category` (`Category`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `NewsImport` '.
+    'ADD CONSTRAINT `NewsImport_ibfk_1` FOREIGN KEY (`Category`) '.
+    ' REFERENCES `NewsCategory` (`Id`);');
+  $Manager->Execute('ALTER TABLE `NetworkInterfaceWireless` ADD `Product` INT NULL AFTER `AntennaPolarity` ,
+ADD INDEX ( `Product` ) ;');
+  $Manager->Execute('ALTER TABLE `NetworkInterfaceWireless` ADD FOREIGN KEY ( `Product` ) REFERENCES `Product` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
+  $Manager->Execute('ALTER TABLE `NetworkInterfaceWireless` ADD `MAC` VARCHAR( 17 ) NOT NULL ;');
+}
+
 class Updates
 {
@@ -519 +553 @@
       591 => array('Revision' => 597, 'Function' => 'UpdateTo597'),
       597 => array('Revision' => 601, 'Function' => 'UpdateTo601'),
+      601 => array('Revision' => 615, 'Function' => 'UpdateTo615'),
     ));
   }