3tTS7hKT

1-- phpMyAdmin SQL Dump
2-- version 4.5.4.1deb2ubuntu2.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Nov 24, 2019 at 03:10 PM
7-- Server version: 5.7.28-0ubuntu0.16.04.2
8-- PHP Version: 7.0.33-0ubuntu0.16.04.7
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `Measles`
21--
22CREATE DATABASE IF NOT EXISTS `Measles` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
23USE `Measles`;
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `DATA`
29--
30
31DROP TABLE IF EXISTS `DATA`;
32CREATE TABLE IF NOT EXISTS `DATA` (
33  `ConditionName` varchar(255) DEFAULT NULL,
34  `ConditionSNOMED` int(255) DEFAULT NULL,
35  `PathogenName` varchar(255) DEFAULT NULL,
36  `PathogenTaxonID` varchar(255) DEFAULT NULL,
37  `Fatalities` int(255) DEFAULT NULL,
38  `CountryName` varchar(255) DEFAULT NULL,
39  `CountryISO` varchar(255) DEFAULT NULL,
40  `Admin1Name` varchar(255) DEFAULT NULL,
41  `Admin1ISO` varchar(255) DEFAULT NULL,
42  `Admin2Name` varchar(255) DEFAULT NULL,
43  `CityName` varchar(255) DEFAULT NULL,
44  `PeriodStartDay` int(255) DEFAULT NULL,
45  `PeriodStartMonth` int(255) DEFAULT NULL,
46  `PeriodStartYear` int(255) DEFAULT NULL,
47  `PeriodEndDay` int(255) DEFAULT NULL,
48  `PeriodEndMonth` int(255) DEFAULT NULL,
49  `PeriodEndYear` int(255) DEFAULT NULL,
50  `PartOfCumulativeCountSeries` tinyint(1) DEFAULT NULL,
51  `AgeRange` varchar(255) DEFAULT NULL,
52  `Subpopulation` varchar(255) DEFAULT NULL,
53  `PlaceOfAcquisition` varchar(255) DEFAULT NULL,
54  `DiagnosisCertainty` varchar(255) DEFAULT NULL,
55  `SourceName` varchar(255) DEFAULT NULL,
56  `CountValue` varchar(255) DEFAULT NULL
57) ENGINE=InnoDB DEFAULT CHARSET=utf8;
58
59-- --------------------------------------------------------
60
61--
62-- Table structure for table `Events`
63--
64
65DROP TABLE IF EXISTS `Events`;
66CREATE TABLE IF NOT EXISTS `Events` (
67  `LocationId` int(255) NOT NULL,
68  `TimeId` int(255) NOT NULL,
69  `ConditionSNOMED` int(255) NOT NULL,
70  `PlaceOfAquisition` varchar(255) NOT NULL,
71  `Faitalities` int(255) NOT NULL,
72  `PartOfCumulativeSeries` tinyint(1) NOT NULL,
73  `CountValue` int(255) NOT NULL
74) ENGINE=InnoDB DEFAULT CHARSET=utf8;
75
76-- --------------------------------------------------------
77
78--
79-- Table structure for table `Location`
80--
81
82DROP TABLE IF EXISTS `Location`;
83CREATE TABLE IF NOT EXISTS `Location` (
84  `Lid` int(255) NOT NULL AUTO_INCREMENT,
85  `CountryName` varchar(255) NOT NULL,
86  `CountryISO` varchar(255) NOT NULL,
87  `Admin1Name` varchar(255) NOT NULL,
88  `Admin1ISO` varchar(255) NOT NULL,
89  `Admin2Name` varchar(255) NOT NULL,
90  `CityName` varchar(255) NOT NULL,
91  PRIMARY KEY (`Lid`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8;
93
94-- --------------------------------------------------------
95
96--
97-- Table structure for table `Sickness`
98--
99
100DROP TABLE IF EXISTS `Sickness`;
101CREATE TABLE IF NOT EXISTS `Sickness` (
102  `ConditionName` varchar(255) NOT NULL,
103  `ConditionSNOMED` varchar(255) NOT NULL,
104  `PathogenName` varchar(255) NOT NULL,
105  `PathogenTaxonID` varchar(255) NOT NULL,
106  PRIMARY KEY (`ConditionSNOMED`)
107) ENGINE=InnoDB DEFAULT CHARSET=utf8;
108
109-- --------------------------------------------------------
110
111--
112-- Table structure for table `TimePeriod`
113--
114
115DROP TABLE IF EXISTS `TimePeriod`;
116CREATE TABLE IF NOT EXISTS `TimePeriod` (
117  `TimeId` int(255) NOT NULL AUTO_INCREMENT,
118  `PeriodStartDay` int(255) NOT NULL,
119  `PeriodStartMonth` int(255) NOT NULL,
120  `PeriodStartYear` int(255) NOT NULL,
121  `PeriodEndDay` int(255) NOT NULL,
122  `PeriodEndMonth` int(255) NOT NULL,
123  `PeriodEndYear` int(255) NOT NULL,
124  PRIMARY KEY (`TimeId`)
125) ENGINE=InnoDB DEFAULT CHARSET=utf8;
126
127/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
128/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
129/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;