File: version-027.sql

package info (click to toggle)
geary 46.0-10
  • links: PTS, VCS
  • area: main
  • in suites: forky
  • size: 15,092 kB
  • sloc: javascript: 972; ansic: 722; sql: 247; xml: 183; python: 30; makefile: 28; sh: 24
file content (7 lines) | stat: -rw-r--r-- 169 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
 
--
-- Rebuild corrupted message ids.
--

UPDATE MessageTable
SET message_id = '<' || message_id || '>'
WHERE (message_id NOT LIKE '<%') AND (message_id NOT LIKE ' <%');