ddr7wBz7

1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version	5.1.32-community-log
5
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
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17--
18-- Create schema water_uwi
19--
20
21CREATE DATABASE IF NOT EXISTS water_uwi;
22USE water_uwi;
23
24--
25-- Temporary table structure for view `calctime`
26--
27DROP TABLE IF EXISTS `calctime`;
28DROP VIEW IF EXISTS `calctime`;
29CREATE TABLE `calctime` (
30  `delivery_id` int(11),
31  `LAST_DELIVERY` time,
32  `delivery_date` date,
33  `description` varchar(100)
34);
35
36--
37-- Temporary table structure for view `last_call_time`
38--
39DROP TABLE IF EXISTS `last_call_time`;
40DROP VIEW IF EXISTS `last_call_time`;
41CREATE TABLE `last_call_time` (
42  `call_id` int(11),
43  `description` varchar(100),
44  `call_date` datetime,
45  `notes` varchar(500),
46  `status` varchar(45)
47);
48
49--
50-- Temporary table structure for view `last_delivery`
51--
52DROP TABLE IF EXISTS `last_delivery`;
53DROP VIEW IF EXISTS `last_delivery`;
54CREATE TABLE `last_delivery` (
55  `delivery_id` int(11),
56  `delivery_date` date,
57  `driver_name` varchar(45),
58  `capacity` int(11),
59  `description` varchar(100),
60  `cap_measure` varchar(45)
61);
62
63--
64-- Temporary table structure for view `tank_cap`
65--
66DROP TABLE IF EXISTS `tank_cap`;
67DROP VIEW IF EXISTS `tank_cap`;
68CREATE TABLE `tank_cap` (
69  `tank_id` varchar(10),
70  `capacity` int(11),
71  `description` varchar(100),
72  `cap_measure` varchar(45)
73);
74
75--
76-- Temporary table structure for view `tank_list`
77--
78DROP TABLE IF EXISTS `tank_list`;
79DROP VIEW IF EXISTS `tank_list`;
80CREATE TABLE `tank_list` (
81  `location_code` varchar(45),
82  `description` varchar(100),
83  `capacity` int(11),
84  `cap_measure` varchar(45)
85);
86
87--
88-- Definition of table `cap_measure`
89--
90
91DROP TABLE IF EXISTS `cap_measure`;
92CREATE TABLE `cap_measure` (
93  `meter_id` int(11) NOT NULL AUTO_INCREMENT,
94  `cap_measure` varchar(45) NOT NULL,
95  PRIMARY KEY (`meter_id`)
96) ENGINE=MyISAM AUTO_INCREMENT=2324 DEFAULT CHARSET=latin1;
97
98--
99-- Dumping data for table `cap_measure`
100--
101
102/*!40000 ALTER TABLE `cap_measure` DISABLE KEYS */;
103/*!40000 ALTER TABLE `cap_measure` ENABLE KEYS */;
104
105
106--
107-- Definition of table `delivery`
108--
109
110DROP TABLE IF EXISTS `delivery`;
111CREATE TABLE `delivery` (
112  `delivery_id` int(11) NOT NULL AUTO_INCREMENT,
113  `delivery_date` date DEFAULT NULL,
114  `delivery_time` time DEFAULT NULL,
115  `truck_id` varchar(6) NOT NULL,
116  `location_id` int(11) NOT NULL,
117  `tank_id` varchar(10) NOT NULL,
118  PRIMARY KEY (`delivery_id`),
119  KEY `idtruck` (`truck_id`),
120  KEY `dev_loc` (`location_id`),
121  KEY `tank_d` (`tank_id`),
122  CONSTRAINT `idtruck` FOREIGN KEY (`truck_id`) REFERENCES `truck` (`truck_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
123  CONSTRAINT `dev_loc` FOREIGN KEY (`location_id`) REFERENCES `tank_location` (`tank_location_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
124  CONSTRAINT `tank_d` FOREIGN KEY (`tank_id`) REFERENCES `tank` (`tank_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
125) ENGINE=InnoDB DEFAULT CHARSET=latin1;
126
127--
128-- Dumping data for table `delivery`
129--
130
131/*!40000 ALTER TABLE `delivery` DISABLE KEYS */;
132/*!40000 ALTER TABLE `delivery` ENABLE KEYS */;
133
134
135--
136-- Definition of table `location`
137--
138
139DROP TABLE IF EXISTS `location`;
140CREATE TABLE `location` (
141  `location_id` int(11) NOT NULL AUTO_INCREMENT,
142  `location_code` varchar(45) NOT NULL,
143  PRIMARY KEY (`location_id`)
144) ENGINE=InnoDB DEFAULT CHARSET=latin1;
145
146--
147-- Dumping data for table `location`
148--
149
150/*!40000 ALTER TABLE `location` DISABLE KEYS */;
151/*!40000 ALTER TABLE `location` ENABLE KEYS */;
152
153
154--
155-- Definition of table `phone_call`
156--
157
158DROP TABLE IF EXISTS `phone_call`;
159CREATE TABLE `phone_call` (
160  `call_id` int(11) NOT NULL AUTO_INCREMENT,
161  `location_id` int(11) NOT NULL,
162  `call_date` datetime NOT NULL,
163  `status` int(11) DEFAULT NULL,
164  `notes` varchar(500) DEFAULT NULL,
165  PRIMARY KEY (`call_id`),
166  KEY `call_loc_id` (`location_id`),
167  KEY `stat` (`status`),
168  CONSTRAINT `call_loc_id` FOREIGN KEY (`location_id`) REFERENCES `tank_location` (`tank_location_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
169  CONSTRAINT `stat` FOREIGN KEY (`status`) REFERENCES `status` (`status_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
170) ENGINE=InnoDB DEFAULT CHARSET=latin1;
171
172--
173-- Dumping data for table `phone_call`
174--
175
176/*!40000 ALTER TABLE `phone_call` DISABLE KEYS */;
177/*!40000 ALTER TABLE `phone_call` ENABLE KEYS */;
178
179
180--
181-- Definition of table `status`
182--
183
184DROP TABLE IF EXISTS `status`;
185CREATE TABLE `status` (
186  `status_id` int(11) NOT NULL AUTO_INCREMENT,
187  `description` varchar(45) NOT NULL,
188  PRIMARY KEY (`status_id`)
189) ENGINE=InnoDB DEFAULT CHARSET=latin1;
190
191--
192-- Dumping data for table `status`
193--
194
195/*!40000 ALTER TABLE `status` DISABLE KEYS */;
196/*!40000 ALTER TABLE `status` ENABLE KEYS */;
197
198
199--
200-- Definition of table `tank`
201--
202
203DROP TABLE IF EXISTS `tank`;
204CREATE TABLE `tank` (
205  `tank_id` varchar(10) NOT NULL,
206  `location_id` int(11) NOT NULL,
207  `capacity` int(11) NOT NULL,
208  `capacity_measure` int(11) NOT NULL,
209  PRIMARY KEY (`tank_id`),
210  KEY `tank_loc_id` (`location_id`),
211  KEY `cap_m` (`capacity_measure`),
212  CONSTRAINT `tank_loc_id` FOREIGN KEY (`location_id`) REFERENCES `tank_location` (`tank_location_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
213  CONSTRAINT `cap_m` FOREIGN KEY (`capacity_measure`) REFERENCES `cap_measure` (`meter_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
214) ENGINE=InnoDB DEFAULT CHARSET=latin1;
215
216--
217-- Dumping data for table `tank`
218--
219
220/*!40000 ALTER TABLE `tank` DISABLE KEYS */;
221/*!40000 ALTER TABLE `tank` ENABLE KEYS */;
222
223
224--
225-- Definition of table `tank_location`
226--
227
228DROP TABLE IF EXISTS `tank_location`;
229CREATE TABLE `tank_location` (
230  `tank_location_id` int(11) NOT NULL AUTO_INCREMENT,
231  `location_id` int(11) NOT NULL,
232  `description` varchar(100) NOT NULL,
233  PRIMARY KEY (`tank_location_id`),
234  KEY `tank_loc` (`location_id`),
235  CONSTRAINT `tank_loc` FOREIGN KEY (`location_id`) REFERENCES `location` (`location_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
236) ENGINE=InnoDB DEFAULT CHARSET=latin1;
237
238--
239-- Dumping data for table `tank_location`
240--
241
242/*!40000 ALTER TABLE `tank_location` DISABLE KEYS */;
243/*!40000 ALTER TABLE `tank_location` ENABLE KEYS */;
244
245
246--
247-- Definition of table `truck`
248--
249
250DROP TABLE IF EXISTS `truck`;
251CREATE TABLE `truck` (
252  `truck_id` varchar(6) NOT NULL,
253  `driver_name` varchar(45) NOT NULL,
254  `capacity` int(11) NOT NULL,
255  `capacity_measure` int(11) NOT NULL,
256  PRIMARY KEY (`truck_id`),
257  KEY `cap_mm` (`capacity_measure`),
258  CONSTRAINT `cap_mm` FOREIGN KEY (`capacity_measure`) REFERENCES `cap_measure` (`meter_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
259) ENGINE=InnoDB DEFAULT CHARSET=latin1;
260
261--
262-- Dumping data for table `truck`
263--
264
265/*!40000 ALTER TABLE `truck` DISABLE KEYS */;
266/*!40000 ALTER TABLE `truck` ENABLE KEYS */;
267
268
269--
270-- Definition of table `user`
271--
272
273DROP TABLE IF EXISTS `user`;
274CREATE TABLE `user` (
275  `user_id` int(11) NOT NULL AUTO_INCREMENT,
276  `username` varchar(45) NOT NULL,
277  `user_pass` varchar(45) NOT NULL,
278  `user_type` int(11) NOT NULL,
279  PRIMARY KEY (`user_id`),
280  KEY `u_type` (`user_type`),
281  CONSTRAINT `u_type` FOREIGN KEY (`user_type`) REFERENCES `user_type` (`usertype_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
282) ENGINE=InnoDB DEFAULT CHARSET=latin1;
283
284--
285-- Dumping data for table `user`
286--
287
288/*!40000 ALTER TABLE `user` DISABLE KEYS */;
289/*!40000 ALTER TABLE `user` ENABLE KEYS */;
290
291
292--
293-- Definition of table `user_type`
294--
295
296DROP TABLE IF EXISTS `user_type`;
297CREATE TABLE `user_type` (
298  `usertype_id` int(11) NOT NULL,
299  `description` varchar(45) NOT NULL,
300  PRIMARY KEY (`usertype_id`)
301) ENGINE=InnoDB DEFAULT CHARSET=latin1;
302
303--
304-- Dumping data for table `user_type`
305--
306
307/*!40000 ALTER TABLE `user_type` DISABLE KEYS */;
308/*!40000 ALTER TABLE `user_type` ENABLE KEYS */;
309
310
311--
312-- Definition of procedure `get_cap_measure`
313--
314
315DROP PROCEDURE IF EXISTS `get_cap_measure`;
316
317DELIMITER $$
318
319/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
320CREATE DEFINER=`root`@`localhost` PROCEDURE `get_cap_measure`()
321BEGIN
322	SELECT * FROM cap_measure;
323END $$
324/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
325
326DELIMITER ;
327
328--
329-- Definition of procedure `get_delivery`
330--
331
332DROP PROCEDURE IF EXISTS `get_delivery`;
333
334DELIMITER $$
335
336/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
337CREATE DEFINER=`root`@`localhost` PROCEDURE `get_delivery`()
338BEGIN
339	SELECT * FROM delivery;
340END $$
341/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
342
343DELIMITER ;
344
345--
346-- Definition of procedure `get_pass`
347--
348
349DROP PROCEDURE IF EXISTS `get_pass`;
350
351DELIMITER $$
352
353/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
354CREATE DEFINER=`root`@`localhost` PROCEDURE `get_pass`(user_nm VARCHAR(50))
355BEGIN
356	SELECT user_pass FROM user WHERE username = user_um ;
357END $$
358/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
359
360DELIMITER ;
361
362--
363-- Definition of procedure `get_tank`
364--
365
366DROP PROCEDURE IF EXISTS `get_tank`;
367
368DELIMITER $$
369
370/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
371CREATE DEFINER=`root`@`localhost` PROCEDURE `get_tank`()
372BEGIN
373	SELECT * from tank;
374END $$
375/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
376
377DELIMITER ;
378
379--
380-- Definition of procedure `get_truck`
381--
382
383DROP PROCEDURE IF EXISTS `get_truck`;
384
385DELIMITER $$
386
387/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
388CREATE DEFINER=`root`@`localhost` PROCEDURE `get_truck`()
389BEGIN
390	SELECT * FROM truck;
391END $$
392/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
393
394DELIMITER ;
395
396--
397-- Definition of procedure `insert_delivery`
398--
399
400DROP PROCEDURE IF EXISTS `insert_delivery`;
401
402DELIMITER $$
403
404/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
405CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_delivery`(delivery_dt DATETIME, truck_num VARCHAR(6),loc_id INT,tank_num VARCHAR(6))
406BEGIN
407	INSERT INTO delivery (delivery_date,truck_id,location_id,tank_id) VALUES (delivery_dt,truck_num,loc_id,tank_num);
408END $$
409/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
410
411DELIMITER ;
412
413--
414-- Definition of procedure `insert_location`
415--
416
417DROP PROCEDURE IF EXISTS `insert_location`;
418
419DELIMITER $$
420
421/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
422CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_location`(loc_code VARCHAR(50))
423BEGIN
424	INSERT INTO location (location_code) VALUES (loc_code);
425END $$
426/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
427
428DELIMITER ;
429
430--
431-- Definition of procedure `insert_phone_call`
432--
433
434DROP PROCEDURE IF EXISTS `insert_phone_call`;
435
436DELIMITER $$
437
438/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
439CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_phone_call`(loc_id INT,call_dt DATETIME, stat INT, nt VARCHAR(500))
440BEGIN
441	INSERT INTO phone_call(location_id,call_date,status,notes) VALUES (loc_id,call_dt,stat,nt);
442END $$
443/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
444
445DELIMITER ;
446
447--
448-- Definition of procedure `insert_tank`
449--
450
451DROP PROCEDURE IF EXISTS `insert_tank`;
452
453DELIMITER $$
454
455/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
456CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_tank`(tank_num VARCHAR(10), loc_id INT, cap INT, cap_meter VARCHAR(45))
457BEGIN
458    INSERT INTO tank (tank_id,location_id,capacity,capacity_measure) VALUES (tank_num,loc_id,cap,cap_meter);
459END $$
460/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
461
462DELIMITER ;
463
464--
465-- Definition of procedure `insert_tank_location`
466--
467
468DROP PROCEDURE IF EXISTS `insert_tank_location`;
469
470DELIMITER $$
471
472/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
473CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_tank_location`(loc_id INT, descript VARCHAR(100))
474BEGIN
475	INSERT INTO tank_location (location_id,description) VALUES (loc_id,descript);
476END $$
477/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
478
479DELIMITER ;
480
481--
482-- Definition of procedure `insert_truck`
483--
484
485DROP PROCEDURE IF EXISTS `insert_truck`;
486
487DELIMITER $$
488
489/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
490CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_truck`(truck_license VARCHAR(6), driver_nm VARCHAR(50), cap INT, cap_meter VARCHAR(45))
491BEGIN
492    INSERT INTO truck (truck_id,driver_name,capacity,capacity_measure) VALUES (truck_license,driver_nm,cap,cap_meter);
493END $$
494/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
495
496DELIMITER ;
497
498--
499-- Definition of procedure `insert_user`
500--
501
502DROP PROCEDURE IF EXISTS `insert_user`;
503
504DELIMITER $$
505
506/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
507CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_user`(user_nm VARCHAR(50),user_ps VARCHAR(50), user_t INT)
508BEGIN
509	INSERT INTO user(username,user_pass,user_type) VALUES (user_nm,user_ps,user_t);
510END $$
511/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
512
513DELIMITER ;
514
515--
516-- Definition of procedure `query_location`
517--
518
519DROP PROCEDURE IF EXISTS `query_location`;
520
521DELIMITER $$
522
523/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
524CREATE DEFINER=`root`@`localhost` PROCEDURE `query_location`()
525BEGIN
526	SELECT * from location;
527END $$
528/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
529
530DELIMITER ;
531
532--
533-- Definition of procedure `validate_user`
534--
535
536DROP PROCEDURE IF EXISTS `validate_user`;
537
538DELIMITER $$
539
540/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
541CREATE DEFINER=`root`@`localhost` PROCEDURE `validate_user`(user_nm VARCHAR(50),user_ps VARCHAR(50), user_t INT)
542BEGIN
543	SELECT user_type FROM user WHERE username = um AND user_pass = user_ps;
544END $$
545/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$
546
547DELIMITER ;
548
549--
550-- Definition of view `calctime`
551--
552
553DROP TABLE IF EXISTS `calctime`;
554DROP VIEW IF EXISTS `calctime`;
555CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `calctime` AS select `delivery`.`delivery_id` AS `delivery_id`,timediff(now(),`delivery`.`delivery_date`) AS `LAST_DELIVERY`,`delivery`.`delivery_date` AS `delivery_date`,`tank_location`.`description` AS `description` from (`delivery` join `tank_location` on((`tank_location`.`tank_location_id` = `delivery`.`location_id`)));
556
557--
558-- Definition of view `last_call_time`
559--
560
561DROP TABLE IF EXISTS `last_call_time`;
562DROP VIEW IF EXISTS `last_call_time`;
563CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `last_call_time` AS select `phone_call`.`call_id` AS `call_id`,`tank_location`.`description` AS `description`,`phone_call`.`call_date` AS `call_date`,`phone_call`.`notes` AS `notes`,`status`.`description` AS `status` from ((`phone_call` join `tank_location` on((`tank_location`.`tank_location_id` = `phone_call`.`location_id`))) join `status` on((`status`.`status_id` = `phone_call`.`status`)));
564
565--
566-- Definition of view `last_delivery`
567--
568
569DROP TABLE IF EXISTS `last_delivery`;
570DROP VIEW IF EXISTS `last_delivery`;
571CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `last_delivery` AS select `delivery`.`delivery_id` AS `delivery_id`,`delivery`.`delivery_date` AS `delivery_date`,`truck`.`driver_name` AS `driver_name`,`truck`.`capacity` AS `capacity`,`tank_location`.`description` AS `description`,`cap_measure`.`cap_measure` AS `cap_measure` from (((`delivery` join `truck` on((`truck`.`truck_id` = `delivery`.`truck_id`))) join `tank_location` on((`tank_location`.`tank_location_id` = `delivery`.`location_id`))) join `cap_measure` on((`cap_measure`.`meter_id` = `truck`.`capacity_measure`)));
572
573--
574-- Definition of view `tank_cap`
575--
576
577DROP TABLE IF EXISTS `tank_cap`;
578DROP VIEW IF EXISTS `tank_cap`;
579CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tank_cap` AS select `tank`.`tank_id` AS `tank_id`,`tank`.`capacity` AS `capacity`,`tank_location`.`description` AS `description`,`cap_measure`.`cap_measure` AS `cap_measure` from ((`tank` join `tank_location` on((`tank_location`.`tank_location_id` = `tank`.`location_id`))) join `cap_measure` on((`cap_measure`.`meter_id` = `tank`.`capacity_measure`)));
580
581--
582-- Definition of view `tank_list`
583--
584
585DROP TABLE IF EXISTS `tank_list`;
586DROP VIEW IF EXISTS `tank_list`;
587CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tank_list` AS select `location`.`location_code` AS `location_code`,`tank_location`.`description` AS `description`,`tank`.`capacity` AS `capacity`,`cap_measure`.`cap_measure` AS `cap_measure` from (((`tank_location` join `tank` on((`tank_location`.`tank_location_id` = `tank`.`location_id`))) join `location` on((`location`.`location_id` = `tank_location`.`location_id`))) join `cap_measure` on((`cap_measure`.`meter_id` = `tank`.`capacity_measure`)));
588
589
590
591/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
592/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
593/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
594/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
595/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
596/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
597/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;