jUHXA8yy

1-- -----------------------------------------------------
2-- Schema Game_buying_db
3-- -----------------------------------------------------
4CREATE SCHEMA IF NOT EXISTS `Game_buying_db` DEFAULT CHARACTER SET utf8 ;
5USE `Game_buying_db` ;
6
7-- -----------------------------------------------------
8-- Table `Game_buying_db`.`Customer`
9-- -----------------------------------------------------
10CREATE TABLE IF NOT EXISTS `Game_buying_db`.`Customer` (
11  `cid` INT NOT NULL,
12  `cname` VARCHAR(45) NULL DEFAULT NULL,
13  `cage` VARCHAR(45) NULL DEFAULT NULL,
14  `ccity` VARCHAR(45) NULL DEFAULT NULL,
15  PRIMARY KEY (`cid`));
16
17
18-- -----------------------------------------------------
19-- Table `Game_buying_db`.`Developer`
20-- -----------------------------------------------------
21CREATE TABLE IF NOT EXISTS `Game_buying_db`.`Developer` (
22  `did` INT NOT NULL,
23  `dname` VARCHAR(45) NULL DEFAULT NULL,
24  `demail` VARCHAR(45) NULL DEFAULT NULL,
25  `dcity` VARCHAR(45) NULL DEFAULT NULL,
26  PRIMARY KEY (`did`));
27
28
29-- -----------------------------------------------------
30-- Table `Game_buying_db`.`Game`
31-- -----------------------------------------------------
32CREATE TABLE IF NOT EXISTS `Game_buying_db`.`Game` (
33  `gid` INT NOT NULL,
34  `gname` VARCHAR(45) NULL DEFAULT NULL,
35  `price` INT NOT NULL,
36  `publishdate` DATETIME NOT NULL,
37  PRIMARY KEY (`gid`));
38
39
40-- -----------------------------------------------------
41-- Table `Game_buying_db`.`DevelopedBy`
42-- -----------------------------------------------------
43CREATE TABLE IF NOT EXISTS `Game_buying_db`.`DevelopedBy` (
44  `gid` INT NOT NULL,
45  `did` INT NOT NULL,
46  PRIMARY KEY (`gid`, `did`),
47  INDEX (`did` ASC),
48  CONSTRAINT ``
49    FOREIGN KEY (`gid`)
50    REFERENCES `Game_buying_db`.`Game` (`gid`),
51  CONSTRAINT ``
52    FOREIGN KEY (`did`)
53    REFERENCES `Game_buying_db`.`Developer` (`did`));