 
 USE ChurchLogger;
 
-DROP TABLE IF EXISTS members, attendance, address;
+DROP TABLE IF EXISTS member, attendance, address, info;
 
 CREATE TABLE members (
 	mID			int NOT NULL AUTO_INCREMENT, # Generated ID for members

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

CREATE TABLE church_user (
	user 		varchar(20),
	password	varchar(15),
	cID			int,
	sub_date	date
);

CREATE TABLE attendance (
