diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 36 |
1 files changed, 18 insertions, 18 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 6461d015..77e0e819 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -541,10 +541,10 @@ CREATE FOREIGN TABLE priced_orig_ntl( model_version smallint, normalization text, timestamp timestamp, - pv numeric(23,6), - pv_RnW numeric(23,6), - pv_io numeric(23,6), - pv_po numeric(23,6), + pv float, + pv_RnW float, + pv_io float, + pv_po float, modDur float, modDur_io float, modDur_po float, @@ -552,17 +552,17 @@ CREATE FOREIGN TABLE priced_orig_ntl( wal_width float, wal_io float, wal_po float, - delta_hpi numeric(23,6), - delta_ir numeric(23,6), - delta_ir_io numeric(23,6), - delta_ir_po numeric(23,6), - delta_mult numeric(23,6), - delta_yield numeric(23,6), - delta_quantile numeric(23,6), - delta_RnW numeric(23,6), - tot_gamma_hpi numeric(23,6), - tot_gamma_ir numeric(23,6), - tot_gamma numeric(23,6)) + delta_hpi float, + delta_ir float, + delta_ir_io float, + delta_ir_po float, + delta_mult float, + delta_yield float, + delta_quantile float, + delta_RnW float, + tot_gamma_hpi float, + tot_gamma_ir float, + tot_gamma float) SERVER mysql_server OPTIONS (dbname 'rmbs_model'); @@ -591,9 +591,9 @@ CREATE FOREIGN TABLE priced_percentiles_orig_ntl( percentile float, normalization text, timestamp timestamp, - pv numeric(23,6), - pv_io numeric(23,6), - pv_po numeric(23,6), + pv float, + pv_io float, + pv_po float, modDur float, modDur_io float, modDur_po float, |