CREATE TABLE `dynamics_order_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_number` varchar(20) NOT NULL,
  `status` tinyint(2) NOT NULL COMMENT '0=Active\n1=Confirmed\n2=Picked\n3=PartiallyDelivered\n4=Delivered\n5=Invoiced\n6=PartiallyInvoiced\n7=Canceled\n8=DeliveredPartiallyInvoiced',
  `error` longtext,
  `data_outgoing` longtext,
  `data_incoming` longtext,
  PRIMARY KEY (`id`)
);


ALTER TABLE `dynamics_order_log`
ADD COLUMN `document_number` VARCHAR(255) NULL AFTER `data_incoming`;


ALTER TABLE `dynamics_order_log`
ADD COLUMN `identifier` VARCHAR(255) NOT NULL COMMENT 'z.B. die (fortlaufende) Nummer der Confirmation' AFTER `status`;


ALTER TABLE `dynamics_order_log`
ADD COLUMN `create_date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP AFTER `document_number`;

CREATE TABLE `edi_error` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) DEFAULT '1' COMMENT '0=internal\\n1=general\\n2=core_data\\norder_data',
  `message` varchar(255) DEFAULT NULL,
  `external_document_number` varchar(255) DEFAULT NULL,
  `data` longtext,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(1) DEFAULT '1' COMMENT '1=Offen\n2=Geschlossen',
  `user_id` int(11) DEFAULT NULL COMMENT 'Der Nutzer, der den Fehler bearbeitet hat',
  `close_date` timestamp NULL DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `customer_gln` varchar(255) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `message_type` tinyint(1) DEFAULT NULL COMMENT '1=Order\n2=OrderResponse\n3=DESADV\n4=Invoice',
  `dynamics_order_number` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `allowResend` tinyint(1) DEFAULT '0' COMMENT 'Flag für die Batch Verarbeitung',
  `edit_link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token_UNIQUE` (`token`),
  KEY `fk_edi_error_1_idx` (`user_id`),
  KEY `fk_edi_error_2_idx` (`company_id`),
  CONSTRAINT `fk_edi_error_1` FOREIGN KEY (`user_id`) REFERENCES `adminuser` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_edi_error_2` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
);