 DROP TABLE user_tasks;
 DROP TABLE booked_events;
 DROP TABLE system_events;
-DROP TABLE system_map_markers;
 DROP TABLE user_messages_lookup;
 DROP TABLE user_messages;
 DROP TABLE paypal_log;

	`payer_address2` VARCHAR(70),
	`payer_town` VARCHAR(70),
	`payer_city` VARCHAR(70) NOT NULL,
	`payer_country` VARCHAR(70),
	`payer_postcode` VARCHAR(70) NOT NULL,
	`payment_type` VARCHAR(5) NOT NULL,
	`payment_status` VARCHAR(9) NOT NULL,

	`updated_on` DATETIME
) ENGINE = InnoDB;

#Timetable
CREATE TABLE `student_portal`.`user_timetable` (
	`userid` INT(11) NOT NULL,
	`moduleid` INT(11) NOT NULL,
FOREIGN KEY (userid)
REFERENCES user_signin(userid),
FOREIGN KEY (moduleid)
REFERENCES system_modules(moduleid)
ON UPDATE CASCADE
ON DELETE CASCADE
) ENGINE = InnoDB;

#Timetable
CREATE TABLE `student_portal`.`system_lectures` (
	`moduleid` INT(11) NOT NULL UNIQUE,
	`lectureid` INT(11) NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY,
	`lecture_name` VARCHAR(300) NOT NULL,
	`lecture_lecturer` INT(11) NOT NULL,
	`lecture_notes` VARCHAR(5000),
