From 021e1ac77366fb0765cb364af0c09f5f2df92266 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 30 Sep 2003 14:58:19 +0000 Subject: [PATCH] agent schema changes --- httemplate/docs/upgrade10.html | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 2f7f4d89a..4a6baa59b 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -74,6 +74,12 @@ ALTER TABLE cust_main_county ADD recurtax char(1) NULL; ALTER TABLE h_cust_main_county ADD recurtax char(1) NULL; ALTER TABLE cust_pkg ADD last_bill int NULL; ALTER TABLE h_cust_pkg ADD last_bill int NULL; +ALTER TABLE agent ADD disabled char(1) NULL; +ALTER TABLE h_agent ADD disabled char(1) NULL; +ALTER TABLE agent ADD username varchar(80) NULL; +ALTER TABLE h_agent ADD username varchar(80) NULL; +ALTER TABLE agent ADD _password varchar(80) NULL; +ALTER TABLE h_agent ADD _password varchar(80) NULL; dump database, edit: - cust_main: increase otaker from 8 to 32 -- 2.11.0