All pastes #474655 Raw Edit

Someone

public sql v1 · immutable
·published 2007-05-06 22:57 UTC
rendered paste body
CREATE TABLE `acl_role` (  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,  `name` VARCHAR(32) NOT NULL DEFAULT '',  `desc` VARCHAR(255),  PRIMARY KEY ('id')) ENGINE=InnoDB;CREATE TABLE `acl_group` (  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,  `name` VARCHAR(32) NOT NULL DEFAULT '',  `desc` VARCHAR(255),  PRIMARY KEY ('id')) ENGINE=InnoDB;CREATE TABLE `acl_role_group` (  `role_id` INT UNSIGNED NOT NULL,  `group_id` INT UNSIGNED NOT NULL,  UNIQUE KEY 'role_group_idx' ('role_id', 'group_id')) ENGINE=InnoDB;CREATE TABLE `acl_user_group` (  `group_id` INT UNSIGNED NOT NULL,  `role_id` INT UNSIGNED NOT NULL,  UNIQUE KEY 'user_group_idx' ('group_id', 'role_id') ) ENGINE=InnoDB;