jKhrsRKr

1-- --------------------------------------------------------
2-- Host:                         localhost
3-- Server version:               10.1.16-MariaDB - mariadb.org binary distribution
4-- Server OS:                    Win32
5-- HeidiSQL Version:             9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for callum
16CREATE DATABASE IF NOT EXISTS `callum` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `callum`;
18
19-- Dumping structure for table callum.customers
20CREATE TABLE IF NOT EXISTS `customers` (
21  `CustomerId` int(5) NOT NULL AUTO_INCREMENT COMMENT 'Random UUID for the customer',
22  `Forename` varchar(10) NOT NULL COMMENT 'Customers forename',
23  `Surname` varchar(20) NOT NULL COMMENT 'Customers lastname',
24  `Title` varchar(4) NOT NULL COMMENT 'Customers title',
25  `DOB` date NOT NULL COMMENT 'Customers date of birth',
26  `HouseNo` varchar(12) NOT NULL COMMENT 'Customers house name/number',
27  `Street` varchar(20) NOT NULL COMMENT 'Street name',
28  `Town` varchar(20) NOT NULL COMMENT 'Town name',
29  `Postcode` varchar(8) NOT NULL COMMENT 'Postcode',
30  `ContactNumber` varchar(11) NOT NULL COMMENT 'Customers choses contact number it may be mobile or landline',
31  `Email` varchar(25) NOT NULL COMMENT 'Customers email address',
32  PRIMARY KEY (`CustomerId`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35-- Dumping data for table callum.customers: ~0 rows (approximately)
36/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
37/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
38
39-- Dumping structure for table callum.items
40CREATE TABLE IF NOT EXISTS `items` (
41  `ItemID` int(5) NOT NULL AUTO_INCREMENT COMMENT 'Random UUID for the item',
42  `CustomerId` int(5) NOT NULL COMMENT 'Customers UUID that owns the item',
43  `Size` varchar(10) NOT NULL COMMENT 'Size of the item',
44  `Location` varchar(6) NOT NULL COMMENT 'Location of the item in the warehouse (nearest “checkpoint”)',
45  `Description` varchar(50) NOT NULL COMMENT 'Description of the item e.g. orange lamp',
46  PRIMARY KEY (`ItemID`)
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48
49-- Dumping data for table callum.items: ~0 rows (approximately)
50/*!40000 ALTER TABLE `items` DISABLE KEYS */;
51/*!40000 ALTER TABLE `items` ENABLE KEYS */;
52
53/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
54/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
55/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;