Add E-R model and SQL bootstrap scripts

1 files changed, 10 insertions, 0 deletions

diff --git a/res/sql/functions/pg_current_datetime.sql b/res/sql/functions/pg_current_datetime.sql
new file mode 100644
index 0000000..75b1b96
--- /dev/null
+++ b/res/sql/functions/pg_current_datetime.sql
@@ -0,0 +1,10 @@
+CREATE OR REPLACE FUNCTION current_datetime()
+  RETURNS TIMESTAMP WITH TIME ZONE
+AS '
+BEGIN
+
+--RETURN to_timestamp(''2014-01-01'', ''YYYY-MM-DD'');
+  RETURN now();
+
+END;
+' LANGUAGE plpgsql;