 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)		
 );

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


USE ChurchLogger;

DROP TABLE IF EXISTS member, attendance, address, info;

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