
Edwin Jesset Barrientos Gonzales
Preguntastudent•hace 5 años
En heidi seria:
CREATE TABLE `Categoria` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `nombre_categoria` VARCHAR(30) NOT NULL DEFAULT '0' COLLATE 'utf8_spanish_ci', PRIMARY KEY (`id`) ) COLLATE='utf8_spanish_ci' ENGINE=InnoDB ; CREATE TABLE `etiquetas` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `nombre_etiqueta` VARCHAR(30) NULL DEFAULT '0' COLLATE 'utf8_spanish_ci', PRIMARY KEY (`id`) ) COLLATE='utf8_spanish_ci' ENGINE=InnoDB ; CREATE TABLE `usuario` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `login` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8_spanish_ci', `password` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8_spanish_ci', `nickname` VARCHAR(40) NULL DEFAULT NULL COLLATE 'utf8_spanish_ci', `email` VARCHAR(40) NULL DEFAULT NULL COLLATE 'utf8_spanish_ci', PRIMARY KEY (`id`), UNIQUE INDEX `email` (`email`) ) COLLATE='utf8_spanish_ci' ENGINE=InnoDB ;