-- MySQL dump 9.08
--
-- Host: localhost    Database: left_joins
---------------------------------------------------------
-- Server version	4.0.14'-Max'

--
-- Table structure for table 'groups'
--

CREATE TABLE groups (
  idgroups int(10) unsigned NOT NULL auto_increment,
  description varchar(45) default NULL,
  PRIMARY KEY  (idgroups),
  KEY idx_description (description)
) TYPE=InnoDB;

--
-- Dumping data for table 'groups'
--

INSERT INTO groups VALUES (1,'Admins with all permissions');
INSERT INTO groups VALUES (4,'Admins without permission manage_users that w');
INSERT INTO groups VALUES (2,'Subadmins with some permissions');
INSERT INTO groups VALUES (3,'Users with no permissions');

--
-- Table structure for table 'groups_has_permissions'
--

CREATE TABLE groups_has_permissions (
  idgroups int(10) unsigned NOT NULL default '0',
  idpermissions int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (idgroups,idpermissions),
  KEY groups_has_permissions_FKIndex1 (idgroups),
  KEY groups_has_permissions_FKIndex2 (idpermissions),
  CONSTRAINT `0_16` FOREIGN KEY (`idgroups`) REFERENCES `groups` (`idgroups`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `0_17` FOREIGN KEY (`idpermissions`) REFERENCES `permissions` (`idpermissions`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB;

--
-- Dumping data for table 'groups_has_permissions'
--

INSERT INTO groups_has_permissions VALUES (1,1);
INSERT INTO groups_has_permissions VALUES (1,2);
INSERT INTO groups_has_permissions VALUES (1,3);
INSERT INTO groups_has_permissions VALUES (2,1);
INSERT INTO groups_has_permissions VALUES (2,3);
INSERT INTO groups_has_permissions VALUES (4,2);
INSERT INTO groups_has_permissions VALUES (4,3);

--
-- Table structure for table 'permissions'
--

CREATE TABLE permissions (
  idpermissions int(10) unsigned NOT NULL auto_increment,
  name varchar(45) default NULL,
  PRIMARY KEY  (idpermissions),
  KEY idx_name (name)
) TYPE=InnoDB;

--
-- Dumping data for table 'permissions'
--

INSERT INTO permissions VALUES (2,'manage_questions');
INSERT INTO permissions VALUES (1,'manage_users');
INSERT INTO permissions VALUES (3,'send_mail');