Index: lams_common/db/sql/updatescripts/alter_201_locale_id.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/updatescripts/Attic/alter_201_locale_id.sql,v diff -u -r1.1 -r1.2 --- lams_common/db/sql/updatescripts/alter_201_locale_id.sql 20 Dec 2006 04:57:28 -0000 1.1 +++ lams_common/db/sql/updatescripts/alter_201_locale_id.sql 26 Feb 2007 23:31:36 -0000 1.2 @@ -4,16 +4,16 @@ -- not only more locales but also to make it a standard datatype ALTER TABLE lams_organisation -CHANGE COLUMN locale_id locale_id SMALLINT; +MODIFY COLUMN locale_id SMALLINT; ALTER TABLE lams_user DROP FOREIGN KEY FK_lams_user_6; ALTER TABLE lams_user -CHANGE COLUMN locale_id locale_id SMALLINT; +MODIFY COLUMN locale_id SMALLINT; ALTER TABLE lams_supported_locale -CHANGE COLUMN locale_id locale_id SMALLINT NOT NULL AUTO_INCREMENT; +MODIFY COLUMN locale_id SMALLINT NOT NULL AUTO_INCREMENT; ALTER TABLE lams_user ADD CONSTRAINT FK_lams_user_6 FOREIGN KEY (locale_id) Index: lams_common/db/sql/updatescripts/alter_201_system_tool_user_workspace.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/updatescripts/Attic/alter_201_system_tool_user_workspace.sql,v diff -u -r1.1 -r1.2 --- lams_common/db/sql/updatescripts/alter_201_system_tool_user_workspace.sql 14 Feb 2007 11:16:01 -0000 1.1 +++ lams_common/db/sql/updatescripts/alter_201_system_tool_user_workspace.sql 26 Feb 2007 23:31:36 -0000 1.2 @@ -7,13 +7,13 @@ WHERE tool_display_name = "Grouping"; ALTER TABLE lams_user -CHANGE COLUMN login varchar(255); +MODIFY COLUMN login varchar(255); ALTER TABLE lams_user ADD COLUMN change_password TINYINT DEFAULT 0; ALTER TABLE lams_workspace_folder -CHANGE COLUMN name name VARCHAR(255) NOT NULL; +MODIFY COLUMN name VARCHAR(255) NOT NULL; UPDATE lams_user SET change_password = 0