Lo primero que debemos realizzar es crear la base de datos:
create database if not exists 'clasicmodels' default character set;
Una vez creada entramos en ella:
use 'classicmodels';
Procedemos a crear las tablas, primero nos aseguraremos de que no existen:
drop table if exists 'customers'
Creamos la tabla (sin restricciones):
CREATE TABLE `customers` (
`customerNumber` int(11) NOT NULL,
`customerName` varchar(50) NOT NULL,
`contactLastName` varchar(50) NOT NULL,
`contactFirstName` varchar(50) NOT NULL,
`phone` varchar(50) NOT NULL,
`addressLine1` varchar(50) NOT NULL,
`addressLine2` varchar(50) DEFAULT NULL,
`city` varchar(50) NOT NULL,
`state` varchar(50) DEFAULT NULL,
`postalCode` varchar(15) DEFAULT NULL,
`country` varchar(50) NOT NULL,
`salesRepEmployeeNumber` int(11) DEFAULT NULL,
`creditLimit` double DEFAULT NULL,
PRIMARY KEY (`customerNumber`),
)
Para implemetar las restricciones:
alter table customers;
KEY `salesRepEmployeeNumber` (`salesRepEmployeeNumber`),
CONSTRAINT `customers_ibfk_1`
FOREIGN KEY (`salesRepEmployeeNumber`)
REFERENCES `employees` (`employeeNumber`);
