18 lines
597 B
SQL
18 lines
597 B
SQL
update activity_activity as t set activity_type = at.id
|
|
from activity_type at, ir_model_data md
|
|
where md.model = 'activity.type' and
|
|
at.id = md.db_id and
|
|
md.fs_id = direction || '_' || "type" || '_type' ;
|
|
|
|
update activity_activity as t set activity_type = at.id
|
|
from activity_type at, ir_model_data md
|
|
where md.model = 'activity.type' and
|
|
at.id = md.db_id and
|
|
md.fs_id = "type" || '_type' ;
|
|
|
|
update ir_sequence
|
|
set number_next_internal = (select max(code::integer)+1
|
|
from activity_activity) where code = 'activity.activity';
|
|
|
|
ALTER TABLE activity_activity alter column activity_type set not null;
|