-- -----------------------------------------------------
-- Table `datenbank`.`order`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `datenbank`.`order` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `user_id` INT NULL ,
  `orderstatus_id` INT NOT NULL ,
  `cartid` VARCHAR(200) NULL ,
  `orderidenthash` VARCHAR(200) NULL ,
  `asin` VARCHAR(200) NOT NULL ,
  `title` VARCHAR(200) NULL ,
  `quantity` INT NOT NULL ,
  `itemprice` DECIMAL(9,2) NOT NULL ,
  `sumprice` DECIMAL(9,2) NOT NULL ,
  `earnings` DECIMAL(9,2) NOT NULL DEFAULT 0.00 ,
  `payback` DECIMAL(9,2) NOT NULL DEFAULT 0.00 ,
  `comment` VARCHAR(200) NULL ,
  `updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
  `created` TIMESTAMP NULL ,
  `disabled` TINYINT(1)  NOT NULL DEFAULT 0 ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_order_user1` (`user_id` ASC) ,
  INDEX `fk_order_orderstatus1` (`orderstatus_id` ASC) ,
  CONSTRAINT `fk_order_user1`
    FOREIGN KEY (`user_id` )
    REFERENCES `datenbank`.`user` (`id` )
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_order_orderstatus1`
    FOREIGN KEY (`orderstatus_id` )
    REFERENCES `datenbank`.`orderstatus` (`id` )
    ON DELETE SET NULL
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `datenbank`.`user`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `datenbank`.`user` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `login` VARCHAR(200) NOT NULL ,
  `email` VARCHAR(200) NOT NULL ,
  `firstname` VARCHAR(200) NULL ,
  `lastname` VARCHAR(200) NULL ,
  `passwdhash` VARCHAR(200) NOT NULL ,
  `hashalgo` VARCHAR(200) NOT NULL ,
  `hashrounds` INT NOT NULL DEFAULT 50 ,
  `tempkey` VARCHAR(200) NULL ,
  `updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
  `created` TIMESTAMP NULL ,
  `disabled` TINYINT(1)  NOT NULL DEFAULT 0 ,
  PRIMARY KEY (`id`) ,
  UNIQUE INDEX `email_UNIQUE` (`email` ASC) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `datenbank`.`orderstatus`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `datenbank`.`orderstatus` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(200) NULL ,
  `updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
  `created` TIMESTAMP NULL ,
  `disabled` TINYINT(1)  NOT NULL DEFAULT 0 ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB;

ON DELETE SET NULL