diff options
| author | ivan <ivan> | 2003-09-30 14:58:19 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-09-30 14:58:19 +0000 |
| commit | 021e1ac77366fb0765cb364af0c09f5f2df92266 (patch) | |
| tree | 9d4ace2e075f01c27a4b74e6947eda26610ec5c9 | |
| parent | d993eaef639b1abd95973b26e7c336fc5e588041 (diff) | |
agent schema changes
| -rw-r--r-- | httemplate/docs/upgrade10.html | 6 |
1 files changed, 6 insertions, 0 deletions
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 |