24 lines
851 B
SQL
24 lines
851 B
SQL
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
ALTER TABLE `order` DROP FOREIGN KEY `fk_order_cart_id`;
|
|
|
|
UPDATE `config` SET `value`='2.0.5' WHERE `name`='thelia_version';
|
|
UPDATE `config` SET `value`='5' WHERE `name`='thelia_release_version';
|
|
UPDATE `config` SET `value`='0' WHERE `name`='thelia_minus_version';
|
|
UPDATE `config` SET `value`='' WHERE `name`='thelia_extra_version';
|
|
|
|
UPDATE `config` SET `name`='form_firewall_active' WHERE `name`='from_firewall_active';
|
|
|
|
SELECT @max_id := IFNULL(MAX(`id`),0) FROM `resource`;
|
|
|
|
INSERT INTO resource (`id`, `code`, `created_at`, `updated_at`) VALUES
|
|
(@max_id + 1, 'admin.search', NOW(), NOW());
|
|
|
|
INSERT INTO resource_i18n (`id`, `locale`, `title`) VALUES
|
|
(@max_id + 1, 'de_DE', 'Suchen'),
|
|
(@max_id + 1, 'en_US', 'Search'),
|
|
(@max_id + 1, 'es_ES', 'Buscar'),
|
|
(@max_id + 1, 'fr_FR', 'Recherche')
|
|
;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1; |