· 8 years ago · Sep 01, 2018, 10:14 PM
1-- MySQL Script generated by MySQL Workbench
2-- Sat 01 Sep 2018 04:11:07 PM CST
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`.`brand`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`brand` (
24 `id` INT NOT NULL AUTO_INCREMENT,
25 `display_name` VARCHAR(45) NULL,
26 `display_logo` VARCHAR(45) NULL,
27 `descrip` TEXT NULL,
28 `key_words` TEXT NULL,
29 `status` TINYINT NULL DEFAULT 1 COMMENT '1:Activo',
30 PRIMARY KEY (`id`))
31ENGINE = InnoDB;
32
33
34-- -----------------------------------------------------
35-- Table `mydb`.`rol`
36-- -----------------------------------------------------
37CREATE TABLE IF NOT EXISTS `mydb`.`rol` (
38 `id` INT NOT NULL AUTO_INCREMENT,
39 `descrip` VARCHAR(45) NULL,
40 `status` TINYINT NULL DEFAULT 1 COMMENT '1:Activo',
41 PRIMARY KEY (`id`))
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `mydb`.`user`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `mydb`.`user` (
49 `id` INT NOT NULL AUTO_INCREMENT,
50 `username` VARCHAR(150) NULL,
51 `p455w0rd` VARCHAR(150) NULL,
52 `rol_id` INT NOT NULL,
53 `rank` TINYINT NULL,
54 `status` TINYINT NULL DEFAULT 1,
55 PRIMARY KEY (`id`),
56 INDEX `fk_user_rol1_idx` (`rol_id` ASC),
57 CONSTRAINT `fk_user_rol1`
58 FOREIGN KEY (`rol_id`)
59 REFERENCES `mydb`.`rol` (`id`)
60 ON DELETE NO ACTION
61 ON UPDATE NO ACTION)
62ENGINE = InnoDB;
63
64
65-- -----------------------------------------------------
66-- Table `mydb`.`campaign`
67-- -----------------------------------------------------
68CREATE TABLE IF NOT EXISTS `mydb`.`campaign` (
69 `id` INT NOT NULL AUTO_INCREMENT,
70 `brand_id` INT NOT NULL,
71 `created_by` INT NOT NULL,
72 `display_name` VARCHAR(45) NULL,
73 `start_date` DATE NULL,
74 `end_date` DATE NULL,
75 `display_image` VARCHAR(45) NULL,
76 `display_image_thumbnail` VARCHAR(45) NULL,
77 `status` TINYINT NULL DEFAULT 1 COMMENT '1:Activo',
78 PRIMARY KEY (`id`),
79 INDEX `fk_campaign_user1_idx` (`created_by` ASC),
80 INDEX `fk_campaign_brand1_idx` (`brand_id` ASC),
81 CONSTRAINT `fk_campaign_user1`
82 FOREIGN KEY (`created_by`)
83 REFERENCES `mydb`.`user` (`id`)
84 ON DELETE NO ACTION
85 ON UPDATE NO ACTION,
86 CONSTRAINT `fk_campaign_brand1`
87 FOREIGN KEY (`brand_id`)
88 REFERENCES `mydb`.`brand` (`id`)
89 ON DELETE NO ACTION
90 ON UPDATE NO ACTION)
91ENGINE = InnoDB;
92
93
94-- -----------------------------------------------------
95-- Table `mydb`.`social_network`
96-- -----------------------------------------------------
97CREATE TABLE IF NOT EXISTS `mydb`.`social_network` (
98 `id` INT NOT NULL AUTO_INCREMENT,
99 `name` VARCHAR(45) NULL,
100 `token` VARCHAR(150) NULL,
101 `scope` VARCHAR(45) NULL,
102 `status` TINYINT NULL COMMENT '1:Activo',
103 PRIMARY KEY (`id`))
104ENGINE = InnoDB;
105
106
107-- -----------------------------------------------------
108-- Table `mydb`.`social_network_brand`
109-- -----------------------------------------------------
110CREATE TABLE IF NOT EXISTS `mydb`.`social_network_brand` (
111 `social_network_id` INT NOT NULL,
112 `brand_id` INT NOT NULL,
113 INDEX `fk_social_network_brand_social_network1_idx` (`social_network_id` ASC),
114 INDEX `fk_social_network_brand_brand1_idx` (`brand_id` ASC),
115 CONSTRAINT `fk_social_network_brand_social_network1`
116 FOREIGN KEY (`social_network_id`)
117 REFERENCES `mydb`.`social_network` (`id`)
118 ON DELETE CASCADE
119 ON UPDATE CASCADE,
120 CONSTRAINT `fk_social_network_brand_brand1`
121 FOREIGN KEY (`brand_id`)
122 REFERENCES `mydb`.`brand` (`id`)
123 ON DELETE CASCADE
124 ON UPDATE CASCADE)
125ENGINE = InnoDB;
126
127
128-- -----------------------------------------------------
129-- Table `mydb`.`compaign_lover`
130-- -----------------------------------------------------
131CREATE TABLE IF NOT EXISTS `mydb`.`compaign_lover` (
132 `campaign_id` INT NOT NULL,
133 `user_id` INT NOT NULL,
134 INDEX `fk_compaign_lover_campaign1_idx` (`campaign_id` ASC),
135 INDEX `fk_compaign_lover_user1_idx` (`user_id` ASC),
136 CONSTRAINT `fk_compaign_lover_campaign1`
137 FOREIGN KEY (`campaign_id`)
138 REFERENCES `mydb`.`campaign` (`id`)
139 ON DELETE NO ACTION
140 ON UPDATE NO ACTION,
141 CONSTRAINT `fk_compaign_lover_user1`
142 FOREIGN KEY (`user_id`)
143 REFERENCES `mydb`.`user` (`id`)
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION)
146ENGINE = InnoDB;
147
148
149-- -----------------------------------------------------
150-- Table `mydb`.`hashtag`
151-- -----------------------------------------------------
152CREATE TABLE IF NOT EXISTS `mydb`.`hashtag` (
153 `id` INT NOT NULL AUTO_INCREMENT,
154 `campaign_id` INT NOT NULL,
155 `hashtag` VARCHAR(45) NULL,
156 PRIMARY KEY (`id`),
157 INDEX `fk_hashtag_campaign1_idx` (`campaign_id` ASC),
158 UNIQUE INDEX `hashtag_UNIQUE` (`hashtag` ASC, `campaign_id` ASC),
159 CONSTRAINT `fk_hashtag_campaign1`
160 FOREIGN KEY (`campaign_id`)
161 REFERENCES `mydb`.`campaign` (`id`)
162 ON DELETE NO ACTION
163 ON UPDATE NO ACTION)
164ENGINE = InnoDB;
165
166
167-- -----------------------------------------------------
168-- Table `mydb`.`price`
169-- -----------------------------------------------------
170CREATE TABLE IF NOT EXISTS `mydb`.`price` (
171 `id` INT NOT NULL AUTO_INCREMENT,
172 `name` VARCHAR(45) NULL,
173 PRIMARY KEY (`id`))
174ENGINE = InnoDB;
175
176
177-- -----------------------------------------------------
178-- Table `mydb`.`price_compaign`
179-- -----------------------------------------------------
180CREATE TABLE IF NOT EXISTS `mydb`.`price_compaign` (
181 `id` INT NOT NULL AUTO_INCREMENT,
182 `price_id` INT NOT NULL,
183 `user_id` INT NOT NULL,
184 `campaign_id` INT NOT NULL,
185 `rank_points` INT NULL DEFAULT 0,
186 PRIMARY KEY (`id`),
187 INDEX `fk_price_compaign_price1_idx` (`price_id` ASC),
188 INDEX `fk_price_compaign_user1_idx` (`user_id` ASC),
189 INDEX `fk_price_compaign_campaign1_idx` (`campaign_id` ASC),
190 CONSTRAINT `fk_price_compaign_price1`
191 FOREIGN KEY (`price_id`)
192 REFERENCES `mydb`.`price` (`id`)
193 ON DELETE NO ACTION
194 ON UPDATE NO ACTION,
195 CONSTRAINT `fk_price_compaign_user1`
196 FOREIGN KEY (`user_id`)
197 REFERENCES `mydb`.`user` (`id`)
198 ON DELETE NO ACTION
199 ON UPDATE NO ACTION,
200 CONSTRAINT `fk_price_compaign_campaign1`
201 FOREIGN KEY (`campaign_id`)
202 REFERENCES `mydb`.`campaign` (`id`)
203 ON DELETE NO ACTION
204 ON UPDATE NO ACTION)
205ENGINE = InnoDB;
206
207
208SET SQL_MODE=@OLD_SQL_MODE;
209SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
210SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;