Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -rbaa2dacb7b58a7543652a196e880d3f4a060c6cb -r82e1c646c21417c7d329bc953489458a141168b3
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision baa2dacb7b58a7543652a196e880d3f4a060c6cb)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 82e1c646c21417c7d329bc953489458a141168b3)
@@ -87,12 +87,13 @@
 CREATE TABLE lams_authentication_method (
        authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
      , authentication_method_type_id INT(3) NOT NULL DEFAULT 0
-     , parameters_file_name VARCHAR(255) NOT NULL
+     , authentication_method_name VARCHAR(255) NOT NULL
      , 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 AUTO_INCREMENT
Index: lams_common/db/sql/create_lams_db.sql
===================================================================
diff -u -rbaa2dacb7b58a7543652a196e880d3f4a060c6cb -r82e1c646c21417c7d329bc953489458a141168b3
--- lams_common/db/sql/create_lams_db.sql	(.../create_lams_db.sql)	(revision baa2dacb7b58a7543652a196e880d3f4a060c6cb)
+++ lams_common/db/sql/create_lams_db.sql	(.../create_lams_db.sql)	(revision 82e1c646c21417c7d329bc953489458a141168b3)
@@ -147,12 +147,13 @@
 CREATE TABLE lams_authentication_method (
        authentication_method_id BIGINT(20) NOT NULL DEFAULT 0
      , authentication_method_type_id INT(3) NOT NULL DEFAULT 0
-     , parameters_file_name VARCHAR(255) NOT NULL
+     , authentication_method_name VARCHAR(255) NOT NULL
      , 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);
 
 DROP TABLE IF EXISTS lams_workspace_folder;
 CREATE TABLE lams_workspace_folder (
Index: lams_common/db/sql/insert_test_data.sql
===================================================================
diff -u -r8e8dac6e21d8a75e8aeafb30fc916141ffbde5c3 -r82e1c646c21417c7d329bc953489458a141168b3
--- lams_common/db/sql/insert_test_data.sql	(.../insert_test_data.sql)	(revision 8e8dac6e21d8a75e8aeafb30fc916141ffbde5c3)
+++ lams_common/db/sql/insert_test_data.sql	(.../insert_test_data.sql)	(revision 82e1c646c21417c7d329bc953489458a141168b3)
@@ -32,8 +32,8 @@
 INSERT INTO lams_user_organisation_role VALUES (13, 5, 5);
 INSERT INTO lams_user_organisation_role VALUES (14, 6, 3);
 
-INSERT INTO lams_authentication_method VALUES (1, 'LAMS-Database', 1);
-INSERT INTO lams_authentication_method VALUES (2, 'Oxford-WebAuth', 2);
-INSERT INTO lams_authentication_method VALUES (3, 'MQ-LDAP', 3);
+INSERT INTO lams_authentication_method VALUES (1, 1, 'LAMS-Database');
+INSERT INTO lams_authentication_method VALUES (2, 2, 'Oxford-WebAuth');
+INSERT INTO lams_authentication_method VALUES (3, 3, 'MQ-LDAP');
 
 SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file