diff options
| author | ivan <ivan> | 2001-08-19 13:50:47 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2001-08-19 13:50:47 +0000 |
| commit | 8c7396531e6bf6f7c6cc4e5d19e2d381442223c5 (patch) | |
| tree | 5f566ec79715c8864bcbb9385d1a9f5e413cd3e8 /httemplate/docs | |
| parent | b400f5e930df471ad42906ae118f0f3b00cec512 (diff) | |
indices on cust_main ship_last and ship_country
Diffstat (limited to 'httemplate/docs')
| -rw-r--r-- | httemplate/docs/upgrade8.html | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 1a5c998c6..60f8f1593 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -129,6 +129,8 @@ ALTER TABLE cust_main ADD COLUMN ship_country char(2) NULL; ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL; ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL; +CREATE INDEX cust_main1 ON cust_main ( ship_last ); +CREATE INDEX cust_main2 ON cust_main ( ship_company ); </pre> <li>If you wish to enable customer comments, apply the following change to your database: |