Index: lams_common/db/sql/updatescripts/alter_201_locale_id.sql =================================================================== diff -u -r570bcc3eaf789d638c08cb96e0fec3e4a9ba6167 -r0f0b43e6c8b9f204582d748e78c6e0b6a6003764 --- lams_common/db/sql/updatescripts/alter_201_locale_id.sql (.../alter_201_locale_id.sql) (revision 570bcc3eaf789d638c08cb96e0fec3e4a9ba6167) +++ lams_common/db/sql/updatescripts/alter_201_locale_id.sql (.../alter_201_locale_id.sql) (revision 0f0b43e6c8b9f204582d748e78c6e0b6a6003764) @@ -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 =================================================================== diff -u -r33ea91d27c610597a8ebc896dddcc289b0405b01 -r0f0b43e6c8b9f204582d748e78c6e0b6a6003764 --- lams_common/db/sql/updatescripts/alter_201_system_tool_user_workspace.sql (.../alter_201_system_tool_user_workspace.sql) (revision 33ea91d27c610597a8ebc896dddcc289b0405b01) +++ lams_common/db/sql/updatescripts/alter_201_system_tool_user_workspace.sql (.../alter_201_system_tool_user_workspace.sql) (revision 0f0b43e6c8b9f204582d748e78c6e0b6a6003764) @@ -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