"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "scanner_sqlite.h" between
minidlna-1.1.5.tar.gz and minidlna-1.2.0.tar.gz

About: ReadyMedia (formerly known as MiniDLNA) is a simple media server software, with the aim of being fully compliant with DLNA/UPnP-AV clients.

scanner_sqlite.h  (minidlna-1.1.5):scanner_sqlite.h  (minidlna-1.2.0)
/* Media table definitions for SQLite database /* Media table definitions for SQLite database
* *
* Project : minidlna * Project : minidlna
* Website : https://sourceforge.net/projects/minidlna/ * Website : http://sourceforge.net/projects/minidlna/
* Author : Douglas Carmichael * Author : Douglas Carmichael
* *
* MiniDLNA media server * MiniDLNA media server
* Copyright (C) 2008-2009 Justin Maggard * Copyright (C) 2008-2017 Justin Maggard
* *
* This file is part of MiniDLNA. * This file is part of MiniDLNA.
* *
* MiniDLNA is free software; you can redistribute it and/or modify * MiniDLNA is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License version 2 as * it under the terms of the GNU General Public License version 2 as
* published by the Free Software Foundation. * published by the Free Software Foundation.
* *
* MiniDLNA is distributed in the hope that it will be useful, * MiniDLNA is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of * but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
skipping to change at line 32 skipping to change at line 32
* along with MiniDLNA. If not, see <http://www.gnu.org/licenses/>. * along with MiniDLNA. If not, see <http://www.gnu.org/licenses/>.
*/ */
char create_objectTable_sqlite[] = "CREATE TABLE OBJECTS (" char create_objectTable_sqlite[] = "CREATE TABLE OBJECTS ("
"ID INTEGER PRIMARY KEY AUTOINCREMENT, " "ID INTEGER PRIMARY KEY AUTOINCREMENT, "
"OBJECT_ID TEXT UNIQUE NOT NULL, " "OBJECT_ID TEXT UNIQUE NOT NULL, "
"PARENT_ID TEXT NOT NULL, " "PARENT_ID TEXT NOT NULL, "
"REF_ID TEXT DEFAULT NULL, " "REF_ID TEXT DEFAULT NULL, "
"CLASS TEXT NOT NULL, " "CLASS TEXT NOT NULL, "
"DETAIL_ID INTEGER DEFAULT NULL, " "DETAIL_ID INTEGER DEFAULT NULL, "
"NAME TEXT DEFAULT NULL);"; "NAME TEXT DEFAULT NULL"
");";
char create_detailTable_sqlite[] = "CREATE TABLE DETAILS (" char create_detailTable_sqlite[] = "CREATE TABLE DETAILS ("
"ID INTEGER PRIMARY KEY AUTOINCREMENT, " "ID INTEGER PRIMARY KEY AUTOINCREMENT, "
"PATH TEXT DEFAULT NULL, " "PATH TEXT DEFAULT NULL, "
"SIZE INTEGER, " "SIZE INTEGER, "
"TIMESTAMP INTEGER, " "TIMESTAMP INTEGER, "
"TITLE TEXT COLLATE NOCASE, " "TITLE TEXT COLLATE NOCASE, "
"DURATION TEXT, " "DURATION TEXT, "
"BITRATE INTEGER, " "BITRATE INTEGER, "
"SAMPLERATE INTEGER, " "SAMPLERATE INTEGER, "
skipping to change at line 57 skipping to change at line 58
"COMMENT TEXT, " "COMMENT TEXT, "
"CHANNELS INTEGER, " "CHANNELS INTEGER, "
"DISC INTEGER, " "DISC INTEGER, "
"TRACK INTEGER, " "TRACK INTEGER, "
"DATE DATE, " "DATE DATE, "
"RESOLUTION TEXT, " "RESOLUTION TEXT, "
"THUMBNAIL BOOL DEFAULT 0, " "THUMBNAIL BOOL DEFAULT 0, "
"ALBUM_ART INTEGER DEFAULT 0, " "ALBUM_ART INTEGER DEFAULT 0, "
"ROTATION INTEGER, " "ROTATION INTEGER, "
"DLNA_PN TEXT, " "DLNA_PN TEXT, "
"MIME TEXT);"; "MIME TEXT"
");";
char create_albumArtTable_sqlite[] = "CREATE TABLE ALBUM_ART (" char create_albumArtTable_sqlite[] = "CREATE TABLE ALBUM_ART ("
"ID INTEGER PRIMARY KEY AUTOINCREMENT, " "ID INTEGER PRIMARY KEY AUTOINCREMENT, "
"PATH TEXT NOT NULL" "PATH TEXT NOT NULL"
");"; ");";
char create_captionTable_sqlite[] = "CREATE TABLE CAPTIONS (" char create_captionTable_sqlite[] = "CREATE TABLE CAPTIONS ("
"ID INTEGER PRIMARY KEY, " "ID INTEGER PRIMARY KEY, "
"PATH TEXT NOT NULL" "PATH TEXT NOT NULL"
");"; ");";
char create_bookmarkTable_sqlite[] = "CREATE TABLE BOOKMARKS (" char create_bookmarkTable_sqlite[] = "CREATE TABLE BOOKMARKS ("
"ID INTEGER PRIMARY KEY, " "ID INTEGER PRIMARY KEY, "
"SEC INTEGER" "SEC INTEGER, "
"WATCH_COUNT INTEGER"
");"; ");";
char create_playlistTable_sqlite[] = "CREATE TABLE PLAYLISTS (" char create_playlistTable_sqlite[] = "CREATE TABLE PLAYLISTS ("
"ID INTEGER PRIMARY KEY AUTOINCREMENT, " "ID INTEGER PRIMARY KEY AUTOINCREMENT, "
"NAME TEXT NOT NULL, " "NAME TEXT NOT NULL, "
"PATH TEXT NOT NULL, " "PATH TEXT NOT NULL, "
"ITEMS INTEGER DEFAULT 0, " "ITEMS INTEGER DEFAULT 0, "
"FOUND INTEGER DEFAULT 0" "FOUND INTEGER DEFAULT 0"
");"; ");";
 End of changes. 5 change blocks. 
5 lines changed or deleted 8 lines changed or added

Home  |  About  |  All  |  Newest  |  Fossies Dox  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTPS