· 10 years ago · Sep 23, 2016, 05:02 AM
1-- MySQL dump 10.16 Distrib 10.1.17-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: analytics_prime
4-- ------------------------------------------------------
5-- Server version 10.1.17-MariaDB
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 `cell_locations`
20--
21
22DROP TABLE IF EXISTS `cell_locations`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `cell_locations` (
26 `site_id` varchar(20) DEFAULT NULL,
27 `cell_name` varchar(80) DEFAULT NULL,
28 `lac` varchar(20) DEFAULT NULL,
29 `cell_id` varchar(20) DEFAULT NULL,
30 `longitude` varchar(20) DEFAULT NULL,
31 `latitude` varchar(20) DEFAULT NULL,
32 `loc_id` varchar(10) DEFAULT NULL,
33 UNIQUE KEY `cell` (`lac`,`cell_id`)
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Table structure for table `cell_util_peak`
39--
40
41DROP TABLE IF EXISTS `cell_util_peak`;
42/*!40101 SET @saved_cs_client = @@character_set_client */;
43/*!40101 SET character_set_client = utf8 */;
44CREATE TABLE `cell_util_peak` (
45 `acquisition_date` date NOT NULL,
46 `loc_id` varchar(6) DEFAULT NULL,
47 `sector` varchar(2) NOT NULL,
48 `power_util_w` float DEFAULT NULL,
49 `acq_date_no` int(5) DEFAULT NULL,
50 `peak_time` time DEFAULT NULL,
51 `power_util_dbm` float DEFAULT NULL,
52 `power_util` float DEFAULT NULL,
53 KEY `aquisition_date_i` (`acquisition_date`),
54 KEY `loc_id_i` (`loc_id`),
55 KEY `sector_i` (`sector`),
56 KEY `acquisition_date_loc_id_i` (`acquisition_date`,`loc_id`),
57 KEY `acquisition_date_loc_i_sector_i` (`acquisition_date`,`loc_id`,`sector`),
58 KEY `loc_i_sector_i` (`loc_id`,`sector`),
59 KEY `acq_date_no_i` (`acq_date_no`),
60 KEY `acquisition_date_i` (`acquisition_date`)
61) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Table structure for table `nodeb_config`
66--
67
68DROP TABLE IF EXISTS `nodeb_config`;
69/*!40101 SET @saved_cs_client = @@character_set_client */;
70/*!40101 SET character_set_client = utf8 */;
71CREATE TABLE `nodeb_config` (
72 `loc_id` varchar(10) DEFAULT NULL,
73 `sector` varchar(10) DEFAULT NULL,
74 `max_cell_power_dbm` float DEFAULT NULL,
75 `vendor` varchar(10) DEFAULT NULL,
76 `max_cell_power_w` float DEFAULT NULL,
77 `max_cell_power_dbmx10` float DEFAULT NULL,
78 UNIQUE KEY `loc_id` (`loc_id`,`sector`,`max_cell_power_dbm`),
79 UNIQUE KEY `loc_id_2` (`loc_id`,`sector`,`max_cell_power_dbm`),
80 UNIQUE KEY `loc_id_3` (`loc_id`,`sector`,`max_cell_power_dbm`),
81 UNIQUE KEY `loc_id_4` (`loc_id`,`sector`,`max_cell_power_dbm`),
82 UNIQUE KEY `loc_id_5` (`loc_id`,`sector`,`max_cell_power_dbm`),
83 UNIQUE KEY `loc_id_6` (`loc_id`,`sector`,`max_cell_power_dbm`),
84 UNIQUE KEY `loc_id_7` (`loc_id`,`sector`,`max_cell_power_dbm`),
85 UNIQUE KEY `loc_id_8` (`loc_id`,`sector`),
86 UNIQUE KEY `loc_id_9` (`loc_id`,`sector`),
87 UNIQUE KEY `loc_id_10` (`loc_id`,`sector`),
88 UNIQUE KEY `loc_id_11` (`loc_id`,`sector`),
89 UNIQUE KEY `loc_id_12` (`loc_id`,`sector`),
90 KEY `loc_id_i` (`loc_id`),
91 KEY `sector_i` (`sector`),
92 KEY `loc_id_sector_i` (`loc_id`,`sector`)
93) ENGINE=InnoDB DEFAULT CHARSET=latin1;
94/*!40101 SET character_set_client = @saved_cs_client */;
95
96--
97-- Table structure for table `nodeb_directory`
98--
99
100DROP TABLE IF EXISTS `nodeb_directory`;
101/*!40101 SET @saved_cs_client = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `nodeb_directory` (
104 `nodeb_name` varchar(200) NOT NULL,
105 `loc_id` varchar(6) NOT NULL,
106 `lat` float DEFAULT NULL,
107 `lon` float DEFAULT NULL,
108 `sectors` varchar(200) DEFAULT NULL,
109 KEY `nodeb_name_i` (`nodeb_name`),
110 KEY `loc_id_i` (`loc_id`),
111 KEY `sectors_i` (`sectors`),
112 KEY `nodeb_name_loc_id_i` (`nodeb_name`,`loc_id`)
113) ENGINE=InnoDB DEFAULT CHARSET=latin1;
114/*!40101 SET character_set_client = @saved_cs_client */;
115
116--
117-- Table structure for table `pred_dict`
118--
119
120DROP TABLE IF EXISTS `pred_dict`;
121/*!40101 SET @saved_cs_client = @@character_set_client */;
122/*!40101 SET character_set_client = utf8 */;
123CREATE TABLE `pred_dict` (
124 `loc_id` varchar(7) DEFAULT NULL,
125 `sector` varchar(7) DEFAULT NULL,
126 `sim_date` date DEFAULT NULL,
127 `ldad` date DEFAULT NULL,
128 `grad` float DEFAULT NULL,
129 `inter` float DEFAULT NULL,
130 `r_value` float DEFAULT NULL,
131 `p_value` float DEFAULT NULL,
132 `std_err` float DEFAULT NULL,
133 `100_inter` float DEFAULT NULL,
134 `upgrade_date` varchar(10) DEFAULT NULL,
135 `upgrade_date_no` varchar(10) DEFAULT NULL,
136 `ldad_no` int(10) DEFAULT NULL,
137 `drop_margin` float DEFAULT NULL,
138 KEY `ldad_i` (`ldad`),
139 KEY `ldad_no_i` (`ldad_no`)
140) ENGINE=MyISAM DEFAULT CHARSET=latin1;
141/*!40101 SET character_set_client = @saved_cs_client */;
142
143--
144-- Table structure for table `upgraded_nodeb`
145--
146
147DROP TABLE IF EXISTS `upgraded_nodeb`;
148/*!40101 SET @saved_cs_client = @@character_set_client */;
149/*!40101 SET character_set_client = utf8 */;
150CREATE TABLE `upgraded_nodeb` (
151 `loc_id` varchar(10) DEFAULT NULL,
152 `sector` varchar(2) DEFAULT NULL,
153 `upgrade_date` date DEFAULT NULL,
154 `details` varchar(300) DEFAULT NULL
155) ENGINE=InnoDB DEFAULT CHARSET=latin1;
156/*!40101 SET character_set_client = @saved_cs_client */;
157/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
158
159/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
160/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
161/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
162/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
163/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
164/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
165/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
166
167-- Dump completed on 2016-09-23 10:26:42