/* $Revision: 1.2.6.3 $ $Date: 2011/01/22 13:53:26 $ $Author: franciscom $ $Name: $ 20101119 - franciscom - fixed missing set INDENTITY_* thanks to contributor */ /* Important Notice: We are updating a column that we have ADDED as part of upgrade. At least for MySQL when this was done inside db_schema_update.sql update was not done. */ UPDATE /*prefix*/req_versions SET log_message='Requirement version migrated from Testlink 1.8.x'; set IDENTITY_INSERT rights on; INSERT INTO /*prefix*/rights (id,description) VALUES (24,'platform_management'); INSERT INTO /*prefix*/rights (id,description) VALUES (25,'platform_view'); INSERT INTO /*prefix*/rights (id,description) VALUES (26,'project_infrastructure_edit'); INSERT INTO /*prefix*/rights (id,description) VALUES (27,'project_infrastructure_view'); set IDENTITY_INSERT rights off; INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (8,24); INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (8,25); INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (8,26); INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (8,27); INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (9,24); INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (9,25); INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (9,26); INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (9,27); INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (6,25); INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (6,27); INSERT INTO /*prefix*/db_version (version,upgrade_ts,notes) VALUES ('DB 1.4',GETDATE(),'');