I'm trying to install ccgv 15.3d and have been stumped with an sql instruction as I am no database buff.
Could someone tell me/explain to me how to enter the following line that is highlighted in bold?
CREATE TABLE coupon_gv_customer (
customer_id int(5) NOT NULL default '0',
amount decimal(8,4) NOT NULL default '0.0000',
PRIMARY KEY (customer_id),
KEY customer_id (customer_id)
) TYPE=MyISAM;
I've created the tables and assigned the primary keys, but do not understand the following 'KEY' instruction.
Thanks in advance.