db-side support for non-standard ccard type bank account

diff --git a/foundation-database/public/functions/setccbankaccnt.sql b/foundation-database/public/functions/setccbankaccnt.sql
index 8e189ba..f1db045 100644 (file)
--- a/foundation-database/public/functions/setccbankaccnt.sql
+++ b/foundation-database/public/functions/setccbankaccnt.sql
@@ -19,7 +19,7 @@ BEGIN
   IF (_numfound <= 0) THEN
     INSERT INTO ccbank (ccbank_ccard_type, ccbank_bankaccnt_id)
                 VALUES (pccardtype,        pbankaccntid)
-    RETURNING _ccbankid;
+    RETURNING ccbank_id INTO _ccbankid;
   END IF;
 
   RETURN _ccbankid;

diff --git a/foundation-database/public/tables/ccbank.sql b/foundation-database/public/tables/ccbank.sql
new file mode 100644 (file)
index 0000000..d4d3915
--- /dev/null
+++ b/foundation-database/public/tables/ccbank.sql
@@ -0,0 +1,3 @@
+ALTER TABLE ccbank DROP CONSTRAINT IF EXISTS ccbank_ccbank_ccard_type_check;
+ALTER TABLE ccbank ADD  CONSTRAINT           ccbank_ccbank_ccard_type_check
+  CHECK (ccbank_ccard_type = ANY (ARRAY['A', 'D', 'M', 'P', 'V', 'O']));