[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-10-05 10:37:19 UTC

  MarcusCom CVS repository

  Modified files:        (Branch: TINDERBOX_3_X)
    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:
  MFH:
  
  Reintroduce user permissions functionality in the webui from 2.x.
  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);
  
  Revision  Changes    Path
  1.68.2.1  +1 -1      portstools/tinderbox/sql/schema.mysql.pre
  1.45.2.2  +1 -1      portstools/tinderbox/sql/schema.pgsql.pre
  1.24.2.1  +8 -6      portstools/tinderbox/webui/index.php
  1.19.2.1  +37 -3     portstools/tinderbox/webui/module/moduleUsers.php
  1.1.2.1   +1 -0      portstools/tinderbox/webui/templates/paefchen/user_admin.tpl