X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=2fe6146941f7422a5b37385cc89fdc019f3bdae7;hb=89e9b7ee6e68f6fd2a6535039ef708828a346bdd;hp=0ad498e79a06c98379dc7dae5c173f51f51de1ad;hpb=deb5a7a249d2be5b133c1741b4ef21c8df63a257;p=Pman.Core

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 0ad498e7..2fe61469 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -106,12 +106,15 @@ ALTER TABLE core_event_audit ADD COLUMN       old_audit_id int(11)  NOT NULL DEF
 ALTER TABLE core_event_audit ADD COLUMN       newvalue BLOB  NOT NULL DEFAULT '';
 ALTER TABLE core_event_audit ADD   INDEX lookup(event_id, name, old_audit_id);
 
-CREATE TABLE  Group_Members  (
+RENAME TABLE Group_Members group_members;
+CREATE TABLE  group_members  (
     id int(11)  NOT NULL AUTO_INCREMENT,
     PRIMARY KEY (id)
 );
-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;
+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;
+
+
 
 CREATE TABLE  Group_Rights  (
     id int(11)  NOT NULL AUTO_INCREMENT,
@@ -182,6 +185,11 @@ ALTER TABLE Person ADD COLUMN   project_id int(11) default 0;
 ALTER TABLE Person ADD COLUMN   deleted_by INT(11) NOT NULL default 0 ;
 ALTER TABLE Person ADD COLUMN   deleted_dt DATETIME ;
 
+ALTER TABLE Person ADD COLUMN   firstname varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN   lastname varchar(128) NOT NULL DEFAULT '';
+
+
+
 # old mysql
 alter table Person change column active active int(11) NOT NULL DEFAULT 1 ;
 alter table Person change role role varchar(254) NOT NULL DEFAULT '';