Changeset 94 for trunk/www/SQL/Updates

Timestamp:

Aug 16, 2013, 10:20:57 PM (11 years ago)

Author:

chronos

Message:

• Added: Primary key for PermissionAssignment table.
• Fixed: Permission check in Server view.

Location:

trunk/www/SQL/Updates

Files:

• 69.sql (modified) (1 diff)
• 94.sql (added)

trunk/www/SQL/Updates/69.sql

@@ -10 +10 @@
 ALTER TABLE `Realm` ADD `ClusterNode` INT NOT NULL ;
 ALTER TABLE `Realm` ADD INDEX ( `ClusterNode` ) ;
-UPDATE `Realm` SET `Node` = 1;
-ALTER TABLE `Realm` ADD FOREIGN KEY ( `Node` ) REFERENCES `ClusterNode` (`Id`);
+UPDATE `Realm` SET `ClusterNode` = 1;
+ALTER TABLE `Realm` ADD FOREIGN KEY ( `ClusterNode` ) REFERENCES `ClusterNode` (`Id`);