File: version-007.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 (9 lines) | stat: -rw-r--r-- 441 bytes parent folder | download | duplicates (9) 
1
2
3
4
5
6
7
8
9
 
--
-- Gmail has a serious bug: its STATUS command returns a message count that includes chat messages,
-- but the SELECT/EXAMINE result codes do not.  That means its difficult to confirm changes to a
-- mailbox without SELECTing it each pass.  This schema modification allows for Geary to store both
-- the SELECT/EXAMINE count and STATUS count in the database for comparison.
--

ALTER TABLE FolderTable ADD COLUMN last_seen_status_total;