sql/core_group_member.sql

[Pman.Core] / sql / core_group_member.sql

diff --git a/sql/core_group_member.sql b/sql/core_group_member.sql
index 8375324..ea1ea03 100644 (file)
--- a/sql/core_group_member.sql
+++ b/sql/core_group_member.sql
@@ -4,7 +4,9 @@ CREATE TABLE  core_group_member  (
     id int(11)  NOT NULL AUTO_INCREMENT,
     PRIMARY KEY (id)
 );
-ALTER TABLE core_group_member ADD COLUMN  group_id int(11) default NULL;
+
+ALTER TABLE core_group_member ALTER 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 ADD UNIQUE KEY `unique_group_user` (`group_id`,`user_id`);
+ALTER TABLE core_group_member ADD UNIQUE KEY  `unique_group_user` (`group_id`,`user_id`);