Skip to content

Instantly share code, notes, and snippets.

@kdambekalns

kdambekalns/gist:5111134

Created March 7, 2013 19:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kdambekalns/5111134 to your computer and use it in GitHub Desktop.
Save kdambekalns/5111134 to your computer and use it in GitHub Desktop.
Download ZIP
SQL to update the table used for storing Role instances (with https://review.typo3.org/13868) - this is needed when switching to patch set 23 or higher.
Raw
gistfile1.sql
ALTER TABLE typo3_flow_security_policy_role ADD new_sourcehint VARCHAR(6) NOT NULL;
UPDATE typo3_flow_security_policy_role SET new_sourcehint='system' where sourcehint=0;
UPDATE typo3_flow_security_policy_role SET new_sourcehint='policy' where sourcehint=1;
UPDATE typo3_flow_security_policy_role SET new_sourcehint='user' where sourcehint=2;
ALTER TABLE typo3_flow_security_policy_role DROP sourcehint;
ALTER TABLE typo3_flow_security_policy_role CHANGE new_sourcehint sourcehint VARCHAR(6) NOT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment