96kEtxmU

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
4
5-- -----------------------------------------------------
6-- Schema pxandcode
7-- -----------------------------------------------------
8CREATE SCHEMA IF NOT EXISTS `pxandcode` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
9USE `pxandcode` ;
10
11-- -----------------------------------------------------
12-- Table `pxandcode`.`categorias`
13-- -----------------------------------------------------
14CREATE TABLE IF NOT EXISTS `pxandcode`.`categorias` (
15  `id` INT(4) NOT NULL AUTO_INCREMENT,
16  `nombre` VARCHAR(60) NOT NULL,
17  PRIMARY KEY (`id`))
18ENGINE = InnoDB;
19
20
21-- -----------------------------------------------------
22-- Table `pxandcode`.`estados_com`
23-- -----------------------------------------------------
24CREATE TABLE IF NOT EXISTS `pxandcode`.`estados_com` (
25  `id` INT(4) NOT NULL AUTO_INCREMENT,
26  `nombre` VARCHAR(20) NOT NULL,
27  PRIMARY KEY (`id`))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `pxandcode`.`estados_usu`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `pxandcode`.`estados_usu` (
35  `id` INT(4) NOT NULL AUTO_INCREMENT,
36  `nombre` VARCHAR(20) NOT NULL,
37  PRIMARY KEY (`id`))
38ENGINE = InnoDB;
39
40
41-- -----------------------------------------------------
42-- Table `pxandcode`.`tipos_usu`
43-- -----------------------------------------------------
44CREATE TABLE IF NOT EXISTS `pxandcode`.`tipos_usu` (
45  `id` INT(4) NOT NULL AUTO_INCREMENT,
46  `nombre` VARCHAR(20) NOT NULL,
47  PRIMARY KEY (`id`))
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `pxandcode`.`usuarios`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `pxandcode`.`usuarios` (
55  `id` INT(4) NOT NULL AUTO_INCREMENT,
56  `estado_usu_id` INT(4) NOT NULL,
57  `tipo_usu_id` INT(4) NOT NULL,
58  `email` VARCHAR(60) NOT NULL,
59  `password` VARCHAR(41) NOT NULL,
60  `nombre` VARCHAR(60) NOT NULL,
61  `apodo` VARCHAR(20) NOT NULL,
62  `imagen` VARCHAR(200) NOT NULL DEFAULT 'img/perfil/blank.png',
63  `modificado` DATETIME NOT NULL,
64  `creado` DATETIME NOT NULL,
65  PRIMARY KEY (`id`),
66  CONSTRAINT `usuario_estado`
67    FOREIGN KEY (`estado_usu_id`)
68    REFERENCES `pxandcode`.`estados_usu` (`id`)
69    ON DELETE NO ACTION
70    ON UPDATE NO ACTION,
71  CONSTRAINT `usuario_tipo`
72    FOREIGN KEY (`tipo_usu_id`)
73    REFERENCES `pxandcode`.`tipos_usu` (`id`)
74    ON DELETE NO ACTION
75    ON UPDATE NO ACTION)
76ENGINE = InnoDB;
77
78
79-- -----------------------------------------------------
80-- Table `pxandcode`.`tipos_posts`
81-- -----------------------------------------------------
82CREATE TABLE IF NOT EXISTS `pxandcode`.`tipos_posts` (
83  `id` INT(4) NOT NULL AUTO_INCREMENT,
84  `nombre` VARCHAR(20) NOT NULL,
85  PRIMARY KEY (`id`))
86ENGINE = InnoDB;
87
88
89-- -----------------------------------------------------
90-- Table `pxandcode`.`posts`
91-- -----------------------------------------------------
92CREATE TABLE IF NOT EXISTS `pxandcode`.`posts` (
93  `id` INT(4) NOT NULL AUTO_INCREMENT,
94  `usuario_id` INT(4) NOT NULL,
95  `categoria_id` INT(4) NOT NULL,
96  `tipo_id` INT(4) NOT NULL,
97  `titulo` VARCHAR(60) NOT NULL,
98  `contenido` TEXT(2000) NOT NULL,
99  `descripcion` VARCHAR(200) NULL,
100  `modificado` DATETIME NOT NULL,
101  `creado` DATETIME NOT NULL,
102  PRIMARY KEY (`id`),
103  CONSTRAINT `post_usuario_fk`
104    FOREIGN KEY (`usuario_id`)
105    REFERENCES `pxandcode`.`usuarios` (`id`)
106    ON DELETE NO ACTION
107    ON UPDATE NO ACTION,
108  CONSTRAINT `post_categoria_fk`
109    FOREIGN KEY (`categoria_id`)
110    REFERENCES `pxandcode`.`categorias` (`id`)
111    ON DELETE NO ACTION
112    ON UPDATE NO ACTION,
113  CONSTRAINT `post_tipo_fk`
114    FOREIGN KEY (`tipo_id`)
115    REFERENCES `pxandcode`.`tipos_posts` (`id`)
116    ON DELETE NO ACTION
117    ON UPDATE NO ACTION)
118ENGINE = InnoDB;
119
120
121-- -----------------------------------------------------
122-- Table `pxandcode`.`comentarios`
123-- -----------------------------------------------------
124CREATE TABLE IF NOT EXISTS `pxandcode`.`comentarios` (
125  `id` INT(4) NOT NULL AUTO_INCREMENT,
126  `usuario_id` INT(4) NOT NULL,
127  `post_id` INT(4) NOT NULL,
128  `estado_com_id` INT(4) NOT NULL,
129  `data` TEXT(1000) NOT NULL,
130  `modificado` DATETIME NOT NULL,
131  `creado` DATETIME NOT NULL,
132  PRIMARY KEY (`id`),
133  CONSTRAINT `comentario_estado_fk`
134    FOREIGN KEY (`estado_com_id`)
135    REFERENCES `pxandcode`.`estados_com` (`id`),
136  CONSTRAINT `comentario_usuario_fk`
137    FOREIGN KEY (`usuario_id`)
138    REFERENCES `pxandcode`.`usuarios` (`id`),
139  CONSTRAINT `comentario_post_fk`
140    FOREIGN KEY (`post_id`)
141    REFERENCES `pxandcode`.`posts` (`id`)
142    ON DELETE CASCADE
143    ON UPDATE NO ACTION)
144ENGINE = InnoDB;
145
146
147SET SQL_MODE=@OLD_SQL_MODE;
148SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
149SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;