vGXDJPEZ

1-- -----------------------------------------------------
2-- Table `unirun`.`USER`
3-- -----------------------------------------------------
4CREATE TABLE IF NOT EXISTS `unirun`.`USER` (
5  `SID` VARCHAR(8) NOT NULL,
6  `fname` VARCHAR(45) NULL,
7  `lname` VARCHAR(45) NULL,
8  `email` VARCHAR(45) NULL,
9  `password` VARCHAR(45) NULL,
10  `phone` VARCHAR(45) NULL,
11  `address` VARCHAR(45) NULL,
12  `gender` CHAR(1) NULL,
13  PRIMARY KEY (`SID`))
14ENGINE = InnoDB;
15
16
17-- -----------------------------------------------------
18-- Table `unirun`.`ADMIN`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `unirun`.`ADMIN` (
21  `SID` VARCHAR(8) NOT NULL,
22  PRIMARY KEY (`SID`))
23ENGINE = InnoDB;
24
25
26-- -----------------------------------------------------
27-- Table `unirun`.`DISTANCE`
28-- -----------------------------------------------------
29CREATE TABLE IF NOT EXISTS `unirun`.`DISTANCE` (
30  `SID` VARCHAR(8) NOT NULL,
31  `distance` INT NULL,
32  PRIMARY KEY (`SID`))
33ENGINE = InnoDB;