From 17d52b98d95c3f5494fd890e1b0e41c6b34463eb Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 12 Jan 2002 07:23:16 +0000 Subject: [PATCH] fix upgrade8.html to be in agreement with fs-setup --- httemplate/docs/upgrade8.html | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 13830dc6c..904694879 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -102,7 +102,7 @@ CREATE TABLE part_svc_column ( CREATE TABLE queue ( jobnum int primary key, - job varchar not null, + job text not null, _date int not null, status varchar(80) not null ); @@ -110,7 +110,7 @@ CREATE TABLE queue ( CREATE TABLE queue_arg ( argnum int primary key, jobnum int not null, - arg varchar null + arg text null ); CREATE INDEX queue_arg1 ON queue_arg ( jobnum ); @@ -150,8 +150,8 @@ ALTER TABLE cust_pay ADD custnum integer; ALTER TABLE cust_pay_batch ADD paybatchnum integer; ALTER TABLE cust_refund ADD custnum integer; ALTER TABLE cust_pkg ADD manual_flag char(1) NULL; -ALTER TABLE part_pkg ADD plan varchar NULL; -ALTER TABLE part_pkg ADD plandata varchar NULL; +ALTER TABLE part_pkg ADD plan varchar(80) NULL; +ALTER TABLE part_pkg ADD plandata text NULL; ALTER TABLE part_pkg ADD setuptax char(1) NULL; ALTER TABLE part_pkg ADD recurtax char(1) NULL; ALTER TABLE part_pkg ADD disabled char(1) NULL; @@ -217,7 +217,7 @@ CREATE INDEX cust_main2 ON cust_main ( ship_company );
  • If you wish to enable customer comments, apply the following change to your database:
    -ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
    +ALTER TABLE cust_main ADD COLUMN comments text NULL;
     
  • If you are using the signup server, reinstall it according to the instructions. The 1.3.x signup server is not compatible with 1.4.x.
  • Run bin/dbdef-create. -- 2.11.0