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_items.sql | |
| parent | 999d0ebce6b2f4ba39ee55daa52ca33f5fac657c (diff) | |
| download | minibay-afe377a9b10b5c1b2badc74d4b9b636e7c4d0cbf.tar.gz | |
Add E-R model and SQL bootstrap scripts
Diffstat (limited to 'res/sql/data/orcl_items.sql')
| -rw-r--r-- | res/sql/data/orcl_items.sql | 10 |
1 files changed, 10 insertions, 0 deletions
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 @@ | |||
| 1 | INSERT INTO ITEMS (UUID, USER_UUID, START_DATE, END_DATE, ITEM_NAME, SHORT_DESC, LONG_DESC, INITIAL_PRICE) VALUES | ||
| 2 | ('0C98CCCC-21A5-C9B1-E050-D7936EBE02BF', '0C99BEF9-375F-3E4A-E050-D7936EBE2782', | ||
| 3 | TO_TIMESTAMP_TZ('2013-03-15 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), | ||
| 4 | TO_TIMESTAMP_TZ('2013-07-01 23:59:59.999999', 'YYYY-MM-DD Hh24:MI:SS.FF'), 'Audi A3', 'Voiture', | ||
| 5 | 'Bonne voiture bon état pas cher', 12900.00); | ||
| 6 | INSERT INTO ITEMS (UUID, USER_UUID, START_DATE, END_DATE, ITEM_NAME, SHORT_DESC, LONG_DESC, INITIAL_PRICE) VALUES | ||
| 7 | ('0C98CCCC-219B-C9B1-E050-D7936EBE02BF', '0C99BEF9-3760-3E4A-E050-D7936EBE2782', | ||
| 8 | TO_TIMESTAMP_TZ('2013-04-25 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), | ||
| 9 | TO_TIMESTAMP_TZ('2013-05-25 23:59:59.999999', 'YYYY-MM-DD Hh24:MI:SS.FF'), 'Harley-Davidson', 'Moto', | ||
| 10 | 'Alors une moto ça roule sur deux roues.', 25000.00); | ||