GetBox-App/getboxapp.sql at master · abmiguez/GetBox-App · GitHub

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
DROP TABLE IF EXISTS `BOXTOKENS`;
DROP TABLE IF EXISTS `DROPBOXTOKENS`;
DROP TABLE IF EXISTS `USERS`;

--
-- Estructura de tabla para la tabla `BOXTOKENS`
--

CREATE TABLE IF NOT EXISTS `BOXTOKENS` (
  `ID` int(100) NOT NULL AUTO_INCREMENT,
  `ACCESSTOKEN` varchar(120) COLLATE latin1_spanish_ci NOT NULL,
  `REFRESHTOKEN` varchar(120) COLLATE latin1_spanish_ci NOT NULL,
  `USERNAME` varchar(30) COLLATE latin1_spanish_ci NOT NULL,
  `SPACE` bigint(100) NOT NULL,
  `USERID` varchar(20) COLLATE latin1_spanish_ci NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `USERID` (`USERID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `DROPBOXTOKENS`
--

CREATE TABLE IF NOT EXISTS `DROPBOXTOKENS` (
  `ID` int(100) NOT NULL AUTO_INCREMENT,
  `TOKENKEY` varchar(120) COLLATE latin1_spanish_ci NOT NULL,
  `TOKENSECRET` varchar(120) COLLATE latin1_spanish_ci NOT NULL,
  `USERNAME` varchar(30) COLLATE latin1_spanish_ci NOT NULL,
  `SPACE` bigint(100) NOT NULL,
  `USERID` varchar(20) COLLATE latin1_spanish_ci NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `USERID` (`USERID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `USERS`
--

CREATE TABLE IF NOT EXISTS `USERS` (
  `NAME` varchar(60) COLLATE latin1_spanish_ci NOT NULL,
  `MAIL` varchar(60) COLLATE latin1_spanish_ci NOT NULL,
  `USERNAME` varchar(20) COLLATE latin1_spanish_ci NOT NULL,
  `PASSWORD` varchar(120) COLLATE latin1_spanish_ci NOT NULL,
  `DEL` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`USERNAME`),
  UNIQUE KEY `MAIL` (`MAIL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;