diff options
| author | ivan <ivan> | 2003-12-10 22:51:06 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-12-10 22:51:06 +0000 |
| commit | a5bc5bcbadafe55b31d9e97fccb6122477e390fb (patch) | |
| tree | a6a5d70377e42206955161cc16458404bc8a5aa4 /httemplate/docs | |
| parent | 10632b11a7222299b19c5949acc983d7eeefbeee (diff) | |
add part_referral.disabled, add disabled indices to agent and part_bill_event
Diffstat (limited to 'httemplate/docs')
| -rw-r--r-- | httemplate/docs/upgrade10.html | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 080528bac..3c6519a61 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -144,6 +144,9 @@ ALTER TABLE agent ADD _password varchar(80) NULL; ALTER TABLE h_agent ADD _password varchar(80) NULL; ALTER TABLE cust_main ADD paycvv varchar(4) NULL; ALTER TABLE h_cust_main ADD paycvv varchar(4) NULL; +ALTER TABLE part_referral ADD disabled char(1) NULL; +ALTER TABLE h_part_referral ADD disabled char(1) NULL; +CREATE INDEX part_referral1 ON part_referral ( disabled ); dump database, edit: - cust_main: increase otaker from 8 to 32 @@ -164,6 +167,8 @@ optionally: 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 ); + CREATE INDEX agent2 ON agent ( disabled ); + CREATE INDEX part_bill_event2 ON part_bill_event ( disabled ); serial columns |