Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * 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());
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement