diff options
| -rwxr-xr-x | bin/fs-setup | 8 | ||||
| -rw-r--r-- | httemplate/docs/upgrade8.html | 5 |
2 files changed, 11 insertions, 2 deletions
diff --git a/bin/fs-setup b/bin/fs-setup index 9075ca2a9..314a7c234 100755 --- a/bin/fs-setup +++ b/bin/fs-setup @@ -1,6 +1,6 @@ #!/usr/bin/perl -Tw # -# $Id: fs-setup,v 1.39 2001-07-30 07:42:39 ivan Exp $ +# $Id: fs-setup,v 1.40 2001-08-11 05:53:42 ivan Exp $ # # ivan@sisd.com 97-nov-8,9 # @@ -32,7 +32,10 @@ # fix radius attributes ivan@sisd.com 98-sep-27 # # $Log: fs-setup,v $ -# Revision 1.39 2001-07-30 07:42:39 ivan +# Revision 1.40 2001-08-11 05:53:42 ivan +# add comments field +# +# Revision 1.39 2001/07/30 07:42:39 ivan # need an DBIx::DBSchema with delcolumn # # Revision 1.38 2001/07/30 07:36:04 ivan @@ -498,6 +501,7 @@ sub tables_hash_hack { 'tax', 'char', 'NULL', 1, 'otaker', 'varchar', '', 8, 'refnum', 'int', '', '', + 'comments', 'varchar', 'NULL', '', ], 'primary_key' => 'custnum', 'unique' => [ [] ], diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index dfeba6505..702da5a1b 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -106,5 +106,10 @@ ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL; </pre> + <li>If you wish to enable customer comments, apply the following change to + your database: +<pre> +ALTER TABLE cust_main ADD COLUMN comments varchar NULL; +</pre> <li>Run bin/dbdef-create. </body> |