[wp-meta] [Making WordPress.org] #1240: Change storage of per-project permissions

[Making WordPress.org]

#1240: Change storage of per-project permissions
----------------------+-------------------------------------
  Reporter:  ocean90  |      Owner:  ocean90
      Type:  defect   |     Status:  assigned
  Priority:  high     |  Component:  translate.wordpress.org
Resolution:           |   Keywords:
----------------------+-------------------------------------

Comment (by ocean90):

 Related: #1398

 Current plan is to use the new table only for project translation editors.
 Schema:

 {{{
 CREATE TABLE `translate_translation_editors` (
   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
   `user_id` bigint(20) unsigned NOT NULL,
   `project_id` int(10) NOT NULL,
   `locale` varchar(255) NOT NULL DEFAULT '',
   `locale_slug` varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   UNIQUE KEY `user_project_id` (`user_id`, `project_id`,
 `locale`,`locale_slug`),
   KEY `locale` (`locale`, `locale_slug`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 }}}


 To handle General Translation Editors a new role will be introduced.

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/1240#comment:9>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org