Changeset 594 for trunk/Modules/User/User.php

Timestamp:

Nov 2, 2013, 11:23:19 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Vylepšena instalace modulu User.

File:

• trunk/Modules/User/User.php (modified) (1 diff)

trunk/Modules/User/User.php

@@ -431 +431 @@
   KEY `User` (`User`)
 ) ENGINE=MEMORY  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+    $this->Database->query("CREATE TABLE IF NOT EXISTS `PermissionGroup` (
+        `Id` int(11) NOT NULL AUTO_INCREMENT,
+        `Description` varchar(255) NOT NULL DEFAULT '',
+        PRIMARY KEY (`Id`)
+    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+    
+    $this->Database->query("CREATE TABLE IF NOT EXISTS `PermissionGroupAssignment` (
+        `Id` int(11) NOT NULL AUTO_INCREMENT,
+        `Group` int(11) NOT NULL DEFAULT '0',
+        `AssignedGroup` int(11) DEFAULT NULL,
+        `AssignedOperation` int(11) DEFAULT NULL,
+        PRIMARY KEY (`Id`),
+        KEY `Group` (`Group`),
+        KEY `AssignedGroup` (`AssignedGroup`),
+        KEY `AssignedOperation` (`AssignedOperation`)
+        ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+    
+    $this->Database->query("CREATE TABLE IF NOT EXISTS `PermissionOperation` (
+            `Id` int(11) NOT NULL AUTO_INCREMENT,
+        `Module` int(11) NOT NULL,
+            `Operation` varchar(128) NOT NULL DEFAULT '',
+            `Item` varchar(64) NOT NULL DEFAULT '',
+                `ItemId` int(11) NOT NULL DEFAULT '0',
+                PRIMARY KEY (`Id`),
+                    KEY `Module` (`Module`),
+                    KEY `Operation` (`Operation`),
+                    KEY `Item` (`Item`),
+                    KEY `ItemId` (`ItemId`)
+                    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+    
+    $this->Database->query("CREATE TABLE IF NOT EXISTS `PermissionUserAssignment` (
+                    `Id` int(11) NOT NULL AUTO_INCREMENT,
+                    `User` int(11) DEFAULT NULL,
+                    `AssignedGroup` int(11) DEFAULT NULL,
+                    `AssignedOperation` int(11) DEFAULT NULL,
+                    PRIMARY KEY (`Id`),
+                        KEY `User` (`User`),
+                        KEY `AssignedGroup` (`AssignedGroup`),
+                            KEY `AssignedOperation` (`AssignedOperation`)
+                    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+    
+    $this->Database->query("ALTER TABLE `PermissionGroupAssignment`
+      ADD CONSTRAINT `PermissionGroupAssignment_ibfk_1` FOREIGN KEY (`Group`) REFERENCES `PermissionGroup` (`Id`),
+      ADD CONSTRAINT `PermissionGroupAssignment_ibfk_2` FOREIGN KEY (`AssignedGroup`) REFERENCES `PermissionGroup` (`Id`),
+      ADD CONSTRAINT `PermissionGroupAssignment_ibfk_3` FOREIGN KEY (`AssignedOperation`) REFERENCES `PermissionOperation` (`Id`);");
+    
+    $this->Database->query("ALTER TABLE `PermissionOperation`
+      ADD CONSTRAINT `PermissionOperation_ibfk_1` FOREIGN KEY (`Module`) REFERENCES `Module` (`Id`);");
+    
+    $this->Database->query("ALTER TABLE `PermissionUserAssignment`
+      ADD CONSTRAINT `PermissionUserAssignment_ibfk_2` FOREIGN KEY (`AssignedGroup`) REFERENCES `PermissionGroup` (`Id`),
+      ADD CONSTRAINT `PermissionUserAssignment_ibfk_3` FOREIGN KEY (`AssignedOperation`) REFERENCES `PermissionOperation` (`Id`),
+      ADD CONSTRAINT `PermissionUserAssignment_ibfk_4` FOREIGN KEY (`User`) REFERENCES `User` (`Id`);");
   }
   
   function DoUninstall()
   {     
+    $this->Database->query('DROP TABLE `PermissionUserAssignment`');
+    $this->Database->query('DROP TABLE `PermissionGroupAssignment`');
+    $this->Database->query('DROP TABLE `PermissionGroup`');
+    $this->Database->query('DROP TABLE `PermissionOperation`');
     $this->Database->query('DROP TABLE `UserOnline`');
     $this->Database->query('DROP TABLE `User`');