Subversion Repositories cheapmusic

Rev

Rev 14 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
38 - 1
-- MySQL dump 10.13  Distrib 5.1.73, for redhat-linux-gnu (x86_64)
14 - 2
--
3
-- Host: localhost    Database: cheapmusic
4
-- ------------------------------------------------------
38 - 5
-- Server version	5.1.73
14 - 6
 
7
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10
/*!40101 SET NAMES utf8 */;
11
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12
/*!40103 SET TIME_ZONE='+00:00' */;
13
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
 
18
--
38 - 19
-- Table structure for table `artistAliases`
20
--
21
 
22
DROP TABLE IF EXISTS `artistAliases`;
23
/*!40101 SET @saved_cs_client     = @@character_set_client */;
24
/*!40101 SET character_set_client = utf8 */;
25
CREATE TABLE `artistAliases` (
26
  `id` int(10) unsigned NOT NULL,
27
  `name` varchar(1024) DEFAULT NULL,
28
  KEY `artistAliasesId` (`id`),
29
  KEY `artistAliasesName` (`name`(255))
30
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31
/*!40101 SET character_set_client = @saved_cs_client */;
32
 
33
--
34
-- Table structure for table `artistGroups`
35
--
36
 
37
DROP TABLE IF EXISTS `artistGroups`;
38
/*!40101 SET @saved_cs_client     = @@character_set_client */;
39
/*!40101 SET character_set_client = utf8 */;
40
CREATE TABLE `artistGroups` (
41
  `id` int(10) unsigned NOT NULL,
42
  `name` varchar(1024) DEFAULT NULL,
43
  KEY `artistGroupsId` (`id`),
44
  KEY `artistGroupsName` (`name`(255))
45
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
46
/*!40101 SET character_set_client = @saved_cs_client */;
47
 
48
--
49
-- Table structure for table `artistMembers`
50
--
51
 
52
DROP TABLE IF EXISTS `artistMembers`;
53
/*!40101 SET @saved_cs_client     = @@character_set_client */;
54
/*!40101 SET character_set_client = utf8 */;
55
CREATE TABLE `artistMembers` (
56
  `id` int(10) unsigned NOT NULL,
57
  `mid` int(10) unsigned NOT NULL,
58
  KEY `artistMembersId` (`id`),
59
  KEY `artistMembersMId` (`mid`)
60
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61
/*!40101 SET character_set_client = @saved_cs_client */;
62
 
63
--
64
-- Table structure for table `artistProfiles`
65
--
66
 
67
DROP TABLE IF EXISTS `artistProfiles`;
68
/*!40101 SET @saved_cs_client     = @@character_set_client */;
69
/*!40101 SET character_set_client = utf8 */;
70
CREATE TABLE `artistProfiles` (
71
  `id` int(10) unsigned NOT NULL,
72
  `profile` blob,
73
  PRIMARY KEY (`id`)
74
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
75
/*!40101 SET character_set_client = @saved_cs_client */;
76
 
77
--
78
-- Table structure for table `artistUrls`
79
--
80
 
81
DROP TABLE IF EXISTS `artistUrls`;
82
/*!40101 SET @saved_cs_client     = @@character_set_client */;
83
/*!40101 SET character_set_client = utf8 */;
84
CREATE TABLE `artistUrls` (
85
  `id` int(10) unsigned NOT NULL,
86
  `url` varchar(1024) DEFAULT NULL,
87
  KEY `artistUrlsId` (`id`)
88
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
89
/*!40101 SET character_set_client = @saved_cs_client */;
90
 
91
--
92
-- Table structure for table `artistVariations`
93
--
94
 
95
DROP TABLE IF EXISTS `artistVariations`;
96
/*!40101 SET @saved_cs_client     = @@character_set_client */;
97
/*!40101 SET character_set_client = utf8 */;
98
CREATE TABLE `artistVariations` (
99
  `id` int(10) unsigned NOT NULL,
100
  `name` varchar(1024) DEFAULT NULL,
101
  KEY `artistVariationsId` (`id`),
102
  KEY `artistVariationsName` (`name`(255))
103
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
104
/*!40101 SET character_set_client = @saved_cs_client */;
105
 
106
--
107
-- Table structure for table `artists`
108
--
109
 
110
DROP TABLE IF EXISTS `artists`;
111
/*!40101 SET @saved_cs_client     = @@character_set_client */;
112
/*!40101 SET character_set_client = utf8 */;
113
CREATE TABLE `artists` (
114
  `id` int(10) unsigned NOT NULL,
115
  `name` varchar(1024) DEFAULT NULL,
116
  `realname` varchar(1024) DEFAULT NULL,
117
  PRIMARY KEY (`id`),
118
  KEY `artistsName` (`name`(255))
119
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
120
/*!40101 SET character_set_client = @saved_cs_client */;
121
 
122
--
123
-- Table structure for table `labelUrls`
124
--
125
 
126
DROP TABLE IF EXISTS `labelUrls`;
127
/*!40101 SET @saved_cs_client     = @@character_set_client */;
128
/*!40101 SET character_set_client = utf8 */;
129
CREATE TABLE `labelUrls` (
130
  `id` int(10) unsigned NOT NULL,
131
  `url` varchar(1024) DEFAULT NULL,
132
  KEY `labelUrlsId` (`id`)
133
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
134
/*!40101 SET character_set_client = @saved_cs_client */;
135
 
136
--
137
-- Table structure for table `labels`
138
--
139
 
140
DROP TABLE IF EXISTS `labels`;
141
/*!40101 SET @saved_cs_client     = @@character_set_client */;
142
/*!40101 SET character_set_client = utf8 */;
143
CREATE TABLE `labels` (
144
  `id` int(10) unsigned NOT NULL,
145
  `name` varchar(1024) DEFAULT NULL,
146
  `parentlabel` varchar(1024) DEFAULT NULL,
147
  `sublabel` varchar(4096) DEFAULT NULL,
148
  PRIMARY KEY (`id`),
149
  KEY `labelsName` (`name`(255))
150
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
151
/*!40101 SET character_set_client = @saved_cs_client */;
152
 
153
--
154
-- Table structure for table `masterArtists`
155
--
156
 
157
DROP TABLE IF EXISTS `masterArtists`;
158
/*!40101 SET @saved_cs_client     = @@character_set_client */;
159
/*!40101 SET character_set_client = utf8 */;
160
CREATE TABLE `masterArtists` (
161
  `id` int(10) unsigned NOT NULL,
162
  `aid` int(10) unsigned NOT NULL,
163
  KEY `masterArtistsId` (`id`),
164
  KEY `masterArtistsAId` (`aid`)
165
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
166
/*!40101 SET character_set_client = @saved_cs_client */;
167
 
168
--
169
-- Table structure for table `masters`
170
--
171
 
172
DROP TABLE IF EXISTS `masters`;
173
/*!40101 SET @saved_cs_client     = @@character_set_client */;
174
/*!40101 SET character_set_client = utf8 */;
175
CREATE TABLE `masters` (
176
  `id` int(10) unsigned NOT NULL,
177
  `rid` int(10) unsigned NOT NULL,
178
  `year` smallint(6) DEFAULT NULL,
179
  `title` varchar(1024) DEFAULT NULL,
180
  `genres` varchar(1024) DEFAULT NULL,
181
  `styles` varchar(1024) DEFAULT NULL,
182
  PRIMARY KEY (`id`),
183
  KEY `mastersRId` (`rid`),
184
  KEY `mastersTitle` (`title`(255))
185
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
186
/*!40101 SET character_set_client = @saved_cs_client */;
187
 
188
--
189
-- Table structure for table `releaseArtists`
190
--
191
 
192
DROP TABLE IF EXISTS `releaseArtists`;
193
/*!40101 SET @saved_cs_client     = @@character_set_client */;
194
/*!40101 SET character_set_client = utf8 */;
195
CREATE TABLE `releaseArtists` (
196
  `id` int(10) unsigned NOT NULL,
197
  `aid` int(10) unsigned NOT NULL,
198
  KEY `releaseArtistsId` (`id`),
199
  KEY `releaseArtistsAId` (`aid`)
200
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
201
/*!40101 SET character_set_client = @saved_cs_client */;
202
 
203
--
204
-- Table structure for table `releaseLabels`
205
--
206
 
207
DROP TABLE IF EXISTS `releaseLabels`;
208
/*!40101 SET @saved_cs_client     = @@character_set_client */;
209
/*!40101 SET character_set_client = utf8 */;
210
CREATE TABLE `releaseLabels` (
211
  `id` int(10) unsigned NOT NULL,
212
  `lid` int(10) unsigned NOT NULL,
213
  `catno` varchar(128) DEFAULT NULL,
214
  KEY `releaseLabelsId` (`id`),
215
  KEY `releaseLabelsLId` (`lid`),
216
  KEY `releaseLabelsCatno` (`catno`)
217
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
218
/*!40101 SET character_set_client = @saved_cs_client */;
219
 
220
--
221
-- Table structure for table `releaseTracks`
222
--
223
 
224
DROP TABLE IF EXISTS `releaseTracks`;
225
/*!40101 SET @saved_cs_client     = @@character_set_client */;
226
/*!40101 SET character_set_client = utf8 */;
227
CREATE TABLE `releaseTracks` (
228
  `id` int(10) unsigned NOT NULL,
229
  `track` blob,
230
  PRIMARY KEY (`id`)
231
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
232
/*!40101 SET character_set_client = @saved_cs_client */;
233
 
234
--
235
-- Table structure for table `releases`
236
--
237
 
238
DROP TABLE IF EXISTS `releases`;
239
/*!40101 SET @saved_cs_client     = @@character_set_client */;
240
/*!40101 SET character_set_client = utf8 */;
241
CREATE TABLE `releases` (
242
  `id` int(10) unsigned NOT NULL,
243
  `mid` int(10) unsigned DEFAULT NULL,
244
  `title` varchar(1024) DEFAULT NULL,
245
  `country` varchar(64) DEFAULT NULL,
246
  `released` year(4) DEFAULT NULL,
247
  `barcode` varchar(16) DEFAULT NULL,
248
  `quantity` tinyint(3) unsigned DEFAULT NULL,
249
  `format` varchar(24) DEFAULT NULL,
250
  `formatExt` varchar(2048) DEFAULT NULL,
251
  `formats` varchar(1024) DEFAULT NULL,
252
  `genres` varchar(1024) DEFAULT NULL,
253
  `styles` varchar(1024) DEFAULT NULL,
254
  PRIMARY KEY (`id`),
255
  KEY `releasesMId` (`mid`),
256
  KEY `releasesTitle` (`title`(255)),
257
  KEY `releasesBarcode` (`barcode`),
258
  KEY `releasesFormat` (`format`)
259
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
260
/*!40101 SET character_set_client = @saved_cs_client */;
261
 
262
--
14 - 263
-- Table structure for table `searches`
264
--
265
 
266
DROP TABLE IF EXISTS `searches`;
267
/*!40101 SET @saved_cs_client     = @@character_set_client */;
268
/*!40101 SET character_set_client = utf8 */;
269
CREATE TABLE `searches` (
270
  `id` bigint(14) NOT NULL AUTO_INCREMENT,
271
  `sessId` varchar(32) NOT NULL,
272
  `access` int(10) unsigned DEFAULT NULL,
273
  `country` char(2) NOT NULL DEFAULT 'US',
274
  `currency` char(3) NOT NULL DEFAULT 'USD',
275
  `zip` char(5) DEFAULT NULL,
276
  `condNew` char(1) DEFAULT 'Y',
277
  `condUsed` char(1) DEFAULT 'Y',
278
  `mediaCD` char(1) DEFAULT 'Y',
279
  `mediaRecord` char(1) DEFAULT 'N',
280
  `mediaDigital` char(1) DEFAULT 'N',
281
  `data` text,
282
  `lowNew` decimal(12,2) DEFAULT '0.00',
283
  `lowUsed` decimal(12,2) DEFAULT '0.00',
284
  `lowDigital` decimal(12,2) DEFAULT '0.00',
285
  `count` smallint(4) DEFAULT '0',
38 - 286
  `mediaBook` char(1) DEFAULT 'N',
287
  `lowBook` decimal(12,2) DEFAULT '0.00',
288
  `userId` int(11) DEFAULT NULL,
289
  PRIMARY KEY (`id`),
290
  KEY `userId` (`userId`)
291
) ENGINE=InnoDB AUTO_INCREMENT=1169 DEFAULT CHARSET=utf8;
14 - 292
/*!40101 SET character_set_client = @saved_cs_client */;
293
 
294
--
295
-- Table structure for table `sessions`
296
--
297
 
298
DROP TABLE IF EXISTS `sessions`;
299
/*!40101 SET @saved_cs_client     = @@character_set_client */;
300
/*!40101 SET character_set_client = utf8 */;
301
CREATE TABLE `sessions` (
302
  `id` varchar(32) NOT NULL,
303
  `tab` bigint(12) NOT NULL,
304
  `access` int(10) unsigned DEFAULT NULL,
305
  `data` mediumtext,
38 - 306
  `userId` int(11) DEFAULT NULL,
14 - 307
  PRIMARY KEY (`id`,`tab`)
308
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
309
/*!40101 SET character_set_client = @saved_cs_client */;
310
 
311
--
312
-- Table structure for table `transfers`
313
--
314
 
315
DROP TABLE IF EXISTS `transfers`;
316
/*!40101 SET @saved_cs_client     = @@character_set_client */;
317
/*!40101 SET character_set_client = utf8 */;
318
CREATE TABLE `transfers` (
319
  `id` bigint(14) NOT NULL AUTO_INCREMENT,
320
  `sessId` varchar(32) NOT NULL,
321
  `access` int(10) unsigned DEFAULT NULL,
322
  `url` text,
38 - 323
  `userId` int(11) DEFAULT NULL,
14 - 324
  PRIMARY KEY (`id`)
38 - 325
) ENGINE=InnoDB AUTO_INCREMENT=322 DEFAULT CHARSET=utf8;
14 - 326
/*!40101 SET character_set_client = @saved_cs_client */;
38 - 327
 
328
--
329
-- Table structure for table `users`
330
--
331
 
332
DROP TABLE IF EXISTS `users`;
333
/*!40101 SET @saved_cs_client     = @@character_set_client */;
334
/*!40101 SET character_set_client = utf8 */;
335
CREATE TABLE `users` (
336
  `id` int(11) NOT NULL AUTO_INCREMENT,
337
  `oauth_provider` enum('','facebook','google','twitter','linkedin') COLLATE utf8_unicode_ci NOT NULL,
338
  `oauth_uid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
339
  `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
340
  `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
341
  `email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
342
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
343
  `picture` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
344
  `zip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
345
  `username` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
346
  `link` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
347
  `activation_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
348
  `forgot_pass_identity` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
349
  `activated` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
350
  `created` datetime NOT NULL,
351
  `modified` datetime NOT NULL,
352
  `status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '1=Active | 0=Inactive',
353
  PRIMARY KEY (`id`),
354
  KEY `email` (`email`),
355
  KEY `forgot_pass_identity` (`forgot_pass_identity`),
356
  KEY `activation_code` (`activation_code`)
357
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
358
/*!40101 SET character_set_client = @saved_cs_client */;
14 - 359
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
360
 
361
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
362
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
363
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
364
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
365
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
366
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
367
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
368
 
38 - 369
-- Dump completed on 2019-06-23  8:08:32