projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
add table cust_main_invoice
[freeside.git]
/
htdocs
/
docs
/
upgrade3.html
diff --git
a/htdocs/docs/upgrade3.html
b/htdocs/docs/upgrade3.html
index
1506642
..
87f551d
100644
(file)
--- 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,
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)
);
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 )
+);
</pre>
<li>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.
</pre>
<li>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.