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

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 11efcfa4..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,8 +185,8 @@ 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);
-ALTER TABLE Person ADD COLUMN   lastname varchar(128);
+ALTER TABLE Person ADD COLUMN   firstname varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN   lastname varchar(128) NOT NULL DEFAULT '';