[glotpress-updates] [GlotPress] #493: Favorites

[GlotPress]

#493: Favorites
---------------------------+-----------------
  Reporter:  markoheijnen  |      Owner:
      Type:  task          |     Status:  new
  Priority:  normal        |  Milestone:  1.0
 Component:  interface     |    Version:
Resolution:                |   Keywords:
---------------------------+-----------------

Comment (by markoheijnen):

 To store favorites I have the following idea. Build up a new Thing called
 User_Porjects with the following data scheme:

 {{{
 CREATE TABLE `gp_user_projects` (
   `user_id` BIGINT(20) unsigned NOT NULL,
   `project_id` INT(10) NOT NULL,
   `type` VARCHAR(8) NOT NULL,
   PRIMARY KEY (`user_id`,`project_id`),
   UNIQUE KEY `user_project_type` (`user_id`,`project_id`,`type`)
 );
 }}}

 I think we can just delete the primary key on the relation itself. Type
 would be favorite or watch(notifications).

--
Ticket URL: <https://glotpress.trac.wordpress.org/ticket/493#comment:1>
GlotPress <https://glotpress.trac.wordpress.org>
Easy comin', easy goin'