GEANT/CAT

/*
 * *****************************************************************************
 * Contributions to this work were made on behalf of the GÉANT project, a 
 * project that has received funding from the European Union’s Framework 
 * Programme 7 under Grant Agreements No. 238875 (GN3) and No. 605243 (GN3plus),
 * Horizon 2020 research and innovation programme under Grant Agreements No. 
 * 691567 (GN4-1) and No. 731122 (GN4-2) and from the Horizon Europe programme 
 * under Grant Agreement No: 101100680  (GN5-1).
 * On behalf of the aforementioned projects, GEANT Association is the sole owner
 * of the copyright in all material which was developed by a member of the GÉANT
 * project. GÉANT Vereniging (Association) is registered with the Chamber of 
 * Commerce in Amsterdam with registration number 40535155 and operates in the 
 * UK as a branch of GÉANT Vereniging.
 * 
 * Registered office: Hoekenrode 3, 1102BR Amsterdam, The Netherlands. 
 * UK branch address: City House, 126-130 Hills Road, Cambridge CB2 1PQ, UK
 *
 * License: see the web/copyright.inc.php file in the file structure or
 *          <base_url>/copyright.php after deploying the software
 */

/**
 * Author:  twoln
 * Created: 21 Aug 2023
 */




INSERT INTO profile_option_dict (name, description,type,flag) VALUES 
  ('device-specific:geteduroam','show the dedicated geteduroam download page for this device','boolean', NULL);
ALTER TABLE downloads ADD KEY profile_id (profile_id);
ALTER TABLE downloads ADD KEY device_id (device_id);
ALTER TABLE federation_option RENAME COLUMN row TO row_id;
ALTER TABLE institution_option RENAME COLUMN row TO row_id;
ALTER TABLE profile_option RENAME COLUMN row TO row_id;
ALTER TABLE user_options RENAME COLUMN row TO row_id;