fix #8131 - chinese translations

[Pman.Core] / sql / core_group.sql

diff --git a/sql/core_group.sql b/sql/core_group.sql
index 4cb6d83..57603e3 100644 (file)
--- a/sql/core_group.sql
+++ b/sql/core_group.sql
@@ -9,7 +9,12 @@ CREATE TABLE core_group (
 );
 
 ALTER TABLE core_group ADD COLUMN name varchar(128)  NOT NULL DEFAULT '';
+ALTER TABLE core_group ADD COLUMN display_name varchar(128)  NOT NULL DEFAULT '';
 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 = '';
+UPDATE core_group SET  is_system = 1 WHERE name = 'Administrators';
+
+ALTER TABLE core_group ADD INDEX lookup_leader (leader);
\ No newline at end of file