PHP Classes

File: db.sql

Recommend this page to a friend!
  Classes of Raskin Veniamin   Manage PHP Permissions Framework   db.sql   Download  
File: db.sql
Role: Auxiliary data
Content type: text/plain
Description: Script mysql database
Class: Manage PHP Permissions Framework
Manage role based user permissions store in MySQL
Author: By
Last change:
Date: 10 years ago
Size: 2,324 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 3.2.3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 17, 2013 at 09:14 AM -- Server version: 5.1.40 -- PHP Version: 5.3.13 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `social` -- -- -------------------------------------------------------- -- -- Table structure for table `prefix_role_assignment` -- CREATE TABLE IF NOT EXISTS `prefix_role_assignment` ( `nameitem` varchar(32) NOT NULL, `user_id` int(10) unsigned NOT NULL, `access` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 - r | 2 - u| 4 - c | 8 - d ', PRIMARY KEY (`nameitem`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `prefix_role_assignment` -- -- -------------------------------------------------------- -- -- Table structure for table `prefix_role_child` -- CREATE TABLE IF NOT EXISTS `prefix_role_child` ( `parent` varchar(32) NOT NULL, `child` varchar(32) NOT NULL, PRIMARY KEY (`parent`,`child`), KEY `child` (`child`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `prefix_role_child` -- -- -------------------------------------------------------- -- -- Table structure for table `prefix_role_item` -- CREATE TABLE IF NOT EXISTS `prefix_role_item` ( `name` varchar(32) NOT NULL, `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0- role 1 - group 2 - comand', `description` text NOT NULL, `accessory` text COMMENT 'принадлежность', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `prefix_role_item` -- -- -- Constraints for dumped tables -- -- -- Constraints for table `prefix_role_assignment` -- ALTER TABLE `prefix_role_assignment` ADD CONSTRAINT `prefix_role_assignment_ibfk_1` FOREIGN KEY (`nameitem`) REFERENCES `prefix_role_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `prefix_role_child` -- ALTER TABLE `prefix_role_child` ADD CONSTRAINT `prefix_role_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `prefix_role_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `prefix_role_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `prefix_role_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;