File: version-002.sql

package info (click to toggle)
geary 46.0-7
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 15,092 kB
  • sloc: javascript: 972; ansic: 722; sql: 247; xml: 183; python: 30; sh: 24; makefile: 23
file content (15 lines) | stat: -rw-r--r-- 320 bytes parent folder | download | duplicates (9) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 

--
-- MessageAttachmentTable
--

CREATE TABLE MessageAttachmentTable (
    id INTEGER PRIMARY KEY,
    message_id INTEGER REFERENCES MessageTable ON DELETE CASCADE,
    filename TEXT,
    mime_type TEXT,
    filesize INTEGER
);

CREATE INDEX MessageAttachmentTableMessageIDIndex ON MessageAttachmentTable(message_id);