~aleteoryx/muditaos

ref: 7fc6627759b0de8b576bb15ddc6b31c70f3617b7 muditaos/module-db/databases/scripts/multimedia_001.sql -rw-r--r-- 1.0 KiB
7fc66277 — Lefucjusz [MOS-783] Fix crash on entering SAR menu 3 years ago 
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

-- 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 files
(
    _id         INTEGER PRIMARY KEY,
    path        TEXT UNIQUE,    /* filepath */
    media_type  TEXT,           /* mime type e.g. "audio/mp3" */
    size        INTEGER,        /* file size in bytes */
    title       TEXT,           /* song title */
    artist      TEXT,           /* song artist */
    album       TEXT,           /* song album */
    comment     TEXT,           /* comment */
    genre       TEXT,           /* e.g. "blues, classic rock" */
    year        INTEGER,        /* year of release */
    track       INTEGER,        /* track number */
    song_length INTEGER,        /* length of the song in seconds */
    bitrate     INTEGER,        /* bitrate of the song in kb/s */
    sample_rate INTEGER,        /* sample rate of the song in Hz */
    channels    INTEGER         /* number of channels 1 - mono, 2 - stereo */
);