1/* Media table definitions for SQLite database 2 * 3 * Project : minidlna 4 * Website : http://sourceforge.net/projects/minidlna/ 5 * Author : Douglas Carmichael 6 * 7 * MiniDLNA media server 8 * Copyright (C) 2008-2009 Justin Maggard 9 * 10 * This file is part of MiniDLNA. 11 * 12 * MiniDLNA is free software; you can redistribute it and/or modify 13 * it under the terms of the GNU General Public License version 2 as 14 * published by the Free Software Foundation. 15 * 16 * MiniDLNA is distributed in the hope that it will be useful, 17 * but WITHOUT ANY WARRANTY; without even the implied warranty of 18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 19 * GNU General Public License for more details. 20 * 21 * You should have received a copy of the GNU General Public License 22 * along with MiniDLNA. If not, see <http://www.gnu.org/licenses/>. 23 */ 24 25char create_objectTable_sqlite[] = "CREATE TABLE OBJECTS (" 26 "ID INTEGER PRIMARY KEY AUTOINCREMENT, " 27 "OBJECT_ID TEXT UNIQUE NOT NULL, " 28 "PARENT_ID TEXT NOT NULL, " 29 "REF_ID TEXT DEFAULT NULL, " 30 "CLASS TEXT NOT NULL, " 31 "DETAIL_ID INTEGER DEFAULT NULL, " 32 "NAME TEXT DEFAULT NULL);"; 33 34char create_detailTable_sqlite[] = "CREATE TABLE DETAILS (" 35 "ID INTEGER PRIMARY KEY AUTOINCREMENT, " 36 "PATH TEXT DEFAULT NULL, " 37 "SIZE INTEGER, " 38 "TIMESTAMP INTEGER, " 39 "TITLE TEXT COLLATE NOCASE, " 40 "DURATION TEXT, " 41 "BITRATE INTEGER, " 42 "SAMPLERATE INTEGER, " 43 "CREATOR TEXT COLLATE NOCASE, " 44 "ARTIST TEXT COLLATE NOCASE, " 45 "ALBUM TEXT COLLATE NOCASE, " 46 "GENRE TEXT COLLATE NOCASE, " 47 "COMMENT TEXT, " 48 "CHANNELS INTEGER, " 49 "DISC INTEGER, " 50 "TRACK INTEGER, " 51 "DATE DATE, " 52 "RESOLUTION TEXT, " 53 "THUMBNAIL BOOL DEFAULT 0, " 54 "ALBUM_ART INTEGER DEFAULT 0, " 55 "ROTATION INTEGER, " 56 "DLNA_PN TEXT, " 57 "MIME TEXT);"; 58 59char create_albumArtTable_sqlite[] = "CREATE TABLE ALBUM_ART (" 60 "ID INTEGER PRIMARY KEY AUTOINCREMENT, " 61 "PATH TEXT NOT NULL" 62 ");"; 63 64char create_captionTable_sqlite[] = "CREATE TABLE CAPTIONS (" 65 "ID INTEGER PRIMARY KEY, " 66 "PATH TEXT NOT NULL" 67 ");"; 68 69char create_bookmarkTable_sqlite[] = "CREATE TABLE BOOKMARKS (" 70 "ID INTEGER PRIMARY KEY, " 71 "SEC INTEGER" 72 ");"; 73 74char create_playlistTable_sqlite[] = "CREATE TABLE PLAYLISTS (" 75 "ID INTEGER PRIMARY KEY AUTOINCREMENT, " 76 "NAME TEXT NOT NULL, " 77 "PATH TEXT NOT NULL, " 78 "ITEMS INTEGER DEFAULT 0, " 79 "FOUND INTEGER DEFAULT 0" 80 ");"; 81 82char create_settingsTable_sqlite[] = "CREATE TABLE SETTINGS (" 83 "KEY TEXT NOT NULL, " 84 "VALUE TEXT" 85 ");"; 86 87 88