INSERT INTO Page (id,slug, url, icon, permission) VALUES (155,'addressBook_list', '/blueseal/indirizzario', 'fa-address-book-o', '/admin/blueseal&&allShops');
INSERT INTO PageTranslation (pageId, langId, title, description, keywords) VALUES (155, 1, 'Indirizzario', null, null);

ALTER TABLE `AddressBook`
  ADD COLUMN `iban` VARCHAR(34) NULL AFTER `province`;

update AddressBook ab join Shop s on ab.id = s.billingAddressBookId set ab.iban = s.iban;

ALTER TABLE `Shop`
  DROP COLUMN `iban`;

INSERT INTO SidebarGroup (id, slug, icon, `order`) VALUES ('id', 'payments-g', 'fa-balance-scale', 120);
INSERT INTO SidebarGroupTranslation (sidebarGroupId, langId, title) VALUES (18, 1, 'Pagamenti');
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder) VALUES (18, 155, 10);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder) VALUES (18, 133, 10);
INSERT INTO Sidebar (sidebarGroupId, pageId, pageOrder) VALUES (18, 128, 10);