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_items.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 res/sql/data/orcl_items.sql

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

diff --git a/res/sql/data/orcl_items.sql b/res/sql/data/orcl_items.sql
new file mode 100644
index 0000000..ab17157
--- /dev/null
+++ b/res/sql/data/orcl_items.sql
@@ -0,0 +1,10 @@
+INSERT INTO ITEMS (UUID, USER_UUID, START_DATE, END_DATE, ITEM_NAME, SHORT_DESC, LONG_DESC, INITIAL_PRICE) VALUES
+  ('0C98CCCC-21A5-C9B1-E050-D7936EBE02BF', '0C99BEF9-375F-3E4A-E050-D7936EBE2782',
+   TO_TIMESTAMP_TZ('2013-03-15 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'),
+   TO_TIMESTAMP_TZ('2013-07-01 23:59:59.999999', 'YYYY-MM-DD Hh24:MI:SS.FF'), 'Audi A3', 'Voiture',
+   'Bonne voiture bon état pas cher', 12900.00);
+INSERT INTO ITEMS (UUID, USER_UUID, START_DATE, END_DATE, ITEM_NAME, SHORT_DESC, LONG_DESC, INITIAL_PRICE) VALUES
+  ('0C98CCCC-219B-C9B1-E050-D7936EBE02BF', '0C99BEF9-3760-3E4A-E050-D7936EBE2782',
+   TO_TIMESTAMP_TZ('2013-04-25 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'),
+   TO_TIMESTAMP_TZ('2013-05-25 23:59:59.999999', 'YYYY-MM-DD Hh24:MI:SS.FF'), 'Harley-Davidson', 'Moto',
+   'Alors une moto ça roule sur deux roues.', 25000.00);
-- 
cgit v1.2.3