mirror of
https://git.code.sf.net/p/minidlna/git
synced 2024-09-19 00:40:48 +00:00
50b1a2e289
Fix several issues with the non-destructive rescan functionality. Most of these issues also affected inotify scanning as well. These include annoying debug messages, adding album art for files that we aren't supposed to be scanning anyway, incrementing the UpdateID when no changes were made to the database, and other smaller issues.
90 lines
2.7 KiB
C
90 lines
2.7 KiB
C
/* Media table definitions for SQLite database
|
|
*
|
|
* Project : minidlna
|
|
* Website : http://sourceforge.net/projects/minidlna/
|
|
* Author : Douglas Carmichael
|
|
*
|
|
* MiniDLNA media server
|
|
* Copyright (C) 2008-2017 Justin Maggard
|
|
*
|
|
* This file is part of MiniDLNA.
|
|
*
|
|
* MiniDLNA is free software; you can redistribute it and/or modify
|
|
* it under the terms of the GNU General Public License version 2 as
|
|
* published by the Free Software Foundation.
|
|
*
|
|
* MiniDLNA is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU General Public License
|
|
* along with MiniDLNA. If not, see <http://www.gnu.org/licenses/>.
|
|
*/
|
|
|
|
char create_objectTable_sqlite[] = "CREATE TABLE OBJECTS ("
|
|
"ID INTEGER PRIMARY KEY AUTOINCREMENT, "
|
|
"OBJECT_ID TEXT UNIQUE NOT NULL, "
|
|
"PARENT_ID TEXT NOT NULL, "
|
|
"REF_ID TEXT DEFAULT NULL, "
|
|
"CLASS TEXT NOT NULL, "
|
|
"DETAIL_ID INTEGER DEFAULT NULL, "
|
|
"NAME TEXT DEFAULT NULL"
|
|
");";
|
|
|
|
char create_detailTable_sqlite[] = "CREATE TABLE DETAILS ("
|
|
"ID INTEGER PRIMARY KEY AUTOINCREMENT, "
|
|
"PATH TEXT DEFAULT NULL, "
|
|
"SIZE INTEGER, "
|
|
"TIMESTAMP INTEGER, "
|
|
"TITLE TEXT COLLATE NOCASE, "
|
|
"DURATION TEXT, "
|
|
"BITRATE INTEGER, "
|
|
"SAMPLERATE INTEGER, "
|
|
"CREATOR TEXT COLLATE NOCASE, "
|
|
"ARTIST TEXT COLLATE NOCASE, "
|
|
"ALBUM TEXT COLLATE NOCASE, "
|
|
"GENRE TEXT COLLATE NOCASE, "
|
|
"COMMENT TEXT, "
|
|
"CHANNELS INTEGER, "
|
|
"DISC INTEGER, "
|
|
"TRACK INTEGER, "
|
|
"DATE DATE, "
|
|
"RESOLUTION TEXT, "
|
|
"THUMBNAIL BOOL DEFAULT 0, "
|
|
"ALBUM_ART INTEGER DEFAULT 0, "
|
|
"ROTATION INTEGER, "
|
|
"DLNA_PN TEXT, "
|
|
"MIME TEXT"
|
|
");";
|
|
|
|
char create_albumArtTable_sqlite[] = "CREATE TABLE ALBUM_ART ("
|
|
"ID INTEGER PRIMARY KEY AUTOINCREMENT, "
|
|
"PATH TEXT NOT NULL"
|
|
");";
|
|
|
|
char create_captionTable_sqlite[] = "CREATE TABLE CAPTIONS ("
|
|
"ID INTEGER PRIMARY KEY, "
|
|
"PATH TEXT NOT NULL"
|
|
");";
|
|
|
|
char create_bookmarkTable_sqlite[] = "CREATE TABLE BOOKMARKS ("
|
|
"ID INTEGER PRIMARY KEY, "
|
|
"SEC INTEGER, "
|
|
"WATCH_COUNT INTEGER"
|
|
");";
|
|
|
|
char create_playlistTable_sqlite[] = "CREATE TABLE PLAYLISTS ("
|
|
"ID INTEGER PRIMARY KEY AUTOINCREMENT, "
|
|
"NAME TEXT NOT NULL, "
|
|
"PATH TEXT NOT NULL, "
|
|
"ITEMS INTEGER DEFAULT 0, "
|
|
"FOUND INTEGER DEFAULT 0, "
|
|
"TIMESTAMP INTEGER DEFAULT 0"
|
|
");";
|
|
|
|
char create_settingsTable_sqlite[] = "CREATE TABLE SETTINGS ("
|
|
"KEY TEXT NOT NULL, "
|
|
"VALUE TEXT"
|
|
");";
|