· 9 years ago · Dec 29, 2016, 10:54 PM
1-- MySQL Script generated by MySQL Workbench
2-- gio 29 dic 2016 23:45:09 CET
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`users`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`users` (
24 `id` INT NOT NULL,
25 `username` VARCHAR(45) NOT NULL,
26 `password` VARCHAR(45) NOT NULL,
27 UNIQUE INDEX `user-id_UNIQUE` (`id` ASC),
28 PRIMARY KEY (`id`),
29 UNIQUE INDEX `username_UNIQUE` (`username` ASC))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`balances`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`balances` (
37 `user-id` INT NOT NULL,
38 `money` INT NULL,
39 PRIMARY KEY (`user-id`),
40 CONSTRAINT `fk_balance_1`
41 FOREIGN KEY (`user-id`)
42 REFERENCES `mydb`.`users` (`id`)
43 ON DELETE NO ACTION
44 ON UPDATE NO ACTION)
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table `mydb`.`universities`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `mydb`.`universities` (
52 `id` INT NOT NULL,
53 `name` VARCHAR(45) NULL,
54 `country` VARCHAR(45) NULL,
55 `page` VARCHAR(45) NULL,
56 PRIMARY KEY (`id`))
57ENGINE = InnoDB;
58
59
60-- -----------------------------------------------------
61-- Table `mydb`.`notes`
62-- -----------------------------------------------------
63CREATE TABLE IF NOT EXISTS `mydb`.`notes` (
64 `id` INT NOT NULL,
65 `name` VARCHAR(255) NOT NULL,
66 `university-id` INT(11) NULL,
67 `owner-user-id` INT NOT NULL,
68 `note-description` TEXT NULL,
69 `language` VARCHAR(45) NULL,
70 PRIMARY KEY (`id`),
71 INDEX `fk_notes_1_idx` (`owner-user-id` ASC),
72 INDEX `fk_notes_2_idx` (`university-id` ASC),
73 CONSTRAINT `fk_notes_1`
74 FOREIGN KEY (`owner-user-id`)
75 REFERENCES `mydb`.`users` (`id`)
76 ON DELETE NO ACTION
77 ON UPDATE NO ACTION,
78 CONSTRAINT `fk_notes_2`
79 FOREIGN KEY (`university-id`)
80 REFERENCES `mydb`.`universities` (`id`)
81 ON DELETE NO ACTION
82 ON UPDATE NO ACTION)
83ENGINE = InnoDB;
84
85
86-- -----------------------------------------------------
87-- Table `mydb`.`transactions`
88-- -----------------------------------------------------
89CREATE TABLE IF NOT EXISTS `mydb`.`transactions` (
90 `id` INT NOT NULL,
91 `status` TINYINT(2) NOT NULL,
92 `user-id` INT NOT NULL,
93 `paypal-id` INT NOT NULL,
94 PRIMARY KEY (`id`),
95 UNIQUE INDEX `paypal-id_UNIQUE` (`paypal-id` ASC))
96ENGINE = InnoDB;
97
98
99-- -----------------------------------------------------
100-- Table `mydb`.`university-types`
101-- -----------------------------------------------------
102CREATE TABLE IF NOT EXISTS `mydb`.`university-types` (
103 `id` INT NOT NULL,
104 `name` VARCHAR(45) NOT NULL,
105 PRIMARY KEY (`id`, `name`))
106ENGINE = InnoDB;
107
108
109-- -----------------------------------------------------
110-- Table `mydb`.`university-relations`
111-- -----------------------------------------------------
112CREATE TABLE IF NOT EXISTS `mydb`.`university-relations` (
113 `id` INT NOT NULL,
114 `university-id` INT NULL,
115 `university-type-id` INT NULL,
116 PRIMARY KEY (`id`))
117ENGINE = InnoDB;
118
119
120SET SQL_MODE=@OLD_SQL_MODE;
121SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
122SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;