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 (