Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -r7b9909ff988dfc3ad341f4c43963db8532244f95 -r704ffe88014bad57c95df909b0d78f6c81842d99
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 7b9909ff988dfc3ad341f4c43963db8532244f95)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 704ffe88014bad57c95df909b0d78f6c81842d99)
@@ -77,12 +77,14 @@
 
 CREATE TABLE lams_authentication_method (
        authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
+     , authentication_method_name VARCHAR(64) NOT NULL
      , authentication_method_type_id INT(3) NOT NULL DEFAULT 0
      , PRIMARY KEY (authentication_method_id)
      , INDEX (authentication_method_type_id)
      , CONSTRAINT FK_lams_authorization_method_1 FOREIGN KEY (authentication_method_type_id)
                   REFERENCES lams_authentication_method_type (authentication_method_type_id) ON DELETE NO ACTION ON UPDATE NO ACTION
 )TYPE=InnoDB;
+CREATE UNIQUE INDEX UQ_lams_authentication_method_name ON lams_authentication_method (authentication_method_name ASC);
 
 CREATE TABLE lams_workspace_folder (
        workspace_folder_id BIGINT(20) NOT NULL DEFAULT 0
@@ -409,14 +411,3 @@
                   REFERENCES lams_group (group_id)
 )TYPE=InnoDB;
 
-CREATE TABLE lams_authentication_method_parameter (
-       authentication_parameter_id BIGINT(20) NOT NULL DEFAULT 0
-     , authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
-     , name VARCHAR(128) NOT NULL
-     , value VARCHAR(255)
-     , PRIMARY KEY (authentication_parameter_id)
-     , INDEX (authentication_method_id)
-     , CONSTRAINT FK_lams_authorization_method_parameter_1 FOREIGN KEY (authentication_method_id)
-                  REFERENCES lams_authentication_method (authentication_method_id) ON DELETE NO ACTION ON UPDATE NO ACTION
-)TYPE=InnoDB;
-