~aleteoryx/muditaos

ref: c1391090c67428aeaffcef5a7a71a6d2ed69ccc9 muditaos/image/user/db/calllog_001.sql -rw-r--r-- 547 bytes
c1391090 — Mateusz Piesta [BH-1389] Catch2 unit tests optimization 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.