     ON DELETE NO ACTION
     ON UPDATE NO ACTION);
 
-CREATE TABLE `reservation_system`.`email_extension`(
-  `email_extensionid` INT NOT NULL AUTO_INCREMENT,
-  `email_extension` VARCHAR(45) NOT NULL,
-  PRIMARY KEY (`email_extensionid`));
-
 CREATE TABLE `reservation_system`.`archive_reservations` (
   `archive_reservationid` INT NOT NULL AUTO_INCREMENT,
   `computerno` INT NOT NULL,

	ON UPDATE NO ACTION);

/*dummy data*/
INSERT INTO `reservation_system`.`email_extension`(`email_extension`)
VALUES ("dlsu.edu.ph"),
	   ("delasalle.ph");

INSERT INTO `reservation_system`.`area_types` (`type`)
VALUES ("Room"),
	   ("Floor");

  `departmentid` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`departmentid`));

CREATE TABLE `reservation_system`.`area_types` (
  `area_typeid` INT NOT NULL AUTO_INCREMENT,
