add cust_pay_refund table to refund payments

1 files changed, 15 insertions, 0 deletions

diff --git a/README.1.5.0pre6 b/README.1.5.0pre6
new file mode 100644
index 000000000..ba9129fab
--- /dev/null
+++ b/README.1.5.0pre6
@@ -0,0 +1,15 @@
+CREATE TABLE cust_pay_refund (
+    payrefundnum serial NOT NULL,
+    paynum int NOT NULL,
+    refundnum int NOT NULL,
+    _date int NOT NULL,
+    amount decimal(10,2) NOT NULL,
+    PRIMARY KEY (payrefundnum)
+);
+CREATE INDEX cust_pay_refund1 ON cust_pay_refund(paynum);
+CREATE INDEX cust_pay_refund2 ON cust_pay_refund(refundnum);
+
+dbdef-create username
+create-history-tables username cust_pay_refund
+dbdef-create username
+