From afe377a9b10b5c1b2badc74d4b9b636e7c4d0cbf Mon Sep 17 00:00:00 2001
From: Pacien TRAN-GIRARD
Date: Tue, 27 Jan 2015 18:01:45 +0100
Subject: Add E-R model and SQL bootstrap scripts

---
 res/sql/data/orcl_charges.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 res/sql/data/orcl_charges.sql

(limited to 'res/sql/data/orcl_charges.sql')

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 @@
+INSERT INTO CHARGES (UUID, START_DATE, END_DATE, FEE, RATE) VALUES
+  ('0CA2E8F1-D1EF-49B7-E050-D7936EBE6A05', TO_TIMESTAMP_TZ('2013-01-01 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'),
+   TO_TIMESTAMP_TZ('2013-12-31 23:59:59.999999', 'YYYY-MM-DD Hh24:MI:SS.FF'), 4.00, 0.25);
+INSERT INTO CHARGES (UUID, START_DATE, END_DATE, FEE, RATE) VALUES
+  ('0CA2E8F1-D1F0-49B7-E050-D7936EBE6A05', TO_TIMESTAMP_TZ('2014-01-01 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'),
+   TO_TIMESTAMP_TZ('2014-12-31 23:59:59.999999', 'YYYY-MM-DD Hh24:MI:SS.FF'), 4.20, 0.27);
-- 
cgit v1.2.3

