/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50736 (5.7.36)
 Source Host           : localhost:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 50736 (5.7.36)
 File Encoding         : 65001

 Date: 05/06/2023 16:21:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for products
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products`  (
  `pro_code` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `man_code` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pro_name` char(35) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pro_description` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pro_type` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pro_theme` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pro_pieces` int(11) NULL DEFAULT NULL,
  `pro_packaging` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pro_shape` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pro_style` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pro_buy_price` decimal(6, 2) NULL DEFAULT NULL,
  `pro_sel_price` decimal(6, 2) NULL DEFAULT NULL,
  `pro_stock` int(11) NULL DEFAULT NULL,
  `pro_stock_min` int(11) NULL DEFAULT NULL,
  `pro_stock_max` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`pro_code`, `man_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of products
-- ----------------------------
INSERT INTO `products` VALUES ('CLAI1020', '3', 'Thirties Sunday and Aero Club', NULL, NULL, 'Airplanes', NULL, NULL, NULL, NULL, 18.99, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLBI1009', '3', 'Kitten in Basket', NULL, NULL, 'Birds', NULL, NULL, NULL, NULL, 18.43, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLBO1007', '3', 'Henley Regatta and Playing', NULL, NULL, 'Boats', NULL, NULL, NULL, NULL, 18.99, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLCA1013', '3', 'No Parking', NULL, NULL, 'Cars', NULL, NULL, NULL, NULL, 18.43, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLCA1019', '3', 'The Cotswolds', NULL, NULL, 'Caribbean', NULL, NULL, NULL, NULL, 18.43, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLCO1005', '3', 'Chatsworth House', NULL, NULL, 'Countryside', NULL, NULL, NULL, NULL, 18.43, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLCO1006', '3', 'Country Drive and TF for 2', NULL, NULL, 'Countryside', NULL, NULL, NULL, NULL, 18.99, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLCO1008', '3', 'Heroes of Comedy', NULL, NULL, 'Comedy/Cartoon', NULL, NULL, NULL, NULL, 18.06, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLCO1011', '3', 'Lovely Jubbly', NULL, NULL, 'Comedy/Cartoon', NULL, NULL, NULL, NULL, 18.06, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLCO1014', '3', 'Ringwood Cottage', NULL, NULL, 'Cottages', NULL, NULL, NULL, NULL, 18.43, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLCO1015', '3', 'Sit-Com Legends', NULL, NULL, 'Comedy/Cartoon', NULL, NULL, NULL, NULL, 18.43, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLFA1002', '3', 'Big Ben', NULL, NULL, 'Famous Landmarks', NULL, NULL, NULL, NULL, 18.99, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLFA1021', '3', 'Tower Bridge by Night', NULL, NULL, 'Famous Landmarks', NULL, NULL, NULL, NULL, 13.36, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLFA1023', '3', 'Who\'s Who', NULL, NULL, 'Fantasy', NULL, NULL, NULL, NULL, 18.43, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLFL1017', '3', 'Sunflowers', NULL, NULL, 'Flowers and Gardens', NULL, NULL, NULL, NULL, 18.76, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLFO1025', '3', 'Ye Olde Red Horse Pub', NULL, NULL, 'Food and Drink', NULL, NULL, NULL, NULL, 18.43, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLHO1022', '3', 'Whilst the Sun Shines', NULL, NULL, 'Horses', NULL, NULL, NULL, NULL, 13.30, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLWA1003', '3', 'Canal Crossing', NULL, NULL, 'Waterways', NULL, NULL, NULL, NULL, 13.30, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES ('CLWA1004', '3', 'Canal Cruise', NULL, NULL, 'Waterways', NULL, NULL, NULL, NULL, 13.30, NULL, NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;
