Skip to content

Instantly share code, notes, and snippets.

@pulponair

pulponair/foobar.sql

Created February 2, 2016 15:19
Show Gist options
  • Save pulponair/1c8f881a9205830eb09b to your computer and use it in GitHub Desktop.
Save pulponair/1c8f881a9205830eb09b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
foobar.sql
UPDATE
tx_foo_domain_model_bar s,
sys_file_reference r,
sys_file f
SET
s.sorting = CAST(SUBSTRING(f.name,6,3) AS UNSIGNED) * 256
WHERE
s.record_type=1 AND
r.tablenames = 'tx_foo_domain_model_bar' AND
r.fieldname = 'image' AND
r.uid_foreign = s.uid AND
r.uid_local = f.uid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment