diff options
Diffstat (limited to 'res/sql/data/orcl_transactions.sql')
| -rw-r--r-- | res/sql/data/orcl_transactions.sql | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/res/sql/data/orcl_transactions.sql b/res/sql/data/orcl_transactions.sql new file mode 100644 index 0000000..fe52e15 --- /dev/null +++ b/res/sql/data/orcl_transactions.sql | |||
| @@ -0,0 +1,38 @@ | |||
| 1 | INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES | ||
| 2 | ('0C98CCCC-219C-C9B1-E050-D7936EBE02BF', '0C99BEF9-375F-3E4A-E050-D7936EBE2782', | ||
| 3 | TO_TIMESTAMP_TZ('2013-01-01 08:39:34.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 18000.00, 'VIR'); | ||
| 4 | INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES | ||
| 5 | ('0C98CCCC-219D-C9B1-E050-D7936EBE02BF', '0C99BEF9-375F-3E4A-E050-D7936EBE2782', | ||
| 6 | TO_TIMESTAMP_TZ('2013-05-02 08:47:26.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 9500.00, 'VIR'); | ||
| 7 | INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES | ||
| 8 | ('0C98CCCC-219F-C9B1-E050-D7936EBE02BF', '0C99BEF9-3762-3E4A-E050-D7936EBE2782', | ||
| 9 | TO_TIMESTAMP_TZ('2013-03-01 08:50:15.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 30000.00, 'VIR'); | ||
| 10 | |||
| 11 | |||
| 12 | -- transactions for sales | ||
| 13 | |||
| 14 | INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES | ||
| 15 | ('0DA506A8-8E2F-EF92-E050-D7936EBE4603', '0C99BEF9-375F-3E4A-E050-D7936EBE2782', | ||
| 16 | TO_TIMESTAMP_TZ('2013-05-26 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), - 26000.00, | ||
| 17 | 'PURCHASE 0C98CCCC-219B-C9B1-E050-D7936EBE02BF'); | ||
| 18 | INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES | ||
| 19 | ('0DA506A8-8E30-EF92-E050-D7936EBE4603', '0C99BEF9-375F-3E4A-E050-D7936EBE2782', | ||
| 20 | TO_TIMESTAMP_TZ('2013-05-26 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), - 6504.00, | ||
| 21 | 'CHARGES 0C98CCCC-219B-C9B1-E050-D7936EBE02BF'); | ||
| 22 | INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES | ||
| 23 | ('0DA506A8-8E31-EF92-E050-D7936EBE4603', '0C99BEF9-3760-3E4A-E050-D7936EBE2782', | ||
| 24 | TO_TIMESTAMP_TZ('2013-05-26 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 26000.00, | ||
| 25 | 'SALE 0C98CCCC-219B-C9B1-E050-D7936EBE02BF'); | ||
| 26 | |||
| 27 | INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES | ||
| 28 | ('0DA506A8-8E32-EF92-E050-D7936EBE4603', '0C99BEF9-3762-3E4A-E050-D7936EBE2782', | ||
| 29 | TO_TIMESTAMP_TZ('2013-07-02 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), - 12900.00, | ||
| 30 | 'PURCHASE 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF'); | ||
| 31 | INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES | ||
| 32 | ('0DA506A8-8E33-EF92-E050-D7936EBE4603', '0C99BEF9-3762-3E4A-E050-D7936EBE2782', | ||
| 33 | TO_TIMESTAMP_TZ('2013-07-02 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), - 3229.00, | ||
| 34 | 'CHARGES 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF'); | ||
| 35 | INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES | ||
| 36 | ('0DA506A8-8E34-EF92-E050-D7936EBE4603', '0C99BEF9-375F-3E4A-E050-D7936EBE2782', | ||
| 37 | TO_TIMESTAMP_TZ('2013-07-02 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 12900.00, | ||
| 38 | 'SALE 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF'); | ||