TWiki>
EGEE Web>EGEEgLite>DataManagement>FTS>FtsInternalDocumentation>DBSchemaChanges (2010-02-17, unknown)
EditAttachPDF
EGEE Web>EGEEgLite>DataManagement>FTS>FtsInternalDocumentation>DBSchemaChanges (2010-02-17, unknown) EditAttachPDFChanges 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 |
- EGEE Web
- EGEE Web Home
- gLite
- ProductTeams
- SA3
- JRA1
- TMB
- EMT
- SA1
- SA2
- NA2
- NA4
- EGEE-UIG
- List of registered projects
- List of EGEE-RP interactions
- Changes
- Index
- Search
Main.WebList
 |
|
Copyright &© 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