 CREATE TABLE church_address (
 	cID			int PRIMARY KEY NOT NULL REFERENCES members.id,
 	straddress	varchar(50),
+	city		varchar(20),
 	state		char(2),  		# 2 letter state
 	zip			varchar(5)		
 );


USE ChurchLogger;

DROP TABLE IF EXISTS members, attendance, address;

CREATE TABLE members (
	mID			int NOT NULL AUTO_INCREMENT, # Generated ID for members

CREATE TABLE member_address (
	mID			int PRIMARY KEY NOT NULL REFERENCES members.id,
	straddress	varchar(50),
	city, 		varchar(30),
	state		char(2),  		# 2 letter state
	zip			varchar(5)		
);
