-- MySQL dump 10.13  Distrib 5.7.44, for Linux (x86_64)
--
-- Host: localhost    Database: aerion
-- ------------------------------------------------------
-- Server version	5.7.44-log

/*!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 */;
/*!40101 SET NAMES utf8 */;
/*!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 */;

--
-- Dumping data for table `net_script`
--

LOCK TABLES `net_script` WRITE;
/*!40000 ALTER TABLE `net_script` DISABLE KEYS */;
INSERT INTO `net_script` VALUES (0,'Test on Oct 23 One','shell','Test on Oct 23 One Desc',3328,'2024-10-23 01:26:21',NULL,NULL,NULL),(1,'bring_ind_data.sh','shell','connect to hyd server and gets data',NULL,NULL,15,NULL,NULL),(6,'hosts.sh','shell','Loads /etc/hosts file from table net_ser by combining host_dm and hostdm_multi columns delete (block_get_ip.sh)',2,'2020-11-05 11:44:56',3,NULL,NULL),(7,'ip_blk.sh','shell','1. Reads IP address from logs files and then adds them into net_blk_ip and net_blk_ip_ser table and then add into server fire wall',3,'2020-08-05 19:44:56',18925,NULL,NULL),(8,'ser_read.sh','shell','Read net_ser table and update allservers.txt file, Runs from Upload deployment and /etc/hosts files to server, Y or N? in deployment.sh',NULL,NULL,17,NULL,NULL),(10,'chk_file_age.sh','shell','Will delete 2 days older execpt .sh files from structured/linux/deploy/scripts/dataoutput and db/tbl_vw directories, ',NULL,NULL,139,NULL,NULL),(11,'discsize.sh','shell','Will Calculate total disc size and availabe disc size and load into net_ser_dis and update net_ser tables',NULL,NULL,2,NULL,NULL),(12,'db_bk.sh','shell','Database backup as per net_ser_clone',NULL,NULL,1132,NULL,NULL),(13,'demo_qa.sh','shell','Will Create dump for demo or development on dev1 or live1',NULL,NULL,79,NULL,NULL),(14,'demo_completed.sh','shell','Will delete deme, test and other exprired copies, to be run on master only',NULL,NULL,1,NULL,NULL),(15,'Test Script Update Test New Edit','python','Test Script Update Test New Edit',3328,'2024-10-21 06:25:34',NULL,NULL,NULL),(19,'Datatable load script 1','shell','Datatable load script 1 Desc',3328,'2024-10-23 01:43:12',NULL,NULL,NULL),(20,'Datatable load script 2','python','Datatable load script 2 Desc',3328,'2024-10-23 01:44:47',NULL,NULL,NULL),(21,'Datatable load script 3','shell','Datatable load script 3 Desc',3328,'2024-10-23 01:45:11',NULL,NULL,NULL),(22,'Test on Oct 23 Three','shell','Test on Oct 23 Three Desc',3328,'2024-10-23 02:28:22',NULL,NULL,NULL),(23,'Test on Oct 23 Four Edit By Ziya and Sv','python','Test on Oct 23 Four Desc Edit By Ziya and Sv',3328,'2024-10-23 02:29:33',NULL,NULL,NULL),(24,'Test Script Update Test sasas','shell','Test Script Update Test sasas',3328,'2024-10-23 05:01:37',NULL,NULL,NULL),(25,'Test Script Update Test 2024','shell','Test Script Update Test 2024 adadsaas',3328,'2024-10-23 05:03:42',NULL,NULL,NULL),(26,'Validtion Test 23 Oct','shell','Validtion Test 23 Oct',3328,'2024-10-23 05:12:54',NULL,NULL,NULL),(28,'Validtion Test 23 Oct Eve','shell','Validtion Test 23 Oct Eve',3328,'2024-10-23 05:13:47',NULL,NULL,NULL),(29,'Scrip_Name.sh','shell','Shell Script for test',3328,'2024-10-23 05:15:27',NULL,NULL,NULL),(30,'Shel script test','shell','Shel script test descripton',3328,'2024-10-23 05:35:25',NULL,NULL,NULL),(31,'scxcXC','python','ZZccc',3328,'2024-10-23 05:34:50',NULL,NULL,NULL),(32,'Is element check','shell','Is element check',3328,'2024-10-23 05:40:01',NULL,NULL,NULL),(34,'Test Script after Edit Save Back','python','Test description after Edit Save Back',3328,'2024-10-23 22:32:41',NULL,NULL,NULL),(35,'Test Script Update Test add test','shell','Test Script Update Test add test desc',3328,'2024-10-23 22:55:31',NULL,NULL,NULL),(36,'save_back.php','shell','Test Edit Record Save Back Desc',3328,'2024-10-23 22:56:53',3,NULL,NULL),(40,'firstpy.py','python','python script for test -fadly',NULL,'2024-11-20 14:23:06',2,NULL,NULL),(43,'firstphp.php','php','for php scripts(fadly)',NULL,'2024-11-20 13:27:05',1,NULL,NULL),(45,'disc_cluster.php','php',NULL,NULL,'2024-11-22 15:17:08',1,NULL,NULL),(46,'disc_size_grp.php','php',NULL,NULL,'2024-11-22 15:18:31',1,NULL,NULL),(47,'sto_sync_bulk_old_files.php','php','script to upload old systems files to current server',NULL,'2025-01-30 15:57:39',1,NULL,NULL),(48,'sto_sync_files.php','php','The script will sync files across servers that haven\'t been synced yet.',NULL,'2025-02-02 06:07:01',1,NULL,NULL),(49,'script_scale_up.php','php','The script will allocate files if the server scales up.',NULL,'2025-02-06 13:51:58',1,NULL,NULL),(50,'audit_import.py','python','priya python script for import csv into TB',NULL,'2025-03-19 06:15:34',1,NULL,NULL),(51,'usage_net.sh','shell',NULL,7,'2025-03-19 14:50:20',1,NULL,NULL),(52,'zipcode.php','php','Will take zip code input and get street, city and state and insert values only if not exists',NULL,NULL,NULL,'Y','ZipCode'),(53,'dyn_form2.php','php','Dynamic 2 colums, hardcode column label name Firstname, Lastname',NULL,NULL,NULL,'Y','First Name | Last Name'),(54,'dyn_form3.php','php','Dynamic 2 colums, hardcode column label name Firstname, middlename,  lastname',NULL,NULL,NULL,'Y','First Name | Last Name | Ph No.'),(55,'no_script_found.php','php','File not created, so throw error message',NULL,NULL,NULL,'Y',NULL);
/*!40000 ALTER TABLE `net_script` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2025-10-14 17:12:02