-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64) -- -- Host: localhost Database: auto -- ------------------------------------------------------ -- Server version 8.0.33-0ubuntu0.22.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `account` -- DROP TABLE IF EXISTS `account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account` ( `id_account` int NOT NULL AUTO_INCREMENT, `acc_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `acc_password` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `acc_role` int NOT NULL DEFAULT '0', `acc_fullname` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id_account`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account` -- LOCK TABLES `account` WRITE; /*!40000 ALTER TABLE `account` DISABLE KEYS */; INSERT INTO `account` VALUES (7,'au','$2b$10$GAuda8zpsdn0q3EYfrStPelo3sdSlq60tgoP4gRF2.shE0n3iOtQW',2,'User AU'),(8,'us','$2b$10$xn6NwyQQZDAOHcXcFJdriODltA584j6g0ZGtXcH4QyIzz0AnbsLMi',2,'User US'),(9,'vn','$2b$10$7v8my.w.4M4z8GE6DCDPjeoU8yoHbCitdHyGvqQBIU1jFAjZ0/Z7y',2,'User VN'),(10,'admin','$2b$10$RiK9fuCT38uIfocMv7neuOpQo6oPV2UCooDtg31b8MuyIlAHgXbEC',0,'Admin'),(11,'dev','$2b$10$E.2pGNmR4LJPL5gDkW3pU.vyAgej.MsBUld9osi/7nuumq0o7uuAu',0,'Dev'),(14,'adminct','$2b$10$fWT9RqFBWumhaChzQJD07.a/ytoTq6UmNHXMKMvAKi6Y0n1qDVOpO',0,'Admin CT'),(15,'frank','$2b$10$WEhLp4M3fmJr8MAiEKpRjeA7XhmH.ddsIAmYlnLTLU1krd8o4GfAm',0,'Frank'),(16,'ken','$2b$10$Rkb30B3cGjvzpt9IuRUsmuyrDO.pTHwVbL12DnDMDpiSthUOMR10e',0,'Ken'),(21,'station1','$2b$10$Sl75HjESScxOsc3O0m/dSOfqAfosFn3UQ/9WjOGmkiahuSHkJGuiO',2,'station1'),(22,'station2','$2b$10$AAXkH3kxAKdtR5EKX5wiGuoh39TdCh9bXA8jpL1jaY8HSU6I5fijO',2,'station2'),(23,'test1','$2b$10$KW6teiae913FqaK2wcuzYe7EYoyUdSwoHCp5hMPQL8clkPAV6riOy',2,'test1'),(24,'test2','$2b$10$AotVm5BY/Nj7.bd/ZPwHP.qzmDBQ13z.8vcalfUTUQPp8zwcoQuc.',2,'test2'),(25,'test3','$2b$10$X66glDhMCZbsBK05h5tYzORIPGB9q0H6K1IMgByjB0lkLrxs0q/cW',2,'test3'),(26,'test4','$2b$10$nlgADNPxkesa67zgEqofDeg2k8iRd8GtbjkeXeM.xRr4TGIIYbyYC',2,'test4'); /*!40000 ALTER TABLE `account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `command_group` -- DROP TABLE IF EXISTS `command_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `command_group` ( `id_cmd` int NOT NULL AUTO_INCREMENT, `cmd_message` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `group_id` int NOT NULL, PRIMARY KEY (`id_cmd`), KEY `fk_group_cmd` (`group_id`), CONSTRAINT `fk_group_cmd` FOREIGN KEY (`group_id`) REFERENCES `group` (`id_group`) ) ENGINE=InnoDB AUTO_INCREMENT=245 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `command_group` -- LOCK TABLES `command_group` WRITE; /*!40000 ALTER TABLE `command_group` DISABLE KEYS */; INSERT INTO `command_group` VALUES (51,'show inv',27),(52,'show ver',27),(53,'show post',27),(54,'show logging',27),(74,'sleep 2',36),(75,'send \"\r\"',36),(76,'send \"\r\"',36),(77,'send \"flash_init\r\"',36),(78,'sleep 15',36),(79,'expect \"MORE\"',36),(80,'send \" \"',36),(81,'sleep 50',36),(82,'send \"\r\"',36),(83,'send \"\r\"',36),(84,'expect \"switch:\"',36),(85,'send \"delete flash:config.text\r\"',36),(86,'expect \"?\"',36),(87,'send \"y\r\"',36),(88,'send \"\r\"',36),(89,'expect \"switch:\"',36),(90,'send \"delete flash:private-config.text\r\"',36),(91,'expect \"?\"',36),(92,'send \"y\r\"',36),(93,'send \"\r\"',36),(94,'expect \"switch:\"',36),(95,'sleep 5',36),(96,'send \"\r\"',36),(97,'send \"\r\"',36),(98,'sleep 5',36),(99,'send \"boot\r\"',36),(100,'sleep 5',36),(101,'send \"boot\r\"',36),(178,'sleep 3',37),(179,'send \"\r\"',37),(180,'send \"\r\"',37),(181,'expect \"switch:\"',37),(182,'send \"SWITCH_IGNORE_STARTUP_CFG=1\"',37),(183,'sleep 5',37),(184,'send \"\r\"',37),(185,'send \"\r\"',37),(186,'sleep 5',37),(187,'send \"boot\r\"',37),(188,'sleep 5',37),(189,'send \"boot\r\"',37),(191,'sleep 300',37),(213,'show inv',40),(214,'show ver',40),(216,'show diag',40),(217,'show post',40),(218,'show env all',40),(235,'show logging',40),(236,'show inv',41),(237,'show ver',41),(238,'show env all',27),(239,'show inv',42),(240,'show ver',42),(241,'show post',42),(242,'show logging',42),(244,'show power',40); /*!40000 ALTER TABLE `command_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `command_model` -- DROP TABLE IF EXISTS `command_model`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `command_model` ( `id_cmd` int NOT NULL AUTO_INCREMENT, `cmd_message` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `model_id` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id_cmd`), KEY `fk_model_cmd` (`model_id`), CONSTRAINT `fk_model_cmd` FOREIGN KEY (`model_id`) REFERENCES `model` (`id_model`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `command_model` -- LOCK TABLES `command_model` WRITE; /*!40000 ALTER TABLE `command_model` DISABLE KEYS */; /*!40000 ALTER TABLE `command_model` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exclude_error` -- DROP TABLE IF EXISTS `exclude_error`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `exclude_error` ( `id_error` int NOT NULL AUTO_INCREMENT, `err_message` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `err_model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id_error`) ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exclude_error` -- LOCK TABLES `exclude_error` WRITE; /*!40000 ALTER TABLE `exclude_error` DISABLE KEYS */; INSERT INTO `exclude_error` VALUES (13,'portasic','All'),(21,'default','All'),(22,'system returned to rom by power failure or unknown','All'),(23,'last reload reason: power failure or unknown','All'),(24,'overruns','All'),(26,'%pnp-6-pnp_saving_tech_summary','All'),(27,'mka-lli: failover event','All'),(52,'% invalid input detected at ~\"~^~\"~ marker.','All'),(53,'interrupt throttling statistics:','All'),(54,'ifr_netint_interrupt_process_release_count: 0','All'),(55,'interrupt stats:','All'),(62,'ok, low speed','All'); /*!40000 ALTER TABLE `exclude_error` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `group` -- DROP TABLE IF EXISTS `group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `group` ( `id_group` int NOT NULL AUTO_INCREMENT, `group_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `group_action` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `created_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `created_at` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id_group`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `group` -- LOCK TABLES `group` WRITE; /*!40000 ALTER TABLE `group` DISABLE KEYS */; INSERT INTO `group` VALUES (27,'Default_Switch_test','test','Admin','1676970115959'),(31,'Default_UpdateIOS_Switch_2960/3560/3750','UpdateIOS','Admin','1677464774952'),(36,'Default_Break_2960/3560/3750','break','Admin','1678074026272'),(37,'Default_Break_3650/3850','break','Admin','1679474911810'),(38,'Default_UpdateIOS_Router','UpdateIOS','Admin','1679533647597'),(39,'Default_UpdateIOS_Switch_3650/3850','UpdateIOS','Admin','1680051364376'),(40,'Default_Router_Test','test','Admin','1680082492463'),(41,'Default_Firewall_Test','test','Admin','1683342506576'),(42,'Default_test','test','Admin','1683852703567'); /*!40000 ALTER TABLE `group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `group_model` -- DROP TABLE IF EXISTS `group_model`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `group_model` ( `idGroup` int NOT NULL, `idModel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, KEY `fk1_group` (`idGroup`), KEY `fk2_model` (`idModel`), CONSTRAINT `fk1_group` FOREIGN KEY (`idGroup`) REFERENCES `group` (`id_group`), CONSTRAINT `fk2_model` FOREIGN KEY (`idModel`) REFERENCES `model` (`id_model`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `group_model` -- LOCK TABLES `group_model` WRITE; /*!40000 ALTER TABLE `group_model` DISABLE KEYS */; INSERT INTO `group_model` VALUES (40,'CISCO1841'),(40,'CISCO1941W-N/K9'),(40,'CISCO2911/K9'),(40,'C897VA-K9'),(41,'ASA5505'),(40,'ASR1001'),(40,'CISCO1921/K9'),(27,'WS-C2950SX-24'),(27,'WS-C2950T-24'),(27,'WS-C2960+24PC-L'),(27,'WS-C2960+24TC-L'),(27,'WS-C2960+48PST-L'),(27,'WS-C2960-8TC-L'),(27,'WS-C2960-8TC-S'),(27,'WS-C2960C-12PC-L'),(27,'WS-C2960C-8PC-L'),(27,'WS-C2960C-8TC-S'),(27,'WS-C2960S-24PS-L'),(27,'WS-C2960S-48FPD-L'),(27,'WS-C2960S-48LPS-L'),(27,'WS-C2960X-24PD-L'),(27,'WS-C2960X-24PS-L'),(27,'WS-C2960X-48LPD-L'),(27,'WS-C2960X-48LPS-L'),(27,'WS-C3560-24TS-S'),(27,'WS-C3560CG-8PC-S'),(27,'WS-C3560CX-12PC-S'),(27,'WS-C3560CX-12TC-S'),(27,'WS-C3560CX-8PC-S'),(27,'WS-C3850-48P'),(27,'WS-C3650-48PS-S'),(27,'WS-C3560E-48TD-S'),(27,'WS-C3560G-48TS-S'),(27,'WS-C3560V2-24PS-S'),(27,'WS-C3560X-24T-E'),(27,'WS-C3560X-24T-L'),(27,'WS-C3560X-24T-S'),(27,'WS-C3560X-48P-L'),(27,'WS-C3560X-48T-S'),(27,'WS-C3650-24PS'),(27,'WS-C3750E-48TD-S'),(27,'WS-C3750G-24PS-S'),(27,'WS-C3750G-24TS-S1U'),(27,'WS-C3750G-48TS-E'),(27,'WS-C3750G-48TS-S'),(27,'WS-C3750X-24P-E'),(27,'WS-C3750X-24P-S'),(27,'WS-C3750X-24T-L'),(27,'WS-C3750X-24T-S'),(27,'WS-C3750X-48P'),(27,'WS-C3750X-48P-S'),(27,'WS-C3750X-48P-L'),(27,'WS-C3750X-48PF-L'),(27,'WS-C3750X-48PF-S'),(27,'WS-C3850-12S'),(27,'WS-C3850-12S-E'),(27,'WS-C3850-24P'),(27,'WS-C3850-24P-S'),(27,'WS-C3850-24PW-S'),(27,'WS-C3850-24T-S'),(40,'ISR4351/K9'),(40,'ISR4331/K9'),(40,'ISR4321/K9'),(40,'CISCO881-K9'),(40,'CISCO3945-CHASSIS'),(40,'CISCO3925-CHASSIS'),(27,'WS-C3560E-12D-E'),(40,'CISCO3845'),(27,'WS-C3750G-24PS-E'),(27,'WS-C3750G-24PS-E'),(27,'WS-C6504-E'),(27,'WS-C6506-E'),(27,'WS-C3750-24TS-S'),(27,'WS-C3750-24TS-E'),(27,'WS-C3560CG-8TC-S'),(40,'CISCO2921/K9'),(40,'CISCO2901/K9'),(27,'WS-C2960X-48TS-L'); /*!40000 ALTER TABLE `group_model` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `items` -- DROP TABLE IF EXISTS `items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `items` ( `id_item` int NOT NULL AUTO_INCREMENT, `item_PID` varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL, `item_SN` varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL, `SN_parent_item` varchar(45) COLLATE utf8mb4_general_ci NOT NULL, `item_desrc` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` varchar(45) COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id_item`) ) ENGINE=InnoDB AUTO_INCREMENT=268 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `items` -- LOCK TABLES `items` WRITE; /*!40000 ALTER TABLE `items` DISABLE KEYS */; INSERT INTO `items` VALUES (1,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685583428737'),(2,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685583428737'),(3,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685583428737'),(4,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685583428737'),(5,'WS-C3650-48PS-S','FDO1911E2N9','FDO1911E2N9','NAME: \"Switch 1\", DESCR: \"WS-C3650-48PS-S\"','1685583428864'),(6,'WS-C3650-48PS-S','FDO1911E2N9','FDO1911E2N9','NAME: \"c36xx Stack\", DESCR: \"c36xx Stack\"','1685583428864'),(7,'C3650-STACK','FDO19121LTQ','FDO1911E2N9','NAME: \"StackAdapter1/1\", DESCR: \"StackAdapter1/1\"','1685583428864'),(8,'C3650-STACK','FDO19121LTH','FDO1911E2N9','NAME: \"StackAdapter1/2\", DESCR: \"StackAdapter1/2\"','1685583428865'),(9,'PWR-C2-640WAC','DCB1906B43X','FDO1911E2N9','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685583428865'),(10,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685583429380'),(11,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685583429380'),(12,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685583429380'),(13,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685583429380'),(14,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685583429380'),(15,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685583429380'),(16,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685583429380'),(17,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685583429380'),(18,'WS-C3650-48PS-S','FDO1911E2N9','FDO1911E2N9','NAME: \"c36xx Stack\", DESCR: \"c36xx Stack\"','1685590749117'),(19,'WS-C3650-48PS-S','FDO1911E2N9','FDO1911E2N9','NAME: \"Switch 1\", DESCR: \"WS-C3650-48PS-S\"','1685590749117'),(20,'C3650-STACK','FDO19121LTQ','FDO1911E2N9','NAME: \"StackAdapter1/1\", DESCR: \"StackAdapter1/1\"','1685590749117'),(21,'C3650-STACK','FDO19121LTH','FDO1911E2N9','NAME: \"StackAdapter1/2\", DESCR: \"StackAdapter1/2\"','1685590749117'),(22,'PWR-C2-640WAC','DCB1906B43X','FDO1911E2N9','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685590749118'),(23,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685590749166'),(24,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685590749166'),(25,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685590749166'),(26,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685590749166'),(27,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685590749693'),(28,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685590749693'),(29,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685590749693'),(30,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685590749693'),(31,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685590749693'),(32,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685590749693'),(33,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685590749693'),(34,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685590749693'),(35,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685601269216'),(36,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685601269216'),(37,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685601269216'),(38,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685601269216'),(39,'WS-C3650-48PS-S','FDO1911E2N9','FDO1911E2N9','NAME: \"c36xx Stack\", DESCR: \"c36xx Stack\"','1685601269421'),(40,'WS-C3650-48PS-S','FDO1911E2N9','FDO1911E2N9','NAME: \"Switch 1\", DESCR: \"WS-C3650-48PS-S\"','1685601269421'),(41,'C3650-STACK','FDO19121LTQ','FDO1911E2N9','NAME: \"StackAdapter1/1\", DESCR: \"StackAdapter1/1\"','1685601269421'),(42,'C3650-STACK','FDO19121LTH','FDO1911E2N9','NAME: \"StackAdapter1/2\", DESCR: \"StackAdapter1/2\"','1685601269421'),(43,'PWR-C2-640WAC','DCB1906B43X','FDO1911E2N9','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685601269421'),(44,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685601269938'),(45,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685601269938'),(46,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685601269938'),(47,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685601269938'),(48,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685601269939'),(49,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685601269939'),(50,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685601269939'),(51,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685601269939'),(52,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685602027045'),(53,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685602027045'),(54,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685602027045'),(55,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685602027045'),(56,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685602027045'),(57,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685602027045'),(58,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685602027045'),(59,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685602027045'),(60,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685602185894'),(61,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685602185894'),(62,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685602185894'),(63,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685602185894'),(64,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685603626166'),(65,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685603626166'),(66,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685603626166'),(67,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685603626166'),(68,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685604089083'),(69,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685604089083'),(70,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685604089083'),(71,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685604089083'),(72,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685604089845'),(73,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685604089845'),(74,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685604089846'),(75,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685604089846'),(76,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685604089846'),(77,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685604089846'),(78,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685604089846'),(79,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685604089845'),(80,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685665771514'),(81,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685665771514'),(82,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685665771514'),(83,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685665771514'),(84,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685665771514'),(85,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685665771517'),(86,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685665771529'),(87,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685665771536'),(88,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685665930633'),(89,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685665930633'),(90,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685665930633'),(91,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685665930633'),(92,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685673450676'),(93,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685673450676'),(94,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685673450676'),(95,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685673450676'),(96,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685674485817'),(97,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685674485817'),(98,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685674485817'),(99,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685674485817'),(100,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685674486362'),(101,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685674486363'),(102,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685674486363'),(103,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685674486363'),(104,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685674486363'),(105,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685674486363'),(106,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685674486363'),(107,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685674486363'),(108,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685675165901'),(109,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685675165901'),(110,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685675165901'),(111,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685675165901'),(112,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685676046538'),(113,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685676046538'),(114,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685676046538'),(115,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685676046538'),(116,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685676046538'),(117,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685676046538'),(118,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685676046538'),(119,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685676046538'),(120,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685676146483'),(121,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685676146483'),(122,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685676146483'),(123,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685676146483'),(124,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685676146483'),(125,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685676146483'),(126,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685676146483'),(127,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685676146484'),(128,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685676767157'),(129,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685676767158'),(130,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685676767158'),(131,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685676767158'),(132,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685676767158'),(133,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685676767158'),(134,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685676767158'),(135,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685676767158'),(136,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685676866607'),(137,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685676866607'),(138,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685676866607'),(139,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685676866607'),(140,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685676866607'),(141,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685676866607'),(142,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685676866607'),(143,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685676866607'),(144,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685676926060'),(145,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685676926061'),(146,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685676926061'),(147,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685676926061'),(148,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685677206485'),(149,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685677206485'),(150,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685677206485'),(151,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685677206485'),(152,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685677206485'),(153,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685677206485'),(154,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685677206485'),(155,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685677206485'),(156,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685677286789'),(157,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685677286790'),(158,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685677286790'),(159,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685677286790'),(160,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685677287242'),(161,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685677287242'),(162,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685677287242'),(163,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685677287242'),(164,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685677287242'),(165,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685677287242'),(166,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685677287242'),(167,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685677287242'),(168,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685678126756'),(169,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685678126757'),(170,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685678126757'),(171,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685678126757'),(172,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685678126757'),(173,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685678126757'),(174,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685678126757'),(175,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685678126757'),(176,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685678566274'),(177,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685678566274'),(178,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685678566274'),(179,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685678566274'),(180,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685679286265'),(181,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685679286265'),(182,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685679286265'),(183,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685679286265'),(184,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685679647594'),(185,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685679647594'),(186,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685679647594'),(187,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685679647594'),(188,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685679647594'),(189,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685679647594'),(190,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685679647594'),(191,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685679647594'),(192,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685679806232'),(193,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685679806232'),(194,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685679806232'),(195,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685679806232'),(196,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685680367618'),(197,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685680367618'),(198,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685680367618'),(199,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685680367618'),(200,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685680367618'),(201,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685680367618'),(202,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685680367618'),(203,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685680367618'),(204,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685680887030'),(205,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685680887029'),(206,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685680887030'),(207,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685680887030'),(208,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685681407690'),(209,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685681407690'),(210,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685681407690'),(211,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685681407690'),(212,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685681407690'),(213,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685681407690'),(214,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685681407691'),(215,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685681407692'),(216,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685681566375'),(217,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685681566376'),(218,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685681566376'),(219,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685681566376'),(220,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685691286499'),(221,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685691286499'),(222,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685691286499'),(223,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685691286499'),(224,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685691286966'),(225,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685691286966'),(226,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685691286966'),(227,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685691286966'),(228,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685691286967'),(229,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685691286967'),(230,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685691286967'),(231,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685691286967'),(232,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685692087452'),(233,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685692087452'),(234,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685692087452'),(235,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685692087452'),(236,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685692087452'),(237,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685692087452'),(238,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685692087453'),(239,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685692087453'),(240,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685692246512'),(241,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685692246513'),(242,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685692246513'),(243,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685692246513'),(244,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685693087469'),(245,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685693087469'),(246,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685693087469'),(247,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685693087469'),(248,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685693087469'),(249,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685693087469'),(250,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685693087469'),(251,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685693087469'),(252,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685693246625'),(253,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685693246625'),(254,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685693246625'),(255,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685693246625'),(256,'ISR4331/K9','FDO2136A1KF','FDO2136A1KF','NAME: \"Chassis\", DESCR: \"Cisco ISR4331 Chassis\"','1685696207558'),(257,'PWR-4330-AC','PST2133N0X6','FDO2136A1KF','NAME: \"Power Supply Module 0\", DESCR: \"250W AC Power Supply for Cisco ISR 4330\"','1685696207558'),(258,'ACS-4330-FANASSY','','FDO2136A1KF','NAME: \"Fan Tray\", DESCR: \"Cisco ISR4330 Fan Assembly\"','1685696207558'),(259,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 0\", DESCR: \"Cisco ISR4331 Built-In NIM controller\"','1685696207558'),(260,'ISR4331-3x1GE','JAB092709EL','FDO2136A1KF','NAME: \"NIM subslot 0/0\", DESCR: \"Front Panel 3 ports Gigabitethernet Module\"','1685696207558'),(261,'ISR4331/K9','','FDO2136A1KF','NAME: \"module 1\", DESCR: \"Cisco ISR4331 Built-In SM controller\"','1685696207558'),(262,'ISR4331/K9','','FDO2136A1KF','NAME: \"module F0\", DESCR: \"Cisco ISR4331 Forwarding Processor\"','1685696207558'),(263,'ISR4331/K9','FDO21351EXU','FDO2136A1KF','NAME: \"module R0\", DESCR: \"Cisco ISR4331 Route Processor\"','1685696207558'),(264,'WS-C3850-48P-S','FCW1852C01E','FCW1852C01E','NAME: \"Switch 1\", DESCR: \"WS-C3850-48P-S\"','1685696328191'),(265,'WS-C3850-48P','FCW1852C01E','FCW1852C01E','NAME: \"c38xx Stack\", DESCR: \"c38xx Stack\"','1685696328191'),(266,'C3KX-PWR-350WAC','LIT191401K4','FCW1852C01E','NAME: \"Switch 1 - Power Supply A\", DESCR: \"Switch 1 - Power Supply A\"','1685696328191'),(267,'C3850-NM-4-1G','FOC1847AG9F','FCW1852C01E','NAME: \"Switch 1 FRU Uplink Module 1\", DESCR: \"4x1G Uplink Module\"','1685696328191'); /*!40000 ALTER TABLE `items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `key_value` -- DROP TABLE IF EXISTS `key_value`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `key_value` ( `id_key_value` int NOT NULL AUTO_INCREMENT, `key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `value` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id_key_value`) ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `key_value` -- LOCK TABLES `key_value` WRITE; /*!40000 ALTER TABLE `key_value` DISABLE KEYS */; INSERT INTO `key_value` VALUES (17,'MODEL_SPECIAL','AIM-'),(18,'MODEL_SPECIAL','PWR-4'),(19,'MODEL_SPECIAL','EHWIC-'),(20,'MODEL_SPECIAL','NIM-'),(21,'MODEL_SPECIAL','ISM-'),(22,'MODEL_SPECIAL','PVDM2-'),(23,'MODEL_SPECIAL','PVDM3-'),(24,'MODEL_SPECIAL','PVDM4-'),(25,'MODEL_SPECIAL','DFC4-'),(26,'MODEL_SPECIAL','WS-X68'),(27,'MODEL_SPECIAL','3CXL'),(28,'MODEL_SPECIAL','ISR'),(29,'MODEL_SPECIAL','SM-'),(30,'MODEL_SPECIAL','800G2-POE-2'),(38,'HIGHLIGHT_STRING','low'),(39,'HIGHLIGHT_STRING','err'),(40,'HIGHLIGHT_STRING','fail'),(41,'HIGHLIGHT_STRING','fault'),(42,'HIGHLIGHT_STRING','trace'),(43,'HIGHLIGHT_STRING','error'),(44,'HIGHLIGHT_STRING','crit'),(45,'HIGHLIGHT_STRING','invalid'),(46,'HIGHLIGHT_STRING','###show'),(47,'HIGHLIGHT_STRING','###'),(48,'MEMORY_SPECIAL','29929471K'),(49,'MEMORY_SPECIAL','7213055K'),(50,'MEMORY_SPECIAL','7081983K'),(51,'MEMORY_SPECIAL','6598655K'),(52,'MEMORY_SPECIAL','7057407K'),(53,'MEMORY_SPECIAL','7341807K'),(54,'MEMORY_SPECIAL','7393215K'),(55,'MEMORY_SPECIAL','8388608K'),(56,'MEMORY_SPECIAL','14888959K'),(57,'MEMORY_SPECIAL','14659583K'),(58,'MEMORY_SPECIAL','16777216K'),(59,'MEMORY_SPECIAL','33554432K'),(68,'CHECK_RAM_EXTRA','WS-C3850-48P:4194304'); /*!40000 ALTER TABLE `key_value` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `line` -- DROP TABLE IF EXISTS `line`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `line` ( `id_line` int NOT NULL AUTO_INCREMENT, `line_ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `line_port` int NOT NULL, `line_clear` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `line_gateway` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '111.111.111.1', `line_number` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `station_id` int NOT NULL, `enable` int NOT NULL DEFAULT '1', PRIMARY KEY (`id_line`), KEY `fk1` (`station_id`), CONSTRAINT `fk1` FOREIGN KEY (`station_id`) REFERENCES `station` (`id_station`) ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `line` -- LOCK TABLES `line` WRITE; /*!40000 ALTER TABLE `line` DISABLE KEYS */; INSERT INTO `line` VALUES (25,'192.168.7.101',2001,'3',NULL,'1',1,1),(26,'192.168.7.102',2002,'4',NULL,'2',1,1),(27,'192.168.7.103',2003,'5',NULL,'3',1,1),(28,'192.168.7.104',2004,'6',NULL,'4',1,1),(29,'192.168.7.105',2005,'7',NULL,'5',1,1),(30,'192.168.7.106',2006,'8',NULL,'6',1,1),(31,'172.16.19.101',2018,'18','111.111.111.1','1',2,1),(32,'172.16.19.102',2019,'19','123.123.123.1','2',2,1),(33,'172.16.19.103',2020,'20',NULL,'3',2,1),(34,'172.16.19.104',2021,'21',NULL,'4',2,1),(35,'192.168.7.101',2003,'3',NULL,'1',3,1),(36,'192.168.7.102',2004,'4',NULL,'2',3,1),(37,'192.168.7.103',2005,'5',NULL,'3',3,1),(38,'192.168.7.104',2006,'6',NULL,'4',3,1),(39,'192.168.7.105',2007,'7',NULL,'5',3,1),(40,'192.168.7.106',2008,'8',NULL,'6',3,1),(41,'192.168.7.107',2009,'9',NULL,'7',3,1),(42,'192.168.7.108',2010,'10',NULL,'8',3,1),(43,'192.168.7.107',2007,'9','111.111.111.1','7',1,1),(44,'192.168.7.108',2008,'10','111.111.111.1','8',1,1),(45,'192.168.7.111',2011,'11','111.111.111.1','11',3,1),(46,'192.168.7.112',2012,'12','111.111.111.1','12',3,1),(47,'192.168.7.113',2013,'13','111.111.111.1','13',3,1),(48,'192.168.7.114',2014,'14','111.111.111.1','14',3,1),(49,'192.168.7.115',2015,'15','111.111.111.1','15',3,1),(50,'192.168.7.116',2016,'16','111.111.111.1','16',3,1),(51,'192.168.7.117',2017,'17','111.111.111.1','17',3,1),(52,'192.168.7.118',2018,'18','111.111.111.1','18',3,1),(53,'172.16.19.105',2022,'22','111.111.111.1','5',2,1),(54,'172.16.19.106',2023,'23','111.111.111.1','6',2,1),(55,'172.16.19.107',2024,'24','111.111.111.1','7',2,1),(56,'172.16.19.108',2025,'25','111.111.111.1','8',2,1),(57,'192.168.7.111',2011,'3','111.111.111.1','11',4,1),(58,'192.168.7.112',2012,'4','111.111.111.1','12',4,1),(59,'192.168.7.113',2013,'5','111.111.111.1','13',4,1),(60,'192.168.7.114',2014,'6','111.111.111.1','14',4,1),(61,'192.168.7.115',2015,'7','111.111.111.1','15',4,1),(62,'192.168.7.116',2016,'8','111.111.111.1','16',4,1),(63,'192.168.7.117',2017,'9','111.111.111.1','17',4,1),(64,'192.168.7.118',2018,'10','111.111.111.1','18',4,1); /*!40000 ALTER TABLE `line` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log` -- DROP TABLE IF EXISTS `log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `log` ( `id_log` int NOT NULL AUTO_INCREMENT, `log_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `log_status` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `log_line` int NOT NULL, `PID` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `SN` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `command` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `created_by` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `created_at` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id_log`), KEY `fk_line` (`log_line`) ) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `log` -- LOCK TABLES `log` WRITE; /*!40000 ALTER TABLE `log` DISABLE KEYS */; INSERT INTO `log` VALUES (1,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port6-09-14-21.log','ROMMON:',54,'','',NULL,'dev','1685092471699'),(2,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port2-09-14-21.log','SWITCH:',32,'','',NULL,'dev','1685092481963'),(3,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port7-09-14-21.log','SWITCH:',55,'','',NULL,'dev','1685092482450'),(4,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port5-09-14-21.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685092487813'),(5,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port3-09-14-21.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685092489187'),(6,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port1-09-15-01.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685092525461'),(7,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port4-09-14-21.log','PASSWORD',34,'','',NULL,'dev','1685092837649'),(8,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port1-09-20-58.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685092882342'),(9,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port5-09-20-58.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685092884509'),(10,'./public/filesTest/20230526-AUTO-Session.AU-dev.Port3-09-20-58.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685092885757'),(11,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port6-00-56-24.log','ROMMON:',54,'','',NULL,'dev','1685148994660'),(12,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port2-00-56-24.log','SWITCH:',32,'','',NULL,'dev','1685149004946'),(13,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port7-00-56-24.log','SWITCH:',55,'','',NULL,'dev','1685149005351'),(14,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port1-00-56-24.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685149008560'),(15,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port5-00-56-24.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685149010680'),(16,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port3-00-56-24.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685149012246'),(17,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port6-01-02-20.log','ROMMON:',54,'','',NULL,'dev','1685149350674'),(18,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port2-01-02-20.log','SWITCH:',32,'','',NULL,'dev','1685149361005'),(19,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port7-01-02-20.log','SWITCH:',55,'','',NULL,'dev','1685149361352'),(20,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port1-01-02-20.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685149364716'),(21,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port5-01-02-20.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685149366640'),(22,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port3-01-02-20.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685149368174'),(23,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port1-01-05-00.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685149523920'),(24,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port4-01-03-00.log','PASSWORD',34,'','',NULL,'dev','1685149758846'),(25,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port6-01-18-32.log','ROMMON:',54,'','',NULL,'dev','1685150323000'),(26,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port2-01-18-32.log','SWITCH:',32,'','',NULL,'dev','1685150333516'),(27,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port7-01-18-32.log','SWITCH:',55,'','',NULL,'dev','1685150333861'),(28,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port1-01-18-32.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685150336863'),(29,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port5-01-18-32.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685150339078'),(30,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port3-01-18-32.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685150340548'),(31,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port4-01-18-32.log','PASSWORD',34,'','',NULL,'dev','1685150689106'),(32,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port1-03-03-53.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'admin','1685156656896'),(33,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port6-03-23-53.log','ROMMON:',54,'','',NULL,'admin','1685157843087'),(34,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port7-03-23-52.log','SWITCH:',55,'','',NULL,'admin','1685157852930'),(35,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port2-03-23-53.log','SWITCH:',32,'','',NULL,'admin','1685157853390'),(36,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port1-03-23-53.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'admin','1685157856983'),(37,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port5-03-23-53.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'admin','1685157859407'),(38,'./public/filesTest/20230527-AUTO-Session.AU-dev.Port3-03-23-53.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'admin','1685157861695'),(39,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port6-00-48-06.log','ROMMON:',54,'','',NULL,'dev','1685407697098'),(40,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port2-00-48-07.log','SWITCH:',32,'','',NULL,'dev','1685407707569'),(41,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port7-00-48-07.log','SWITCH:',55,'','',NULL,'dev','1685407707854'),(42,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port1-00-48-06.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685407711278'),(43,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-00-48-06.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685407713443'),(44,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-00-48-07.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685407714884'),(45,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port4-00-48-07.log','PASSWORD',34,'','',NULL,'dev','1685408063345'),(46,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-01-17-55.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685409502431'),(47,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-01-33-52.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685410460072'),(48,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-01-37-42.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685410689552'),(49,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-01-39-59.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685410826125'),(50,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port2-02-35-19.log','SWITCH:',32,'','',NULL,'dev','1685414139765'),(51,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port7-02-35-19.log','SWITCH:',55,'','',NULL,'dev','1685414140096'),(52,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port6-02-37-19.log','ROMMON:',54,'','',NULL,'dev','1685414249054'),(53,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-02-37-19.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685414265289'),(54,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-02-39-19.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685414387789'),(55,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port1-02-41-59.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685414542939'),(56,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port4-02-40-39.log','PASSWORD',34,'','',NULL,'dev','1685414825616'),(57,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-02-55-16.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685415343722'),(58,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-02-15.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685415762402'),(59,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-06-16.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685416003650'),(60,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-09-09.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685416177048'),(61,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port6-03-15-31.log','ROMMON:',54,'','',NULL,'dev','1685416542927'),(62,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port2-03-15-31.log','SWITCH:',32,'','',NULL,'dev','1685416553115'),(63,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port7-03-15-31.log','SWITCH:',55,'','',NULL,'dev','1685416553560'),(64,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port1-03-15-31.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685416556493'),(65,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-03-15-31.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685416559103'),(66,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-15-31.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685416561197'),(67,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-19-46.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685416814223'),(68,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port4-03-15-31.log','PASSWORD',34,'','',NULL,'dev','1685416909661'),(69,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port6-03-24-33.log','ROMMON:',54,'','',NULL,'dev','1685417083088'),(70,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port2-03-24-32.log','SWITCH:',32,'','',NULL,'dev','1685417093198'),(71,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port7-03-24-32.log','SWITCH:',55,'','',NULL,'dev','1685417093611'),(72,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port1-03-24-33.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685417096748'),(73,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-03-24-32.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685417098827'),(74,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-24-33.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685417101582'),(75,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-03-29-26.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685417392514'),(76,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-29-26.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685417394013'),(77,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port6-03-37-20.log','ROMMON:',54,'','',NULL,'dev','1685417850825'),(78,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port2-03-37-20.log','SWITCH:',32,'','',NULL,'dev','1685417860982'),(79,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port7-03-37-20.log','SWITCH:',55,'','',NULL,'dev','1685417861693'),(80,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port1-03-37-20.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685417864508'),(81,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-03-37-20.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685417866919'),(82,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-37-20.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685417868347'),(83,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-03-41-59.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685418145059'),(84,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-41-59.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685418147770'),(85,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port6-03-57-19.log','ROMMON:',54,'','',NULL,'dev','1685419050145'),(86,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port2-03-57-19.log','SWITCH:',32,'','',NULL,'dev','1685419060238'),(87,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port7-03-57-19.log','SWITCH:',55,'','',NULL,'dev','1685419060789'),(88,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port1-03-57-19.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685419063717'),(89,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-03-57-19.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685419066167'),(90,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-03-57-19.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685419067523'),(91,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port4-03-57-19.log','PASSWORD',34,'','',NULL,'dev','1685419417241'),(92,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-04-06-39.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685419626565'),(93,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-04-07-19.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685419665353'),(94,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-04-12-23.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685419969524'),(95,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-04-12-23.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685419970614'),(96,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-04-18-17.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685420323471'),(97,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port3-04-18-17.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685420326594'),(98,'./public/filesTest/20230530-AUTO-Session.AU-dev.Port5-04-32-58.log','DPELP--Successful test!',53,'C897VA-K9','FJC2320L011',NULL,'dev','1685421203808'),(99,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port6-00-34-42.log','ROMMON:',54,'','',NULL,'dev','1685579692675'),(100,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port7-00-34-42.log','SWITCH:',55,'','',NULL,'dev','1685579703035'),(101,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port2-00-34-42.log','SWITCH:',32,'','',NULL,'dev','1685579703126'),(102,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port3-00-34-42.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685579710434'),(103,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port1-00-36-42.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685579826201'),(104,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port4-00-36-02.log','PASSWORD',34,'','',NULL,'dev','1685580145448'),(105,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port2-00-49-22.log','Faulty',32,'WS-C3650-48PS-S','FDO1911E2N9',NULL,'dev','1685580587404'),(106,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port6-01-36-59.log','ROMMON:',54,'','',NULL,'dev','1685583429140'),(107,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port7-01-36-59.log','SWITCH:',55,'','',NULL,'dev','1685583439842'),(108,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port1-01-36-59.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685583443090'),(109,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port2-01-36-59.log','Faulty',32,'WS-C3650-48PS-S','FDO1911E2N9',NULL,'dev','1685583444454'),(110,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port3-01-36-59.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685583447415'),(111,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port6-03-38-59.log','ROMMON:',54,'','',NULL,'dev','1685590749530'),(112,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port7-03-38-59.log','SWITCH:',55,'','',NULL,'dev','1685590760167'),(113,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port1-03-38-59.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685590763531'),(114,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port2-03-38-59.log','Faulty',32,'WS-C3650-48PS-S','FDO1911E2N9',NULL,'dev','1685590764622'),(115,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port3-03-38-59.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685590767031'),(116,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port4-03-38-59.log','PASSWORD',34,'','',NULL,'dev','1685591115392'),(117,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port6-06-34-19.log','ROMMON:',54,'','',NULL,'dev','1685601269646'),(118,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port7-06-34-19.log','SWITCH:',55,'','',NULL,'dev','1685601280644'),(119,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port1-06-34-19.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685601283565'),(120,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port2-06-34-19.log','Faulty',32,'WS-C3650-48PS-S','FDO1911E2N9',NULL,'dev','1685601284937'),(121,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port3-06-34-19.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685601287258'),(122,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port4-06-34-19.log','PASSWORD',34,'','',NULL,'dev','1685601645798'),(123,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port2-06-42-57.log','SWITCH:',32,'','',NULL,'dev','1685601797020'),(124,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port7-06-42-57.log','SWITCH:',55,'','',NULL,'dev','1685601797549'),(125,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port6-06-44-56.log','ROMMON:',54,'','',NULL,'dev','1685601906168'),(126,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port3-06-46-56.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685602044446'),(127,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port1-06-49-36.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685602200359'),(128,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port1-07-13-37.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685603640380'),(129,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port1-07-21-20.log','Error',31,'','',NULL,'dev','1685604280152'),(130,'./public/filesTest/20230601-AUTO-Session.AU-dev.Port3-07-21-20.log','Error',33,'','',NULL,'dev','1685604280341'),(131,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port6-00-29-21.log','ROMMON:',54,'','',NULL,'dev','1685665771499'),(132,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port2-00-29-21.log','SWITCH:',32,'','',NULL,'dev','1685665781771'),(133,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port7-00-29-21.log','SWITCH:',55,'','',NULL,'dev','1685665782124'),(134,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-00-29-21.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685665790460'),(135,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-00-32-01.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685665944828'),(136,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port4-00-30-41.log','PASSWORD',34,'','',NULL,'dev','1685666224192'),(137,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-02-37-21.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685673465094'),(138,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-02-54-36.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685674500012'),(139,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-02-54-36.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685674504412'),(140,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-03-05-56.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685675180383'),(141,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-20-36.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685676063966'),(142,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-20-36.log','Error',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685676159278'),(143,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-20-36.log','Error',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685676159283'),(144,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-20-36.log','Error',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685676159290'),(145,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-20-36.log','Error',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685676159293'),(146,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-32-37.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685676784535'),(147,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-32-37.log','Error',33,'','',NULL,'dev','1685676861444'),(148,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-32-37.log','Error',33,'','',NULL,'dev','1685676861481'),(149,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-32-37.log','Error',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685676879104'),(150,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-32-37.log','Error',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685676879114'),(151,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-03-35-16.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685676940448'),(152,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-39-56.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685677224483'),(153,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port6-03-41-16.log','ROMMON:',54,'','',NULL,'dev','1685677287228'),(154,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port2-03-41-17.log','SWITCH:',32,'','',NULL,'dev','1685677297568'),(155,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port7-03-41-16.log','SWITCH:',55,'','',NULL,'dev','1685677297753'),(156,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-03-41-17.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685677300982'),(157,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-41-16.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685677305710'),(158,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port4-03-41-17.log','PASSWORD',34,'','',NULL,'dev','1685677653279'),(159,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port2-03-53-17.log','SWITCH:',32,'','',NULL,'dev','1685678017273'),(160,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port6-03-53-57.log','ROMMON:',54,'','',NULL,'dev','1685678046805'),(161,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port7-03-53-57.log','SWITCH:',55,'','',NULL,'dev','1685678057588'),(162,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-03-55-17.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685678144158'),(163,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-03-56-37.log','Error',31,'','',NULL,'dev','1685678304342'),(164,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port4-03-56-37.log','PASSWORD',34,'','',NULL,'dev','1685678573358'),(165,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-04-02-37.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685678580790'),(166,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-04-14-37.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685679300738'),(167,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-04-20-37.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685679665875'),(168,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-04-23-17.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685679820625'),(169,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-04-32-37.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685680385042'),(170,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-04-32-37.log','Error',31,'','',NULL,'dev','1685680557316'),(171,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-04-41-17.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685680901738'),(172,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-04-49-56.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685681425109'),(173,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-04-52-37.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685681581166'),(174,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-07-34-37.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685691300958'),(175,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-07-34-37.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685691304347'),(176,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port2-07-43-57.log','SWITCH:',32,'','',NULL,'dev','1685691857713'),(177,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port7-07-43-57.log','SWITCH:',55,'','',NULL,'dev','1685691858092'),(178,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port6-07-45-57.log','ROMMON:',54,'','',NULL,'dev','1685691967202'),(179,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-07-47-57.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685692106589'),(180,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-07-50-37.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685692260928'),(181,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port4-07-49-17.log','PASSWORD',34,'','',NULL,'dev','1685692535041'),(182,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-08-04-37.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685693104853'),(183,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-08-07-17.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685693260774'),(184,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port3-08-56-37.log','DPELP--Successful test!',33,'ISR4331/K9','FDO2136A1KF',NULL,'dev','1685696226357'),(185,'./public/filesTest/20230602-AUTO-Session.AU-dev.Port1-08-58-37.log','Faulty',31,'WS-C3850-48P','FCW1852C01E',NULL,'dev','1685696342604'); /*!40000 ALTER TABLE `log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `model` -- DROP TABLE IF EXISTS `model`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `model` ( `id_model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `model_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `created_at` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, PRIMARY KEY (`id_model`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `model` -- LOCK TABLES `model` WRITE; /*!40000 ALTER TABLE `model` DISABLE KEYS */; INSERT INTO `model` VALUES ('ASA5505','Group','1683338833810'),('ASR1001','Group','1683334898332'),('C897VA-K9','Group','1681275491118'),('CISCO1841','Group','1677036767335'),('CISCO1921/K9','Group','1679547486362'),('CISCO1941W-N/K9','Group','1680575904241'),('CISCO2811','Group','1681899383170'),('CISCO2901/K9','Group','1684894832407'),('CISCO2911/K9','Group','1681275288654'),('CISCO2921/K9','Group','1684894783041'),('CISCO3845','Group','1683853142515'),('CISCO3925-CHASSIS','Group','1680739229676'),('CISCO3945-CHASSIS','Group','1680739231327'),('CISCO881-K9','Group','1682120244933'),('ISR4321/K9','Group','1682483955634'),('ISR4331/K9','Group','1678941086053'),('ISR4351/K9','Group','1678941087981'),('WS-C2950SX-24','Group','1679105872471'),('WS-C2950T-24','Group','1678175742392'),('WS-C2960+24PC-L','Group','1682483474024'),('WS-C2960+24TC-L','Group','1680045692764'),('WS-C2960+48PST-L','Group','1678175845137'),('WS-C2960-8TC-L','Group','1679873849799'),('WS-C2960-8TC-S','Group','1682559474413'),('WS-C2960C-12PC-L','Group','1680740795666'),('WS-C2960C-8PC-L','Group','1682483994208'),('WS-C2960C-8TC-S','Group','1679958905920'),('WS-C2960S-24PS-L','Group','1682035266087'),('WS-C2960S-48FPD-L','Group','1680045816881'),('WS-C2960S-48LPS-L','Group','1682035697337'),('WS-C2960X-24PD-L','Group','1681697483810'),('WS-C2960X-24PS-L','Group','1681948065283'),('WS-C2960X-48LPD-L','Group','1679896418783'),('WS-C2960X-48LPS-L','Group','1682037085549'),('WS-C2960X-48TS-L','Group','1684992619173'),('WS-C3560-24TS-S','Group','1681275477504'),('WS-C3560CG-8PC-S','Group','1680245500648'),('WS-C3560CG-8TC-S','Group','1684892226128'),('WS-C3560CX-12PC-S','Group','1679958905077'),('WS-C3560CX-12TC-S','Group','1680223329244'),('WS-C3560CX-8PC-S','Group','1682467563941'),('WS-C3560E-12D-E','Group','1683851546629'),('WS-C3560E-48TD-S','Group','1682295524091'),('WS-C3560G-48TS-S','Group','1682313655980'),('WS-C3560V2-24PS-S','Group','1677483340689'),('WS-C3560X-24T-E','Group','1680224565987'),('WS-C3560X-24T-L','Group','1680234174433'),('WS-C3560X-24T-S','Group','1680234171054'),('WS-C3560X-48P-L','Group','1681345399862'),('WS-C3560X-48T-L','Group','1682302356307'),('WS-C3560X-48T-S','Group','1682308699972'),('WS-C3650-24PS','Group','1679537737711'),('WS-C3650-48PS-S','Group','1679536728756'),('WS-C3750-24TS-E','Group','1684890934197'),('WS-C3750-24TS-S','Group','1684883567645'),('WS-C3750E-48TD-S','Group','1681948094432'),('WS-C3750G-24PS-E','Group','1684803556212'),('WS-C3750G-24PS-S','Group','1680046493403'),('WS-C3750G-24TS-S1U','Group','1680224567652'),('WS-C3750G-48TS-E','Group','1682313727621'),('WS-C3750G-48TS-S','Group','1680667545977'),('WS-C3750X-24P-E','Group','1677721180101'),('WS-C3750X-24P-S','Group','1681948171174'),('WS-C3750X-24T-L','Group','1677721223262'),('WS-C3750X-24T-S','Group','1680224565075'),('WS-C3750X-48P','Group','1676970145366'),('WS-C3750X-48P-L','Group','1677721208963'),('WS-C3750X-48P-S','Group','1682484154334'),('WS-C3750X-48PF-L','Group','1681948189836'),('WS-C3750X-48PF-S','Group','1677721194595'),('WS-C3850-12S','Group','1680654892203'),('WS-C3850-12S-E','Group','1680654904044'),('WS-C3850-24P','Group','1680225736639'),('WS-C3850-24P-S','Group','1679620298053'),('WS-C3850-24PW-S','Group','1679878887732'),('WS-C3850-24T-S','Group','1679621405229'),('WS-C3850-48P','Group','1682484975681'),('WS-C6504-E','Group','1684819609328'),('WS-C6506-E','Group','1684819699977'); /*!40000 ALTER TABLE `model` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `station` -- DROP TABLE IF EXISTS `station`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `station` ( `id_station` int NOT NULL AUTO_INCREMENT, `sta_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `sta_ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `sta_netmask` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '255.255.255.0', `sta_port_telnet` int NOT NULL DEFAULT '23', `sta_network` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0.0.0.0', `sta_gateway` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0.0.0.0', `sta_tftp` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0.0.0.0', `netmask_line` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '255.255.255.0', `gateway_line` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0.0.0.0', `sta_APC1` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0.0.0.0', `APC1_port` int NOT NULL DEFAULT '23', `sta_APC2` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0.0.0.0', `APC2_port` int NOT NULL DEFAULT '23', `updated_by` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `updated_at` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id_station`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `station` -- LOCK TABLES `station` WRITE; /*!40000 ALTER TABLE `station` DISABLE KEYS */; INSERT INTO `station` VALUES (1,'US1 01-08','192.168.5.7','255.255.255.0',2323,'192.168.10.0','172.16.5.2','192.168.7.9','255.255.255.0','192.168.7.9','192.168.5.7',2000,'',0,'Admin','21:12:58 - 02/02/2023'),(2,'AU-dev','172.16.20.17','255.255.255.0',23,'192.168.11.0','192.168.11.1','172.16.5.7','255.255.0.0','172.16.5.2','172.16.20.36',23,'2.2.2.2',23,'Admin','21:12:58 - 02/02/2023'),(3,'AUS-2','172.16.20.7','255.255.0.0',23,'192.168.11.0','172.16.5.2','172.16.5.8','255.255.255.0','192.168.7.1','172.16.20.32',23,'172.16.20.33',23,'Admin','21:12:58 - 02/02/2023'),(4,'US2 11-18','192.168.5.7','255.255.255.0',2333,'192.168.10.0','192.168.7.9','192.168.7.9','255.255.255.0','192.168.7.9','192.168.5.7',2020,'192.168.5.7',2020,'Admin','21:12:58 - 02/02/2023'),(5,'AUS-1','172.16.20.1','255.255.0.0',23,'0.0.0.0','0.0.0.0','0.0.0.0','255.255.255.0','0.0.0.0','0.0.0.0',23,'0.0.0.0',23,NULL,NULL); /*!40000 ALTER TABLE `station` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'auto' -- /*!50003 DROP PROCEDURE IF EXISTS `pro_account_addAccount` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_account_addAccount`( in pUsername text, in pPassword text, in pRole text, in pFullName text) BEGIN insert into `account`(acc_name, acc_password, acc_role, acc_fullname) values (pUsername, pPassword, pRole, pFullName); select 1 as pCode; select concat("add user") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_account_getAccountByUsername` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_account_getAccountByUsername`(in pUsername text) BEGIN select * from `account` where acc_name = pUsername; select 1 as pCode; select concat("get user by id") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_device_addError` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_device_addError`( in pMessage text, in pModel text) BEGIN insert into exclude_error(err_message, err_model) values (pMessage, pModel); select 1 as pCode; select concat("add exclude error") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_device_deleteError` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_device_deleteError`( in pId text) BEGIN delete from exclude_error where id_error=pId; select 1 as pCode; select concat("delete exclude error") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_device_getAllError` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_device_getAllError`() BEGIN select * from exclude_error; select 1 as pCode; select concat("get all exclude error") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_addCmdForGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_addCmdForGroup`( in pIdGroup text, in pMessage text) BEGIN insert into `command_group`(group_id, cmd_message) values (pIdGroup, pMessage); select 1 as pCode; select concat("add command group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_addCmdForModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_addCmdForModel`( in pIdModel text, in pMessage text) BEGIN insert into `command_model`(model_id, cmd_message) values (pIdModel, pMessage); select 1 as pCode; select concat("add command model") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_addGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_addGroup`( in pNameGroup text, in pCreatedBy text, in pCreatedAt text, in pAction text) BEGIN insert into `group`(group_name, created_by, created_at, group_action) values (pNameGroup, pCreatedBy, pCreatedAt, pAction); select id_group from `group` where created_at = pCreatedAt; select 1 as pCode; select concat("add group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_addModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_addModel`( in pIdModel text, in pIdGroup text, in pType text, in pCreatedAt text) BEGIN declare checkModel int(2) default -1; select 1 into checkModel from model where id_model = pIdModel; IF(pType = "Group") THEN insert into `model`(id_model, model_type, created_at) values (pIdModel, pType, pCreatedAt); insert into `group_model`(idModel, idGroup) values (pIdModel, pIdGroup); select 1 as pCode; select concat("add model group") as pMess; ELSE insert into `model`(id_model, model_type, created_at) values (pIdModel, pType, pCreatedAt); select 1 as pCode; select concat("add model single") as pMess; END IF; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_addModelForGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_addModelForGroup`( in pIdGroup text, in pIdModel text) BEGIN declare checkModel int(2) default -1; select 1 into checkModel from model where id_model = pIdModel; IF(checkModel = 1) THEN insert into `group_model`(idGroup, idModel) values (pIdGroup, pIdModel); END IF; select 1 as pCode; select concat("add model for group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_clearCmdOfModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_clearCmdOfModel`( in pIdModel text) BEGIN delete from command_model where model_id = pIdModel; select 1 as pCode; select concat("clear cmd of model") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_clearGroupOfModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_clearGroupOfModel`( in pIdModel text) BEGIN delete from group_model where idModel = pIdModel; select 1 as pCode; select concat("clear group of model") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_deleteCmdOfGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_deleteCmdOfGroup`( in pMessage text, in pIdGroup text) BEGIN delete from command_group where group_id=pIdGroup and cmd_message = pMessage; select 1 as pCode; select concat("delete cmd of group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_deleteCmdOfModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_deleteCmdOfModel`( in pMessage text, in pIdModel text) BEGIN delete from command_model where model_id=pIdModel and cmd_message = pMessage; select 1 as pCode; select concat("delete cmd of model") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_deleteGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_deleteGroup`( in pIdGroup text) BEGIN delete from command_group where group_id=pIdGroup; delete from group_model where idGroup=pIdGroup; delete from `group` where id_group=pIdGroup; select 1 as pCode; select concat("delete group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_deleteModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_deleteModel`( in pIdModel text) BEGIN delete from command_model where model_id=pIdModel; delete from group_model where idModel=pIdModel; delete from `model` where id_model=pIdModel; select 1 as pCode; select concat("delete model") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_deleteModelOfGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_deleteModelOfGroup`( in pIdModel text, in pIdGroup text) BEGIN delete from group_model where idGroup=pIdGroup and idModel = pIdModel; select 1 as pCode; select concat("delete model of group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_editGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_editGroup`(in pId text, in pName text) BEGIN update `group` set group_name = pName where id_group = pId; select 1 as pCode; select concat("edit information group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_editModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_editModel`(in pId text, in pType text) BEGIN update `model` set model_type = pType where id_model = pId; select 1 as pCode; select concat("edit information model") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_getAllCmdOfGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_getAllCmdOfGroup`(in pIdGroup text) BEGIN select * from command_group where group_id=pIdGroup; select 1 as pCode; select concat("get all command of group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_getAllCmdOfModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_getAllCmdOfModel`(in pIdModel text) BEGIN select * from command_model where model_id=pIdModel; select 1 as pCode; select concat("get all command of model") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_getAllGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_getAllGroup`() BEGIN select * from `group`; select 1 as pCode; select concat("get all group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_getAllGroupOfModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_getAllGroupOfModel`(in pIdModel text) BEGIN select * from `model`, `group`, group_model where id_model=idModel and id_group = idGroup and idModel=pIdModel; select 1 as pCode; select concat("get all group of model") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_getAllModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_getAllModel`() BEGIN select * from `model`; select 1 as pCode; select concat("get all model") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_group_getAllModelOfGroup` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_group_getAllModelOfGroup`(in pIdGroup text) BEGIN select * from `model`, `group`, group_model where id_model=idModel and id_group = idGroup and idGroup=pIdGroup; select 1 as pCode; select concat("get all model of group") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_item_addItem` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_item_addItem`(in pItem_SN text,in pItem_PID text, in pItem_Descr text, in pSN_Parent text, in pCreated_at text) BEGIN insert into items(item_SN, item_PID, item_desrc, SN_parent_item, created_at) values (pItem_SN, pItem_PID, pItem_Descr, pSN_Parent, pCreated_at); select 1 as pCode; select concat("add item") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_item_getAllItem` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_item_getAllItem`() BEGIN select * from items; select 1 as pCode; select concat("get all items") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_item_getAllItemBySNParent` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_item_getAllItemBySNParent`(in pSNParent text) BEGIN select * from items where SN_parent_item = pSNParent; select 1 as pCode; select concat("get all items by SN parent") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_log_addLog` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_log_addLog`( in pIdLine text, in pContent text, in pStatus text, in pCreatedAt text, in pCreatedBy text , in pPID text, in pSN text) BEGIN insert into `log`(log_content, log_status, log_line, created_at, created_by, PID, SN) values (pContent, pStatus, pIdLine, pCreatedAt, pCreatedBy,pPID,pSN); select 1 as pCode; select concat("add log") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_log_changeCommand` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_log_changeCommand`(in pId text, in pCommand text) BEGIN update `log` set command = pCommand where id_log = pId; select 1 as pCode; select concat("change command") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_log_getAllLogOfLine` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_log_getAllLogOfLine`( in pIdLine text) BEGIN select * from `log` where log_line = pIdLine order by created_at desc; select 1 as pCode; select concat("add log") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_station_addLineForStation` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_station_addLineForStation`( in pNumber text, in pPort text, in pClear text, in pIp text, in pStation text) BEGIN insert into line(line_number, line_port, line_clear, line_ip, station_id) values (pNumber, pPort, pClear, pIp, pStation); select 1 as pCode; select concat("add line for station") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_station_editLine` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_station_editLine`(in pId text, in pNumber text, in pPort text, in pClear text, in pIp text) BEGIN update line set line_number = pNumber, line_port = pPort, line_clear = pClear, line_ip = pIp where id_line = pId; select 1 as pCode; select concat("edit information line") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_station_editStation` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_station_editStation`(in pId text, in pIp text, in pTftp text,in pNetwork text, in pNetmask text, in pGateway text, in pGatewayLine text, in pNetmaskLine text,in pAPC1 text, in pAPC2 text, in pPortTelnet text, in pAPC1Port text, in pAPC2Port text) BEGIN update station set sta_ip = pIp, sta_tftp = pTftp, sta_network = pNetwork, sta_netmask = pNetmask, sta_gateway = pGateway, gateway_line = pGatewayLine, netmask_line = pNetmaskLine, sta_APC1 = pAPC1, sta_APC2 = pAPC2, sta_port_telnet = pPortTelnet, APC1_port = pAPC1Port, APC2_port = pAPC2Port where id_station = pId; select 1 as pCode; select concat("edit information station") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_station_enableLine` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_station_enableLine`(in pId text, in pStatus text) BEGIN update line set `enable` = pStatus where id_line = pId; select 1 as pCode; select concat("edit enable line") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_station_getAllLineOfStation` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_station_getAllLineOfStation`(in pId text) BEGIN select * from line where station_id = pId; select 1 as pCode; select concat("get all line of station") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_station_getAllStation` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_station_getAllStation`() BEGIN select * from station; select 1 as pCode; select concat("get all station") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_test_getCommandByModel` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_test_getCommandByModel`( in pIdModel text, in pAction text) BEGIN select id_group from model, `group`, group_model where id_model = idModel and id_group=idGroup AND id_model=pIdModel AND group_action=pAction; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_value_addValue` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_value_addValue`(in pKey text, in pValue text) BEGIN insert into key_value(`key`, `value`) values (pKey, pValue); select 1 as pCode; select concat("add key-value") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_value_deleteValue` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_value_deleteValue`(in pId text) BEGIN delete from key_value where id_key_value=pId; select 1 as pCode; select concat("delete value") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 DROP PROCEDURE IF EXISTS `pro_value_getAllValue` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; CREATE DEFINER=`nswuser`@`localhost` PROCEDURE `pro_value_getAllValue`() BEGIN select * from key_value; select 1 as pCode; select concat("get all value") as pMess; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2023-06-02 10:10:15