From: ivan <ivan>
Date: Sat, 11 Aug 2001 05:54:45 +0000 (+0000)
Subject: add comments field
X-Git-Tag: merged-freeside_vpopmail_support~9
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=1dd250b6ff2c32f0bb9b4db7606066f34721e7d9

add comments field
---

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>