The following table outlines the schema changes made in AudienceView Unlimited 7.47.0:
ts_order_admission and ts_order_admission_audit tables |
New column •orderadmission_price_type_allocated |
ts_order_charge and ts_order_charge_audit tables |
New column •ordercharge_perf_alloc_add_incl |
ts_performance_request and ts_performance_request_audit tables |
New column •perfreq_price_type_allocated |
ts_allocation_performance and ts_allocation_performance_audit tables |
New columns •allocperf_price_type_id •allocperf_add_charge1_net •allocperf_add_charge1_net_currency •allocperf_add_charge2_net •allocperf_add_charge2_net_currency •allocperf_add_charge3_net •allocperf_add_charge3_net_currency •allocperf_add_charge4_net •allocperf_add_charge4_net_currency •allocperf_add_charge5_net •allocperf_add_charge5_net_currency •allocperf_incl_charge1_net •allocperf_incl_charge1_net_currency •allocperf_incl_charge2_net •allocperf_incl_charge2_net_currency •allocperf_incl_charge3_net •allocperf_incl_charge3_net_currency •allocperf_incl_charge4_net •allocperf_incl_charge4_net_currency •allocperf_incl_charge5_net •allocperf_incl_charge5_net_currency
Updated columns (to allow NULL) •allocperf_charge1_net •allocperf_charge1_net_currency •allocperf_charge2_net •allocperf_charge2_net_currency •allocperf_charge3_net •allocperf_charge3_net_currency •allocperf_charge4_net •allocperf_charge4_net_currency •allocperf_charge5_net •allocperf_charge5_net_currency
New index •FK_ts_allocation_performance_ts_price_type |
