   INDEX `bank_billing_id_idx` (`bank_billing_address_id` ASC),
   CONSTRAINT `bank_user_id`
     FOREIGN KEY (`bank_user_id`)
-    REFERENCES `emarket`.`user_info` (`user_id`)
+    REFERENCES `emarket_test`.`user_info` (`user_id`)
     ON DELETE CASCADE
     ON UPDATE CASCADE,
   CONSTRAINT `bank_billing_id`
     FOREIGN KEY (`bank_billing_address_id`)
-    REFERENCES `emarket`.`billing_info` (`billing_id`)
-    ON DELETE CASCADE
-    ON UPDATE CASCADE)
-ENGINE = InnoDB;
-
-
--- -----------------------------------------------------
--- Table `emarket`.`category_info`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `emarket`.`category_info` (
+    REFERENCES `emarket_test`.`billing_info` (`billing_id`)
+    ON DELETE CASCADE
+    ON UPDATE CASCADE)
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `emarket_test`.`category_info`
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS `emarket_test`.`category_info` (
   `category_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
   `category_name` VARCHAR(45) NOT NULL,
   `category_parent_id` INT UNSIGNED NULL DEFAULT NULL,

WHERE ps.product_spec_is_draft = 0;

-- -----------------------------------------------------
-- View `emarket`.`report_params`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `emarket`.`report_params`;
USE `emarket`;
CREATE  OR REPLACE VIEW report_params AS SELECT 5000 as operation_cost, 0.05 as sales_fee_percent;

-- -----------------------------------------------------
-- View `emarket`.`report_items`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `emarket`.`report_items`;
USE `emarket`;
CREATE  OR REPLACE VIEW report_items AS
SELECT  category_info.category_id,
    category_info.category_name,

    category_info.category_status = 1;

-- -----------------------------------------------------
-- View `emarket_test`.`report_month`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `emarket_test`.`report_month`;
USE `emarket_test`;
CREATE  OR REPLACE VIEW report_month AS
SELECT  category_info.category_id,
    category_info.category_name,
