e1yJqyyA

1/* 
2*  DB Script Tool
3*  MySQL - 2016-12-09 21:08:02
4*  Demo: Sales database
5*/ 
6CREATE DATABASE IF NOT EXISTS `dbSalesDemo`
7    DEFAULT CHARACTER SET utf8
8    DEFAULT COLLATE utf8_general_ci;
9
10USE `dbSalesDemo`;
11
12
13
14/* 
15*  category
16*  Demo: Table for categories
17*/ 
18DROP TABLE IF EXISTS `category`;
19CREATE TABLE IF NOT EXISTS `category` (
20    `id2607:f8b0:4006:803::1001` INT UNSIGNED NOT NULL AUTO_INCREMENT,
21    `name` VARCHAR(20) COLLATE utf8_general_ci,
22 PRIMARY KEY (`id2607:f8b0:4006:803::1001`)
23) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ;
24
25
26
27/* 
28*  product
29*  Demo: Table for products
30*/ 
31DROP TABLE IF EXISTS `product`;
32CREATE TABLE IF NOT EXISTS `product` (
33    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
34    `name` VARCHAR(100) COLLATE utf8_general_ci,
35    `category_id` INTEGER(10),
36    `stock` INTEGER(10) DEFAULT '0',
37    `cost` NUMERIC(10,2) DEFAULT '0',
38    `price` NUMERIC(10,2) DEFAULT '0',
39    `status` TINYINT(1) DEFAULT '1',
40 PRIMARY KEY (`id`),
41CONSTRAINT fk_rel_category_product FOREIGN KEY (`category_id`) REFERENCES category(`id2607:f8b0:4006:803::1001`) ON DELETE CASCADE
42) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ;