M80ZKMFK

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema fyr1
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema fyr1
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `fyr1` DEFAULT CHARACTER SET utf8 ;
18USE `fyr1` ;
19
20-- -----------------------------------------------------
21-- Table `fyr1`.`warehouse_cumulative`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `fyr1`.`warehouse_cumulative` (
24  `order_product_id` VARCHAR(30) NOT NULL,
25  `content_id` VARCHAR(30) NOT NULL,
26  `archive_status` VARCHAR(45) NULL DEFAULT NULL,
27  `order_id` VARCHAR(45) NULL DEFAULT NULL,
28  `order_date` VARCHAR(45) NULL DEFAULT NULL,
29  `UPC_number` VARCHAR(45) NULL DEFAULT NULL,
30  `catalog_number` VARCHAR(45) NULL DEFAULT NULL,
31  `label_studio_name` VARCHAR(45) NULL DEFAULT NULL,
32  `artist_name` VARCHAR(45) NULL DEFAULT NULL,
33  `item_title` VARCHAR(45) NULL DEFAULT NULL,
34  `month_code` VARCHAR(45) NULL DEFAULT NULL,
35  `year_code` VARCHAR(45) NULL DEFAULT NULL,
36  `vendor_number` VARCHAR(45) NULL DEFAULT NULL,
37  `price` VARCHAR(45) NULL DEFAULT NULL,
38  `reorder_number` VARCHAR(45) NULL DEFAULT NULL,
39  `pressing` VARCHAR(45) NULL DEFAULT NULL,
40  PRIMARY KEY (`content_id`))
41ENGINE = InnoDB
42DEFAULT CHARACTER SET = utf8;
43
44
45-- -----------------------------------------------------
46-- Table `fyr1`.`warehouse_reconciled`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `fyr1`.`warehouse_reconciled` (
49  `order_product_id` VARCHAR(30) NOT NULL,
50  `content_id` VARCHAR(30) NULL DEFAULT NULL,
51  `archive_status` VARCHAR(45) NULL DEFAULT NULL,
52  `order_id` VARCHAR(45) NULL DEFAULT NULL,
53  `order_date` VARCHAR(45) NULL DEFAULT NULL,
54  `UPC_number` VARCHAR(45) NULL DEFAULT NULL,
55  `catalog_number` VARCHAR(45) NULL DEFAULT NULL,
56  `label_studio_name` VARCHAR(45) NULL DEFAULT NULL,
57  `artist_name` VARCHAR(45) NULL DEFAULT NULL,
58  `item_title` VARCHAR(45) NULL DEFAULT NULL,
59  `month_code` VARCHAR(45) NULL DEFAULT NULL,
60  `year_code` VARCHAR(45) NULL DEFAULT NULL,
61  `vendor_number` VARCHAR(45) NULL DEFAULT NULL,
62  `price` VARCHAR(45) NULL DEFAULT NULL,
63  `reorder_number` VARCHAR(45) NULL DEFAULT NULL,
64  `pressing` VARCHAR(45) NULL DEFAULT NULL)
65ENGINE = InnoDB
66DEFAULT CHARACTER SET = utf8;
67
68
69SET SQL_MODE=@OLD_SQL_MODE;
70SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
71SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;