------------------------------------------------------------------
-- jm@poure.com
------------------------------------------------------------------

BEGIN;


-- $Id: mambo.acl.sql,v 1.6 2005/08/09 05:17:43 eddieajau Exp $

--
-- Table structure for table "mos_core_acl_aro"
--

CREATE TABLE "mos_core_acl_aro" (
  "id" serial NOT NULL,
  "section_value" varchar(240) NOT NULL DEFAULT '0',
  "value" varchar(240) NOT NULL DEFAULT '',
  "order_value" INT4 NOT NULL DEFAULT '0',
  "name" varchar(255) NOT NULL DEFAULT '',
  "hidden" INT4 NOT NULL DEFAULT '0',
  PRIMARY KEY ("id")

);

INSERT INTO "mos_core_acl_aro" VALUES (10,'users','62',0,'Administrator',0);

--
-- Table structure for table "mos_core_acl_aro_groups"
--
CREATE TABLE "mos_core_acl_aro_groups" (
  "id" serial NOT NULL,
  "parent_id" INT4 NOT NULL DEFAULT '0',
  "name" varchar(255) NOT NULL DEFAULT '',
  "lft" INT4 NOT NULL DEFAULT '0',
  "rgt" INT4 NOT NULL DEFAULT '0',
  "value" varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY ("id","value")

);

--
-- Dumping data for table "mos_core_acl_aro_groups"
--
INSERT INTO "mos_core_acl_aro_groups" VALUES (17,0,'ROOT',1,22,'ROOT');
INSERT INTO "mos_core_acl_aro_groups" VALUES (28,17,'USERS',2,21,'USERS');
INSERT INTO "mos_core_acl_aro_groups" VALUES (29,28,'Public Frontend',3,12,'Public Frontend');
INSERT INTO "mos_core_acl_aro_groups" VALUES (18,29,'Registered',4,11,'Registered');
INSERT INTO "mos_core_acl_aro_groups" VALUES (19,18,'Author',5,10,'Author');
INSERT INTO "mos_core_acl_aro_groups" VALUES (20,19,'Editor',6,9,'Editor');
INSERT INTO "mos_core_acl_aro_groups" VALUES (21,20,'Publisher',7,8,'Publisher');
INSERT INTO "mos_core_acl_aro_groups" VALUES (30,28,'Public Backend',13,20,'Public Backend');
INSERT INTO "mos_core_acl_aro_groups" VALUES (23,30,'Manager',14,19,'Manager');
INSERT INTO "mos_core_acl_aro_groups" VALUES (24,23,'Administrator',15,18,'Administrator');
INSERT INTO "mos_core_acl_aro_groups" VALUES (25,24,'Super Administrator',16,17,'Super Administrator');

--
-- Table structure for table "mos_core_acl_groups_aro_map"
--
CREATE TABLE "mos_core_acl_groups_aro_map" (
  "group_id" INT4 NOT NULL DEFAULT '0',
  "section_value" varchar(240) NOT NULL DEFAULT '',
  "aro_id" INT4 NOT NULL DEFAULT '0'
);

INSERT INTO "mos_core_acl_groups_aro_map" VALUES (25,'',10);

--
-- Table structure for table "mos_core_acl_aro_sections"
--
CREATE TABLE "mos_core_acl_aro_sections" (
  "id" INT4 NOT NULL DEFAULT '0',
  "value" varchar(230) NOT NULL DEFAULT '',
  "order_value" INT4 NOT NULL DEFAULT '0',
  "name" varchar(230) NOT NULL DEFAULT '',
  "hidden" INT4 NOT NULL DEFAULT '0',
  PRIMARY KEY ("id")

);

INSERT INTO "mos_core_acl_aro_sections" VALUES (10,'users',1,'Users',0);


COMMIT;