MOVED sql/group_members.sql to sql/core_group_member.sql
authorAlan Knowles <alan@roojs.com>
Fri, 7 Oct 2016 05:37:16 +0000 (13:37 +0800)
committerAlan Knowles <alan@roojs.com>
Fri, 7 Oct 2016 05:37:16 +0000 (13:37 +0800)
sql/core_group_member.sql [new file with mode: 0644]

diff --git a/sql/core_group_member.sql b/sql/core_group_member.sql
new file mode 100644 (file)
index 0000000..d9bff83
--- /dev/null
@@ -0,0 +1,11 @@
+-- BC name..
+RENAME TABLE Group_Members TO group_members;
+
+CREATE TABLE  group_members  (
+    id int(11)  NOT NULL AUTO_INCREMENT,
+    PRIMARY KEY (id)
+);
+ALTER TABLE group_members ADD COLUMN  group_id int(11) default NULL;
+ALTER TABLE group_members ADD COLUMN   user_id int(11) NOT NULL default 0;
+
\ No newline at end of file