From 56b98dd1587282585a92a93dbac5781da58154f1 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 16 Dec 1998 06:05:40 +0000 Subject: add table cust_main_invoice --- htdocs/docs/upgrade3.html | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'htdocs/docs/upgrade3.html') diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html index 15066423e..87f551d26 100644 --- a/htdocs/docs/upgrade3.html +++ b/htdocs/docs/upgrade3.html @@ -22,9 +22,16 @@ ALTER TABLE cust_main_county ADD country char(2); UPDATE cust_main_county SET country = "US" where country IS NULL; CREATE TABLE part_title ( titlenum int NOT NULL, - title varchar(80), + title varchar(80) NOT NULL, PRIMARY KEY (titlenum) ); +CREATE TABLE cust_main_invoice ( + destnum int NOT NULL, + custnum int NOT NULL, + dest varchar(80) NOT NULL, + PRIMARY KEY (destnum), + INDEX ( custnum ) +);
  • Run bin/dbdef-create. This file uses MySQL-specific syntax. If you are r unning a different database engine you will need to modify it slightly. -- cgit v1.2.1