103 lines
7.2 KiB
SQL
103 lines
7.2 KiB
SQL
SET NAMES 'utf8';
|
|
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('PS_DASHBOARD_USE_PUSH', '0', NOW(), NOW());
|
|
UPDATE `PREFIX_configuration` SET `value` = 'graphnvd3' WHERE `name` = 'PS_STATS_RENDER';
|
|
|
|
ALTER TABLE `PREFIX_employee` CHANGE `bo_show_screencast` `bo_menu` TINYINT(1) NOT NULL DEFAULT '1';
|
|
UPDATE `PREFIX_employee` SET bo_menu = 1;
|
|
|
|
CREATE TABLE `PREFIX_configuration_kpi` (
|
|
`id_configuration_kpi` int(10) unsigned NOT NULL auto_increment,
|
|
`id_shop_group` INT(11) UNSIGNED DEFAULT NULL,
|
|
`id_shop` INT(11) UNSIGNED DEFAULT NULL,
|
|
`name` varchar(32) NOT NULL,
|
|
`value` text,
|
|
`date_add` datetime NOT NULL,
|
|
`date_upd` datetime NOT NULL,
|
|
PRIMARY KEY (`id_configuration_kpi`),
|
|
KEY `name` (`name`),
|
|
KEY `id_shop` (`id_shop`),
|
|
KEY `id_shop_group` (`id_shop_group`)
|
|
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_configuration_kpi_lang` (
|
|
`id_configuration_kpi` int(10) unsigned NOT NULL,
|
|
`id_lang` int(10) unsigned NOT NULL,
|
|
`value` text,
|
|
`date_upd` datetime default NULL,
|
|
PRIMARY KEY (`id_configuration_kpi`,`id_lang`)
|
|
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8;
|
|
|
|
/* PHP:ps1600_add_missing_index(); */;
|
|
|
|
UPDATE `PREFIX_configuration` SET `value` = '-' WHERE `name` = 'PS_ATTRIBUTE_ANCHOR_SEPARATOR';
|
|
|
|
UPDATE `PREFIX_tab` SET class_name = 'AdminDashboard', id_parent = 0, active = 1, module = '' WHERE class_name = 'AdminHome';
|
|
UPDATE `PREFIX_tab_lang` SET name = 'Dashboard' WHERE id_tab IN (SELECT id_tab FROM `PREFIX_tab` WHERE class_name = 'AdminDashboard') AND id_lang IN (SELECT id_lang FROM `PREFIX_lang` WHERE iso_code = 'en');
|
|
UPDATE `PREFIX_tab_lang` SET name = 'Tableau de Bord' WHERE id_tab IN (SELECT id_tab FROM `PREFIX_tab` WHERE class_name = 'AdminDashboard') AND id_lang IN (SELECT id_lang FROM `PREFIX_lang` WHERE iso_code = 'fr');
|
|
|
|
|
|
INSERT INTO `PREFIX_module` (`name`, `active`, `version`)
|
|
VALUES ('graphnvd3', '1', '1.0'),('dashactivity', '1', '0.1'),('dashtrends', '1', '0.1'),('dashgoals', '1', '0.1'),('dashproducts', '1', '0.1');
|
|
|
|
INSERT INTO `PREFIX_module_access` (`id_profile`, `id_module`, `view`, `configure`) (
|
|
SELECT p.id_profile, m.id_module, 1, 1 FROM `PREFIX_module` m, `PREFIX_profile` p WHERE m.name IN ('graphnvd3', 'dashactivity', 'dashtrends', 'dashgoals', 'dashproducts')
|
|
);
|
|
|
|
INSERT INTO `PREFIX_module_shop` (`id_module`, `id_shop`) (
|
|
SELECT m.id_module, s.id_shop FROM `PREFIX_module` m, `PREFIX_shop` s WHERE m.name IN ('graphnvd3', 'dashactivity', 'dashtrends', 'dashgoals', 'dashproducts')
|
|
);
|
|
|
|
INSERT INTO `PREFIX_hook` (`name`, `title`, `position`, `live_edit`) VALUES
|
|
('dashboardZoneOne', 'dashboardZoneOne', 1, 0),
|
|
('dashboardZoneTwo', 'dashboardZoneTwo', 1, 0),
|
|
('dashboardData', 'dashboardData', 0, 0);
|
|
|
|
INSERT INTO `PREFIX_hook_module` (`id_module`, `id_shop`, `id_hook`, `position`) (
|
|
SELECT m.id_module, s.id_shop, h.id_hook, 0 FROM `PREFIX_module` m, `PREFIX_shop` s, `PREFIX_hook` h WHERE m.name IN ('dashactivity', 'dashtrends', 'dashproducts') AND h.name IN ('dashboardData')
|
|
);
|
|
INSERT INTO `PREFIX_hook_module` (`id_module`, `id_shop`, `id_hook`, `position`) (
|
|
SELECT m.id_module, s.id_shop, h.id_hook, 1 FROM `PREFIX_module` m, `PREFIX_shop` s, `PREFIX_hook` h WHERE m.name IN ('dashactivity') AND h.name IN ('dashboardZoneOne')
|
|
);
|
|
INSERT INTO `PREFIX_hook_module` (`id_module`, `id_shop`, `id_hook`, `position`) (
|
|
SELECT m.id_module, s.id_shop, h.id_hook, 1 FROM `PREFIX_module` m, `PREFIX_shop` s, `PREFIX_hook` h WHERE m.name IN ('dashtrends') AND h.name IN ('dashboardZoneTwo')
|
|
);
|
|
INSERT INTO `PREFIX_hook_module` (`id_module`, `id_shop`, `id_hook`, `position`) (
|
|
SELECT m.id_module, s.id_shop, h.id_hook, 2 FROM `PREFIX_module` m, `PREFIX_shop` s, `PREFIX_hook` h WHERE m.name IN ('dashgoals') AND h.name IN ('dashboardZoneTwo')
|
|
);
|
|
INSERT INTO `PREFIX_hook_module` (`id_module`, `id_shop`, `id_hook`, `position`) (
|
|
SELECT m.id_module, s.id_shop, h.id_hook, 3 FROM `PREFIX_module` m, `PREFIX_shop` s, `PREFIX_hook` h WHERE m.name IN ('dashproducts') AND h.name IN ('dashboardZoneTwo')
|
|
);
|
|
|
|
INSERT INTO `PREFIX_configuration` (`id_shop_group`, `id_shop`, `name`, `value`, `date_add`, `date_upd`) VALUES (NULL, NULL, 'CONF_AVERAGE_PRODUCT_MARGIN', '40', NOW(), NOW());
|
|
|
|
ALTER TABLE `PREFIX_employee` ADD `stats_compare_from` DATE NULL DEFAULT NULL AFTER `stats_date_to` , ADD `stats_compare_to` DATE NULL DEFAULT NULL AFTER `stats_compare_from`;
|
|
|
|
INSERT INTO `PREFIX_hook` (`name` , `title` , `description` , `position` , `live_edit`)
|
|
VALUES ('displayHomeTab', 'Home Page Tabs', 'This hook displays new elements on the homepage tabs', '1', '1')
|
|
ON DUPLICATE KEY UPDATE `position` = 1, `live_edit` = 1;
|
|
INSERT INTO `PREFIX_hook` (`name` , `title` , `description` , `position` , `live_edit`)
|
|
VALUES ('displayHomeTabContent', 'Home Page Tabs Content', 'This hook displays new elements on the homepage tabs content', '1', '1')
|
|
ON DUPLICATE KEY UPDATE `position` = 1, `live_edit` = 1;
|
|
INSERT INTO `PREFIX_hook` (`name` , `title` , `description` , `position` , `live_edit`)
|
|
VALUES ('displayBackOfficeCategory', 'Display new elements in the Back Office, tab AdminCategories', 'This hook launches modules when the AdminCategories tab is displayed in the Back Office', '1', '1')
|
|
ON DUPLICATE KEY UPDATE `position` = 1, `live_edit` = 1;
|
|
INSERT INTO `PREFIX_hook` (`name` , `title` , `description` , `position` , `live_edit`)
|
|
VALUES ('actionBackOfficeCategory', 'Process new elements in the Back Office, tab AdminCategories', 'This hook process modules when the AdminCategories tab is displayed in the Back Office', '1', '1')
|
|
ON DUPLICATE KEY UPDATE `position` = 1, `live_edit` = 1;
|
|
|
|
ALTER TABLE `PREFIX_employee` ADD `stats_compare_option` INT( 1 ) NOT NULL DEFAULT '1' AFTER `stats_compare_to`;
|
|
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('DASHACTIVITY_CART_ACTIVE', '30', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('DASHACTIVITY_CART_ABANDONED_MIN', '24', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('DASHACTIVITY_CART_ABANDONED_MAX', '48', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('DASHACTIVITY_VISITOR_ONLINE', '30', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('PS_DASHGOALS_CURRENT_YEAR', YEAR(NOW()), NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('DASHPRODUCT_NBR_SHOW_LAST_ORDER', '10', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('DASHPRODUCT_NBR_SHOW_BEST_SELLER', '10', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('DASHPRODUCT_NBR_SHOW_MOST_VIEWED', '10', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('DASHPRODUCT_NBR_SHOW_TOP_SEARCH', '10', NOW(), NOW());
|
|
|
|
INSERT INTO `PREFIX_configuration` (name, value, date_add, date_upd) VALUES ('PS_RETURN_PREFIX', '#RE', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration_lang` (`id_configuration`, `id_lang`, `value`, `date_upd`) SELECT c.`id_configuration`, l.`id_lang`, c.`value`, NOW() FROM `PREFIX_configuration` c, `PREFIX_lang` l WHERE c.`name` = 'PS_RETURN_PREFIX';
|