Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
llx_00_c_country.sql	31.04 KB	-rwxr-x---	2023-04-04 15:50
llx_10_c_regions.sql	39.32 KB	-rwxr-x---	2023-04-04 15:50
llx_20_c_departements.sql	242.22 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_abc.sql	11.05 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_at.sql	114.94 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_be.sql	204.62 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_bf.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_bj.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ca.sql	34.99 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cd.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cf.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cg.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ch.sql	56.25 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ci.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cl.sql	35.58 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_cm.sql	281.17 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_de.sql	1.63 MB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_dk.sql	20.28 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_dz.sql	171.39 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ec.sql	100.92 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_es.sql	190.42 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_fr.sql	607.11 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ga.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_gb.sql	78.13 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_gq.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_jp.sql	73.33 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_km.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_lu.sql	173.04 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ma.sql	184.91 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ml.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_mx.sql	264.92 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ne.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_nl.sql	18.9 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_ro.sql	142.22 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_se.sql	7.6 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_sn.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_td.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_tg.sql	281.16 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_tn.sql	131.66 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_account_us.sql	62.02 KB	-rwxr-x---	2023-04-04 15:50
llx_accounting_category.sql	1.63 KB	-rwxr-x---	2023-04-04 15:50
llx_c_action_trigger.sql	28.17 KB	-rwxr-x---	2023-04-04 15:50
llx_c_actioncomm.sql	4.79 KB	-rwxr-x---	2023-04-04 15:50
llx_c_asset_disposal_type-asset.sql	1.16 KB	-rwxr-x---	2023-04-04 15:50
llx_c_availability.sql	2.69 KB	-rwxr-x---	2023-04-04 15:50
llx_c_chargesociales.sql	5.29 KB	-rwxr-x---	2023-04-04 15:50
llx_c_civilite.sql	1.71 KB	-rwxr-x---	2023-04-04 15:50
llx_c_currencies.sql	19.51 KB	-rwxr-x---	2023-04-04 15:50
llx_c_ecotaxe.sql	4.51 KB	-rwxr-x---	2023-04-04 15:50
llx_c_effectif.sql	1.89 KB	-rwxr-x---	2023-04-04 15:50
llx_c_email_templates.sql	10.76 KB	-rwxr-x---	2023-04-04 15:50
llx_c_exp_tax_cat.sql	3.49 KB	-rwxr-x---	2023-04-04 15:50
llx_c_exp_tax_range.sql	2.52 KB	-rwxr-x---	2023-04-04 15:50
llx_c_format_cards.sql	4.85 KB	-rwxr-x---	2023-04-04 15:50
llx_c_forme_juridique.sql	41.63 KB	-rwxr-x---	2023-04-04 15:50
llx_c_holiday_type.sql	2.32 KB	-rwxr-x---	2023-04-04 15:50
llx_c_hrm_department.sql	2.6 KB	-rwxr-x---	2023-04-04 15:50
llx_c_hrm_function.sql	2.17 KB	-rwxr-x---	2023-04-04 15:50
llx_c_hrm_public_holiday.sql	10.99 KB	-rwxr-x---	2023-04-04 15:50
llx_c_incoterms.sql	4.55 KB	-rwxr-x---	2023-04-04 15:50
llx_c_input_method.sql	1.81 KB	-rwxr-x---	2023-04-04 15:50
llx_c_input_reason.sql	2.17 KB	-rwxr-x---	2023-04-04 15:50
llx_c_lead_status.sql	1.68 KB	-rwxr-x---	2023-04-04 15:50
llx_c_paiement.sql	3.01 KB	-rwxr-x---	2023-04-04 15:50
llx_c_paper_format.sql	4.39 KB	-rwxr-x---	2023-04-04 15:50
llx_c_partnership_type-partnership.sql	1.05 KB	-rwxr-x---	2023-04-04 15:50
llx_c_payment_term.sql	4.07 KB	-rwxr-x---	2023-04-04 15:50
llx_c_product_nature.sql	1.12 KB	-rwxr-x---	2023-04-04 15:50
llx_c_productbatch_qcstatus.sql	1.15 KB	-rwxr-x---	2023-04-04 15:50
llx_c_propalst.sql	1.75 KB	-rwxr-x---	2023-04-04 15:50
llx_c_prospectcontactlevel.sql	1.31 KB	-rwxr-x---	2023-04-04 15:50
llx_c_prospectlevel.sql	1.72 KB	-rwxr-x---	2023-04-04 15:50
llx_c_revenuestamp.sql	1.42 KB	-rwxr-x---	2023-04-04 15:50
llx_c_shipment_mode.sql	4.08 KB	-rwxr-x---	2023-04-04 15:50
llx_c_socialnetworks.sql	5.57 KB	-rwxr-x---	2023-04-04 15:50
llx_c_stcomm.sql	1.76 KB	-rwxr-x---	2023-04-04 15:50
llx_c_stcommcontact.sql	1.35 KB	-rwxr-x---	2023-04-04 15:50
llx_c_ticket_category.sql	917 B	-rwxr-x---	2023-04-04 15:50
llx_c_ticket_resolution.sql	1.17 KB	-rwxr-x---	2023-04-04 15:50
llx_c_ticket_severity.sql	1.38 KB	-rwxr-x---	2023-04-04 15:50
llx_c_ticket_type.sql	1.8 KB	-rwxr-x---	2023-04-04 15:50
llx_c_transport_mode.sql	1.7 KB	-rwxr-x---	2023-04-04 15:50
llx_c_tva.sql	33.41 KB	-rwxr-x---	2023-04-04 15:50
llx_c_type_contact.sql	10.44 KB	-rwxr-x---	2023-04-04 15:50
llx_c_type_container.sql	1.85 KB	-rwxr-x---	2023-04-04 15:50
llx_c_type_fees.sql	5.58 KB	-rwxr-x---	2023-04-04 15:50
llx_c_type_resource.sql	1.49 KB	-rwxr-x---	2023-04-04 15:50
llx_c_typent.sql	2.8 KB	-rwxr-x---	2023-04-04 15:50
llx_c_units.sql	6.29 KB	-rwxr-x---	2023-04-04 15:50
llx_const.sql	8.33 KB	-rwxr-x---	2023-04-04 15:50
llx_expensereport_ik.sql	2.6 KB	-rwxr-x---	2023-04-04 15:50
llx_holiday_config.sql	74 B	-rwxr-x---	2023-04-04 15:50

Rename

-- Copyright (C) 2017 Laurent Destailleur <eldy@users.sourceforge.net>
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 3 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program. If not, see <https://www.gnu.org/licenses/>.
--
--

--
-- Ne pas placer de commentaire en fin de ligne, ce fichier est parsé lors
-- de l'install et tous les sigles '--' sont supprimés.
--

-- Bank Thirdparty
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, enabled, active, topic, content, content_lines, joinfiles) VALUES (0, 'banque','thirdparty','',0,null,null,'(YourSEPAMandate)',1,'isModEnabled("societe") && isModEnabled("banque") && isModEnabled("prelevement")',0,'__(YourSEPAMandate)__','__(Hello)__, \n\n__(FindYourSEPAMandate)__ : \n__MYCOMPANY_NAME__ \n__MYCOMPANY_FULLADDRESS__ \n__(Sincerely)__ \n__USER_SIGNATURE__',null, 0);

-- Members
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, enabled, active, topic, content, content_lines, joinfiles) VALUES (0, 'adherent','member','',0,null,null,'(SendingEmailOnAutoSubscription)' ,10, 'isModEnabled("adherent")',1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourMembershipRequestWasReceived)__','__(Hello)__ __MEMBER_FULLNAME__, \n\n__(ThisIsContentOfYourMembershipRequestWasReceived)__ \n __ONLINE_PAYMENT_TEXT_AND_URL__ \n \n__(Sincerely)__ __USER_SIGNATURE__',null, 0);
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, enabled, active, topic, content, content_lines, joinfiles) VALUES (0, 'adherent','member','',0,null,null,'(SendingEmailOnMemberValidation)' ,20, 'isModEnabled("adherent")',1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourMembershipWasValidated)__', '__(Hello)__ __MEMBER_FULLNAME__, \n\n__(ThisIsContentOfYourMembershipWasValidated)__ __(FirstName)__ : __MEMBER_FIRSTNAME__ __(LastName)__ : __MEMBER_LASTNAME__ __(ID)__ : __MEMBER_ID__ \n __ONLINE_PAYMENT_TEXT_AND_URL__ \n \n__(Sincerely)__ __USER_SIGNATURE__',null, 0);
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, enabled, active, topic, content, content_lines, joinfiles) VALUES (0, 'adherent','member','',0,null,null,'(SendingEmailOnNewSubscription)' ,30, 'isModEnabled("adherent")',1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourSubscriptionWasRecorded)__', '__(Hello)__ __MEMBER_FULLNAME__, \n\n__(ThisIsContentOfYourSubscriptionWasRecorded)__ \n\n \n__(Sincerely)__ __USER_SIGNATURE__',null, 1);
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, enabled, active, topic, content, content_lines, joinfiles) VALUES (0, 'adherent','member','',0,null,null,'(SendingReminderForExpiredSubscription)',40, 'isModEnabled("adherent")',1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(SubscriptionReminderEmail)__', '__(Hello)__ __MEMBER_FULLNAME__, \n\n__(ThisIsContentOfSubscriptionReminderEmail)__ \n __ONLINE_PAYMENT_TEXT_AND_URL__ \n \n__(Sincerely)__ __USER_SIGNATURE__',null, 0);
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, enabled, active, topic, content, content_lines, joinfiles) VALUES (0, 'adherent','member','',0,null,null,'(SendingEmailOnCancelation)' ,50, 'isModEnabled("adherent")',1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourMembershipWasCanceled)__', '__(Hello)__ __MEMBER_FULLNAME__, \n\n__(YourMembershipWasCanceled)__ \n \n__(Sincerely)__ __USER_SIGNATURE__',null, 0);
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, enabled, active, topic, content, content_lines, joinfiles) VALUES (0, 'adherent','member','',0,null,null,'(SendingAnEMailToMember)' ,60, 'isModEnabled("adherent")',1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(CardContent)__', '__(Hello)__, \n\n__(ThisIsContentOfYourCard)__ \n__(ID)__ : __ID__ \n__(Civility)__ : __MEMBER_CIVILITY__ \n__(Firstname)__ : __MEMBER_FIRSTNAME__ \n__(Lastname)__ : __MEMBER_LASTNAME__ \n__(Fullname)__ : __MEMBER_FULLNAME__ \n__(Company)__ : __MEMBER_COMPANY__ \n__(Address)__ : __MEMBER_ADDRESS__ \n__(Zip)__ : __MEMBER_ZIP__ \n__(Town)__ : __MEMBER_TOWN__ \n__(Country)__ : __MEMBER_COUNTRY__ \n__(Email)__ : __MEMBER_EMAIL__ \n__(Birthday)__ : __MEMBER_BIRTH__ \n__(Photo)__ : __MEMBER_PHOTO__ \n__(Login)__ : __MEMBER_LOGIN__ \n__(Phone)__ : __MEMBER_PHONE__ \n__(PhonePerso)__ : __MEMBER_PHONEPRO__ \n__(PhoneMobile)__ : __MEMBER_PHONEMOBILE__ \n__(Sincerely)__ __USER_SIGNATURE__',null, 0);

-- Recruiting
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, enabled, active, topic, content, content_lines, joinfiles) VALUES (0, 'recruitment','recruitmentcandidature_send','',0,null,null,'(AnswerCandidature)' ,100,'isModEnabled("recruitment")',1,'[__[MAIN_INFO_SOCIETE_NOM]__] __(YourCandidature)__', '__(Hello)__ __CANDIDATE_FULLNAME__, \n\n__(YourCandidatureAnswerMessage)__ __ONLINE_INTERVIEW_SCHEDULER_TEXT_AND_URL__\n \n__(Sincerely)__ __USER_SIGNATURE__',null, 0);

-- Event organization 
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailAskConf)', 10, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailAskConf)__', '__(Hello)__, __(OrganizationEventConfRequestWasReceived)__ __(Sincerely)__ __USER_SIGNATURE__', null, '1', null);
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailAskBooth)', 20, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailAskBooth)__', '__(Hello)__, __(OrganizationEventBoothRequestWasReceived)__ __(Sincerely)__ __USER_SIGNATURE__', null, '1', null);
-- TODO Add message for registration only to event __ONLINE_PAYMENT_TEXT_AND_URL__
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailBoothPayment)', 30, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailBoothPayment)__', '__(Hello)__, __(OrganizationEventPaymentOfBoothWasReceived)__ __(Sincerely)__ __USER_SIGNATURE__', null, '1', null);
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailRegistrationPayment)', 40, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailRegistrationPayment)__', '__(Hello)__, __(OrganizationEventPaymentOfRegistrationWasReceived)__ __(Sincerely)__ __USER_SIGNATURE__', null, '1', null);
--
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationMassEmailAttendees)', 50, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailAttendees)__', '__(Hello)__, __(OrganizationEventBulkMailToAttendees)__ __(Sincerely)__ __USER_SIGNATURE__', null, '1', null);
INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationMassEmailSpeakers)', 60, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailSpeakers)__', '__(Hello)__, __(OrganizationEventBulkMailToSpeakers)__ __(Sincerely)__ __USER_SIGNATURE__', null, '1', null);

-- Partnership
INSERT INTO llx_c_email_templates (entity, module, type_template, label, lang, position, topic, joinfiles, content) VALUES (0, 'partnership', 'partnership_send', '(SendingEmailOnPartnershipWillSoonBeCanceled)', '', 100, '[__[MAIN_INFO_SOCIETE_NOM]__] - __(YourPartnershipWillSoonBeCanceledTopic)__', 0, '<body>\n __(Hello)__, \n__(YourPartnershipWillSoonBeCanceledContent)__\n \n\n \n\n __(Sincerely)__ \n __[MAIN_INFO_SOCIETE_NOM]__ \n </body>\n');
INSERT INTO llx_c_email_templates (entity, module, type_template, label, lang, position, topic, joinfiles, content) VALUES (0, 'partnership', 'partnership_send', '(SendingEmailOnPartnershipCanceled)', '', 100, '[__[MAIN_INFO_SOCIETE_NOM]__] - __(YourPartnershipCanceledTopic)__', 0, '<body>\n __(Hello)__, \n__(YourPartnershipCanceledContent)__\n \n\n \n\n __(Sincerely)__ \n __[MAIN_INFO_SOCIETE_NOM]__ \n </body>\n');
INSERT INTO llx_c_email_templates (entity, module, type_template, label, lang, position, topic, joinfiles, content) VALUES (0, 'partnership', 'partnership_send', '(SendingEmailOnPartnershipRefused)', '', 100, '[__[MAIN_INFO_SOCIETE_NOM]__] - __(YourPartnershipRefusedTopic)__', 0, '<body>\n __(Hello)__, \n__(YourPartnershipRefusedContent)__\n \n\n \n\n __(Sincerely)__ \n __[MAIN_INFO_SOCIETE_NOM]__ \n </body>\n');
INSERT INTO llx_c_email_templates (entity, module, type_template, label, lang, position, topic, joinfiles, content) VALUES (0, 'partnership', 'partnership_send', '(SendingEmailOnPartnershipAccepted)', '', 100, '[__[MAIN_INFO_SOCIETE_NOM]__] - __(YourPartnershipAcceptedTopic)__', 0, '<body>\n __(Hello)__, \n__(YourPartnershipAcceptedContent)__\n \n\n \n\n __(Sincerely)__ \n __[MAIN_INFO_SOCIETE_NOM]__ \n </body>\n');