-- --------------------------------------------------------
-- Versione server:              10.1.18-MariaDB - MariaDB Server
-- S.O. server:                  Linux
-- HeidiSQL Versione:            9.4.0.5139
-- --------------------------------------------------------



-- Dump della struttura di tabella Events
CREATE TABLE IF NOT EXISTS `Events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `event` varchar(50) NOT NULL,
  `eventListener` varchar(100) NOT NULL,
  `isActive` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `priority` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `isAsync` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `event` (`event`),
  KEY `isStopped` (`isActive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='gestore degli eventi';

-- Dump dei dati della tabella Events: ~11 rows (circa)
DELETE FROM `Events`;
INSERT INTO `Events` (`id`, `event`, `eventListener`, `isActive`, `priority`, `isAsync`) VALUES
	(1, 'SetReleaseDate', 'Logging', 1, 10, 1),
	(2, 'releaseProduct', 'ReleaseProduct', 1, 10, 1),
	(3, 'assignPhotosToProduct', 'ReleaseProduct', 1, 10, 1),
	(4, 'changeOrderStatus', 'OrderStatusLog', 1, 10, 1),
	(5, 'friendSendRequestSuccess', 'OrderStatusLog', 1, 10, 1),
	(6, 'friendSendRequestFail', 'OrderStatusLog', 1, 10, 1),
	(7, 'friendOrderShipped', 'OrderStatusLog', 1, 10, 1),
	(8, 'friendOrderPayd', 'OrderStatusLog', 1, 10, 1),
	(9, 'changeOrderLineStatus', 'OrderStatusLog', 1, 10, 1),
	(10, 'userCreateOrder', 'OrderStatusLog', 1, 10, 1),
	(11, 'payOrder', 'OrderStatusLog', 1, 10, 1);

INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('userActivation', 'CActivateUser', 1, 10, 0);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('newOrder', 'CMailOrderBack', 1, 10, 1);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('orderLineStatusChange', 'COrderLineStatusHandler', 1, 10, 0);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('test', 'CTestSync', 1, 10, 0);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('dbUpdate', 'CCacheCleanUp', 1, 10, 1);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('catalogPhotoMissing', 'CCatalogCorrection', 1, 10, 1);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('marketplace.product.add', 'CEbayMarketplaceAddProduct', 1, 10, 1);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('product.stock.change', 'CEbayMarketplaceReviseProduct', 1, 10, 1);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('userActivation', 'CCreateCoupon', 0, 10, 1);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('newOrder', 'CMailOrderClient', 1, 10, 1);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('newOrder', 'CUpdateConversionStatistics', 1, 10, 1);
INSERT INTO Events (event, eventListener, isActive, priority, isAsync) VALUES ('test', 'CTestAsync', 1, 10, 1);

