-If you created your database with a version before 1.4.2, dump database, edit:
-- cust_main and h_cust_main: increase otaker from 8 to 32
-- cust_main and h_cust_main: change ss from char(11) to varchar(11) ( "character(11)" to "character varying(11)" )
-- cust_credit and h_cust_credit: increase otaker from 8 to 32
-- cust_pkg and h_cust_pkg: increase otaker from 8 to 32
-- cust_refund and h_cust_refund: increase otaker from 8 to 32
-- domain_record and h_domain_record: increase reczone from 80 to 255
-- domain_record and h_domain_record: change rectype from char to varchar ( "character(5)" to "character varying(5)" )
-- domain_record and h_domain_record: increase recdata from 80 to 255
-then reload
-
-mandatory again:
-
-make install-perl-modules to install the new libraries and CLI utilities
-run "freeside-upgrade username" to create the remaining new tables and columns
-
-optionally:
-
-CREATE INDEX cust_main6 ON cust_main ( daytime );
-CREATE INDEX cust_main7 ON cust_main ( night );
-CREATE INDEX cust_main8 ON cust_main ( fax );
-CREATE INDEX cust_main9 ON cust_main ( ship_daytime );
-CREATE INDEX cust_main10 ON cust_main ( ship_night );
-CREATE INDEX cust_main11 ON cust_main ( ship_fax );
+ <li> If you created your database with a version before 1.4.2, dump database, edit the following, then reload:
+ <ul>
+ <li>cust_main and h_cust_main: increase otaker from 8 to 32
+ <li>cust_main and h_cust_main: change ss from char(11) to varchar(11) ( "character(11)" to "character varying(11)" )
+ <li>cust_credit and h_cust_credit: increase otaker from 8 to 32
+ <li>cust_pkg and h_cust_pkg: increase otaker from 8 to 32
+ <li>cust_refund and h_cust_refund: increase otaker from 8 to 32
+ <li>domain_record and h_domain_record: increase reczone from 80 to 255
+ <li>domain_record and h_domain_record: change rectype from char to varchar ( "character(5)" to "character varying(5)" )
+ <li>domain_record and h_domain_record: increase recdata from 80 to 255
+ </ul>
+
+<li>make install-perl-modules to install the new libraries and CLI utilities
+<li>run "freeside-upgrade username" to create the remaining new tables and columns
+
+<li>optionally:
+<pre>
+CREATE INDEX cust_main4 ON cust_main ( daytime );
+CREATE INDEX cust_main5 ON cust_main ( night );
+CREATE INDEX cust_main6 ON cust_main ( fax );
+CREATE INDEX cust_main7 ON cust_main ( refnum );
+CREATE INDEX cust_main8 ON cust_main ( county );
+CREATE INDEX cust_main9 ON cust_main ( state );
+CREATE INDEX cust_main10 ON cust_main ( country );
+CREATE INDEX cust_main11 ON cust_main ( ship_last );
+CREATE INDEX cust_main12 ON cust_main ( ship_company );
+CREATE INDEX cust_main13 ON cust_main ( ship_daytime );
+CREATE INDEX cust_main14 ON cust_main ( ship_night );
+CREATE INDEX cust_main15 ON cust_main ( ship_fax );