From 8c7396531e6bf6f7c6cc4e5d19e2d381442223c5 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 19 Aug 2001 13:50:47 +0000 Subject: indices on cust_main ship_last and ship_country --- httemplate/docs/upgrade8.html | 2 ++ 1 file changed, 2 insertions(+) (limited to 'httemplate/docs') 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 );
  • If you wish to enable customer comments, apply the following change to your database: -- cgit v1.2.1