/* FILLING LANG */
INSERT INTO Lang (id, lang, name) VALUES (1, 'it', 'Italiano');
INSERT INTO Lang (id, lang, name) VALUES (2, 'en', 'English');
INSERT INTO Lang (id, lang, name) VALUES (3, 'de', 'Deutsch');

/* FILLING CURRENCY */
INSERT INTO Currency (id, code, conversionToEur) VALUES (1, 'EUR', 1);

/* FILLING CURRENCY TRANLSATION */
INSERT INTO CurrencyTranslation (currencyId, langId, name) VALUES (1, 1, 'Euro');
INSERT INTO CurrencyTranslation (currencyId, langId, name) VALUES (1, 2, 'Euro');
INSERT INTO CurrencyTranslation (currencyId, langId, name) VALUES (1, 3, 'Euro');


INSERT INTO ImporterField (id, name, location, title, description) VALUES (12, 'category', 'Product', 'Categoria', 'La categoria calcolata del prodotto');
INSERT INTO ImporterField (id, name, location, title, description) VALUES (13, 'audience', 'Extend', 'Audience', 'La macrocategoria indicata dall''importatore');
INSERT INTO ImporterField (id, name, location, title, description) VALUES (14, 'cat1', 'Extend', 'Categoria 1', 'La prima categoria indicata dall''importatore');
INSERT INTO ImporterField (id, name, location, title, description) VALUES (15, 'sizeGroup', 'Extend', 'Gruppo Taglia', 'Il gruppo taglia indicato dall''importatore');
INSERT INTO ImporterField (id, name, location, title, description) VALUES (16, 'cat2', 'Extend', 'Categoria 2', 'La seconda cat indicata dall''importatore');

INSERT INTO ImporterFieldModifier (id, modifier) VALUES (5, 'max');
INSERT INTO ImporterFieldModifier (id, modifier) VALUES (6, 'min');
INSERT INTO ImporterFieldModifier (id, modifier) VALUES (7, 'avg');
INSERT INTO ImporterFieldModifier (id, modifier) VALUES (8, 'first');
INSERT INTO ImporterFieldModifier (id, modifier) VALUES (9, 'last');

INSERT INTO ImporterLogicConnector (id, name, title, description) VALUES (1, 'and', 'E', 'Vero se entrambe le condizioni sono vere');
INSERT INTO ImporterLogicConnector (id, name, title, description) VALUES (2, 'or', 'O', 'Vero se una delle due condizioni è vera');
INSERT INTO ImporterLogicConnector (id, name, title, description) VALUES (3, 'xor', 'X', 'Vero se i risultati delle cond. sono diversi');

INSERT INTO ImporterOperator (id, name, title, description) VALUES (9, '==', 'uguale', 'è uguale a');
INSERT INTO ImporterOperator (id, name, title, description) VALUES (10, '!=', 'diverso', 'è diverso da');
INSERT INTO ImporterOperator (id, name, title, description) VALUES (11, '>', 'maggiore', 'è maggiore di');
INSERT INTO ImporterOperator (id, name, title, description) VALUES (12, '<', 'minore', 'è minore di');
INSERT INTO ImporterOperator (id, name, title, description) VALUES (13, '>=', 'maggiore o uguale', 'è maggiore o uguale a');
INSERT INTO ImporterOperator (id, name, title, description) VALUES (14, '<=', 'minore o uguale', 'è minore o uguale a');
INSERT INTO ImporterOperator (id, name, title, description) VALUES (15, 'in', 'nel gruppo', 'è uguale a uno dei seguenti');
INSERT INTO ImporterOperator (id, name, title, description) VALUES (16, 'not in', 'non nel gruppo', 'è diverso da ciascuno dei seguenti');

/* ORDER LINE STATUS !!!MULTISHOP!!! */
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (1, 'CRT', 'Cart', 'OrderLine is a still a Cart', 3, 2, 1, null, '#00FF00', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (2, 'CRT_MRG', 'Cart Merged', 'OrderLine is a cart meged into an other', null, null, 1, null, '#00FF00', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (3, 'ORD_PENDING', 'Pending', 'Order is waiting for payment confirm', 4, 15, 2, 1, '#00FF00', 1);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (4, 'ORD_WAIT', 'Waiting', 'OrderLine is waiting for internal OK', 17, 15, 3, 1, '#00FF00', 1);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (5, 'ORD_FRND_SENT', 'Fr Req Sent', 'OrderLine is waiting for Friend OK', 7, 6, 6, null, '#FFD700', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (6, 'ORD_FRND_CANC', 'Fr Cancel', 'Friend Refused this Line', 17, 14, 7, 1, '#FF0000', 1);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (7, 'ORD_FRND_OK', 'Fr Accept', 'Friend Accepted this Line', 8, 6, 7, 1, '#00FF00', 1);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (8, 'ORD_FRND_PYD', 'Fr Paying', 'Friend was paidAmount and have to ship Product', 19, 17, 8, 0, '#FF4500', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (9, 'ORD_FRND_SNDING', 'Fr Req Sending', 'Order line will be sent to Friend', 5, 18, 5, null, '#FF4500', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (10, 'ORD_CHK_IN', 'Check In', 'Product is in place and is being accepted', 11, 16, 10, 1, '#00FF00', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (11, 'ORD_PCK_CLI', 'Packing', 'Product is being packed', 12, 16, 11, 1, '#00FF00', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (12, 'ORD_SENT', 'Shipped', 'Product is being sent', 13, 15, 12, 1, '#0000FF', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (13, 'ORD_ARCH', 'Archived', 'It''s been long enough since shipment, no return/refound is possible', null, null, 99, null, '#0000FF', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (14, 'ORD_MISSNG', 'Missing', 'Product is not really in stock, user action is needed', 17, 15, 98, 1, '#FF0000', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (15, 'ORD_CANCEL', 'Canceled', 'Order Line has been cancelled forever', null, null, 99, null, '#0000FF', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (16, 'ORD_QLTY_KO', 'Quality Fail', 'The quality of the product is below standard', 17, 15, 98, 1, '#FF0000', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (17, 'ORD_LAB', 'Working', 'Order has been accepted and is in working status', 9, 14, 4, 1, '#00FF00', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (18, 'ORD_ERR_SEND', 'Fr Req ErrSend', 'There''s been an error while sending hte order', 9, 17, 6, 1, '#FF0000', 0);
INSERT INTO OrderLineStatus (id, code, title, description, nextOrderLineStatusId, errOrderLineStatusId, phase, isManageable, colore, notify) VALUES (19, 'ORD_FRND_ORDSNT', 'Fr Paid', 'We sent payment confirm to Friend', 10, 8, 9, 1, '#FFD700', 0);

/* ORDER STATUS */
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (1, 'CRT', 'Cart', 'Order is a still a Cart', 3, 2, 1, '#FF4500');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (2, 'CRT_MRG', 'Cart Merged', 'Order is a cart meged into an other', null, null, 1, '#FFD700');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (3, 'ORD_PENDING', 'Pending', 'Order is waiting for payment confirm', 4, 11, 2, '#FF4500');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (4, 'ORD_WAIT', 'Waiting', 'Order is waiting for internal OK', 5, null, 3, '#FF4500');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (5, 'ORD_WORK', 'Working', 'Order is being Prepared', 6, 12, 4, '#00FF00');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (6, 'ORD_PACK', 'Packing', 'Order is being Packed and will be ready soon', 7, 14, 5, '#00FF00');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (7, 'ORD_READY', 'Ready for shipment', 'Order is ready to be delivered/Picked', 8, null, 6, '#00FF00');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (8, 'ORD_SHIPPED', 'Shipped', 'Order was given to Carrier', 9, 15, 7, '#0000FF');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (9, 'ORD_DELIVERED', 'Delivered', 'Order was delivered to Costumer', 10, null, 8, '#0000FF');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (10, 'ORD_CLOSED', 'Closed', 'Order cannot be returned', null, null, 9, '#0000FF');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (11, 'ORD_ERR_PAY', 'Payment Error', 'Order was canceled becouse of payment', 3, 13, 2, '#FF0000');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (12, 'ORD_ERR_MISS', 'Product Missing', 'Order has some missing product and can''t be packed', 6, 13, 5, '#FF0000');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (13, 'ORD_CANCEL', 'Order Cancelled Definitively', 'Order is deleted', null, null, 9, '#FF0000');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (14, 'ORD_ERR_QLTY', 'Quality Check issue', 'Order has some quality check issue', null, null, 6, '#00FF00');
INSERT INTO OrderStatus (id, code, title, description, nextOrderStatusId, errOrderStatusId, `order`, color) VALUES (15, 'ORD_ERR_DELI', 'Order delivery error', 'Order coudnt be delivered', 8, 13, 9, '#FF0000');

/* ORDER STATUS TRANSLATION */
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (1, 1, 'Carrello', '');
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (2, 1, 'Carrello', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (3, 1, 'Attesa di pagamento', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (4, 1, 'In accettazione', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (5, 1, 'In lavorazione', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (6, 1, 'Pacco in preparazione', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (7, 1, 'In spedizione', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (8, 1, 'Spedito', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (9, 1, 'Consegnato', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (10, 1, 'Chiuso', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (11, 1, 'Errore di Pagamento', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (12, 1, 'Incompleto', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (13, 1, 'Annullato', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (14, 1, 'Qualità non conforme', null);
INSERT INTO OrderStatusTranslation (orderStatusId, langId, title, name) VALUES (15, 1, 'Errore spedizione', null);

/* BACKOFFICE PAGES !!!MULTISHOP!!! */
INSERT INTO Page (id, slug, url, icon, permission) VALUES (1, 'login', '/blueseal/', 'fa-signin', null);
INSERT INTO Page (id, slug, url, icon, permission) VALUES (2, 'dashboard', '/blueseal/dashboard', 'fa-home', '/admin/dashboard');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (3, 'content_manage', '/blueseal/contenuti', 'fa-paragraph', '/admin/content/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (4, 'product_list', '/blueseal/prodotti', 'fa-list-alt', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (5, 'product_add', '/blueseal/prodotti/aggiungi', 'fa-plus-circle', '/admin/product/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (6, 'product_edit', '/blueseal/prodotti/modifica', 'fa-pencil-square', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (7, 'product_user_bug_list', '/blueseal/prodotti/incompleti', 'fa-list-alt', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (8, 'product_importer_bug_list', '/blueseal/prodotti/incompleti/importatori', 'fa-list-alt', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (9, 'product_brand_list', '/blueseal/prodotti/brand', 'fa-list-alt', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (10, 'product_brand_add', '/blueseal/prodotti/brand/aggiungi', 'fa-plus-circle', '/admin/product/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (11, 'product_brand_edit', '/blueseal/prodotti/brand/modifica', 'fa-pencil-square', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (12, 'product_sizegroup_list', '/blueseal/prodotti/gruppo-taglie', 'fa-list-alt', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (13, 'product_sizegroup_add', '/blueseal/prodotti/gruppo-taglie/aggiungi', 'fa-plus-circle', '/admin/product/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (14, 'product_colorgroup_list', '/blueseal/prodotti/gruppo-colore', 'fa-list-alt', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (15, 'product_colorgroup_add', '/blueseal/prodotti/gruppo-colore/aggiungi', 'fa-plus-circle', '/admin/product/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (16, 'product_category_list', '/blueseal/prodotti/categorie', 'fa-list-alt', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (17, 'product_category_add', '/blueseal/prodotti/categorie/aggiungi', 'fa-plus-circle', '/admin/product/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (18, 'order_list', '/blueseal/ordini', 'fa-list-alt', '/admin/order/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (19, 'aztec_print', '/blueseal/print/azteccode', 'fa-default', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (20, 'product_sku', '/blueseal/skus', 'fa-default', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (21, 'order_manage', '/blueseal/ordini/aggiungi', 'fa-default', '/admin/order/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (22, 'product_photo_manage', '/blueseal/prodotti/foto', 'fa-default', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (23, 'user_list', '/blueseal/utenti', 'fa-list-alt', '/admin/user/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (24, 'landing_list', '/blueseal/marketing/landing', 'fa-hand-pointer-o', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (25, 'landing_add', '/blueseal/marketing/landing/aggiungi', 'fa-plus-circle', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (26, 'product_roulette', '/blueseal/prodotti/roulette', 'fa-default', '/admin/product/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (27, 'product_brand_delete', '/blueseal/prodotti/brand/elimina', 'fa-default', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (28, 'product_colorgroup_edit', '/blueseal/prodotti/gruppo-colore/aggiungi', 'fa-default', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (29, 'product_active_list', '/blueseal/prodotti/attivi', 'fa-flag-checkered', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (30, 'order_friend_confirmation', '/blueseal/confirm', 'fa-default', '/admin/order/friend-confirm');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (31, 'blog_list', '/blueseal/blog', 'fa-list-alt', '/admin/content/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (32, 'blog_add', '/blueseal/blog/aggiungi', 'fa-plus-circle', '/admin/content/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (33, 'blog_edit', '/blueseal/blog/modifica', 'fa-default', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (34, 'blog_trash', '/blueseal/blog/cestino', 'fa-trash', '/admin/content/delete');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (35, 'blog_category', '/blueseal/blog/categorie', 'fa-sitemap', '/admin/content/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (36, 'blog_tag', '/blueseal/blog/tag', 'fa-tags', '/admin/content/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (37, 'content_homepage_list', '/blueseal/contenuti/homepage', 'fa-home', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (38, 'content_catalog_list', '/blueseal/contenuti/catalogo', 'fa-cubes', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (39, 'content_checkout_list', '/blueseal/contenuti/checkout', 'fa-shopping-cart', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (40, 'content_database_list', '/blueseal/contenuti/database', 'fa-database', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (41, 'content_general_list', '/blueseal/contenuti/generale', 'fa-folder-o', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (42, 'content_other_list', '/blueseal/contenuti/altro', 'fa-folder-o', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (43, 'product_detail_list', '/blueseal/prodotti/dettagli', 'fa-list-alt', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (44, 'content_productsheet_list', '/blueseal/contenuti/prodotti/schede', 'fa-folder-o', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (45, 'xhr_controller', '/blueseal/xhr/', 'fa-folder-o', '/admin/blueseal');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (46, 'content_homepage_edit', '/blueseal/contenuti/homepage/modifica/:id', 'fa-home', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (47, 'coupon_list', '/blueseal/coupon', 'fa-eur', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (48, 'coupon_edit', '/blueseal/coupon/modifica', 'fa-eur', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (49, 'coupon_add', '/blueseal/coupon/aggiungi', 'fa-eur', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (50, 'coupontype_list', '/blueseal/tipocoupon', 'fa-eur', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (51, 'coupontype_edit', '/blueseal/tipocoupon/modifica', 'fa-eur', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (52, 'coupontype_add', '/blueseal/tipocoupon/aggiungi', 'fa-eur', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (53, 'couponevent_list', '/blueseal/eventocoupon', 'fa-eur', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (54, 'couponevent_edit', '/blueseal/eventocoupon/modifica', 'fa-eur', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (55, 'couponevent_add', '/blueseal/eventocoupon/aggiungi', 'fa-eur', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (56, 'content_homepage_add', '/blueseal/contenuti/homepage/aggiungi', 'fa-plus-circle', '/admin/content/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (57, 'invoice_print', '/blueseal/print/invoice', 'fa-default', '/admin/order/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (58, 'order_print', '/blueseal/print/order', 'fa-default', '/admin/order/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (59, 'content_catalog_edit', '/blueseal/contenuti/catalogo/modifica/:id', 'fa-cubes', '/admin/content/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (60, 'detail_translate_list', '/blueseal/traduzioni/dettagli', 'fa-list-alt', '/admin/product/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (61, 'detail_translate_edit', '/blueseal/traduzioni/dettagli/modifica', 'fa-list-alt', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (62, 'detail_lang_list', '/blueseal/traduzioni/dettagli/lingua/:langid', 'fa-list-alt', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (63, 'detail_langall_list', '/blueseal/traduzioni/dettagli/lingua_list/:langId', 'fa-list-alt', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (64, 'dictionary_brand_list', '/blueseal/importatori/dizionari/brand', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (65, 'connector_edit', '/blueseal/importatori/connettori/aggiungi', 'fa-connectdevelop', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (66, 'logs_list', '/blueseal/importatori/logs', 'fa-sign-in', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (67, 'shop_list', '/blueseal/importatori/connettori', 'fa-connectdevelop', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (68, 'dictionary_brand_edit', '/blueseal/importatori/dizionari/brand/modifica/:shopId', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (69, 'dictionary_size_list', '/blueseal/importatori/dizionari/taglie', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (70, 'dictionary_size_edit', '/blueseal/importatori/dizionari/taglie/modifica/:shopId', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (71, 'dictionary_season_list', '/blueseal/importatori/dizionari/stagioni', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (72, 'dictionary_season_edit', '/blueseal/importatori/dizionari/stagioni/modifica/:shopId', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (73, 'dictionary_tag_list', '/blueseal/importatori/dizionari/tag', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (74, 'dictionary_tag_edit', '/blueseal/importatori/dizionari/tag/modifica/:shopId', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (75, 'dictionary_category_list', '/blueseal/importatori/dizionari/categorie', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (76, 'dictionary_category_edit', '/blueseal/importatori/dizionari/categorie/modifica/:shopId', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (77, 'dictionary_color_list', '/blueseal/importatori/dizionari/colori', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (78, 'dictionary_color_edit', '/blueseal/importatori/dizionari/colori/modifica/:shopId', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (79, 'setting_ebay', '/blueseal/impostazioni/ebay', 'fa-cog', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (80, 'tag_list', '/blueseal/tag', 'fa-tags', '/admin/product/list');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (81, 'importer_list', '/blueseal/importatori', 'fa-connectdevelop', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (82, 'dictionary_list', '/blueseal/importatori/dizionari', 'fa-language', '/admin/marketing');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (83, 'description_translate_list', '/blueseal/traduzioni/descrizioni', 'fa-list-alt', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (84, 'tag_add', '/blueseal/tag/aggiungi', 'fa-tags', '/admin/product/add');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (85, 'description_translate_edit', '/blueseal/traduzioni/descrizioni/modifica', 'fa-language', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (86, 'name_translate_list', '/blueseal/traduzioni/nomi', 'fa-list-alt', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (87, 'name_translate_edit', '/blueseal/traduzioni/nomi/modifica', 'fa-language', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (88, 'name_lang_list', '/blueseal/traduzioni/nomi/lingua/:langid', 'fa-language', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (89, 'name_langall_list', '/blueseal/traduzioni/nomi/lingua_list/:langid', 'fa-language', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (90, 'description_lang_edit', '/blueseal/traduzioni/descrizioni/lingua', 'fa-language', '/admin/product/edit');
INSERT INTO Page (id, slug, url, icon, permission) VALUES (91, 'tag_edit', '/blueseal/tag/modifica/:id', 'fa-tags', '/admin/product/edit');

INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (1, 1, 'Accedi a Blueseal', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (2, 1, 'Benvenuto', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (3, 1, 'Gestisci i contenuti dell''e-commerce', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (4, 1, 'Elenco prodotti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (5, 1, 'Aggiungi un prodotto', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (6, 1, 'Modifica un prodotto', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (7, 1, 'Prodotti incompleti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (8, 1, 'Prodotti incompleti da importazione', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (9, 1, 'Elenco brand', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (10, 1, 'Aggiungi un brand', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (11, 1, 'Modifica un brand', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (12, 1, 'Elenco gruppi taglie', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (13, 1, 'Aggiungi un gruppo taglie', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (14, 1, 'Elenco gruppi colore', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (15, 1, 'Aggiungi un gruppo colore', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (16, 1, 'Elenco categorie di prodotti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (17, 1, 'Aggiungi una categoria di prodotti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (18, 1, 'Elenco ordinazioni', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (19, 1, 'Stampa Aztec Code', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (20, 1, 'Modifica Skus', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (21, 1, 'Opera Ordine', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (22, 1, 'Gestisci Foto', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (23, 1, 'Utenti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (24, 1, 'Landing Page', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (25, 1, 'Nuova landing page', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (26, 1, 'Roulette Prodotti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (27, 1, 'Elimina un brand', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (28, 1, 'Modifica gruppo Colore', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (29, 1, 'Prodotti Pronti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (30, 1, 'Conferma Accettazione Ordine', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (31, 1, 'Elenco post', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (32, 1, 'Nuovo post', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (33, 1, 'Modifica post', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (34, 1, 'Cestino', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (35, 1, 'Categorie', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (36, 1, 'Tag', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (37, 1, 'Homepage', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (38, 1, 'Catalogo', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (39, 1, 'Processo d''acquisto', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (40, 1, 'Database', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (41, 1, 'Generale', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (42, 1, 'Altre pagine', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (43, 1, 'Dettagli prodotto', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (44, 1, 'Schede prodotto', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (46, 1, 'Modifica widget homepage', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (47, 1, 'Coupon', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (48, 1, 'Modifica coupon', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (49, 1, 'Aggiungi coupon', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (50, 1, 'Tipo coupon', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (51, 1, 'Modifica tipo coupon', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (52, 1, 'Aggiungi tipo coupon', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (53, 1, 'Evento coupon', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (54, 1, 'Modifica evento coupon', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (55, 1, 'Aggiungi evento coupon', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (56, 1, 'Aggiungi un widget', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (57, 1, 'Stampa fattura', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (58, 1, 'Stampa ordine', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (59, 1, 'Modifica widget catalogo', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (60, 1, 'Traduzione dettagli', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (61, 1, 'Modifica traduzione dettaglio', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (62, 1, 'Lista dettagli', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (63, 1, 'Lista dettagli per lingua', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (64, 1, 'Dizionari brand', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (65, 1, 'Connettori', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (66, 1, 'Logs', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (67, 1, 'Connettori', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (68, 1, 'Traduci dizionari brand', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (69, 1, 'Dizionari taglie', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (70, 1, 'Traduci dizionari taglie', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (71, 1, 'Dizionari stagioni', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (72, 1, 'Traduci dizionari stagioni', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (73, 1, 'Dizionari tag', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (74, 1, 'Traduci dizionari tag', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (75, 1, 'Dizionari categorie', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (76, 1, 'Traduci dizionari categorie', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (77, 1, 'Dizionari colori', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (78, 1, 'Traduci dizionari colori', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (79, 1, 'Impostazioni ebay', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (80, 1, 'Gestione Tag', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (81, 1, 'Gestione importatori', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (82, 1, 'Dizionari', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (83, 1, 'Traduzione descrizioni', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (84, 1, 'Aggiungi Tag', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (85, 1, 'Traduci descrizioni prodotti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (86, 1, 'Traduzione nomi', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (87, 1, 'Traduci nomi prodotti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (88, 1, 'Lista nomi prodotti', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (89, 1, 'Lista nomi prodotti per lingua', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (90, 1, 'Traduci descrizioni', null, null);
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (91, 1, 'Modifica tag', null, null);

/* SIDEBAR GROUP */
INSERT INTO SidebarGroup (id, slug, icon) VALUES (1, 'dashboard-g', 'fa-dashboard');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (2, 'content-g', 'fa-paragraph');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (3, 'product-g', 'fa-industry');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (4, 'order-g', 'fa-money');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (5, 'brand-g', 'fa-trademark');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (6, 'size-g', 'fa-sort-numeric-asc');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (7, 'color-g', 'fa-paint-brush');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (8, 'category-g', 'fa-sitemap');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (9, 'user-g', 'fa-users');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (10, 'marketing-g', 'fa-bullseye');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (11, 'blog-g', 'fa-bold');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (12, 'translation-g', 'fa-language');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (13, 'importer-g', 'fa-download');
INSERT INTO SidebarGroup (id, slug, icon) VALUES (14, 'setting-g', 'fa-cog');

/* SIDEBAR GROUP TRANSLATION */
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (1, 1, 'Dashboard');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (2, 1, 'Contenuti');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (3, 1, 'Prodotti');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (4, 1, 'Ordini');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (5, 1, 'Brand');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (6, 1, 'Taglie');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (7, 1, 'Colori');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (8, 1, 'Categorie');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (9, 1, 'Utenti');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (10, 1, 'Marketing');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (11, 1, 'Blog');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (12, 1, 'Traduzioni');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (13, 1, 'Importatori');
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (14, 1, 'Impostazioni');

/* SIDEBAR */
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (1, 2, 100, 100);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (2, 3, 100, 200);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (2, 37, 200, 200);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (2, 38, 300, 200);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (2, 39, 400, 200);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (2, 40, 500, 200);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (2, 41, 600, 200);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (2, 44, 700, 200);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (3, 4, 100, 400);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (3, 5, 200, 400);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (3, 7, 300, 400);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (3, 8, 400, 400);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (3, 29, 500, 400);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (3, 43, 600, 400);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (3, 80, 700, 400);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (4, 18, 100, 900);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (5, 9, 100, 500);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (5, 10, 200, 500);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (6, 12, 100, 600);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (6, 13, 200, 600);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (7, 14, 100, 700);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (7, 15, 200, 700);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (8, 16, 100, 800);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (9, 23, 100, 1000);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (10, 24, 100, 1100);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (10, 47, 200, 1100);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (10, 53, 300, 1100);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (11, 31, 100, 250);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (11, 32, 200, 250);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (11, 34, 400, 250);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (11, 35, 500, 250);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (11, 36, 600, 250);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (12, 60, 100, 300);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (12, 83, 200, 300);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (12, 86, 300, 300);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (13, 64, 60, 350);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (13, 66, 400, 350);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (13, 67, 350, 350);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (13, 69, 150, 350);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (13, 71, 200, 350);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (13, 73, 250, 350);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (13, 75, 100, 350);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (13, 77, 300, 350);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (13, 81, 50, 350);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder, groupOrder) VALUES (14, 79, 100, 1200);

/* POST STATUS */
INSERT INTO PostStatus (id, name, `show`) VALUES (1, 'Bozza', 1);
INSERT INTO PostStatus (id, name, `show`) VALUES (2, 'Pubblicato', 1);
INSERT INTO PostStatus (id, name, `show`) VALUES (3, 'Cancellato', 0);

/* PRODUCT STATUS */
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (1, 'S', 'Accettato', null, 0, 0);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (2, 'D', 'Bozza', null, 0, 0);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (3, 'G', 'Bozza - Foto Mancante', null, 0, 0);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (4, 'Q', 'Approvato - Senza Dettagli', null, 0, 0);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (5, 'A', 'Approvato', null, 0, 0);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (6, 'P', 'Pubblicato', null, 0, 1);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (7, 'N', 'Nascosto', null, 0, 0);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (8, 'C', 'Cancellato', null, 0, 0);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (9, 'W', 'Foto Errata', 'Foto errata o non visibile', 0, 0);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (10, 'F', 'Prodotto Friend', null, 0, 0);
INSERT INTO ProductStatus (id, code, name, description, isReady, isVisible) VALUES (11, 'I', 'Automatico', 'Prodotto inserito automaticamente', 0, 0);

/* RBAC PERMISSION */
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (1, 0, 71, 'root', 'root');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (2, 1, 70, 'admin', 'can anything everywhere');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (3, 2, 3, 'dashboard', 'can enter the backoffice');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (4, 4, 17, 'product', 'can see all product related issues');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (5, 5, 6, 'list', 'productList Page');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (6, 7, 8, 'add', 'can read the aztec code');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (7, 9, 10, 'edit', 'can enter the detail page');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (8, 11, 12, 'mag', 'can see the sku page');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (9, 13, 14, 'publish', 'can publish products');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (10, 15, 16, 'delete', 'can delete the product');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (11, 18, 27, 'order', 'can see all order related issues');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (12, 19, 20, 'list', 'orderList Page');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (13, 21, 22, 'add', 'can see an order user');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (14, 23, 24, 'edit', 'can see an order and manage it');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (15, 28, 29, 'marketing', 'can manage marketing');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (16, 30, 31, 'tech', 'can manage cms settings');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (17, 32, 41, 'economics', 'can see economic data');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (18, 33, 34, 'product', 'can see economic product');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (19, 35, 36, 'order', 'can see economic order');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (20, 37, 38, 'shipment', 'can see economic shipment');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (21, 39, 40, 'user', 'can see economic user');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (22, 42, 43, 'shipment', 'can manage shippings');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (23, 44, 55, 'content', 'can manage contents');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (24, 45, 46, 'list', 'can see content');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (25, 47, 48, 'add', 'can see content');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (26, 49, 50, 'edit', 'can see content');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (27, 51, 52, 'delete', 'can see content');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (28, 53, 54, 'publish', 'can see content');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (29, 56, 67, 'user', 'can manage users');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (30, 57, 58, 'list', 'can see user');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (31, 59, 60, 'add', 'can see user');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (32, 61, 62, 'edit', 'can see user');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (33, 63, 64, 'ban', 'can see user');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (34, 65, 66, 'role', 'can see user');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (35, 25, 26, 'friend-confirm', 'Friend orderline confirmation');
INSERT INTO RbacPermission (id, lft, rght, title, description) VALUES (36, 68, 69, 'blueseal', 'can log into backoffice');

/* RBAC ROLE */
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (1, 0, 35, 'root', 'root');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (2, 1, 34, 'sa', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (3, 2, 3, 'cto', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (4, 4, 33, 'ceo', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (5, 5, 20, 'manager', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (6, 6, 7, 'account', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (7, 8, 9, 'support', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (8, 10, 11, 'editor', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (9, 12, 17, 'warehouse', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (10, 13, 14, 'shipping', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (11, 15, 16, 'mag', 'has every thing');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (12, 18, 19, 'content', 'can insert content');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (13, 21, 24, 'epperoManager', '');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (14, 22, 23, 'epperoEmployee', '');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (15, 25, 26, 'cartechiniGioielleria', '');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (16, 27, 28, 'dellamartira', '');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (17, 29, 30, 'piccolecanaglieManager', '');
INSERT INTO RbacRole (id, lft, rght, title, description) VALUES (18, 31, 32, 'cartechiniManager', '');

/* RBAC ROLE HAS RBAC PERMISSION */
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (2, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (3, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (3, 4, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (3, 11, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (3, 15, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (3, 16, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (3, 17, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (3, 22, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (3, 23, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (3, 29, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (4, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (5, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (5, 4, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (5, 11, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (5, 15, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (5, 17, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (5, 22, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (5, 23, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (5, 29, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (5, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (6, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (6, 15, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (6, 17, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (6, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 5, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 11, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 21, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 22, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 30, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 31, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 32, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 33, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (7, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (8, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (8, 5, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (8, 6, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (8, 7, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (8, 10, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (8, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (9, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (9, 18, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (9, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (10, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (10, 22, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (10, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (11, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (11, 5, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (11, 8, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (11, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (12, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (12, 23, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (12, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (13, 7, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (13, 35, '2015-11-30 11:36:33');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (13, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (14, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (14, 5, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (14, 8, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (14, 35, '2015-11-30 11:36:47');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (14, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (15, 3, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (15, 5, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (15, 8, '2015-10-05 19:46:01');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (15, 35, '2015-11-27 17:07:26');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (15, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (16, 35, '2015-11-23 12:36:08');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (16, 36, '2015-11-23 13:08:10');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (17, 3, '2015-11-30 13:02:39');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (17, 5, '2015-11-30 13:02:39');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (17, 8, '2015-11-30 13:02:39');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (17, 35, '2015-11-30 13:02:39');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (17, 36, '2015-11-30 13:02:39');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (18, 3, '2015-11-30 17:20:53');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (18, 5, '2015-11-30 17:20:53');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (18, 8, '2015-11-30 17:20:53');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (18, 35, '2015-11-30 17:20:53');
INSERT INTO RbacRoleHasRbacPermission (rbacRoleId, rbacPermissionId, assignmentDate) VALUES (18, 36, '2015-11-30 17:20:53');

/* SORTING PRIORITY */
INSERT INTO SortingPriority (id, priority) VALUES (10, 'Altissima');
INSERT INTO SortingPriority (id, priority) VALUES (20, 'Alta');
INSERT INTO SortingPriority (id, priority) VALUES (30, 'Media');
INSERT INTO SortingPriority (id, priority) VALUES (40, 'Bassa');
INSERT INTO SortingPriority (id, priority) VALUES (50, 'Bassissima');
INSERT INTO SortingPriority (id, priority) VALUES (99, 'Nessuna');
INSERT INTO SortingPriority (id, priority) VALUES (100, 'Saldo');

INSERT INTO Event (id,name, stopped) VALUES (1,'userActivation', 0);
INSERT INTO Event (id,name, stopped) VALUES (5,'newOrder', 0);
INSERT INTO Event (id,name, stopped) VALUES (6,'orderInternalAcceptance', 0);
INSERT INTO Event (id,name, stopped) VALUES (7,'orderLineStatusChange', 0);
INSERT INTO Event (id,name, stopped) VALUES (8,'test', 0);
INSERT INTO Event (id,name, stopped) VALUES (9,'dbUpdate', 0);
INSERT INTO Event (id,name, stopped) VALUES (10,'catalogPhotoMissing', 0);

INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (1,'CActivateUser', 0, 0);
INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (3,'CCreateCoupon', 0, 0);
INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (4,'CMailActivate', 1, 0);
INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (5,'CMailOrderBack', 0, 0);
INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (6,'CMailOrderClient', 0, 0);
INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (8,'COrderLineStatusHandler', 0, 0);
INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (9,'CTestSync', 0, 0);
INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (10,'CTestAsync', 0, 1);
INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (11,'CCacheCleanUp', 0, 0);
INSERT INTO EventListener (id,classToInvoke, stopped, isAsync) VALUES (12,'CCatalogCorrection', 0, 1);

INSERT INTO EventHasListener (eventId, listenerId) VALUES (1, 1);
INSERT INTO EventHasListener (eventId, listenerId) VALUES (1, 3);
INSERT INTO EventHasListener (eventId, listenerId) VALUES (5, 5);
INSERT INTO EventHasListener (eventId, listenerId) VALUES (5, 6);
INSERT INTO EventHasListener (eventId, listenerId) VALUES (7, 8);
INSERT INTO EventHasListener (eventId, listenerId) VALUES (8, 9);
INSERT INTO EventHasListener (eventId, listenerId) VALUES (8, 10);
INSERT INTO EventHasListener (eventId, listenerId) VALUES (9, 11);
INSERT INTO EventHasListener (eventId, listenerId) VALUES (10, 12);