1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
|
-- MySQL dump 8.21
--
-- Host: localhost Database: GiantDisc
---------------------------------------------------------
-- Server version 3.23.49
--
-- Current Database: GiantDisc
--
--CREATE DATABASE /*!32312 IF NOT EXISTS*/ GiantDisc;
USE GiantDisc;
--
-- Table structure for table 'album'
--
drop table if exists album;
CREATE TABLE album (
artist varchar(255) default NULL,
title varchar(255) default NULL,
cddbid varchar(20) NOT NULL default '',
coverimg varchar(255) default NULL,
covertxt mediumtext,
modified date default NULL,
genre varchar(10) default NULL,
PRIMARY KEY (cddbid),
KEY artist (artist(10)),
KEY title (title(10)),
KEY genre (genre),
KEY modified (modified)
) TYPE=MyISAM;
--
-- Table structure for table 'genre'
--
drop table if exists genre;
CREATE TABLE genre (
id varchar(10) NOT NULL default '',
id3genre smallint(6) default NULL,
genre varchar(255) default NULL,
freq int(11) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Table structure for table 'language'
--
drop table if exists language;
CREATE TABLE language (
id varchar(4) NOT NULL default '',
language varchar(40) default NULL,
freq int(11) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Table structure for table 'musictype'
--
drop table if exists musictype;
CREATE TABLE musictype (
musictype varchar(40) default NULL,
id tinyint(3) unsigned NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Table structure for table 'player'
--
drop table if exists player;
CREATE TABLE player (
ipaddr varchar(255) NOT NULL default '',
uichannel varchar(255) NOT NULL default '',
logtarget int(11) default NULL,
cdripper varchar(255) default NULL,
mp3encoder varchar(255) default NULL,
cdromdev varchar(255) default NULL,
cdrwdev varchar(255) default NULL,
id int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Table structure for table 'playerstate'
--
drop table if exists playerstate;
CREATE TABLE playerstate (
playerid int(11) NOT NULL default '0',
playertype int(11) NOT NULL default '0',
snddevice varchar(255) default NULL,
playerapp varchar(255) default NULL,
playerparams varchar(255) default NULL,
ptlogger varchar(255) default NULL,
currtracknb int(11) default NULL,
state varchar(4) default NULL,
shufflepar varchar(255) default NULL,
shufflestat varchar(255) default NULL,
pauseframe int(11) default NULL,
framesplayed int(11) default NULL,
framestotal int(11) default NULL,
anchortime bigint(20) default NULL,
PRIMARY KEY (playerid,playertype)
) TYPE=HEAP;
--
-- Table structure for table 'playlist'
--
drop table if exists playlist;
CREATE TABLE playlist (
title varchar(255) default NULL,
author varchar(255) default NULL,
note varchar(255) default NULL,
created timestamp(8) NOT NULL,
id int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Table structure for table 'playlistitem'
--
drop table if exists playlistitem;
CREATE TABLE playlistitem (
playlist int(11) NOT NULL default '0',
tracknumber mediumint(9) NOT NULL default '0',
trackid int(11) default NULL,
PRIMARY KEY (playlist,tracknumber)
) TYPE=MyISAM;
--
-- Table structure for table 'playlog'
--
drop table if exists playlog;
CREATE TABLE playlog (
trackid int(11) default NULL,
played date default NULL,
id tinyint(3) unsigned NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Table structure for table 'recordingitem'
--
drop table if exists recordingitem;
CREATE TABLE recordingitem (
trackid int(11) default NULL,
recdate date default NULL,
rectime time default NULL,
reclength int(11) default NULL,
enddate date default NULL,
endtime time default NULL,
repeat varchar(10) default NULL,
initcmd varchar(255) default NULL,
parameters varchar(255) default NULL,
atqjob int(11) default NULL,
id int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Table structure for table 'source'
--
drop table if exists source;
CREATE TABLE source (
source varchar(40) default NULL,
id tinyint(3) unsigned NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Table structure for table 'tracklistitem'
--
drop table if exists tracklistitem;
CREATE TABLE tracklistitem (
playerid int(11) NOT NULL default '0',
listtype smallint(6) NOT NULL default '0',
tracknb int(11) NOT NULL default '0',
trackid int(11) NOT NULL default '0',
PRIMARY KEY (playerid,listtype,tracknb)
) TYPE=MyISAM;
--
-- Table structure for table 'tracks'
--
drop table if exists tracks;
CREATE TABLE tracks (
artist varchar(255) default NULL,
title varchar(255) default NULL,
genre1 varchar(10) default NULL,
genre2 varchar(10) default NULL,
year smallint(5) unsigned default NULL,
lang varchar(4) default NULL,
type tinyint(3) unsigned default NULL,
rating tinyint(3) unsigned default NULL,
length smallint(5) unsigned default NULL,
source tinyint(3) unsigned default NULL,
sourceid varchar(20) default NULL,
tracknb tinyint(3) unsigned default NULL,
mp3file varchar(255) default NULL,
condition tinyint(3) unsigned default NULL,
voladjust smallint(6) default '0',
lengthfrm mediumint(9) default '0',
startfrm mediumint(9) default '0',
bpm smallint(6) default '0',
lyrics mediumtext,
bitrate varchar(10) default NULL,
created date default NULL,
modified date default NULL,
backup tinyint(3) unsigned default NULL,
samplerate int(7) unsigned default NULL,
channels tinyint(3) unsigned default NULL,
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id),
KEY title (title(10)),
KEY mp3file (mp3file(10)),
KEY genre1 (genre1),
KEY genre2 (genre2),
KEY year (year),
KEY lang (lang),
KEY type (type),
KEY rating (rating),
KEY sourceid (sourceid),
KEY artist (artist(10))
) TYPE=MyISAM;
|
