From: Steven <steven@roojs.com>
Date: Wed, 1 Aug 2018 04:12:54 +0000 (+0800)
Subject: sql/core_group_member.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=487c548917a1f916ea3377358b5ecdb0893586a3

sql/core_group_member.sql
---

diff --git a/sql/core_group_member.sql b/sql/core_group_member.sql
index 25aefc84..7a0a91c3 100644
--- a/sql/core_group_member.sql
+++ b/sql/core_group_member.sql
@@ -1,12 +1,13 @@
 -- BC name..
- 
+
 CREATE TABLE  core_group_member  (
     id int(11)  NOT NULL AUTO_INCREMENT,
     PRIMARY KEY (id)
 );
 
-ALTER TABLE core_group_member ALTER COLUMN  group_id  group_id int(11) NOT NULL default 0;
+ALTER TABLE core_group_member CHANGE COLUMN  group_id  group_id int(11) NOT NULL default 0;
 ALTER TABLE core_group_member ADD COLUMN  group_id int(11) NOT NULL default 0;
+
 ALTER TABLE core_group_member ADD COLUMN   user_id int(11) NOT NULL default 0;
 
 ALTER TABLE core_group_member ADD UNIQUE KEY  unique_group_user (group_id,user_id);