Changes in the DB Schema.

The following table presents a relation between the version FTS and DB versions, as well as the list of changes in each new schema version.

Schema Version FTS Release Notes (known and fixed bugs, etc)
2.0.0 1.3 - Bug #10060 (affect only oracle schema)
2.0.1 1.3 QF 01 - Fix bug #10060: upgrade script is oracle-upgrade_2.0.0-2.0.1.sql
2.1.0 1.4 - Add t_agent and statistics tables.
- Upgrade for oracle from 2.0.0 and 2.0.1 is available through the script oracle-upgrade_2.0.0-2.1.0.sql
(patch fix in oracle-upgrade_2.0.0-2.1.0-fix.sql)
2.2.0 1.5 - Add t_credential, t_credential_cache table
- Alter t_job, t_file t_transfer_period_stats with a couple new columns
- Upgrade for oracle from 2.1.0 is available through the script oracle-upgrade_2.1.0-2.2.0.sql
2.2.1 1.5.1 - Add indicies on f_file,t_job and t_transfert tables to improve
performances. Indices have been suggested by M. Anjo
- Upgrade for oracle from 2.2.0 is available through the script oracle-upgrade_2.2.0-2.2.1.sql
3.0.0 2.0 - Modify t_channel, t_channel_vo_share, t_job, t_file, t_transfer tables adding extra parameters
- Add t_stage_req table and indices
- Add the t_audit_channel table, auti_inc sequence and indices
- Add the t_bad_ses table, auto_inc sequence and indices
- Add the t_transfer_extra table, auto_inc sequence and indices
- Drop the t_transfer_cumulative_stats and t_transfer_period stats table
- Drop t_credential and t_credential_cache tables:
the schema of delegation-interface provides the delegation schema now.
- Drop the unused t_trace table
- Drop the MySQL schema
- Upgrade is available using:oracle-upgrade_2.2.1-3.0.0.sql
3.1.0 XXX - Add the t_site_group_table
- Add the column t_schema_vers.state
- Add the following columns to t_channel: blocksize,http_to,tx_loglevel,urlcopy_put_to,
urlcopy_putdone_to,urlcopy_get_to,urlcopy_gettdone_to,urlcopy_tx_to,urlcopy_txmarks_to,
srmcopy_direction,srmcopy_to,srmcopy_refresh_to
- Add the following columns to t_job: job_finished
- Add the following columns to t_file: job_finished, error_scope, error_phase
- Add the following columns to t_transfer: job_finished, error_scope, error_phase, finish_time
- Add the following columns to t_stage_req: job_finished, error_scope, error_phase, finish_time
- Add the trigger to set the job_finished time in t_job, t_file, t_transfer, t_stage_req
- Upgrade is available using: oracle-upgrade_3.0.0-3.1.0.sql
3.2.0 2.1 - Add the following columns to t_job:
source_space_token:token
source_token_description:token due to the legacy code using token as a description in fact
- Add the following columns to t_channel:
target_dir_check:boolean -
url_copy_first_txmark_to:seconds
transfer_type with check constraint: varchar(15) with check constraint for URLCOPY and SRMCOPY values
- Upgrade is available using:oracle-upgrade_3.1.0-3.2.0.sql
3.3.0 2.1 - Add the following colums to t_channel:tx_to_per_mb,no_tx_activity_to,preparing_files_ratio
- Modified constraint in t_channel for check_transfer_type, valid values: URLCOPY,SRMCOPY,STUB
- Add the following columns to t_job: copy_pin_lifetime,lan_connection,fail_nearline
- Add the following columns to the t_audit_channel: se_limit.channel_type,blocksize,http_to,tx_loglevel,
urlcopy_put_to, urlcopy_putdone_to, urlcopy_get_to, urlcopy_getdone_to, urlcopy_tx_to,
urlcopy_txmarks_to, srmcopy_direction, srmcopy_to, srmcopy_refresh_to, target_dir_check,
url_copy_first_txmark_to, transfer_type, tx_to_per_mb, no_tx_activity_to, preparing_files_ratio
- Upgrade is available using: oracle-upgrade_3.2.0-3.3.0.sql
3.4.0 2.2 - Add the history package into the schema:
- Add the following tables: t_job_history, t_file_history, t_transfer_history.
- Add temporary tables: x_fileids, x_jobids
- Add the following columns to t_history_log:finishtime,jobs,files,transfers,errcode,errmsg
- Add the tables used by the purge package:t_history_purge_log,x_purge_jobids,x_purge_fileids.
- Add tables to register the plugins: t_fts_plugin, t_fts_plugin_schema
- Drop the indexes channel_vo_share_channel_name,channel_acl_channel_name,vo_acl_vo_name,site_group_gname_id,
file_file_state,transfer_request_id,stagereq_unique_idx
- Add some constrains
- Upgrade is available using: oracle-upgrade_3.3.0-3.4.0.sql
3.4.1 2.2.1 - Add the following column to t_job and t_job_history: checksum_method
- Upgrade is available using: oracle-upgrade_3.4.0-3.4.1.sql
3.5.0 2.3 - Add the tables t_se and t_se_acl in order to replace the the service discovering mechanism.
- Upgrade is available using: oracle-upgrade_3.4.1-3.5.0.sql

-- Main.RosaGarciaRioja - 13 Jul 2009

Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r4 - 2010-02-17 - unknown
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    EGEE All webs login

This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright & by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Ask a support question or Send feedback