DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 2b5fd6b..9f9750e 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -29,8 +29,8 @@ ALTER TABLE Companies ADD COLUMN    country varchar(4) NOT NULL DEFAULT '';
 
 
 ALTER TABLE Companies ADD COLUMN    comptype varchar(32)  NOT NULL DEFAULT '';
--- not sure if this needs to change..
---ALTER TABLE Companies ADD COLUMN    comptype_id INT(11) DEFAULT 0;
+-- not sure if this needs to change.. << there is code in core/update that fills this in??
+ALTER TABLE Companies ADD COLUMN    comptype_id INT(11) DEFAULT 0;
 
 
 ALTER TABLE Companies CHANGE COLUMN isOwner isOwner int(11);
@@ -152,10 +152,12 @@ CREATE TABLE Groups (
 );
 
 ALTER TABLE Groups ADD COLUMN name varchar(64)  NOT NULL DEFAULT '';
-ALTER TABLE Groups ADD COLUMN   type int(11) default NULL ;
+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..
-ALTER TABLE Groups CHANGE COLUMN type type int(11) default 0;
+update Groups set type=0 where type is null;
+
+ALTER TABLE Groups CHANGE COLUMN type type int(11)  NOT NULL  default 0;