File: version-005.sql

package info (click to toggle)
geary 0.8.2-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 8,332 kB
  • ctags: 5,261
  • sloc: ansic: 26,847; sql: 174; makefile: 121; xml: 101; python: 18; sh: 17
file content (13 lines) | stat: -rw-r--r-- 288 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 

--
-- Create ContactTable for autocompletion contacts. Data is migrated in vala upgrade hooks.
--

CREATE TABLE ContactTable (
    id INTEGER PRIMARY KEY,
    normalized_email TEXT NOT NULL,
    real_name TEXT,
    email TEXT UNIQUE NOT NULL,
    highest_importance INTEGER NOT NULL
);