CREATE TABLE IF NOT EXISTS `delevery_folders` (
  `folder_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`folder_id`),
  KEY `delevery_folders` (`user_id`)
);

ALTER TABLE delevery_parcel
ADD parcel_folder int,
ADD FOREIGN KEY (parcel_folder) REFERENCES delevery_folders(folder_id);

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