1 | SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |
---|
2 | SET AUTOCOMMIT = 0; |
---|
3 | START TRANSACTION; |
---|
4 | SET time_zone = "+00:00"; |
---|
5 | |
---|
6 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
---|
7 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
---|
8 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
---|
9 | /*!40101 SET NAMES utf8 */; |
---|
10 | |
---|
11 | CREATE DATABASE IF NOT EXISTS `analytics` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; |
---|
12 | USE `analytics`; |
---|
13 | |
---|
14 | CREATE TABLE IF NOT EXISTS `alias` ( |
---|
15 | `name` varchar(50) NOT NULL, |
---|
16 | `alias` varchar(50) DEFAULT NULL, |
---|
17 | PRIMARY KEY (`name`) |
---|
18 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
19 | |
---|
20 | CREATE TABLE IF NOT EXISTS `clients` ( |
---|
21 | `id` int(10) NOT NULL AUTO_INCREMENT, |
---|
22 | `user` varchar(18) NOT NULL, |
---|
23 | `lastlogin` datetime NOT NULL, |
---|
24 | `version` char(20) NOT NULL, |
---|
25 | `sabor` char(50) NOT NULL, |
---|
26 | PRIMARY KEY (`id`), |
---|
27 | UNIQUE KEY `user_2` (`user`,`version`,`sabor`) |
---|
28 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
29 | |
---|
30 | CREATE TABLE IF NOT EXISTS `historico` ( |
---|
31 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
32 | `app` varchar(150) NOT NULL, |
---|
33 | `count` int(11) NOT NULL, |
---|
34 | `fecha` date NOT NULL, |
---|
35 | `version` char(20) NOT NULL, |
---|
36 | `sabor` char(50) NOT NULL, |
---|
37 | PRIMARY KEY (`id`), |
---|
38 | KEY `fecha` (`fecha`), |
---|
39 | KEY `version_sabor` (`version`,`sabor`), |
---|
40 | KEY `app` (`app`), |
---|
41 | KEY `sabor` (`sabor`), |
---|
42 | KEY `version` (`version`), |
---|
43 | KEY `app_count` (`app`,`count`) |
---|
44 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
45 | |
---|
46 | CREATE TABLE IF NOT EXISTS `historico_clients` ( |
---|
47 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
48 | `version` char(20) NOT NULL, |
---|
49 | `sabor` char(50) NOT NULL, |
---|
50 | `fecha` date NOT NULL, |
---|
51 | `nclients` int(11) NOT NULL, |
---|
52 | PRIMARY KEY (`id`) |
---|
53 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
54 | |
---|
55 | CREATE TABLE IF NOT EXISTS `packages` ( |
---|
56 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
57 | `app` varchar(150) NOT NULL, |
---|
58 | `count` int(10) NOT NULL, |
---|
59 | `version` char(20) NOT NULL, |
---|
60 | `sabor` char(50) NOT NULL, |
---|
61 | PRIMARY KEY (`id`), |
---|
62 | KEY `app` (`app`), |
---|
63 | KEY `version_sabor` (`version`,`sabor`), |
---|
64 | KEY `sabor` (`sabor`), |
---|
65 | KEY `version` (`version`), |
---|
66 | KEY `app_count` (`app`,`count`), |
---|
67 | KEY `app_version_sabor` (`app`,`version`,`sabor`) |
---|
68 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
69 | COMMIT; |
---|
70 | |
---|
71 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
---|
72 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
---|
73 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
---|