DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 88fd0d6..09bddea 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -43,7 +43,7 @@ ALTER TABLE Companies ALTER url SET DEFAULT '';
 ALTER TABLE Companies ADD COLUMN    address1 text ;
 ALTER TABLE Companies ADD COLUMN    address2 text ;
 ALTER TABLE Companies ADD COLUMN    address3 text ;
-
+ALTER TABLE Companies ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;-- #2028
 
 
 ALTER TABLE Companies ADD INDEX name_lookup (name);
@@ -152,9 +152,11 @@ 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;
+
 ALTER TABLE Groups CHANGE COLUMN type type int(11)  NOT NULL  default 0;