From 26d6f7b4bef504283bf9f2344e094bce1f48f464 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 7 Oct 2016 12:30:44 +0800 Subject: [PATCH] sql/core_groups.sql --- sql/core_groups.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) diff --git a/sql/core_groups.sql b/sql/core_groups.sql index e69de29b..107e132b 100644 --- a/sql/core_groups.sql +++ b/sql/core_groups.sql @@ -0,0 +1,22 @@ + + + +-- used to be Groups .... we will need to flip all old code to use this... + + + +CREATE TABLE Groups ( + id int(11) NOT NULL auto_increment, + PRIMARY KEY (id) +); + +ALTER TABLE Groups ADD COLUMN name varchar(64) NOT NULL DEFAULT ''; +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; + + + -- 2.39.2