Scribd
Upload
11 views4 pages

Update RUID for Database Records

The document contains a series of SQL update statements that set the '_ruid' field for multiple tables to a formatted string based on the 'id' field, specifically for records where '_ruid' is currently NULL. This operation is performed across various tables including equipment, partner, product, and survey-related tables. The purpose of these updates is to ensure that all entries have a unique identifier in the '_ruid' field.

Uploaded by

MIMOUNI WAFAA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views4 pages

Update RUID for Database Records

The document contains a series of SQL update statements that set the '_ruid' field for multiple tables to a formatted string based on the 'id' field, specifically for records where '_ruid' is currently NULL. This operation is performed across various tables including equipment, partner, product, and survey-related tables. The purpose of these updates is to ensure that all entries have a unique identifier in the '_ruid' field.

Uploaded by

MIMOUNI WAFAA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

UPDATE equipment_equipment_contract SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE api_synchronisation_mixin SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner_image SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner_pref_visit_days SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner_selector SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_currency SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_country SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_country_region SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_country_state SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_country_substate SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_country_city SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_country_sector SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE model_custom_attribute SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE model_custom_attribute_value SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE model_custom_attribute_selector SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_company SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_users SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE ir_attachment SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE form_config_model_field SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE form_config_model SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE form_config SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE fleet_vehicle SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE calendar_event_type SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE real_date_range SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_no_visit SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_no_visit_reason SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE user_workflow SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE user_workflow_activity SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE user_workflow_transition SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_user_event SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_template SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_template_event SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_report_template SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_brand SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_ul SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_category SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_template SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_product SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_packaging SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;


UPDATE uom_category SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE uom_uom SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_product_selector SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_pricelist SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_pricelist_item SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner_pricelist SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE survey_user_input_line_image SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE survey_survey SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE survey_question SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE survey_label SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE survey_user_input SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE survey_user_input_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE stock_warehouse SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner_modification_type SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner_modification SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE census_census SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE census_user_event SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE merchandising_activity_configuration SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE merchandising_activity_configuration_target SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE merchandising_activity_configuration_item SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_state SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_category SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_attribute_category_rel SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_attribute SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_attribute_value SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_attribute_value_entry SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_branding SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_image SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_affectation SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE equipment_equipment_affectation_reason SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_equipment_survey SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_equipment_survey_image SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE merchandising_survey_target SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE merchandising_survey_target_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE survey_no_user_input_reason SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_stock_price_survey SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_stock_price_survey_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_stock_price_survey_image SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_stock_attribute SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;


UPDATE planning_stock_attribute_value SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_stock_survey_value SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_availability_survey SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_availability_survey_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_availability_survey_image SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_suggested_price SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_promotion SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_promotion_offer SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_promotion_offer_condition SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_promotion_offer_trigger SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_promotion_offer_trigger_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_promotion_offer_product SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE product_promotion_offer_product_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE crm_team SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_user_task SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_user_task_item SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_user_task_type SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE account_tax SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE account_payment_method SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE account_payment_term_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE account_payment_term SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE account_journal SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner_balance SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner_payment_term SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_partner_limit_credit SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_users_payment_term SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE account_bank_statement_import_journal_creation SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE account_journal_cash_configuration SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_cash_payment SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_no_sale_reason SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE res_users_product_limit SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_no_delivery_reason SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE stock_picking_reason_return SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_initial_final_stock_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_loading_request SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_loading_request_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_loading_request_reason SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0') WHERE _ruid IS NULL;

UPDATE planning_planning SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0');


UPDATE calendar_event SET _ruid = '00000000-0000-00s00-0000-'||LPAD(id::text, 12,'0');

UPDATE account_payment SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0');

UPDATE sale_order_line SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0');

UPDATE sale_order SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0');

UPDATE stock_picking SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0');

UPDATE stock_inventory SET _ruid = '00000000-0000-0000-0000-'||LPAD(id::text, 12,'0');

You might also like