DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index ace0c13..44aefd3 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -117,7 +117,7 @@ ALTER TABLE group_members ADD COLUMN  group_id int(11) default NULL;
 ALTER TABLE group_members ADD COLUMN   user_id int(11) NOT NULL default 0;
 
 -- BC name..
-RENAME TABLE Group_Members TO group_rights;
+RENAME TABLE Group_Rights TO group_rights;
 
 
 CREATE TABLE  group_rights  (
@@ -317,14 +317,16 @@ CREATE TABLE   core_enum (
  
 );
  
-alter table  core_enum ADD COLUMN etype varchar(32)  NOT NULL DEFAULT '';
+alter table  core_enum ADD COLUMN  etype varchar(32)  NOT NULL DEFAULT '';
 alter table  core_enum ADD COLUMN  name varchar(255)  NOT NULL DEFAULT '';
-alter table  core_enum ADD COLUMN   active int(2)  NOT NULL DEFAULT 1;
+alter table  core_enum ADD COLUMN  active int(2)  NOT NULL DEFAULT 1;
 alter table  core_enum ADD COLUMN  seqid int(11)  NOT NULL DEFAULT 0;
 alter table  core_enum ADD COLUMN  seqmax int(11)  NOT NULL DEFAULT 0;
+alter table  core_enum ADD COLUMN  display_name varchar(255)  NOT NULL DEFAULT '';
 
 alter table  core_enum ADD  INDEX lookup(seqid, active, name, etype);
- 
+
+UPDATE core_enum SET display_name = name WHERE display_name = '';