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.3 -r1.4
--- lams_common/db/sql/create_lams_11_tables.sql	29 Nov 2004 03:32:28 -0000	1.3
+++ lams_common/db/sql/create_lams_11_tables.sql	2 Dec 2004 06:20:49 -0000	1.4
@@ -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;
-