小绿叶结界-数据库表+批量添加 ip 白名单

l数据库表+自定义ip库

 #    批量添加 ip白名单

neiwang=(

127.0.0.1

100.100.0.0

172.24.57.242

10.111.111.2

192.168.1.1

0.0.0.0

172.24.57.0

100.100.30.0

)

for ip in ${neiwang[*]}

do

echo "白名单ip：$ip"

mysql -u enchantment -peisc.cn  -e "use enchantment ;INSERT INTO setip(name,ip,status) values('neiwang','$ip','neiwang'); select * from setip;"

done

 #    数据库表

-- MariaDB dump 10.17  Distrib 10.5.6-MariaDB, for Linux (x86_64)

--

-- Host: localhost    Database: enchantment

-- ------------------------------------------------------

-- Server version       10.5.6-MariaDB-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 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 `login`

--

DROP TABLE IF EXISTS `login`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `login` (

  `id` int(11) DEFAULT NULL,

  `name` varchar(100) COLLATE utf8_bin DEFAULT NULL,

  `password` varchar(100) COLLATE utf8_bin DEFAULT NULL,

  `status` varchar(100) COLLATE utf8_bin DEFAULT NULL,

  `city` varchar(100) COLLATE utf8_bin DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `login`

--

LOCK TABLES `login` WRITE;

/*!40000 ALTER TABLE `login` DISABLE KEYS */;

INSERT INTO `login` VALUES (1,'root','eisc.cn','0','登录用户');

/*!40000 ALTER TABLE `login` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `setip`

--

DROP TABLE IF EXISTS `setip`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `setip` (

  `id` int(22) NOT NULL AUTO_INCREMENT,

  `name` varchar(200) DEFAULT NULL,

  `ip` varchar(30) DEFAULT NULL,

  `status` varchar(9) DEFAULT NULL,

  `details` varchar(9999) DEFAULT NULL,

  `setdate` varchar(90) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `setip`

--

LOCK TABLES `setip` WRITE;

/*!40000 ALTER TABLE `setip` DISABLE KEYS */;

INSERT INTO `setip` VALUES (22,'neiwang','127.0.0.1','neiwang',NULL,NULL),(23,'neiwang','100.100.0.0','neiwang',NULL,NULL),(24,'neiwang','172.24.57.242','neiwang',NULL,NULL),(25,'neiwang','10.111.111.2','neiwang',NULL,NULL),(26,'neiwang','192.168.1.1','neiwang',NULL,NULL),(27,'neiwang','0.0.0.0','neiwang',NULL,NULL),(28,'neiwang','172.24.57.0','neiwang',NULL,NULL),(29,'neiwang','100.100.30.0','neiwang',NULL,NULL);

/*!40000 ALTER TABLE `setip` 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 2022-02-02 13:44:05