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

CREATE TABLE IF NOT EXISTS events(
                                     _id INTEGER PRIMARY KEY,
                                     name TEXT DEFAULT '',
                                     start_date DATETIME,
                                     end_date DATETIME,
                                     duration INTEGER,
                                     is_all_day BOOLEAN,
                                     rrule TEXT DEFAULT ''
);

CREATE TABLE IF NOT EXISTS alarms(
                                     _id INTEGER PRIMARY KEY,
                                     hour INTEGER,
                                     minute INTEGER,
                                     music_tone TEXT,
                                     enabled BOOLEAN,
                                     snooze_duration INTEGER,
                                     rrule TEXT DEFAULT ''
);