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

After further consideration:

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