From 2a1ab5ecf225c51bba0ee1d5f20f371a4fe37178 Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Thu, 10 Aug 2006 09:07:15 +0000
Subject: [PATCH] name should be unique key, and should be length 255

---
 lib/db/migrate2utf8.xml | 2 +-
 lib/db/mysql.php        | 2 +-
 lib/db/mysql.sql        | 2 +-
 lib/db/postgres7.php    | 2 +-
 lib/db/postgres7.sql    | 2 +-
 5 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/lib/db/migrate2utf8.xml b/lib/db/migrate2utf8.xml
index 7811e61f20..433ab2493f 100755
--- a/lib/db/migrate2utf8.xml
+++ b/lib/db/migrate2utf8.xml
@@ -40,7 +40,7 @@
     
 	<TABLE name="capabilities">
 	  <FIELDS>
-	    <FIELD name="name" method="NO_CONV" type="varchar" length="255" dropindex="name" addindex ="name(name(150))" />
+	    <FIELD name="name" method="NO_CONV" type="varchar" length="255" dropindex="name" adduniqueindex ="name(name(255))" />
 		<FIELD name="captype" method="NO_CONV" type="varchar" length="50" />
 		<FIELD name="component" method="NO_CONV" type="varchar" length="100" />		
       </FIELDS>
diff --git a/lib/db/mysql.php b/lib/db/mysql.php
index 56117a1167..f00004054c 100644
--- a/lib/db/mysql.php
+++ b/lib/db/mysql.php
@@ -2094,7 +2094,7 @@ function main_upgrade($oldversion=0) {
         execute_sql("ALTER TABLE `{$CFG->prefix}role_deny_grant` ADD INDEX `unviewableroleid` (`unviewableroleid`)",true);    
         execute_sql("ALTER TABLE `{$CFG->prefix}role_deny_grant` ADD UNIQUE INDEX `roleid-unviewableroleid` (`roleid`, `unviewableroleid`)",true);         
        
-        execute_sql("ALTER TABLE `{$CFG->prefix}capabilities` ADD INDEX `name` (`name`)",true); 
+        execute_sql("ALTER TABLE `{$CFG->prefix}capabilities` ADD UNIQUE INDEX `name` (`name`)",true); 
                              
         execute_sql("ALTER TABLE `{$CFG->prefix}role_names` ADD INDEX `roleid` (`roleid`)",true);                         
         execute_sql("ALTER TABLE `{$CFG->prefix}role_names` ADD INDEX `contextid` (`contextid`)",true); 
diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql
index 7737809e85..bbb1cc415d 100644
--- a/lib/db/mysql.sql
+++ b/lib/db/mysql.sql
@@ -972,7 +972,7 @@ CREATE TABLE prefix_capabilities (
   `captype` varchar(50) NOT NULL default '', 
   `contextlevel` int(10) unsigned NOT NULL default '0', 
   `component` varchar(100) NOT NULL default '', 
-  KEY `name` (`name`),
+  UNIQUE KEY `name` (`name`),
   PRIMARY KEY (`id`) 
 ) TYPE=MYISAM COMMENT ='this defines all capabilities';
 
diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php
index ab36a4c56a..586249f976 100644
--- a/lib/db/postgres7.php
+++ b/lib/db/postgres7.php
@@ -1696,7 +1696,7 @@ function main_upgrade($oldversion=0) {
         modify_database('',"CREATE INDEX prefix_role_deny_grant_roleid_idx ON prefix_role_deny_grant (roleid);");
         modify_database('',"CREATE INDEX prefix_role_deny_grant_unviewableroleid_idx ON prefix_role_deny_grant (unviewableroleid);");
         modify_database('',"CREATE UNIQUE INDEX prefix_role_deny_grant_roleidunviewableroleid_idx ON prefix_role_deny_grant (roleid, unviewableroleid);");
-        modify_database('',"CREATE INDEX prefix_capabilities_name_idx ON prefix_capabilities (name);");
+        modify_database('',"CREATE UNIQUE INDEX prefix_capabilities_name_idx ON prefix_capabilities (name);");
         modify_database('',"CREATE INDEX prefix_role_names_roleid_idx ON prefix_role_names (roleid);");
         modify_database('',"CREATE INDEX prefix_role_names_contextid_idx ON prefix_role_names (contextid);");
         modify_database('',"CREATE UNIQUE INDEX prefix_role_names_roleidcontextid_idx ON prefix_role_names (roleid, contextid);");     
diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql
index 320081a5e7..9575112309 100644
--- a/lib/db/postgres7.sql
+++ b/lib/db/postgres7.sql
@@ -736,7 +736,7 @@ CREATE TABLE prefix_capabilities (
   contextlevel integer NOT NULL default 0,   
   component varchar(100) NOT NULL default ''     
 );         
-CREATE INDEX prefix_capabilities_name_idx ON prefix_capabilities (name);
+CREATE UNIQUE INDEX prefix_capabilities_name_idx ON prefix_capabilities (name);
 
 CREATE TABLE prefix_role_names (     
   id SERIAL PRIMARY KEY,     
-- 
2.39.5