jsersan
jsersan
/ jardineria.sql
Created
April 17, 2021 16:19
— forked from josejuansanchez/jardineria.sql
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, |