DELIMITER DLM00

DROP PROCEDURE IF EXISTS coreinit DLM00

CREATE PROCEDURE coreinit()

declare tenant_id int;

declare user_id varchar(36);

IF NOT EXISTS(SELECT 1 FROM tenants_tenants LIMIT 1) THEN

start transaction;

select uuid() into @user_id;

insert into tenants_tenants(alias, name, creationdatetime, owner_id) values ('localhost','Web Office',UTC_TIMESTAMP(), @user_id);

select last_insert_id() into @tenant_id;

insert ignore into core_user(id, firstname, lastname, username, tenant, email, workfromdate, last_modified) values (@user_id,'Administrator','','administrator',@tenant_id,'', utc_timestamp(), utc_timestamp());

insert ignore into core_usersecurity(tenant, userid, pwdhash, pwdhashsha512) values (@tenant_id,@user_id,'jGl25bVBBBW96Qi9Te4V37Fnqchz/Eu4qB9vKrRIqRg=','l/DFJ5yg4oh1F6Qp7uDhBw==');

insert ignore into core_usergroup(tenant, userid, groupid, ref_type) values (@tenant_id,@user_id,'cd84e66b-b803-40fc-99f9-b2969a54a1de',0);

insert ignore into webstudio_settings (tenantid, id, userid, data) values (@tenant_id, '9a925891-1f92-4ed7-b277-d6f649739f06', '00000000-0000-0000-0000-000000000000', '{"Completed":false}');

commit;

END IF;

replace into tenants_quota (tenant, name, max_file_size, max_total_size, active_users, features) values (-1, 'default', 102400, 10995116277760, 10000, 'sso,domain,audit,controlpanel,healthcheck,ldap,portals:2');

replace into core_settings(tenant, id, value) values (-1, 'SmtpSettings', 0xF052E090A1A3750DADCD4E9961DA04AA51EF0197E2C0623CF12C5838BFA40A9B48BAEFCBE371587731D7E3DC9E7C6009742F9E415D56DB0F0AE08E32F8904B2C441CC657C64543EAEE262044A28B4335DCB0F0C4E9401D891FA06369F984CA2D475C86C237917961C5827769831585230A66AC7787E6FB56FD3E37389267A46A);

insert ignore into core_settings(tenant, id, value) values (-1, 'FullTextSearchSettings', 0x0878CF0599B517CAA2D3DAED9D064C3EDCEEAF431F35A6F642DCADA04817E3513227BBB1DE6E2BABEB9E1077B2CF318C489814545E877501F633FBBE94022CFCDD025B5395973AF510943408BB56962EE35DA35F2F8374CF5FD12695359449D7CEFBC2C7BD112AE58752179AA2A59E5E17801E580CCC60FAEC8EBDD3D612C4886666D96D6CF060605E64C90A1FAA80C0);

insert ignore into core_settings(tenant, id, value) values (-1, 'CompanyWhiteLabelSettings', 0xF547048A4865171587D9CEBC8A496C601D96031F2C1C3E9160353942EE765DACD316F4B5F42892436FC4A21B9A6DF8FFD3BC4036B47E3A5A1B4C881B26609869FEBB6848BD88C02EEAC6A4CCB3E8F404290812F0E6E124A552BE81A58C64BB8BD3C9A8C0EDE1F9421281DE0C7AF82733C0B754E97EFFFA5A75607A91957896CBECF9563FC831300DC8E7C930A55B298EB82D6F69E0ED6E4D8752607F1881F61B032306E0F069A5F69F086A177EB41AC06F889EB0B39CBFD4B5CDB763E996554DEADB9C71CF3EF86F4A0354A864A10639DFD29B5C6D5DCDA9D4B0988EE406948BCB54C6A70ADC6C00577174285CEBCD76);

start transaction;

insert ignore into core_subscription(source, action, recipient, object, tenant) values('asc.web.studio','send_whats_new','c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e','',-1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values('asc.web.studio','send_whats_new','c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e','email.sender',-1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('6504977c-75af-4691-9099-084d3ddeea04','new feed','c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e','',-1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values('6504977c-75af-4691-9099-084d3ddeea04','new feed','c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e','email.sender|messanger.sender',-1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('6a598c74-91ae-437d-a5f4-ad339bd11bb2','new post','c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e','',-1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values('6a598c74-91ae-437d-a5f4-ad339bd11bb2','new post','c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e','email.sender|messanger.sender',-1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('853b6eb9-73ee-438d-9b09-8ffeedf36234', 'new topic in forum', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('853b6eb9-73ee-438d-9b09-8ffeedf36234', 'new topic in forum', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('9d51954f-db9b-4aed-94e3-ed70b914e101', 'new photo uploaded', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('9d51954f-db9b-4aed-94e3-ed70b914e101', 'new photo uploaded', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('28b10049-dd20-4f54-b986-873bc14ccfc7', 'new bookmark created', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('28b10049-dd20-4f54-b986-873bc14ccfc7', 'new bookmark created', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('742cf945-cbbc-4a57-82d6-1600a12cf8ca', 'new wiki page', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('742cf945-cbbc-4a57-82d6-1600a12cf8ca', 'new wiki page', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('37620ae5-c40b-45ce-855a-39dd7d76a1fa','BirthdayReminder','abef62db-11a8-4673-9d32-ef1d8af19dc0','',-1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values('37620ae5-c40b-45ce-855a-39dd7d76a1fa','BirthdayReminder','abef62db-11a8-4673-9d32-ef1d8af19dc0','email.sender|messanger.sender',-1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('6fe286a4-479e-4c25-a8d9-0156e332b0c0', 'sharedocument', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('6fe286a4-479e-4c25-a8d9-0156e332b0c0', 'sharefolder', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6fe286a4-479e-4c25-a8d9-0156e332b0c0', 'sharedocument', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6fe286a4-479e-4c25-a8d9-0156e332b0c0', 'sharefolder', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6fe286a4-479e-4c25-a8d9-0156e332b0c0', 'updatedocument', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'invitetoproject', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'milestonedeadline', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'newcommentformessage', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'newcommentformilestone', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'newcommentfortask', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'projectcreaterequest', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'projecteditrequest', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'removefromproject', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'responsibleforproject', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'responsiblefortask', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('6045b68c-2c2e-42db-9e53-c272e814c4ad', 'taskclosed', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('40650da3-f7c1-424c-8c89-b9c115472e08', 'calendar_sharing', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('40650da3-f7c1-424c-8c89-b9c115472e08', 'event_alert', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('40650da3-f7c1-424c-8c89-b9c115472e08', 'calendar_sharing', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('40650da3-f7c1-424c-8c89-b9c115472e08', 'event_alert', 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values('asc.web.studio','admin_notify','cd84e66b-b803-40fc-99f9-b2969a54a1de','',-1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values('asc.web.studio','admin_notify','cd84e66b-b803-40fc-99f9-b2969a54a1de','email.sender',-1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'SetAccess', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'SetAccess', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'ResponsibleForTask', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'ResponsibleForTask', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'AddRelationshipEvent', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'AddRelationshipEvent', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'ExportCompleted', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'ExportCompleted', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'CreateNewContact', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'CreateNewContact', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'ResponsibleForOpportunity', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '', -1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values ('13ff36fb-0272-4887-b416-74f52b0d0b02', 'ResponsibleForOpportunity', 'abef62db-11a8-4673-9d32-ef1d8af19dc0', 'email.sender|messanger.sender', -1);

insert ignore into core_subscription(source, action, recipient, object, tenant) VALUES ('asc.web.studio','periodic_notify','c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e','',-1);

insert ignore into core_subscriptionmethod(source, action, recipient, sender, tenant) values('asc.web.studio','periodic_notify','c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e','email.sender',-1);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, '5d5b7260-f7f7-49f1-a1c9-95fbb6a12604', 'ef5e6790-f346-4b6e-b662-722bc28cb0db', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, '5d5b7260-f7f7-49f1-a1c9-95fbb6a12604', 'f11e8f3f-46e6-4e55-90e3-09c22ec565bd', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '088d5940-a80f-4403-9741-d610718ce95c', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '08d66144-e1c9-4065-9aa1-aa4bba0a7bc8', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '08d75c97-cf3f-494b-90d1-751c941fe2dd', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '0d1f72a8-63da-47ea-ae42-0900e4ac72a9', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '13e30b51-5b4d-40a5-8575-cb561899eeb1', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '19f658ae-722b-4cd8-8236-3ad150801d96', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '2c6552b3-b2e0-4a00-b8fd-13c161e337b1', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '388c29d3-c662-4a61-bf47-fc2f7094224a', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '40bf31f4-3132-4e76-8d5c-9828a89501a3', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '49ae8915-2b30-4348-ab74-b152279364fb', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '63e9f35f-6bb5-4fb1-afaa-e4c2f4dec9bd', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '9018c001-24c2-44bf-a1db-d1121a570e74', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '948ad738-434b-4a88-8e38-7569d332910a', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', '9d75a568-52aa-49d8-ad43-473756cd8903', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'a362fe79-684e-4d43-a599-65bc1f4e167f', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'c426c349-9ad4-47cd-9b8f-99fc30675951', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'd11ebcb9-0e6e-45e6-a6d0-99c41d687598', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'd1f3b53d-d9e2-4259-80e7-d24380978395', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', 'd49f4e30-da10-4b39-bc6d-b41ef6e039d3', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'abef62db-11a8-4673-9d32-ef1d8af19dc0', 'd852b66f-6719-45e1-8657-18f0bb791690', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'e0759a42-47f0-4763-a26a-d5aa665bec35', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'e37239bd-c5b5-4f1e-a9f8-3ceeac209615', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'fbc37705-a04c-40ad-a68c-ce2f0423f397', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', 'fcac42b8-9386-48eb-a938-d19b3c576912', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'ba74ca02-873f-43dc-8470-8620c156bc67', '13e30b51-5b4d-40a5-8575-cb561899eeb1', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'ba74ca02-873f-43dc-8470-8620c156bc67', '49ae8915-2b30-4348-ab74-b152279364fb', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'ba74ca02-873f-43dc-8470-8620c156bc67', '63e9f35f-6bb5-4fb1-afaa-e4c2f4dec9bd', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'ba74ca02-873f-43dc-8470-8620c156bc67', '9018c001-24c2-44bf-a1db-d1121a570e74', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'ba74ca02-873f-43dc-8470-8620c156bc67', 'd1f3b53d-d9e2-4259-80e7-d24380978395', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'ba74ca02-873f-43dc-8470-8620c156bc67', 'e0759a42-47f0-4763-a26a-d5aa665bec35', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'ba74ca02-873f-43dc-8470-8620c156bc67', 'e37239bd-c5b5-4f1e-a9f8-3ceeac209615', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'ba74ca02-873f-43dc-8470-8620c156bc67', 'f11e88d7-f185-4372-927c-d88008d2c483', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'ba74ca02-873f-43dc-8470-8620c156bc67', 'f11e8f3f-46e6-4e55-90e3-09c22ec565bd', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '00e7dfc5-ac49-4fd3-a1d6-98d84e877ac4', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '14be970f-7af5-4590-8e81-ea32b5f7866d', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '18ecc94d-6afa-4994-8406-aee9dff12ce2', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '298530eb-435e-4dc6-a776-9abcd95c70e9', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '430eaf70-1886-483c-a746-1a18e3e6bb63', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '557d6503-633b-4490-a14c-6473147ce2b3', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '724cbb75-d1c9-451e-bae0-4de0db96b1f7', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '7cb5c0d1-d254-433f-abe3-ff23373ec631', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '91b29dcd-9430-4403-b17a-27d09189be88', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', 'a18480a4-6d18-4c71-84fa-789888791f45', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', 'b630d29b-1844-4bda-bbbe-cf5542df3559', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', 'c62a9e8d-b24c-4513-90aa-7ff0f8ba38eb', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', 'd7cdb020-288b-41e5-a857-597347618533', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '662f3db7-9bc8-42cf-84da-2765f563e9b0', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, '712d9ec3-5d2b-4b13-824f-71f00191dcca', 'e0759a42-47f0-4763-a26a-d5aa665bec35', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'bba32183-a14d-48ed-9d39-c6b4d8925fbf', '0d68b142-e20a-446e-a832-0d6b0b65a164', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '6f05c382-8bca-4469-9424-c807a98c40d7', '', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|1e04460243b54d7982f3fd6208a11960', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|6743007c6f954d208c88a8601ce5e76d', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|e67be73df9ae4ce18fec1880cb518cb4', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|ea942538e68e49079394035336ee0ba8', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|32d24cb57ece46069c9419216ba42086', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|bf88953e3c434850a3fbb1e43ad53a3e', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|2a9230378b2d487b9a225ac0918acf3f', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|f4d98afdd336433287783c6945c81ea0', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|28b10049dd204f54b986873bc14ccfc7', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|3cfd481b46f24a4ab55cb8c0c9def02c', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|6a598c7491ae437da5f4ad339bd11bb2', 0);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|742cf945cbbc4a5782d61600a12cf8ca', 1);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, 'c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e', '77777777-32ae-425f-99b5-83176061d1ae', 'ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|853b6eb973ee438d9b098ffeedf36234', 1);

insert ignore into core_acl (tenant, subject, action, object, acetype) values (-1, "c5cc67d1-c3e8-43c0-a3ad-3928ae3e5b5e", "77777777-32ae-425f-99b5-83176061d1ae", "ASC.Web.Core.WebItemSecurity+WebItemSecurityObject|46cfa73af32046cf8d5bcd82e1d67f26", 0);

insert ignore into tenants_forbiden (address) values ('controlpanel');

insert ignore into tenants_forbiden (address) values ('localhost');

commit;

start transaction;

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_AlgerianDinar', 'DZD', 'د.ج', 'DZ', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_ArgentinianPeso', 'ARS', '$a', 'AR', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_ArmenianDram', 'AMD', 'dram', 'AM', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_AustralianDollar', 'AUD', 'A$', 'AU', 1, 1);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_AzerbaijaniManat', 'AZN', 'm', 'AZ', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_BangladeshiTaka', 'BDT', 'Tk', 'BD', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_BelarusianRuble', 'BYR', 'Br', 'BY', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_BrazilianReal', 'BRL', 'R$', 'BR', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_BulgarianLev', 'BGN', 'лв', 'BG', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_CanadianDollar', 'CAD', 'C$', 'CA', 1, 1);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_CentralAfricanFranc', 'XAF', 'franc', 'CF', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_ChileanPeso', 'CLP', '$', 'CL', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_ChineseYuan', 'CNY', '¥', 'CN', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_ColombianPeso', 'COP', '$', 'CO', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_CostaRicanColon', 'CRC', '₡', 'CR', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_CroatianKuna', 'HRK', 'kn', 'HR', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_CubanPeso', 'CUP', '$', 'CU', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_CzechKoruna', 'CZK', 'Kc', 'CZ', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_DanishKrone', 'DKK', 'kr', 'DK', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_DominicanPeso', 'DOP', 'RD$', 'DO', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_Euro', 'EUR', '€', 'EU', 1, 1);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_GeorgianLari', 'GEL', 'ლარი', 'GE', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_HongKongDollar', 'HKD', 'HK$', 'HK', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_HungarianForint', 'HUF', 'Ft', 'HU', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_IndianRupee', 'INR', '₨', 'IN', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_IndonesianRupiah', 'IDR', 'Rp', 'ID', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_IsraeliSheqel', 'ILS', '₪', 'IL', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_JapaneseYen', 'JPY', '¥', 'JP', 1, 1);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_KazakhstaniTenge', 'KZT', 'тңг', 'KZ', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_KenyanShilling', 'KES', 'KSh', 'KE', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_KuwaitiDinar', 'KWD', 'K.D.', 'KW', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_LatvianLats', 'LVL', 'Ls', 'LV', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_LithuanianLitas', 'LTL', 'Lt', 'LT', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_MalagasyAriary', 'MGA', 'Ar', 'MG', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_MalaysianRinggit', 'MYR', 'RM', 'MY', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_MauritianRupee', 'MUR', 'Rs', 'MU', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_MexicanPeso', 'MXN', 'MEX$', 'MX', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_MoldovanLeu', 'MDL', 'lei', 'MD', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_MoroccanDirham', 'MAD', 'د.م', 'MA', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_NewBelarusianRuble', 'BYN', 'Br', 'BY', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_NewZealandDollar', 'NZD', 'NZ$', 'NZ', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_NigerianNaira', 'NGN', '₦', 'NG', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_NorwegianKrone', 'NOK', 'kr', 'NO', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_OmaniRial', 'OMR', 'ر.ع', 'OM', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_PacificFranc', 'XPF', 'franc', 'NC', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_PakistaniRupee', 'PKR', 'Rp.', 'PK', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_PhilippinePeso', 'PHP', 'P', 'PH', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_PolishZloty', 'PLN', 'zł', 'PL', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_PoundSterling', 'GBP', '£', 'GB', 1, 1);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_RomanianLeu', 'RON', 'lei', 'RO', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_Rouble', 'RUB', '₽', 'RU', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_SaudiRiyal', 'SAR', 'ر.س', 'SA', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_SerbianDinar', 'RSD', 'din.', 'SR', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_SingaporeDollar', 'SGD', 'S$', 'SG', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_SouthAfricanRand', 'ZAR', 'R', 'ZA', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_SouthKoreanWon', 'KRW', '₩', 'KR', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_SwedishKrona', 'SEK', 'kr', 'SE', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_SwissFranc', 'CHF', 'Fr', 'CH', 1, 1);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_ThaiBaht', 'THB', '฿', 'TH', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_TrinidadAndTobagoDollar', 'TTD', 'TT$', 'TT', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_TurkishNewLira', 'TRY', 'YTL', 'TR', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_UkraineHryvnia', 'UAH', 'грн.', 'UA', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_UnitedArabEmiratesDirham', 'AED', 'د.إ', 'AE', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_UnitedStatesDollar', 'USD', '$', 'US', 1, 1);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_UzbekistaniSom', 'UZS', 'som', 'UZ', 0, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_VenezuelanBolivar', 'VEF', 'Bs.', 'VE', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_VietnameseDong', 'VND', '₫', 'VN', 1, 0);

insert ignore into crm_currency_info (resource_key, abbreviation, symbol, culture_name, is_convertable, is_basic) values ('Currency_WestAfricanFranc', 'XOF', 'franc', 'ML', 1, 0);

commit;

truncate table files_converts;

start transaction;

insert into files_converts (input, output) values ('.csv', '.ods');

insert into files_converts (input, output) values ('.csv', '.pdf');

insert into files_converts (input, output) values ('.csv', '.xlsx');

insert into files_converts (input, output) values ('.doc', '.docx');

insert into files_converts (input, output) values ('.doc', '.odt');

insert into files_converts (input, output) values ('.doc', '.pdf');

insert into files_converts (input, output) values ('.doc', '.rtf');

insert into files_converts (input, output) values ('.doc', '.txt');

insert into files_converts (input, output) values ('.docm', '.docx');

insert into files_converts (input, output) values ('.docm', '.odt');

insert into files_converts (input, output) values ('.docm', '.pdf');

insert into files_converts (input, output) values ('.docm', '.rtf');

insert into files_converts (input, output) values ('.docm', '.txt');

insert into files_converts (input, output) values ('.doct', '.docx');

insert into files_converts (input, output) values ('.docx', '.odt');

insert into files_converts (input, output) values ('.docx', '.pdf');

insert into files_converts (input, output) values ('.docx', '.rtf');

insert into files_converts (input, output) values ('.docx', '.txt');

insert into files_converts (input, output) values ('.dot', '.docx');

insert into files_converts (input, output) values ('.dot', '.odt');

insert into files_converts (input, output) values ('.dot', '.pdf');

insert into files_converts (input, output) values ('.dot', '.rtf');

insert into files_converts (input, output) values ('.dot', '.txt');

insert into files_converts (input, output) values ('.dotm', '.docx');

insert into files_converts (input, output) values ('.dotm', '.odt');

insert into files_converts (input, output) values ('.dotm', '.pdf');

insert into files_converts (input, output) values ('.dotm', '.rtf');

insert into files_converts (input, output) values ('.dotm', '.txt');

insert into files_converts (input, output) values ('.dotx', '.docx');

insert into files_converts (input, output) values ('.dotx', '.odt');

insert into files_converts (input, output) values ('.dotx', '.pdf');

insert into files_converts (input, output) values ('.dotx', '.rtf');

insert into files_converts (input, output) values ('.dotx', '.txt');

insert into files_converts (input, output) values ('.epub', '.docx');

insert into files_converts (input, output) values ('.epub', '.odt');

insert into files_converts (input, output) values ('.epub', '.pdf');

insert into files_converts (input, output) values ('.epub', '.rtf');

insert into files_converts (input, output) values ('.epub', '.txt');

insert into files_converts (input, output) values ('.fodp', '.odp');

insert into files_converts (input, output) values ('.fodp', '.pdf');

insert into files_converts (input, output) values ('.fodp', '.pptx');

insert into files_converts (input, output) values ('.fods', '.csv');

insert into files_converts (input, output) values ('.fods', '.ods');

insert into files_converts (input, output) values ('.fods', '.pdf');

insert into files_converts (input, output) values ('.fods', '.xlsx');

insert into files_converts (input, output) values ('.fodt', '.docx');

insert into files_converts (input, output) values ('.fodt', '.odt');

insert into files_converts (input, output) values ('.fodt', '.pdf');

insert into files_converts (input, output) values ('.fodt', '.rtf');

insert into files_converts (input, output) values ('.fodt', '.txt');

insert into files_converts (input, output) values ('.html', '.docx');

insert into files_converts (input, output) values ('.html', '.odt');

insert into files_converts (input, output) values ('.html', '.pdf');

insert into files_converts (input, output) values ('.html', '.rtf');

insert into files_converts (input, output) values ('.html', '.txt');

insert into files_converts (input, output) values ('.mht', '.docx');

insert into files_converts (input, output) values ('.mht', '.odt');

insert into files_converts (input, output) values ('.mht', '.pdf');

insert into files_converts (input, output) values ('.mht', '.rtf');

insert into files_converts (input, output) values ('.mht', '.txt');

insert into files_converts (input, output) values ('.odp', '.pdf');

insert into files_converts (input, output) values ('.odp', '.pptx');

insert into files_converts (input, output) values ('.otp', '.odp');

insert into files_converts (input, output) values ('.otp', '.pdf');

insert into files_converts (input, output) values ('.otp', '.pptx');

insert into files_converts (input, output) values ('.ods', '.csv');

insert into files_converts (input, output) values ('.ods', '.pdf');

insert into files_converts (input, output) values ('.ods', '.xlsx');

insert into files_converts (input, output) values ('.ots', '.csv');

insert into files_converts (input, output) values ('.ots', '.ods');

insert into files_converts (input, output) values ('.ots', '.pdf');

insert into files_converts (input, output) values ('.ots', '.xlsx');

insert into files_converts (input, output) values ('.odt', '.docx');

insert into files_converts (input, output) values ('.odt', '.pdf');

insert into files_converts (input, output) values ('.odt', '.rtf');

insert into files_converts (input, output) values ('.odt', '.txt');

insert into files_converts (input, output) values ('.ott', '.docx');

insert into files_converts (input, output) values ('.ott', '.odt');

insert into files_converts (input, output) values ('.ott', '.pdf');

insert into files_converts (input, output) values ('.ott', '.rtf');

insert into files_converts (input, output) values ('.ott', '.txt');

insert into files_converts (input, output) values ('.pot', '.odp');

insert into files_converts (input, output) values ('.pot', '.pdf');

insert into files_converts (input, output) values ('.pot', '.pptx');

insert into files_converts (input, output) values ('.potm', '.odp');

insert into files_converts (input, output) values ('.potm', '.pdf');

insert into files_converts (input, output) values ('.potm', '.pptx');

insert into files_converts (input, output) values ('.potx', '.odp');

insert into files_converts (input, output) values ('.potx', '.pdf');

insert into files_converts (input, output) values ('.potx', '.pptx');

insert into files_converts (input, output) values ('.pps', '.odp');

insert into files_converts (input, output) values ('.pps', '.pdf');

insert into files_converts (input, output) values ('.pps', '.pptx');

insert into files_converts (input, output) values ('.ppsm', '.odp');

insert into files_converts (input, output) values ('.ppsm', '.pdf');

insert into files_converts (input, output) values ('.ppsm', '.pptx');

insert into files_converts (input, output) values ('.ppsx', '.odp');

insert into files_converts (input, output) values ('.ppsx', '.pdf');

insert into files_converts (input, output) values ('.ppsx', '.pptx');

insert into files_converts (input, output) values ('.ppt', '.odp');

insert into files_converts (input, output) values ('.ppt', '.pdf');

insert into files_converts (input, output) values ('.ppt', '.pptx');

insert into files_converts (input, output) values ('.pptm', '.odp');

insert into files_converts (input, output) values ('.pptm', '.pdf');

insert into files_converts (input, output) values ('.pptm', '.pptx');

insert into files_converts (input, output) values ('.pptt', '.pptx');

insert into files_converts (input, output) values ('.pptx', '.odp');

insert into files_converts (input, output) values ('.pptx', '.pdf');

insert into files_converts (input, output) values ('.rtf', '.docx');

insert into files_converts (input, output) values ('.rtf', '.odt');

insert into files_converts (input, output) values ('.rtf', '.pdf');

insert into files_converts (input, output) values ('.rtf', '.txt');

insert into files_converts (input, output) values ('.txt', '.docx');

insert into files_converts (input, output) values ('.txt', '.odt');

insert into files_converts (input, output) values ('.txt', '.pdf');

insert into files_converts (input, output) values ('.txt', '.rtf');

insert into files_converts (input, output) values ('.xls', '.csv');

insert into files_converts (input, output) values ('.xls', '.ods');

insert into files_converts (input, output) values ('.xls', '.pdf');

insert into files_converts (input, output) values ('.xls', '.xlsx');

insert into files_converts (input, output) values ('.xlsm', '.csv');

insert into files_converts (input, output) values ('.xlsm', '.ods');

insert into files_converts (input, output) values ('.xlsm', '.pdf');

insert into files_converts (input, output) values ('.xlsm', '.xlsx');

insert into files_converts (input, output) values ('.xlst', '.xlsx');

insert into files_converts (input, output) values ('.xlsx', '.csv');

insert into files_converts (input, output) values ('.xlsx', '.ods');

insert into files_converts (input, output) values ('.xlsx', '.pdf');

insert into files_converts (input, output) values ('.xlt', '.csv');

insert into files_converts (input, output) values ('.xlt', '.ods');

insert into files_converts (input, output) values ('.xlt', '.pdf');

insert into files_converts (input, output) values ('.xlt', '.xlsx');

insert into files_converts (input, output) values ('.xltm', '.csv');

insert into files_converts (input, output) values ('.xltm', '.ods');

insert into files_converts (input, output) values ('.xltm', '.pdf');

insert into files_converts (input, output) values ('.xltm', '.xlsx');

insert into files_converts (input, output) values ('.xltx', '.csv');

insert into files_converts (input, output) values ('.xltx', '.ods');

insert into files_converts (input, output) values ('.xltx', '.pdf');

insert into files_converts (input, output) values ('.xltx', '.xlsx');

insert into files_converts (input, output) values ('.xps', '.pdf');

commit;

start transaction;

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.gmx.com', 'Drafts', 3, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.gmx.com', 'OUTBOX', 2, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.gmx.com', 'Sent', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.gmx.com', 'Spam', 5, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.gmx.com', 'Trash', 4, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', 'Migrated', 1, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', '[Gmail]', 1, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', '[Gmail]/Destacados', 0, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', '[Gmail]/Enviados', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', '[Gmail]/Gesendet', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', '[Gmail]/Important', 0, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', '[Gmail]/Sent Mail', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', '[Gmail]/Wichtig', 0, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', '[Gmail]/Важное', 0, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.googlemail.com', '[Gmail]/Отправленные', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.hushmail.com', 'Drafts', 3, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.hushmail.com', 'Junk', 5, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.hushmail.com', 'Sent', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.hushmail.com', 'Trash', 4, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.mail.yahoo.com', 'Bulk Mail', 5, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.mail.yahoo.com', 'Draft', 3, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.mail.yahoo.com', 'Sent', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.mail.yahoo.com', 'Trash', 4, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.rambler.ru', 'DraftBox', 3, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.rambler.ru', 'SentBox', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.rambler.ru', 'Spam', 5, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.rambler.ru', 'Trash', 4, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('imap.yandex.ru', 'исходящие', 0, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('mail.rambler.ru', 'DraftBox', 3, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('mail.rambler.ru', 'SentBox', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('mail.rambler.ru', 'Spam', 5, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('mail.rambler.ru', 'Trash', 4, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('secureimap.t-online.de', 'INBOX.Archive', 0, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('secureimap.t-online.de', 'INBOX.Drafts', 3, 1);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('secureimap.t-online.de', 'INBOX.Sent', 2, 0);

insert ignore into mail_imap_special_mailbox (server, name, folder_id, skip) values ('secureimap.t-online.de', 'INBOX.Trash', 4, 1);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('all', 0, 1);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('archive', 0, 1);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('bulk', 5, 0);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('drafts', 0, 1);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('flagged', 0, 1);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('important', 0, 1);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('inbox', 1, 0);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('junk', 5, 0);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('noselect', 0, 1);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('sent', 2, 0);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('spam', 5, 0);

insert ignore into mail_imap_flags (name, folder_id, skip) values ('trash', 0, 1);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (1, '1und1.de', '1&1', '1&1', 'http://hilfe-center.1und1.de/access/search/go.php?t=e698123');

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (2, 'abc.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (3, 'agate.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (4, 'alice.it', 'Alice Italy', 'Alice', 'http://aiuto.alice.it/informazioni/clientemail/thunderbird.html');

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (5, 'amail.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (6, 'amber.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (7, 'aol.com', 'AOL Mail', 'AOL', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (8, 'apost.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (9, 'aqua.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (10, 'arcor.de', 'Arcor', 'Arcor', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (11, 'arubapec.it', 'Aruba PEC', 'Aruba', 'http://pec.aruba.it/guide_filmate.asp');

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (12, 'att.net', 'AT&T', 'AT&T', 'http://www.att.com/esupport/article.jsp?sid=KB401570&ct=9000152');

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (13, 'ballade.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (14, 'bay.wind.ne.jp', '?????????', 'wind', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (15, 'bb-niigata.jp', 'BB????', 'BB-NIIGATA', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (16, 'beige.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (17, 'biglobe.ne.jp', 'Biglobe', 'Biglobe', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (18, 'bigpond.com', 'Telstra Bigpond', 'Bigpond', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (19, 'blue.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (20, 'bluemail.ch', 'bluewin.ch', 'bluewin.ch', 'http://smtphelp.bluewin.ch/swisscomdtg/setup/?');

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (21, 'bluewin.ch', 'bluewin.ch', 'bluewin.ch', 'http://smtphelp.bluewin.ch/swisscomdtg/setup/');

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (22, 'bmail.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (23, 'bolero.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (24, 'bpost.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (25, 'broba.cc', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (26, 'brown.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (27, 'camel.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (28, 'cameo.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (29, 'cc9.ne.jp', 'CC9???????????', 'CC9', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (30, 'cek.ne.jp', '???????????', 'CEK-Net', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (31, 'cgl.ucsf.edu', 'UCSF CGL email', 'CGL email', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (32, 'charter.com', 'Charter Commuications', 'Charter', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (33, 'clio.ne.jp', 'CLIO-Net??????', 'CLIO-Net', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (34, 'cmail.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (35, 'co1.wind.ne.jp', '?????????', 'wind', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (36, 'co2.wind.ne.jp', '?????????', 'wind', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (37, 'co3.wind.ne.jp', '?????????', 'wind', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (38, 'cocoa.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (39, 'coda.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (40, 'comcast.net', 'Comcast', 'Comcast', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (41, 'concerto.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (42, 'coral.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (43, 'courante.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (44, 'cpost.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (45, 'cream.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (46, 'dan.wind.ne.jp', '?????????', 'wind', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (47, 'dance.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (48, 'dd.iij4u.or.jp', 'IIJ4U', 'IIJ4U', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (49, 'df.eu', 'domainFACTORY', 'domainFACTORY', 'http://www.df.eu/de/service/df-faq/e-mail/mail-programme/');

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (50, 'dmail.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (51, 'earthlink.net', 'EarthLink', 'EarthLink', 'http://support.earthlink.net/email/email-server-settings.php');

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (52, 'ebony.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (53, 'email.it', 'email.it', 'email.it', 'http://www.email.it/ita/config/thunder.php');

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (54, 'email.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (55, 'ewetel.de', 'EWE Tel', 'EWE Tel', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (56, 'fantasy.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (57, 'flamenco.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (58, 'fmail.plala.or.jp', '???', '???', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (59, 'francetelecom.fr', 'France Telecom / Orange', 'Orange', NULL);

insert ignore into mail_mailbox_provider (id, name, display_name, display_short_name, documentation) values (60, 'free.fr', 'Free Telecom', 'free.fr', 'http://www.free.fr/assistance/599-thunderbird.html');