From c729c6b46027e1bd8b94b314d229beee261ef79e Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 9 Dec 2013 15:51:07 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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; -- 2.39.2