32 lines
1.2 KiB
Django/Jinja
32 lines
1.2 KiB
Django/Jinja
-- Update Odoo database with dev/testing settings
|
|
|
|
-- Change Electronic Invoice settings to prevent invoices from being sent
|
|
|
|
UPDATE "res_company" SET "einvoicing_enabled"=false,"ei_environment"='test',"edi_ds_ambient"='2' WHERE id = 1;
|
|
|
|
-- Deactivate Electronic Invoice periodic checks and downloads
|
|
|
|
UPDATE "ir_cron" SET "active"=false WHERE id IN (25, 27);
|
|
|
|
-- Change Client ID for Google OAuth authentication
|
|
|
|
UPDATE "auth_oauth_provider" SET "client_id"='839348907645-51gmj31708h2vuts2sorqh842uhohoce.apps.googleusercontent.com' WHERE id = 3;
|
|
{#
|
|
-- Change password for user 'admin'
|
|
|
|
UPDATE "res_users" SET "password_crypt"='$pbkdf2-sha512$6400$tnYOAUCoNSbkHKMUAmAMgQ$UTwtQj2mGD1KnW5.S7dq0qxMw5M4tuWb2ckr8vB8k7MLrwG5aDyWDA6sLXawE..xrLDjvYrtxgIRvNf97knYVQ' WHERE id = 2;
|
|
|
|
UPDATE "res_users" SET "password"='' WHERE id = 2;
|
|
|
|
UPDATE "res_users" SET "share"=false WHERE id = 2;
|
|
#}
|
|
-- Delete incoming and change outgoing mail servers
|
|
|
|
DELETE FROM fetchmail_server where id = 1;
|
|
|
|
UPDATE "ir_mail_server" SET "name"='Mailpit',"smtp_host"='mailtest.agofer.net',"active"=true where id = 1;
|
|
|
|
-- Change base URL
|
|
|
|
UPDATE "ir_config_parameter" SET "value"='https://{{ ansible_hostname }}.{{ dominio }}' WHERE id = 4;
|