-- Build a simple mysql table
		
DROP TABLE IF EXISTS vendor;
CREATE TABLE vendor (
	vid		INTEGER(8)	UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY,
	name		VARCHAR(50) 	NOT NULL,
	phone		VARCHAR(14),
	street		VARCHAR(60),
	city		VARCHAR(20),
	state		CHAR(2),
	zip		VARCHAR(10),
	INDEX(vid)
);

LOCK TABLES
	vendor WRITE;

INSERT INTO vendor (name,phone,street,city,state,zip)
	VALUES ('Never Summer','303-494-2541','1211 Downing St.','Denver','CO','80302');
INSERT INTO vendor (name,phone,street,city,state,zip)
	VALUES ('SMP','818-555-0923','24 Industry Way','Santa Clausa','CA','90024');
INSERT INTO vendor (name,phone,street,city,state,zip)
	VALUES ('Muddys','212-941-7778','4513 7th Ave.','New York','NY','10013');
INSERT INTO vendor (name,phone,street,city,state,zip)
	VALUES ('Muddys','455-838-2997','8 Broadway','Afton','MN','55442');
INSERT INTO vendor (name,phone,street,city,state,zip)
	VALUES ('SMP','818-553-8876','76 Pompano','La Enigma','CA','90024');
	
UNLOCK TABLES;