diff options
| author | Pacien TRAN-GIRARD | 2015-01-27 18:01:45 +0100 |
|---|---|---|
| committer | Pacien TRAN-GIRARD | 2015-01-27 18:27:51 +0100 |
| commit | afe377a9b10b5c1b2badc74d4b9b636e7c4d0cbf (patch) | |
| tree | e6808c16b8bf7b7a2cd79435706465181cbe4295 /res/sql/data/orcl_charges.sql | |
| parent | 999d0ebce6b2f4ba39ee55daa52ca33f5fac657c (diff) | |
| download | minibay-afe377a9b10b5c1b2badc74d4b9b636e7c4d0cbf.tar.gz | |
Add E-R model and SQL bootstrap scripts
Diffstat (limited to 'res/sql/data/orcl_charges.sql')
| -rw-r--r-- | res/sql/data/orcl_charges.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/res/sql/data/orcl_charges.sql b/res/sql/data/orcl_charges.sql new file mode 100644 index 0000000..bb8d99d --- /dev/null +++ b/res/sql/data/orcl_charges.sql | |||
| @@ -0,0 +1,6 @@ | |||
| 1 | INSERT INTO CHARGES (UUID, START_DATE, END_DATE, FEE, RATE) VALUES | ||
| 2 | ('0CA2E8F1-D1EF-49B7-E050-D7936EBE6A05', TO_TIMESTAMP_TZ('2013-01-01 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), | ||
| 3 | TO_TIMESTAMP_TZ('2013-12-31 23:59:59.999999', 'YYYY-MM-DD Hh24:MI:SS.FF'), 4.00, 0.25); | ||
| 4 | INSERT INTO CHARGES (UUID, START_DATE, END_DATE, FEE, RATE) VALUES | ||
| 5 | ('0CA2E8F1-D1F0-49B7-E050-D7936EBE6A05', TO_TIMESTAMP_TZ('2014-01-01 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), | ||
| 6 | TO_TIMESTAMP_TZ('2014-12-31 23:59:59.999999', 'YYYY-MM-DD Hh24:MI:SS.FF'), 4.20, 0.27); | ||