~aleteoryx/muditaos

ref: 1723f12895946e20558ba5ed1a9bc74d6151fc24 muditaos/image/user/db/calllog_001.sql -rw-r--r-- 547 bytes
1723f128 — Pawel Olejniczak [CP-1483] Add test for sync API 3 years ago 
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

-- Copyright (c) 2017-2021, Mudita Sp. z.o.o. All rights reserved.
-- For licensing, see https://github.com/mudita/MuditaOS/LICENSE.md

CREATE TABLE IF NOT EXISTS calls(
    _id INTEGER PRIMARY KEY,
    number TEXT DEFAULT '',
    e164number TEXT DEFAULT '',
    presentation INTEGER DEFAULT 0,
    date INTEGER DEFAULT 0,
    duration INTEGER DEFAULT 0,
    type INTEGER DEFAULT 0,
    name TEXT DEFAULT '',
    contactId INTEGER DEFAULT 0,
    isRead INTEGER DEFAULT 1
);
-- calls.contactId should not be used.
-- calls.name should not be used.