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

  `end_restime` TIME NOT NULL,
  `verified` BIT NOT NULL DEFAULT 0,
  `verificationcode` VARCHAR(40) NOT NULL,
  `attendance` INT NOT NULL DEFAULT 0,
  `time_reserved` DATETIME DEFAULT NULL,
  PRIMARY KEY (`reservationid`),
  INDEX `computerid_idx` (`computerid` ASC),
  CONSTRAINT `computerid`
    FOREIGN KEY (`computerid`)
    REFERENCES `reservation_system`.`computers` (`computerid`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);


  `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,
