From 957f66d407c7cd6ebc418f63df08d055218d8d92 Mon Sep 17 00:00:00 2001
From: Ludovic Pouzenc <ludovic@pouzenc.fr>
Date: Sun, 28 Aug 2016 10:57:13 +0200
Subject: Handy script/sql to mass import some data in ippubliques table

---
 schema/ip_import.sh | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100755 schema/ip_import.sh

(limited to 'schema/ip_import.sh')

diff --git a/schema/ip_import.sh b/schema/ip_import.sh
new file mode 100755
index 0000000..31e960c
--- /dev/null
+++ b/schema/ip_import.sh
@@ -0,0 +1,9 @@
+#!/bin/bash
+cat <<"EOF"
+INSERT INTO `gestion_demo`.`ippubliques` (`ip4`, `ip6`, `secteur_id`) VALUES
+EOF
+
+for i in $(seq 1 254)
+do
+	printf "('203.0.113.%i', '2001:db8:71:%x::', '1'),\n" $i $i
+done
-- 
cgit v1.1