FriendManagementSystem/src/main/resources/sql/scripts/SQL_Script.sql at master · chandrika1993/FriendManagementSystem · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71

-- -----------------------------------------------------
-- Table `ad_6bc4d13c46fbd3f`.`userprofile`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ad_6bc4d13c46fbd3f`.`userprofile` (
  `userProfileId` INT(11) NOT NULL AUTO_INCREMENT,
  `contactNo` VARCHAR(256) NULL DEFAULT NULL,
  `userEmailId` VARCHAR(256) NULL DEFAULT NULL,
  `userName` VARCHAR(256) NULL DEFAULT NULL,
  PRIMARY KEY (`userProfileId`))
ENGINE = InnoDB
AUTO_INCREMENT = 112
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ad_6bc4d13c46fbd3f`.`block`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ad_6bc4d13c46fbd3f`.`block` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `block_status` CHAR(1) NULL DEFAULT NULL,
  `emailId` VARCHAR(256) NOT NULL,
  `userProfileId` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_gq070atf6yam0p89dna243p2y` (`userProfileId` ASC),
  CONSTRAINT `FK_gq070atf6yam0p89dna243p2y`
    FOREIGN KEY (`userProfileId`)
    REFERENCES `ad_6bc4d13c46fbd3f`.`userprofile` (`userProfileId`))
ENGINE = InnoDB
AUTO_INCREMENT = 12
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ad_6bc4d13c46fbd3f`.`friends`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ad_6bc4d13c46fbd3f`.`friends` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `friendEmailId` VARCHAR(256) NOT NULL,
  `userProfileId` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_fm9np713flxtox10t1lajfgax` (`userProfileId` ASC),
  CONSTRAINT `FK_fm9np713flxtox10t1lajfgax`
    FOREIGN KEY (`userProfileId`)
    REFERENCES `ad_6bc4d13c46fbd3f`.`userprofile` (`userProfileId`))
ENGINE = InnoDB
AUTO_INCREMENT = 192
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ad_6bc4d13c46fbd3f`.`subscription`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ad_6bc4d13c46fbd3f`.`subscription` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `emailId` VARCHAR(256) NOT NULL,
  `subscriptionStatus` CHAR(1) NULL DEFAULT NULL,
  `userProfileId` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `FK_gkfax6xe0avkoe20k0r0to8yy` (`userProfileId` ASC),
  CONSTRAINT `FK_gkfax6xe0avkoe20k0r0to8yy`
    FOREIGN KEY (`userProfileId`)
    REFERENCES `ad_6bc4d13c46fbd3f`.`userprofile` (`userProfileId`))
ENGINE = InnoDB
AUTO_INCREMENT = 12
DEFAULT CHARACTER SET = utf8;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;