[tinderbox-cvs] cvs commit: portstools/tinderbox/sql schema.mysql.pre schema.pgsql.pre portstools/tinderbox/webui index.php portstools/tinderbox/webui/module moduleUsers.php portstools/tinderbox/webui/templates/paefchen user_admin.tpl

[Beat Gaetzi]

beat        2008-09-23 22:41:27 UTC

  MarcusCom CVS repository

  Modified files:
    tinderbox/sql        schema.mysql.pre schema.pgsql.pre 
    tinderbox/webui      index.php 
    tinderbox/webui/module moduleUsers.php 
    tinderbox/webui/templates/paefchen user_admin.tpl 
  Log:
  Reintroduce user permissions functionality in the webui from 2.x back
  into HEAD. The primary key on user_permissions needs to be dropped and
  recreated.
  
  mysql:
  ALTER TABLE user_permissions DROP PRIMARY KEY;
  ALTER TABLE user_permissions ADD PRIMARY KEY
      (user_id, user_permission_object_type,
      user_permission_object_id,user_permission);
  
  pgsql:
  ALTER TABLE user_permissions DROP CONSTRAINT user_permissions_pkey;
  ALTER TABLE user_permissions ADD CONSTRAINT user_permissions_pkey
      PRIMARY KEY (user_id, user_permission_object_type,
      user_permission_object_id, user_permission);
  
  Requested/tested by:    miwi
  
  Revision  Changes    Path
  1.70      +1 -1      portstools/tinderbox/sql/schema.mysql.pre
  1.48      +1 -1      portstools/tinderbox/sql/schema.pgsql.pre
  1.29      +7 -5      portstools/tinderbox/webui/index.php
  1.20      +37 -3     portstools/tinderbox/webui/module/moduleUsers.php
  1.3       +1 -0      portstools/tinderbox/webui/templates/paefchen/user_admin.tpl