summaryrefslogtreecommitdiff
path: root/httemplate/docs/upgrade10.html
diff options
context:
space:
mode:
authorivan <ivan>2003-02-06 05:26:50 +0000
committerivan <ivan>2003-02-06 05:26:50 +0000
commitc232fac0743999105f6948b9fa352fe2293b09f8 (patch)
treecfeb31670fdedeeefd286d58fa6bef2e0d9e1095 /httemplate/docs/upgrade10.html
parent6e2dcb26245ef419438f60e99c91873a8d762625 (diff)
time/data detail on invoices
Diffstat (limited to 'httemplate/docs/upgrade10.html')
-rw-r--r--httemplate/docs/upgrade10.html11
1 files changed, 11 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html
new file mode 100644
index 000000000..7aa26f698
--- /dev/null
+++ b/httemplate/docs/upgrade10.html
@@ -0,0 +1,11 @@
+this is very incomplete
+
+CREATE TABLE cust_bill_pkg_detail (
+ detailnum serial,
+ pkgnum int NOT NULL,
+ invnum int NOT NULL,
+ detail varchar(80),
+ PRIMARY KEY (detailnum)
+);
+CREATE INDEX cust_bill_pkg_detail1 ON cust_bill_pkg_detail ( pkgnum, invnum );
+