openphoto/frontend — comment on commit 0c5c6cdf3bce51897af474375ec56afa5b8910cb
File: src/configs/upgrade/db/mysql/mysql-schema-1.0.0.sql line 66
By jmathai:

We've started talking about having to break members out into a separate table. I think we could do something like the following:

CREATE TABLE IF NOT EXISTS `op_group_member` (
`groupId` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`permission` tinyint(3) unsigned NOT NULL COMMENT 'bitmask of permissions',
UNIQUE KEY `groupId` (`groupId`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;