jsersan
josejuansanchez
/ jardineria.sql
Last active
June 21, 2024 12:41
Script SQL para crear la base de datos `jardineria` que aparece en el libro Bases de Datos de Iván López Montalbán.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DROP DATABASE IF EXISTS jardineria; | |
| CREATE DATABASE jardineria CHARACTER SET utf8mb4; | |
| USE jardineria; | |
| CREATE TABLE oficina ( | |
| codigo_oficina VARCHAR(10) NOT NULL, | |
| ciudad VARCHAR(30) NOT NULL, | |
| pais VARCHAR(50) NOT NULL, | |
| region VARCHAR(50) DEFAULT NULL, | |
| codigo_postal VARCHAR(10) NOT NULL, |