Sql

CREATE DATABASE IF NOT EXISTS sales;

USE sales;

SET foreign_key_checks = 0;

DROP TABLE IF EXISTS `customers`;

CREATE TABLE `customers` (
`id` INT(11) NOT NULL,
`name` VARCHAR(200) DEFAULT NULL,
`address` VARCHAR(200) DEFAULT NULL,
`vat_number` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `invoice_details`;

CREATE TABLE `invoice_details` (
`id` INT(11) NOT NULL,
`invoice_id` INT(11) DEFAULT NULL,
`product_id` INT(11) DEFAULT NULL,
`quantity` DECIMAL(20,5) DEFAULT NULL,
`price` DECIMAL(20,5) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `invoice_id` (`invoice_id`),
KEY `product_id` (`product_id`),
CONSTRAINT `invoice_details_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
CONSTRAINT `invoice_details_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `invoices`;

CREATE TABLE `invoices` (
`id` INT(11) NOT NULL,
`customer_id` INT(11) DEFAULT NULL,
`number` VARCHAR(25) DEFAULT NULL,
`date` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `customer_id` (`customer_id`),
CONSTRAINT `invoices_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS `products`;

CREATE TABLE `products` (
`id` INT(11) NOT NULL,
`name` VARCHAR(200) DEFAULT NULL,
`vat_prc` DECIMAL(20,5) DEFAULT NULL,
`price` DECIMAL(20,5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

SET foreign_key_checks = 1;