Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.10 -r1.11
--- lams_common/db/sql/create_lams_11_tables.sql	15 Dec 2004 22:38:06 -0000	1.10
+++ lams_common/db/sql/create_lams_11_tables.sql	16 Dec 2004 06:01:56 -0000	1.11
@@ -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
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/create_lams_db.sql,v
diff -u -r1.4 -r1.5
Binary files differ
Index: lams_common/db/sql/insert_test_data.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_test_data.sql,v
diff -u -r1.3 -r1.4
--- lams_common/db/sql/insert_test_data.sql	16 Dec 2004 03:34:53 -0000	1.3
+++ lams_common/db/sql/insert_test_data.sql	16 Dec 2004 06:02:07 -0000	1.4
@@ -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