From: ivan <ivan>
Date: Tue, 30 Sep 2003 14:58:19 +0000 (+0000)
Subject: agent schema changes
X-Git-Tag: NET_WHOIS_RAW_0_31~358
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=021e1ac77366fb0765cb364af0c09f5f2df92266

agent schema changes
---

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