Changeset 285 for trunk

Timestamp:

Sep 1, 2010, 5:23:58 PM (14 years ago)

Author:

george

Message:

• Přidáno: SQL aktualizace k předchozímu commitu.

Location:

trunk/sql/updates

Files:

• 281.sql (modified) (1 diff)
• 284.sql (added)

trunk/sql/updates/281.sql

@@ -1 @@
-ALTER TABLE `NetworkDevice` ADD `Location` INT NOT NULL AFTER `Member` ;
-UPDATE `NetworkDevice` SET `Location` = `Member`;
-ALTER TABLE `NetworkDevice` CHANGE `Location` `Location` INT( 11 ) NOT NULL COMMENT 'Member';
-ALTER TABLE `NetworkDevice` CHANGE `Type` `Type` INT( 11 ) NOT NULL COMMENT 'NetworkDeviceType';
-ALTER TABLE `NetworkDevice` CHANGE `Member` `Member` INT( 11 ) NOT NULL COMMENT 'Member';
+ALTER TABLE `NetworkSubnet` ADD `AddressRangeIPv6` VARCHAR( 255 ) NOT NULL ;
+ALTER TABLE `NetworkInterface` ADD `IPv6` VARCHAR( 255 ) NOT NULL AFTER `LocalIP` ;