case on update

[Pman.Core] / sql / core_group.sql

diff --git a/sql/core_group.sql b/sql/core_group.sql
index 3bea6f3..8e4cb19 100644 (file)
--- a/sql/core_group.sql
+++ b/sql/core_group.sql
@@ -14,3 +14,6 @@ ALTER TABLE core_group ADD COLUMN type  int(11)  NOT NULL DEFAULT 0;
 ALTER TABLE core_group ADD COLUMN leader int(11)  NOT NULL default 0;
 ALTER TABLE core_group ADD COLUMN is_system int(2) NOT NULL default 0;
 
+UPDATE core_group SET  display_name = name WHERE display_name = '';
+
+ALTER TABLE core_group ADD INDEX lookup_leader (leader);
\ No newline at end of file