PVXuyg6S

1DROP TABLE IF EXISTS hospital;
2
3CREATE TABLE hospital(
4	Hid int(4) NOT NULL,
5	Hname varchar(50) NOT NULL,
6	Street varchar(30) NOT NULL,
7	City varchar(30) NOT NULL,
8	ZIP char(5) NOT NULL,
9	State char(2) NOT NULL,
10	Phone char(10) NOT NULL,
11	PRIMARY KEY(Hid)
12	-- add other keys?
13);