remove dropIfExists call from functions/views as to not drop them unexpectedly

diff --git a/foundation-database/public/functions/usercanlogin.sql b/foundation-database/public/functions/usercanlogin.sql
index 72a559f..2c097d3 100644 (file)
--- a/foundation-database/public/functions/usercanlogin.sql
+++ b/foundation-database/public/functions/usercanlogin.sql
@@ -1,5 +1,5 @@
-DROP VIEW     IF EXISTS usr;
-DROP FUNCTION IF EXISTS userCanLogin(TEXT);
+--DROP VIEW     IF EXISTS usr;
+--DROP FUNCTION IF EXISTS userCanLogin(TEXT);
 CREATE OR REPLACE FUNCTION userCanLogin(pUsername TEXT) RETURNS BOOLEAN AS $$
 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple. 
 -- See www.xtuple.com/CPAL for the full text of the software license.

diff --git a/foundation-database/public/views/remitto.sql b/foundation-database/public/views/remitto.sql
index 81b4566..d66cb88 100644 (file)
--- a/foundation-database/public/views/remitto.sql
+++ b/foundation-database/public/views/remitto.sql
@@ -1,5 +1,5 @@
 
-SELECT dropIfExists('VIEW', 'remitto');
+--SELECT dropIfExists('VIEW', 'remitto');
 CREATE OR REPLACE VIEW remitto AS
   SELECT (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_name'::text)) AS remitto_name,
          (SELECT metric.metric_value FROM metric WHERE (metric.metric_name = 'remitto_address1'::text)) AS remitto_address1,

diff --git a/foundation-database/public/views/usr.sql b/foundation-database/public/views/usr.sql
index e53b13f..c3cf540 100644 (file)
--- a/foundation-database/public/views/usr.sql
+++ b/foundation-database/public/views/usr.sql
@@ -1,5 +1,5 @@
 
-SELECT dropIfExists('VIEW', 'usr');
+--SELECT dropIfExists('VIEW', 'usr');
 CREATE OR REPLACE VIEW usr AS
   SELECT usesysid::integer AS usr_id,
          usename::text AS usr_username,