· 7 years ago · Nov 16, 2018, 05:30 AM
1root@linux-box:~/RDM# mysqldump rdmdb device
2-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
3--
4-- Host: localhost Database: rdmdb
5-- ------------------------------------------------------
6-- Server version 5.7.24-0ubuntu0.18.04.1
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11/*!40101 SET NAMES utf8 */;
12/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
13/*!40103 SET TIME_ZONE='+00:00' */;
14/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
15/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18
19--
20-- Table structure for table `device`
21--
22
23DROP TABLE IF EXISTS `device`;
24/*!40101 SET @saved_cs_client = @@character_set_client */;
25/*!40101 SET character_set_client = utf8 */;
26CREATE TABLE `device` (
27 `uuid` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
28 `instance_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
29 `last_host` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
30 `last_seen` int(11) unsigned NOT NULL DEFAULT '0',
31 `account_username` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
32 PRIMARY KEY (`uuid`),
33 UNIQUE KEY `uk_iaccount_username` (`account_username`),
34 KEY `fk_instance_name` (`instance_name`),
35 CONSTRAINT `fk_account_username` FOREIGN KEY (`account_username`) REFERENCES `account` (`username`) ON DELETE SET NULL ON UPDATE CASCADE,
36 CONSTRAINT `fk_instance_name` FOREIGN KEY (`instance_name`) REFERENCES `instance` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
37) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `device`
42--
43
44LOCK TABLES `device` WRITE;
45/*!40000 ALTER TABLE `device` DISABLE KEYS */;
46INSERT INTO `device` VALUES ('134a6dcb62cc92dfc4a0d63ddcb4cc734df616eb','Dryden Raid','192.168.0.114:60681',1542334403,'PortBag9yBet'),('1818098f93b0949d75526236f8baaf14eed853eb','Ottawa Raid','192.168.0.119:55540',1542334400,NULL),('22db53b3fc0670458a465520cd7a76af06139ef1','Ottawa Raid','192.168.0.115:52875',1542334402,NULL),('2a2565e6794afd3e68cb1f667de901ba0f396421','Ottawa Raid','192.168.0.120:55072',1542334400,'J0yNude417o'),('2da5c7634335b9ae130e2b87cb5d8d4502768b56','Ottawa Raid','192.168.0.117:56345',1542334402,'FuseJun3Cat'),('556af80b589e7f7b03ee96f062d12515fea83239','Tbay-Kak-Shore Raid','192.168.0.118:50001',1542334403,'Hide3ggarH4m'),('72b2234fbcd855dc4dedd236d4156cf24509683b','Tbay-Kak-Shore Raid','192.168.0.121:61811',1542334402,'2ebuV0wedRod'),('919e3eab684d422c70cefff6e7572a2752f4da25','SSM Raid','192.168.0.113:55531',1542334400,'H4mH3rd1vy'),('b430e29e34f8eaaa6ce51b5abd67b9556cdb31b8','Sudbury Raid','192.168.0.110:52756',1542334286,'0nus1mpsC0l4'),('bd53e430392411a8e096c8ce38ad5f8f6123ec19','Sudbury Raid','192.168.0.112:54743',1542334402,'L0wPea17chy'),('ce04b4ca71348dd8f1b13aa6912b41aef6c01e10','Timmins Raid','192.168.0.111:65383',1542334399,'Fax3dH37Som'),('f6d67d2dd3dbe95ab6ca0119cdf18f1fce2fec70','NBay-Tem Raid','192.168.0.116:55756',1542334401,'SwarmCupSulk');
47/*!40000 ALTER TABLE `device` ENABLE KEYS */;
48UNLOCK TABLES;
49/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
50
51/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
52/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
53/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
54/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
55/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
56/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
57/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
58
59-- Dump completed on 2018-11-16 0:25:38