Add E-R model and SQL bootstrap scripts

1 files changed, 38 insertions, 0 deletions

diff --git a/res/sql/data/pg_transactions.sql b/res/sql/data/pg_transactions.sql
new file mode 100644
index 0000000..40178bd
--- /dev/null
+++ b/res/sql/data/pg_transactions.sql
@@ -0,0 +1,38 @@
+INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
+  ('0C98CCCC-219C-C9B1-E050-D7936EBE02BF', '0C99BEF9-375F-3E4A-E050-D7936EBE2782', '2013-01-01 08:39:34.000000',
+   18000.00, 'VIR');
+INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
+  ('0C98CCCC-219D-C9B1-E050-D7936EBE02BF', '0C99BEF9-375F-3E4A-E050-D7936EBE2782', '2013-05-02 08:47:26.000000',
+   9500.00, 'VIR');
+INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
+  ('0C98CCCC-219F-C9B1-E050-D7936EBE02BF', '0C99BEF9-3762-3E4A-E050-D7936EBE2782', '2013-03-01 08:50:15.000000',
+   30000.00, 'VIR');
+
+
+-- transactions for sales
+
+INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
+  ('0DA506A8-8E2F-EF92-E050-D7936EBE4603', '0C99BEF9-375F-3E4A-E050-D7936EBE2782',
+   '2013-05-26 00:00:00.000000', - 26000.00,
+   'PURCHASE 0C98CCCC-219B-C9B1-E050-D7936EBE02BF');
+INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
+  ('0DA506A8-8E30-EF92-E050-D7936EBE4603', '0C99BEF9-375F-3E4A-E050-D7936EBE2782',
+   '2013-05-26 00:00:00.000000', - 6504.00,
+   'CHARGES 0C98CCCC-219B-C9B1-E050-D7936EBE02BF');
+INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
+  ('0DA506A8-8E31-EF92-E050-D7936EBE4603', '0C99BEF9-3760-3E4A-E050-D7936EBE2782',
+   '2013-05-26 00:00:00.000000', 26000.00,
+   'SALE 0C98CCCC-219B-C9B1-E050-D7936EBE02BF');
+
+INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
+  ('0DA506A8-8E32-EF92-E050-D7936EBE4603', '0C99BEF9-3762-3E4A-E050-D7936EBE2782',
+   '2013-07-02 00:00:00.000000', - 12900.00,
+   'PURCHASE 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF');
+INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
+  ('0DA506A8-8E33-EF92-E050-D7936EBE4603', '0C99BEF9-3762-3E4A-E050-D7936EBE2782',
+   '2013-07-02 00:00:00.000000', - 3229.00,
+   'CHARGES 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF');
+INSERT INTO TRANSACTIONS (UUID, USER_UUID, TRANSACTION_DATE, AMOUNT, LABEL) VALUES
+  ('0DA506A8-8E34-EF92-E050-D7936EBE4603', '0C99BEF9-375F-3E4A-E050-D7936EBE2782',
+   '2013-07-02 00:00:00.000000', 12900.00,
+   'SALE 0C98CCCC-21A5-C9B1-E050-D7936EBE02BF');