scanner_sqlite.h

   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-2017  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
  25 char 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                                         ");";
  34
  35 char create_detailTable_sqlite[] = "CREATE TABLE DETAILS ("
  36                                         "ID INTEGER PRIMARY KEY AUTOINCREMENT, "
  37                                         "PATH TEXT DEFAULT NULL, "
  38                                         "SIZE INTEGER, "
  39                                         "TIMESTAMP INTEGER, "
  40                                         "TITLE TEXT COLLATE NOCASE, "
  41                                         "DURATION TEXT, "
  42                                         "BITRATE INTEGER, "
  43                                         "SAMPLERATE INTEGER, "
  44                                         "CREATOR TEXT COLLATE NOCASE, "
  45                                         "ARTIST TEXT COLLATE NOCASE, "
  46                                         "ALBUM TEXT COLLATE NOCASE, "
  47                                         "GENRE TEXT COLLATE NOCASE, "
  48                                         "COMMENT TEXT, "
  49                                         "CHANNELS INTEGER, "
  50                                         "DISC INTEGER, "
  51                                         "TRACK INTEGER, "
  52                                         "DATE DATE, "
  53                                         "RESOLUTION TEXT, "
  54                                         "THUMBNAIL BOOL DEFAULT 0, "
  55                                         "ALBUM_ART INTEGER DEFAULT 0, "
  56                                         "ROTATION INTEGER, "
  57                                         "DLNA_PN TEXT, "
  58                                         "MIME TEXT"
  59                                         ");";
  60
  61 char create_albumArtTable_sqlite[] = "CREATE TABLE ALBUM_ART ("
  62                                         "ID INTEGER PRIMARY KEY AUTOINCREMENT, "
  63                                         "PATH TEXT NOT NULL"
  64                                         ");";
  65
  66 char create_captionTable_sqlite[] = "CREATE TABLE CAPTIONS ("
  67                                         "ID INTEGER PRIMARY KEY, "
  68                                         "PATH TEXT NOT NULL"
  69                                         ");";
  70
  71 char create_bookmarkTable_sqlite[] = "CREATE TABLE BOOKMARKS ("
  72                                         "ID INTEGER PRIMARY KEY, "
  73                                         "SEC INTEGER, "
  74                                         "WATCH_COUNT INTEGER"
  75                                         ");";
  76
  77 char create_playlistTable_sqlite[] = "CREATE TABLE PLAYLISTS ("
  78                                         "ID INTEGER PRIMARY KEY AUTOINCREMENT, "
  79                                         "NAME TEXT NOT NULL, "
  80                                         "PATH TEXT NOT NULL, "
  81                                         "ITEMS INTEGER DEFAULT 0, "
  82                                         "FOUND INTEGER DEFAULT 0, "
  83                                         "TIMESTAMP INTEGER DEFAULT 0"
  84                                         ");";
  85
  86 char create_settingsTable_sqlite[] = "CREATE TABLE SETTINGS ("
  87                                         "KEY TEXT NOT NULL, "
  88                                         "VALUE TEXT"
  89                                         ");";