Commit emails of the iDok project

["AFS account Florian Huebner" <huebner AT savannah.psi.ch>]

Author: huebner
Date: Mon Apr 27 16:11:21 2009
New Revision: 359

Log:
Increased the length of the group/user names from 32 to 256 characters 

Modified:
   trunk/java/ch/idok/service/server/admin/PermissionRoleDBAdapter.java

Modified: trunk/java/ch/idok/service/server/admin/PermissionRoleDBAdapter.java
==============================================================================
--- trunk/java/ch/idok/service/server/admin/PermissionRoleDBAdapter.java      
  (original)
+++ trunk/java/ch/idok/service/server/admin/PermissionRoleDBAdapter.java      
  Mon Apr 27 16:11:21 2009
@@ -264,11 +264,11 @@
             conn.setAutoCommit(false);
             Statement s = conn.createStatement();
             s
-                    .execute("CREATE TABLE policy (id SMALLINT NOT NULL 
GENERATED ALWAYS AS IDENTITY PRIMARY KEY, name VARCHAR(32) NOT NULL, task 
VARCHAR(256) NOT NULL, action VARCHAR(256) NOT NULL, CONSTRAINT 
name_task_unique UNIQUE (name, task))");
+                    .execute("CREATE TABLE policy (id SMALLINT NOT NULL 
GENERATED ALWAYS AS IDENTITY PRIMARY KEY, name VARCHAR(256) NOT NULL, task 
VARCHAR(256) NOT NULL, action VARCHAR(256) NOT NULL, CONSTRAINT 
name_task_unique UNIQUE (name, task))");
             s.execute("INSERT INTO policy (name,task,action) VALUES ('"
                     + adminName + "','<admin>','admin')");
             s
-                    .execute("CREATE TABLE group_membership (id SMALLINT NOT 
NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY, name VARCHAR(32) NOT NULL, 
in_group VARCHAR(256) NOT NULL, CONSTRAINT unique_membership UNIQUE (name, 
in_group))");
+                    .execute("CREATE TABLE group_membership (id SMALLINT NOT 
NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY, name VARCHAR(256) NOT NULL, 
in_group VARCHAR(256) NOT NULL, CONSTRAINT unique_membership UNIQUE (name, 
in_group))");
             s.close();
             conn.commit();
         } catch (SQLException e) {