Issue #23459 Add payco table primary key.

diff --git a/foundation-database/manifest.js b/foundation-database/manifest.js
index 4e27a2d..8d5351b 100644 (file)
--- a/foundation-database/manifest.js
+++ b/foundation-database/manifest.js
@@ -1013,6 +1013,7 @@
     "public/tables/bankrecitem.sql",
     "public/tables/cashrcpt.sql",
     "public/tables/metric.sql",
+    "public/tables/payco.sql",
     "public/tables/priv.sql",
     "public/tables/tax.sql",
     "public/tables/taxpay.sql",

diff --git a/foundation-database/public/tables/payco.sql b/foundation-database/public/tables/payco.sql
new file mode 100644 (file)
index 0000000..c74de1f
--- /dev/null
+++ b/foundation-database/public/tables/payco.sql
@@ -0,0 +1,4 @@
+-- TODO: Add a precheck in the upgrade package.xml for this.
+select xt.add_constraint('payco','payco_unique_ccpay_id_cohead_id', 'unique(payco_ccpay_id, payco_cohead_id)', 'public');
+-- Add primary key.
+select xt.add_column('payco','payco_id', 'serial', 'primary key', 'public', 'payco table primary key.');