X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=9f9750e1cd695e221648a19740a31b8ea9c221de;hp=b1695a15ed1e7243a1ae57ba1de6e344b4fd114d;hb=c729c6b46027e1bd8b94b314d229beee261ef79e;hpb=2e520047e2453794b4f82c0f88ea54c23b95562c

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index b1695a15..9f9750e1 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -152,10 +152,10 @@ CREATE TABLE Groups (
 );
 
 ALTER TABLE Groups ADD COLUMN name varchar(64)  NOT NULL DEFAULT '';
-ALTER TABLE Groups ADD COLUMN   type int(11) default NOT NULL DEFAULT 0;
+ALTER TABLE Groups ADD COLUMN   type int(11)  NOT NULL DEFAULT 0;
 ALTER TABLE Groups ADD COLUMN leader int(11)  NOT NULL default 0;
 #old mysql..
-update groups set type=0 where type is null;
+update Groups set type=0 where type is null;
 
 ALTER TABLE Groups CHANGE COLUMN type type int(11)  NOT NULL  default 0;