CREATE TABLE `delevery_customer_api` (
  `api_id` int(255) NOT NULL,
  `api_customer_id` int(255) NOT NULL,
  `api_type` enum('holder') DEFAULT NULL
);


CREATE TABLE `delevery_customer_api_auth` (
  `auth_id` int(255) NOT NULL,
  `auth_api_id` int(255) DEFAULT NULL,
  `auth_type` enum('basic_token','jwt') DEFAULT NULL,
  `auth_response` json DEFAULT NULL,
  `auth_response_token_fields` varchar(255) DEFAULT NULL,
  `auth_token` text,
  `auth_token_path` text,
  `auth_api_configs_id` int(255) DEFAULT NULL
) ;


CREATE TABLE `delevery_customer_api_configs` (
  `api_configs_id` int(11) NOT NULL,
  `api_configs_headers` json DEFAULT NULL,
  `api_configs_params` json DEFAULT NULL,
  `api_configs_body` json DEFAULT NULL,
  `api_configs_url` text,
  `api_configs_method` varchar(255) DEFAULT NULL
);



CREATE TABLE `delevery_customer_api_parcel` (
  `parcel_id` int(255) NOT NULL,
  `parcel_api_id` int(255) NOT NULL,
  `parcel_api_configs_id` int(11) DEFAULT NULL,
  `parcel_response_path` varchar(255) DEFAULT NULL,
  `parcel_response_key` varchar(255) DEFAULT NULL,
  `parcel_response_value` varchar(255) DEFAULT NULL
);


CREATE TABLE `delevery_customer_api_status` (
  `status_id` int(255) NOT NULL,
  `status_api_id` int(255) NOT NULL,
  `status_response_path` varchar(255) DEFAULT NULL,
  `status_response_key` varchar(255) DEFAULT NULL,
  `status_response_value` varchar(255) DEFAULT NULL,
  `status_api_configs_id` int(255) NOT NULL,
  `status_response_result` json DEFAULT NULL
);

CREATE TABLE `delevery_customer_api_status_equal` (
  `status_equal_id` int(11) NOT NULL,
  `status_equal_status_local` varchar(255) DEFAULT NULL,
  `status_equal_status_api` json DEFAULT NULL,
  `status_equal_api_status_id` int(255) DEFAULT NULL
);

ALTER TABLE `delevery_customer_api`
  ADD PRIMARY KEY (`api_id`);

ALTER TABLE `delevery_customer_api_auth`
  ADD PRIMARY KEY (`auth_id`);

ALTER TABLE `delevery_customer_api_configs`
  ADD PRIMARY KEY (`api_configs_id`);

ALTER TABLE `delevery_customer_api_parcel`
  ADD PRIMARY KEY (`parcel_id`);

ALTER TABLE `delevery_customer_api_status`
  ADD PRIMARY KEY (`status_id`);

ALTER TABLE `delevery_customer_api_status_equal`
  ADD PRIMARY KEY (`status_equal_id`);

ALTER TABLE `delevery_customer_api`
  MODIFY `api_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;

ALTER TABLE `delevery_customer_api_auth`
  MODIFY `auth_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;

ALTER TABLE `delevery_customer_api_configs`
  MODIFY `api_configs_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;

ALTER TABLE `delevery_customer_api_parcel`
  MODIFY `parcel_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;

ALTER TABLE `delevery_customer_api_status`
  MODIFY `status_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;

ALTER TABLE `delevery_customer_api_status_equal`
  MODIFY `status_equal_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;

UPDATE `delevery_configs` SET `configs_val` =  CONCAT(`configs_val`, ',1') WHERE `delevery_configs`.`configs_var` = 'migration_symfony_api';