/* * Create Tables */ CREATE TABLE IF NOT EXISTS `PREFIX_permissions` ( `ID` int(11) NOT NULL auto_increment, `Lft` int(11) NOT NULL, `Rght` int(11) NOT NULL, `Title` char(64) NOT NULL, `Description` text NOT NULL, PRIMARY KEY (`ID`), KEY `Title` (`Title`), KEY `Lft` (`Lft`), KEY `Rght` (`Rght`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1; CREATE TABLE IF NOT EXISTS `PREFIX_rolepermissions` ( `RoleID` int(11) NOT NULL, `PermissionID` int(11) NOT NULL, `AssignmentDate` int(11) NOT NULL, PRIMARY KEY (`RoleID`,`PermissionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE IF NOT EXISTS `PREFIX_roles` ( `ID` int(11) NOT NULL auto_increment, `Lft` int(11) NOT NULL, `Rght` int(11) NOT NULL, `Title` varchar(128) NOT NULL, `Description` text NOT NULL, PRIMARY KEY (`ID`), KEY `Title` (`Title`), KEY `Lft` (`Lft`), KEY `Rght` (`Rght`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE IF NOT EXISTS `PREFIX_userroles` ( `UserID` int(11) NOT NULL, `RoleID` int(11) NOT NULL, `AssignmentDate` int(11) NOT NULL, PRIMARY KEY (`UserID`,`RoleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /* * Insert Initial Table Data */ INSERT INTO `PREFIX_permissions` (`ID`, `Lft`, `Rght`, `Title`, `Description`) VALUES (1, 0, 1, 'root', 'root'); INSERT INTO `PREFIX_rolepermissions` (`RoleID`, `PermissionID`, `AssignmentDate`) VALUES (1, 1, UNIX_TIMESTAMP()); INSERT INTO `PREFIX_roles` (`ID`, `Lft`, `Rght`, `Title`, `Description`) VALUES (1, 0, 1, 'root', 'root'); INSERT INTO `PREFIX_userroles` (`UserID`, `RoleID`, `AssignmentDate`) VALUES (1, 1, UNIX_TIMESTAMP());