INSERT INTO `qs_Application` (`class`, `role`, `title`, `sorter`) VALUES ('App_ViewControllerLog_Admin_View', 'admin,staff', 'Action Log', '420');

UPDATE `qs_Application` SET `class` = 'App\\Gallery\\Image\\Admin\\View' WHERE `class` = 'App\\Gallery\\Category\\Admin\\View';
UPDATE `qs_Application` SET `title` = 'Gallery Photos' WHERE `class` = 'App\\Gallery\\Image\\Admin\\View';

UPDATE `qs_Application` SET `title` = 'Gallery Albums' WHERE `class` = 'App\\Gallery\\Admin\\View';

DELETE FROM `qs_Application` WHERE `class` = 'App_Slide_Admin_HotSpot_View';
DELETE FROM `qs_Application` WHERE `class` = 'App_Slide_Admin_View';

UPDATE `qs_Application` SET `title` = 'Slides' WHERE `class` = 'App\\WideSlide\\Admin\\View';

-- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- -------- --------

UPDATE `qs_Application` SET `class` = 'App\\Gallery\\View' WHERE `class` = 'App\\Gallery\\Category\\View';
INSERT INTO `qs_Application` (`class`, `role`, `title`, `sorter`) VALUES ('App\\ECommerce\\Product\\Review\\View', 'User', 'Product Reviews', '430');

ALTER TABLE `qs_ViewControllerLogSession` ADD `lastActivityId` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `roleId`;

-- !!! execute routinesAndTriggers.sql !!!

DELETE FROM `qs_Application` WHERE `qs_Application`.`class` = 'App_ViewControllerLog_Admin_View';
INSERT INTO `qs_Application` (`class`, `role`, `title`, `sorter`) VALUES
('App\\ViewControllerLog\\Session\\Admin\\View', 'admin,staff', 'Action Log: Sessions', '440'),
('App\\ViewControllerLog\\Log\\Admin\\View', 'admin,staff', 'Action Log: Activity', '450');