private-tag-denamer.sql

Revision 898, 285 bytes (checked in by hirokai, 3 years ago)
SQL that fixes the p/name wart in tag names
Property svn:eol-style set to `native` Property svn:keywords set to `Author Date Id Revision`

Line
1	ALTER TABLE linksGroups ADD isPrivate tinyint;
2	UPDATE linksGroups SET isPrivate = 1 WHERE name NOT LIKE "p\%2F%" AND name NOT LIKE "p/%";
3	UPDATE linksGroups SET name = SUBSTRING(name, 5) WHERE name LIKE "p\%2F%";
4	UPDATE linksGroups SET name = SUBSTRING(name, 3) WHERE name LIKE "p/%";

Note: See TracBrowser for help on using the browser.