· 4 years ago · Feb 22, 2021, 02:22 PM
1-- --------------------------------------------------------
2-- Host: 10.0.0.209
3-- Server version: 5.7.26-enterprise-commercial-advanced - MySQL Enterprise Server - Advanced Edition (Commercial)
4-- Server OS: Win32
5-- HeidiSQL Version: 11.1.0.6116
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
14
15
16-- Dumping database structure for piscada_cameras
17CREATE DATABASE IF NOT EXISTS `piscada_cameras` /*!40100 DEFAULT CHARACTER SET latin1 */;
18USE `piscada_cameras`;
19
20-- Dumping structure for table piscada_cameras.sites
21CREATE TABLE IF NOT EXISTS `sites` (
22 `id` int(10) NOT NULL AUTO_INCREMENT,
23 `name` varchar(128) NOT NULL DEFAULT '',
24 `timestamp` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
25 `cameraSetup` mediumtext,
26 `siteSettings` mediumtext,
27 `cameraGroups` mediumtext,
28 `uuid` varchar(48) NOT NULL DEFAULT '',
29 PRIMARY KEY (`id`)
30) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
31
32-- Dumping data for table piscada_cameras.sites: 1 rows
33/*!40000 ALTER TABLE `sites` DISABLE KEYS */;
34REPLACE INTO `sites` (`id`, `name`, `timestamp`, `cameraSetup`, `siteSettings`, `cameraGroups`, `uuid`) VALUES
35 (27, 'Dale', '2021-02-17 22:46:57.650', '[{"PTZ_type":"scaleaqvisual","description":"","externalID":"1","id":"DA-01","legacyPelcoCamera":true,"pelcoID":1,"pelcoPort":"4001","popupLayout":"STD","speed":"25","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.10","winchPulse":"default"},{"PTZ_type":"scaleaqvisual","description":"","externalID":"2","id":"DA-02","legacyPelcoCamera":true,"pelcoID":2,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.20"},{"PTZ_type":"scaleaqvisual","description":"","externalID":"3","id":"DA-03","legacyPelcoCamera":true,"pelcoID":3,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.30"},{"PTZ_type":"pelco_sv","description":"","id":"DA-04","legacyPelcoCamera":true,"pelcoID":1,"pelcoPort":"4001","popupLayout":"","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.40"},{"PTZ_type":"pelco_sv","description":"","id":"DA-05","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.50"},{"PTZ_type":"pelco_sv","description":"","id":"DA-06","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.60"},{"PTZ_type":"pelco_sv","description":"","id":"DA-07","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.70"},{"PTZ_type":"pelco_sv","description":"","id":"DA-08","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.80"},{"PTZ_type":"pelco_sv","description":"","id":"DA-09","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.90"},{"PTZ_type":"pelco_sv","description":"","id":"DA-10","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.100"},{"PTZ_type":"pelco_sv","description":"","id":"DA-11","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.110"},{"PTZ_type":"pelco_sv","description":"","id":"DA-12","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD","type":"subSurface","unrealHost":"172.29.91.92","url":"10.10.2.120"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-01","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.11"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-02","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.21"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-03","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.31"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-04","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.41"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-05","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.51"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-06","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.61"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-07","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.71"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-08","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.81"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-09","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.91"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-10","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.101"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-11","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.111"},{"PTZ_type":"pelco_sv","description":"","id":"DA-S-12","pelcoID":1,"pelcoPort":"4001","popupLayout":"STD-S","type":"surface","unrealHost":"172.29.91.92","url":"10.10.2.121"},{"PTZ_type":"onvif","description":"DA-DOME","id":"DA-DOME","password":"ZWjEP7ZQpv3J","pelcoID":1,"pelcoPort":"80","popupLayout":"STD-DOME","speed":"25","type":"standalone","unrealHost":"172.29.91.92","url":"10.10.2.14","username":"Grieg","winchPulse":"default"}]', '{"SAQVclientID":"37517573-78b2-46d1-8c04-307b92e72337","SAQVemail":"grieg@griegseafood.com","SAQVlogin":"http://10.20.2.252:5000","SAQVpw":"Grieg2018","SAQVurl":"http://10.20.2.252:8080","aqApiUrl":"http://10.20.2.251","aqId":"7a1e890f-505d-4fd1-bbce-28bd1a59cad7","aqSecret":"OM%25%25a(%7Do38%7C%24q_8%7Dz%3FRry%5Bx%5EnT%7DW%3A%40NP%3Fk7Ci.HG%3E%2B%242%5DN%5E%2B3_9P%24","cageCount":4,"feedingType":"SteinsvikFS","feedingUrl":"http://10.20.2.251","httpOnly":true,"pmsHostname":"nofinsap03.judaberg.prod","unrealHost":"172.29.91.92","url":"http://10.20.2.251","usePMS":true}', '[\r\n { "cameras": ["DA-01", "DA-S-01"], "description": "Merd 1", "group": "group_1" },\r\n { "cameras": ["DA-02", "DA-S-02"], "description": "Merd 2", "group": "group_2" },\r\n { "cameras": ["DA-03", "DA-S-03"], "description": "Merd 3", "group": "group_3" },\r\n { "cameras": ["DA-04", "DA-S-04"], "description": "Merd 4", "group": "group_4" }\r\n]\r\n', '4875752d-c483-43a9-a156-4e87cfd6a55e');
36/*!40000 ALTER TABLE `sites` ENABLE KEYS */;
37
38/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
39/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
40/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
41/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
42