Init sortable_rank when using propel with sortable behavior

init_sortable_rank.sql

/* Init sortable_rank without scope */
select @rank:=0;
update TABLE_NAME set sortable_rank=(@rank:=(@rank+1));

/* Init sortable_rank with scope */
select @range:=0;
update TABLE_NAME set sortable_rank=IF(@range!=SCOPE_COLUMN, @rank:=1 && (@range:=SCOPE_COLUMN), @rank:=@rank+1) order by SCOPE_COLUMN, PK_COLUMN;