gest366/update/update_2.1.7.sql

8 lines
525 B
SQL

INSERT INTO `zz_modules` (`name`, `name2`, `module_dir`, `options`, `options2`, `icon`, `version`, `compatibility`, `order`, `parent`, `default`, `default_menu`, `enabled`, `type`, `new`) VALUES
('Import XML', '', 'import_pa', 'custom', '', 'fa fa-download', '2.0.1', '2.0.1', 9, 36, 1, 0, 1, 'menu', 0);
UPDATE `zz_modules` SET `parent`=( SELECT `id` FROM (SELECT `id` FROM `zz_modules` `m2` WHERE `name`='Documenti') AS `m2`) WHERE `name` IN('Import XML');
alter Table co_iva add xml int(0) NOT NULL DEFAULT '0';