From 520662b14ac86813cc46e5c1102d75fd629598dc Mon Sep 17 00:00:00 2001 From: Cake Date: Tue, 2 Mar 2010 23:03:39 +0900 Subject: [PATCH] =?utf8?q?ACL=E3=82=BB=E3=83=83=E3=83=88=E3=82=A2=E3=83=83?= =?utf8?q?=E3=83=97SQL=E3=82=92null=20ID=E6=8C=87=E5=AE=9A=E3=81=AB?= =?utf8?q?=E5=A4=89=E6=9B=B4?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- app/config/sql/setup_acl.sql | 86 ++++++++++++++++++++++---------------------- 1 file changed, 43 insertions(+), 43 deletions(-) diff --git a/app/config/sql/setup_acl.sql b/app/config/sql/setup_acl.sql index c1acad3..231cce9 100644 --- a/app/config/sql/setup_acl.sql +++ b/app/config/sql/setup_acl.sql @@ -25,19 +25,19 @@ CREATE TABLE `acos` ( LOCK TABLES `acos` WRITE; /*!40000 ALTER TABLE `acos` DISABLE KEYS */; INSERT INTO `acos` VALUES -(1,NULL,'',NULL,'controllers',1,18), -(2,1,'',NULL,'Users',2,3), -(3,1,'',NULL,'Groups',4,5), -(4,NULL,'',NULL,'prefix',19,26), -(5,4,'',NULL,'admin',20,21), -(6,4,'',NULL,'pc',22,23), -(7,4,'',NULL,'m',24,25), -(8,1,'',NULL,'Systems',6,7), -(9,1,'',NULL,'Characters',8,9), -(10,1,'',NULL,'Profiles',10,11), -(11,1,'',NULL,'ProfileSelects',12,13), -(12,1,'',NULL,'ProfileTables',14,15), -(13,1,'',NULL,'SiteConfigs',16,17); +(NULL,NULL,'',NULL,'controllers',1,18), +(NULL,1,'',NULL,'Users',2,3), +(NULL,1,'',NULL,'Groups',4,5), +(NULL,NULL,'',NULL,'prefix',19,26), +(NULL,4,'',NULL,'admin',20,21), +(NULL,4,'',NULL,'pc',22,23), +(NULL,4,'',NULL,'m',24,25), +(NULL,1,'',NULL,'Systems',6,7), +(NULL,1,'',NULL,'Characters',8,9), +(NULL,1,'',NULL,'Profiles',10,11), +(NULL,1,'',NULL,'ProfileSelects',12,13), +(NULL,1,'',NULL,'ProfileTables',14,15), +(NULL,1,'',NULL,'SiteConfigs',16,17); /*!40000 ALTER TABLE `acos` ENABLE KEYS */; UNLOCK TABLES; @@ -65,35 +65,35 @@ CREATE TABLE `aros_acos` ( LOCK TABLES `aros_acos` WRITE; /*!40000 ALTER TABLE `aros_acos` DISABLE KEYS */; INSERT INTO `aros_acos` VALUES -(1,1,1,'1','1','1','1'), -(2,1,4,'1','1','1','1'), -(3,2,1,'1','1','1','1'), -(4,2,4,'1','1','1','1'), -(5,2,3,'-1','-1','-1','-1'), -(6,3,1,'-1','-1','-1','-1'), -(7,3,4,'1','1','1','1'), -(8,3,2,'1','1','1','1'), -(9,3,5,'-1','1','-1','1'), -(10,4,4,'1','1','1','1'), -(11,4,2,'1','1','1','1'), -(12,4,1,'-1','-1','-1','-1'), -(13,4,5,'-1','-1','-1','-1'), -(14,5,1,'-1','-1','-1','-1'), -(15,5,4,'1','1','1','1'), -(16,5,5,'-1','-1','-1','-1'), -(17,5,2,'-1','-1','1','-1'), -(18,6,1,'-1','-1','-1','-1'), -(19,7,1,'-1','-1','-1','-1'), -(20,8,1,'-1','-1','-1','-1'), -(21,3,8,'-1','1','-1','-1'), -(22,4,8,'-1','1','-1','-1'), -(23,4,9,'1','1','1','1'), -(24,3,10,'-1','1','-1','-1'), -(25,4,10,'-1','1','-1','-1'), -(26,3,11,'-1','1','-1','-1'), -(27,4,11,'-1','1','-1','-1'), -(28,3,12,'-1','1','-1','-1'), -(29,4,12,'-1','1','-1','-1'), -(30,4,13,'1','1','1','1'); +(NULL,1,1,'1','1','1','1'), +(NULL,1,4,'1','1','1','1'), +(NULL,2,1,'1','1','1','1'), +(NULL,2,4,'1','1','1','1'), +(NULL,2,3,'-1','-1','-1','-1'), +(NULL,3,1,'-1','-1','-1','-1'), +(NULL,3,4,'1','1','1','1'), +(NULL,3,2,'1','1','1','1'), +(NULL,3,5,'-1','1','-1','1'), +(NULL,4,4,'1','1','1','1'), +(NULL,4,2,'1','1','1','1'), +(NULL,4,1,'-1','-1','-1','-1'), +(NULL,4,5,'-1','-1','-1','-1'), +(NULL,5,1,'-1','-1','-1','-1'), +(NULL,5,4,'1','1','1','1'), +(NULL,5,5,'-1','-1','-1','-1'), +(NULL,5,2,'-1','-1','1','-1'), +(NULL,6,1,'-1','-1','-1','-1'), +(NULL,7,1,'-1','-1','-1','-1'), +(NULL,8,1,'-1','-1','-1','-1'), +(NULL,3,8,'-1','1','-1','-1'), +(NULL,4,8,'-1','1','-1','-1'), +(NULL,4,9,'1','1','1','1'), +(NULL,3,10,'-1','1','-1','-1'), +(NULL,4,10,'-1','1','-1','-1'), +(NULL,3,11,'-1','1','-1','-1'), +(NULL,4,11,'-1','1','-1','-1'), +(NULL,3,12,'-1','1','-1','-1'), +(NULL,4,12,'-1','1','-1','-1'), +(NULL,4,13,'1','1','1','1'); /*!40000 ALTER TABLE `aros_acos` ENABLE KEYS */; UNLOCK TABLES; -- 2.11.0