mirror of
https://github.com/mudita/MuditaOS.git
synced 2026-04-19 14:40:57 -04:00
24 lines
1015 B
SQL
24 lines
1015 B
SQL
-- 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 ''
|
|
);
|
|
|