xP7fD3C6

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema finalproject
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema finalproject
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `finalproject` DEFAULT CHARACTER SET utf8 ;
18USE `finalproject` ;
19
20-- -----------------------------------------------------
21-- Table `finalproject`.`users`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `finalproject`.`users` (
24  `UserID` INT(11) NOT NULL,
25  `Email` VARCHAR(50) NOT NULL,
26  `Password` VARCHAR(256) NOT NULL,
27  PRIMARY KEY (`UserID`))
28ENGINE = InnoDB
29DEFAULT CHARACTER SET = utf8;
30
31
32-- -----------------------------------------------------
33-- Table `finalproject`.`requests`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `finalproject`.`requests` (
36  `RequestID` INT(11) NOT NULL AUTO_INCREMENT,
37  `RequestType` VARCHAR(45) NOT NULL,
38  `RequestStatus` VARCHAR(45) NOT NULL,
39  `RequestDate` VARCHAR(45) NOT NULL,
40  `RequestsUserID` INT(11) NOT NULL,
41  PRIMARY KEY (`RequestID`),
42  INDEX `UserID_idx` (`RequestsUserID` ASC) VISIBLE,
43  CONSTRAINT `UserID`
44    FOREIGN KEY (`RequestsUserID`)
45    REFERENCES `finalproject`.`users` (`UserID`)
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION)
48ENGINE = InnoDB
49DEFAULT CHARACTER SET = utf8;
50
51
52-- -----------------------------------------------------
53-- Table `finalproject`.`user_info`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `finalproject`.`user_info` (
56  `UserInfoID` INT(11) UNSIGNED NOT NULL,
57  `FirstName` VARCHAR(256) NOT NULL,
58  `FirstNameCyrillic` VARCHAR(256) NOT NULL,
59  `LastName` VARCHAR(30) NOT NULL,
60  `LastNameCyrillic` VARCHAR(45) NOT NULL,
61  `PersonalNumber` VARCHAR(25) NOT NULL,
62  `Address` VARCHAR(100) NOT NULL,
63  `PhoneNumber` VARCHAR(20) NOT NULL,
64  `DateOfBirth` VARCHAR(25) NOT NULL,
65  `Reason` VARCHAR(45) NULL DEFAULT NULL,
66  `EuIssuerCountry` VARCHAR(45) NULL DEFAULT NULL,
67  `TcardNumber` INT(20) NULL DEFAULT NULL,
68  `DriverLicenseIssuerCountry` VARCHAR(45) NULL DEFAULT NULL,
69  `DriverLicenseNumber` VARCHAR(20) NULL DEFAULT NULL,
70  `CountryOfIssuing` VARCHAR(45) NULL DEFAULT NULL,
71  `IssuingAuthority` VARCHAR(45) NULL DEFAULT NULL,
72  `DateOfExpiryPrevious` VARCHAR(25) NULL DEFAULT NULL,
73  `EGN` VARCHAR(25) NULL,
74  `UserID` INT(11) NOT NULL,
75  PRIMARY KEY (`UserInfoID`),
76  UNIQUE INDEX `EGN_UNIQUE` (`UserInfoID` ASC) VISIBLE,
77  INDEX `fk_user_info_users1_idx` (`UserID` ASC) VISIBLE,
78  CONSTRAINT `fk_user_info_users1`
79    FOREIGN KEY (`UserID`)
80    REFERENCES `finalproject`.`users` (`UserID`)
81    ON DELETE NO ACTION
82    ON UPDATE NO ACTION)
83ENGINE = InnoDB
84DEFAULT CHARACTER SET = utf8;
85
86
87SET SQL_MODE=@OLD_SQL_MODE;
88SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
89SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;