Compatibility Changes

Compatibility Changes

Database schema

NOTE: when using the new project system, schema migration happens automatically unless specified below.

Version 1 (around r6941)

• Admin ids need to be updated.
  You can run:
  

  
  
  sy -cPROJECT db_shell ‘UPDATE t063_web_pages SET id=17732923532771328 WHERE id=177329235327713281;UPDATE t063_web_pages SET id=17732923532771329 WHERE id=177329235327713282;UPDATE t063_web_pages SET id=17732923532771330 WHERE id=177329235327713283;UPDATE 
  
  t063_web_pages SET up_id=17732923532771328 WHERE up_id=177329235327713281;’
  
  

  
  Then, you need to regenerate the Apache configuration with system_install.

• New t086_pt_services_configurations table created from t025_sites.

Copy the following columns: name online_booking use_old_data max_connections use_dates_range periods display_road_approach_detail

WARNING: this must be done before Synthese is launched, otherwise it will delete the missing columns from t025_sites.

Version 0 (r6775)

• r6775: passwords are now stored hashed in the database (only for updated or new users). The change is transparent unless you depend on having cleartext passwords in the database.

Other

• r9866 : CommercialLine output : <@color@> is now equal to <@xmlColor@>, to get the same value as before use <@line_color@>
• r7613: require.js was update to version 2.0 in order to fix an issue with IE. You need to change your projects in the following way:
  • Remove the “order!” prefix from dependencies: for instance, change "order!map/js/legacy/app.Gis" to "map/js/legacy/app.Gis"
  • The dependency "core/js/backbone" is renamed to @"backbone", "order!core/vendor/jquery-1.7.1.min" to "jquery", "order!core/vendor/jquery.tmpl.beta1.min" to "jquery.tmpl".
  • The old jquery 1.6 was removed. You need to run the “load_data” command to update the admin template.
  • You should increment the data-version attribute so that the new JS are forced to be fetched.

• r6941: PTRoutePlannerInputFunction service: replace site parameter with config_id and adjust the id (from the t086_pt_services_configurations table).

• r6676: move departure/arrival/connection png files to files_local folder [Map package]
  After updating Map package run load_data and load_local_data command

To be done in the futures

Schema

• t025_sites: rename column cient_url to client_url
• t007_connection_place: convert connection_type from integer to boolean.

• rename t009_lines to t009_journey_patterns (or the new name of JourneyPatter if renamed)
• rename t012_physical_stops to t012_stop_points (or the new name of StopPoint if renamed)
• rename t063_web_pages to t063_webpages

• rename t014_road_chunks.address_id to t014_road_chunks.crossing_id