From 547a25e36d480afd18409901b6330be35e4ba431 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Mon, 9 Dec 2013 15:36:30 +0800
Subject: [PATCH] DataObjects/core.sql

---
 DataObjects/core.sql | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 88fd0d6b..b1695a15 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -155,6 +155,8 @@ 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 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;
 
 
-- 
2.39.2