jaCYmVfQ

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 07, 2019 at 07:40 AM
7-- Server version: 5.7.19-log
8-- PHP Version: 5.6.3
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 utf8 */;
18
19--
20-- Database: `microwave_communication_systems`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `path_end_point_info`
27--
28
29CREATE TABLE IF NOT EXISTS `path_end_point_info` (
30`id` int(11) NOT NULL,
31  `path_wide_id` int(11) DEFAULT NULL,
32  `dis_from_str` float DEFAULT NULL,
33  `ground_height` float DEFAULT NULL,
34  `antenna_height` float DEFAULT NULL
35) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
36
37--
38-- Dumping data for table `path_end_point_info`
39--
40
41INSERT INTO `path_end_point_info` (`id`, `path_wide_id`, `dis_from_str`, `ground_height`, `antenna_height`) VALUES
42(32, 22, 0, 50, 40),
43(33, 22, 15, 75, 20),
44(40, 26, 0, 50, 40),
45(41, 26, 45, 75, 20);
46
47-- --------------------------------------------------------
48
49--
50-- Table structure for table `path_mid_points`
51--
52
53CREATE TABLE IF NOT EXISTS `path_mid_points` (
54`id` int(11) NOT NULL,
55  `path_id` int(11) DEFAULT NULL,
56  `dst_frm_str` float DEFAULT NULL,
57  `ground_height` float DEFAULT NULL,
58  `terrain_type` varchar(50) DEFAULT NULL,
59  `obstruction_height` float DEFAULT NULL,
60  `obstruction_type` varchar(50) DEFAULT NULL
61) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8;
62
63--
64-- Dumping data for table `path_mid_points`
65--
66
67INSERT INTO `path_mid_points` (`id`, `path_id`, `dst_frm_str`, `ground_height`, `terrain_type`, `obstruction_height`, `obstruction_type`) VALUES
68(127, 22, 1, 50, 'Grassland', 10, 'Trees'),
69(128, 22, 2, 45, 'Grassland', 1, 'Brush'),
70(129, 22, 3, 48, 'Rough rock', 0, 'None'),
71(130, 22, 4, 52, 'Rough rock', 0, 'None'),
72(131, 22, 5, 60, 'Smooth rock', 0, 'None'),
73(132, 22, 6, 61, 'Grassland', 20, 'Trees'),
74(133, 22, 7, 60, 'Lake', 0, 'None'),
75(134, 22, 8, 60, 'Lake', 0, 'None'),
76(135, 22, 9, 60, 'Lake', 0, 'None'),
77(136, 22, 10, 61, 'Rough rock', 5, 'Building'),
78(137, 22, 11, 70, 'Bare soil', 2, 'Trees'),
79(138, 22, 12, 53, 'Grassland', 10, 'Trees'),
80(139, 22, 13, 66, 'Grassland', 20, 'Trees'),
81(140, 22, 14, 80, 'Grassland', 3, 'Trees'),
82(183, 26, 3, 50, 'Grassland', 10, 'Trees'),
83(184, 26, 6, 45, 'Grasslan', 1, 'Brush '),
84(185, 26, 10, 48, 'Rough rock', 0, 'None '),
85(186, 26, 12, 52, 'Rough rock', 0, 'None'),
86(187, 26, 15, 60, 'Smooth rock', 0, 'None'),
87(188, 26, 18, 61, 'Grassland', 20, 'Trees'),
88(189, 26, 21, 60, 'Lake', 0, 'None'),
89(190, 26, 24, 60, 'Lake', 0, 'None'),
90(191, 26, 27, 60, 'Lake', 0, 'None'),
91(192, 26, 30, 61, 'Rough rock', 5, 'Building'),
92(193, 26, 33, 70, 'Bare soil', 2, 'Trees'),
93(194, 26, 36, 53, 'Grassland', 10, 'Trees'),
94(195, 26, 39, 66, 'Grassland', 20, 'Trees'),
95(196, 26, 42, 80, 'Grassland', 3, 'Trees');
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `path_wide_information`
101--
102
103CREATE TABLE IF NOT EXISTS `path_wide_information` (
104`id` int(11) NOT NULL,
105  `path_name` varchar(100) DEFAULT NULL,
106  `path_length` float DEFAULT NULL,
107  `note` mediumtext,
108  `file_path` varchar(45) DEFAULT NULL
109) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='						';
110
111--
112-- Dumping data for table `path_wide_information`
113--
114
115INSERT INTO `path_wide_information` (`id`, `path_name`, `path_length`, `note`, `file_path`) VALUES
116(22, 'Pah 02', 13, 'Demonstration path,A note about path 2, the first demo path   ', 'upload/perm/path02.csv'),
117(26, 'Pah 03', 13, 'Demonstration path,A note about path 3, the first demo path', 'upload/perm/path03.csv');
118
119--
120-- Indexes for dumped tables
121--
122
123--
124-- Indexes for table `path_end_point_info`
125--
126ALTER TABLE `path_end_point_info`
127 ADD PRIMARY KEY (`id`), ADD KEY `path_wide_id_idx` (`path_wide_id`);
128
129--
130-- Indexes for table `path_mid_points`
131--
132ALTER TABLE `path_mid_points`
133 ADD PRIMARY KEY (`id`), ADD KEY `path_id_idx` (`path_id`);
134
135--
136-- Indexes for table `path_wide_information`
137--
138ALTER TABLE `path_wide_information`
139 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `path_name_UNIQUE` (`path_name`);
140
141--
142-- AUTO_INCREMENT for dumped tables
143--
144
145--
146-- AUTO_INCREMENT for table `path_end_point_info`
147--
148ALTER TABLE `path_end_point_info`
149MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=42;
150--
151-- AUTO_INCREMENT for table `path_mid_points`
152--
153ALTER TABLE `path_mid_points`
154MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=197;
155--
156-- AUTO_INCREMENT for table `path_wide_information`
157--
158ALTER TABLE `path_wide_information`
159MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
160--
161-- Constraints for dumped tables
162--
163
164--
165-- Constraints for table `path_end_point_info`
166--
167ALTER TABLE `path_end_point_info`
168ADD CONSTRAINT `path_wide_id` FOREIGN KEY (`path_wide_id`) REFERENCES `path_wide_information` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
169
170--
171-- Constraints for table `path_mid_points`
172--
173ALTER TABLE `path_mid_points`
174ADD CONSTRAINT `path_id` FOREIGN KEY (`path_id`) REFERENCES `path_wide_information` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
175
176/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
177/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
178/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;