From ea4f185d1fbe2bc363523aa5b89ed503383972ff Mon Sep 17 00:00:00 2001
From: rub <rub@piwigo.org>
Date: Thu, 19 Apr 2007 20:40:38 +0000
Subject: git-svn-id: http://piwigo.org/svn/trunk@1963
 68402e56-0260-453c-a942-63ccdbb3a9ee

---
 install/phpwebgallery_structure.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'install/phpwebgallery_structure.sql')

diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index 651154cae..24e69005c 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -105,7 +105,8 @@ CREATE TABLE `phpwebgallery_groups` (
   `id` smallint(5) unsigned NOT NULL auto_increment,
   `name` varchar(255) NOT NULL default '',
   `is_default` enum('true','false') NOT NULL default 'false',
-  PRIMARY KEY  (`id`)
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `groups_ui1` (`name`)
 ) TYPE=MyISAM;
 
 --
-- 
cgit v1.2.3

