Subversion Repositories cheapmusic

Rev

Rev 38 | Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
14 - 1
-- MySQL dump 10.13  Distrib 5.5.55, for Linux (x86_64)
2
--
3
-- Host: localhost    Database: cheapmusic
4
-- ------------------------------------------------------
5
-- Server version	5.5.55
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
--
19
-- Table structure for table `searches`
20
--
21
 
22
DROP TABLE IF EXISTS `searches`;
23
/*!40101 SET @saved_cs_client     = @@character_set_client */;
24
/*!40101 SET character_set_client = utf8 */;
25
CREATE TABLE `searches` (
26
  `id` bigint(14) NOT NULL AUTO_INCREMENT,
27
  `sessId` varchar(32) NOT NULL,
28
  `access` int(10) unsigned DEFAULT NULL,
29
  `country` char(2) NOT NULL DEFAULT 'US',
30
  `currency` char(3) NOT NULL DEFAULT 'USD',
31
  `zip` char(5) DEFAULT NULL,
32
  `condNew` char(1) DEFAULT 'Y',
33
  `condUsed` char(1) DEFAULT 'Y',
34
  `mediaCD` char(1) DEFAULT 'Y',
35
  `mediaRecord` char(1) DEFAULT 'N',
36
  `mediaDigital` char(1) DEFAULT 'N',
37
  `data` text,
38
  `lowNew` decimal(12,2) DEFAULT '0.00',
39
  `lowUsed` decimal(12,2) DEFAULT '0.00',
40
  `lowDigital` decimal(12,2) DEFAULT '0.00',
41
  `count` smallint(4) DEFAULT '0',
42
  PRIMARY KEY (`id`)
43
) ENGINE=InnoDB AUTO_INCREMENT=380 DEFAULT CHARSET=utf8;
44
/*!40101 SET character_set_client = @saved_cs_client */;
45
 
46
--
47
-- Table structure for table `sessions`
48
--
49
 
50
DROP TABLE IF EXISTS `sessions`;
51
/*!40101 SET @saved_cs_client     = @@character_set_client */;
52
/*!40101 SET character_set_client = utf8 */;
53
CREATE TABLE `sessions` (
54
  `id` varchar(32) NOT NULL,
55
  `tab` bigint(12) NOT NULL,
56
  `access` int(10) unsigned DEFAULT NULL,
57
  `data` mediumtext,
58
  PRIMARY KEY (`id`,`tab`)
59
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60
/*!40101 SET character_set_client = @saved_cs_client */;
61
 
62
--
63
-- Table structure for table `transfers`
64
--
65
 
66
DROP TABLE IF EXISTS `transfers`;
67
/*!40101 SET @saved_cs_client     = @@character_set_client */;
68
/*!40101 SET character_set_client = utf8 */;
69
CREATE TABLE `transfers` (
70
  `id` bigint(14) NOT NULL AUTO_INCREMENT,
71
  `sessId` varchar(32) NOT NULL,
72
  `access` int(10) unsigned DEFAULT NULL,
73
  `url` text,
74
  PRIMARY KEY (`id`)
75
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8;
76
/*!40101 SET character_set_client = @saved_cs_client */;
77
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
78
 
79
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
80
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
81
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
82
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
83
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
84
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
85
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
86
 
87
-- Dump completed on 2019-05-17  8:45:58