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