diff options
Diffstat (limited to 'README.1.5.0pre6')
-rw-r--r-- | README.1.5.0pre6 | 15 |
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 + |