From 487c548917a1f916ea3377358b5ecdb0893586a3 Mon Sep 17 00:00:00 2001 From: Steven Date: Wed, 1 Aug 2018 12:12:54 +0800 Subject: [PATCH] sql/core_group_member.sql --- sql/core_group_member.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) 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); -- 2.39.2