1. 创建表customer

CREATE TABLE customer
(
	cid INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
	cname VARCHAR(50) NOT NULL,
	caddress VARCHAR(50) NOT NULL,
	ccity VARCHAR(50) NOT NULL,
	cstate VARCHAR(20) NOT NULL,
	czip VARCHAR(20) NOT NULL,
	ccountry VARCHAR(20) NULL,
	ccontact VARCHAR(20) NULL,
	cemail VARCHAR(20) NULL
);