Handy script/sql to mass import some data in ippubliques table

2 files changed, 263 insertions, 0 deletions

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
diff --git a/schema/ip_import.sql b/schema/ip_import.sql
new file mode 100644
index 0000000..5483397
--- /dev/null
+++ b/schema/ip_import.sql
@@ -0,0 +1,254 @@
+INSERT INTO `gestion_demo`.`ippubliques` (`ip4`, `ip6`, `secteur_id`) VALUES
+('203.0.113.2', '2001:db8:71:2::', '1'),
+('203.0.113.3', '2001:db8:71:3::', '1'),
+('203.0.113.4', '2001:db8:71:4::', '1'),
+('203.0.113.5', '2001:db8:71:5::', '1'),
+('203.0.113.6', '2001:db8:71:6::', '1'),
+('203.0.113.7', '2001:db8:71:7::', '1'),
+('203.0.113.8', '2001:db8:71:8::', '1'),
+('203.0.113.9', '2001:db8:71:9::', '1'),
+('203.0.113.10', '2001:db8:71:a::', '1'),
+('203.0.113.11', '2001:db8:71:b::', '1'),
+('203.0.113.12', '2001:db8:71:c::', '1'),
+('203.0.113.13', '2001:db8:71:d::', '1'),
+('203.0.113.14', '2001:db8:71:e::', '1'),
+('203.0.113.15', '2001:db8:71:f::', '1'),
+('203.0.113.16', '2001:db8:71:10::', '1'),
+('203.0.113.17', '2001:db8:71:11::', '1'),
+('203.0.113.18', '2001:db8:71:12::', '1'),
+('203.0.113.19', '2001:db8:71:13::', '1'),
+('203.0.113.20', '2001:db8:71:14::', '1'),
+('203.0.113.21', '2001:db8:71:15::', '1'),
+('203.0.113.22', '2001:db8:71:16::', '1'),
+('203.0.113.23', '2001:db8:71:17::', '1'),
+('203.0.113.24', '2001:db8:71:18::', '1'),
+('203.0.113.25', '2001:db8:71:19::', '1'),
+('203.0.113.26', '2001:db8:71:1a::', '1'),
+('203.0.113.27', '2001:db8:71:1b::', '1'),
+('203.0.113.28', '2001:db8:71:1c::', '1'),
+('203.0.113.29', '2001:db8:71:1d::', '1'),
+('203.0.113.30', '2001:db8:71:1e::', '1'),
+('203.0.113.31', '2001:db8:71:1f::', '1'),
+('203.0.113.32', '2001:db8:71:20::', '1'),
+('203.0.113.33', '2001:db8:71:21::', '1'),
+('203.0.113.34', '2001:db8:71:22::', '1'),
+('203.0.113.35', '2001:db8:71:23::', '1'),
+('203.0.113.36', '2001:db8:71:24::', '1'),
+('203.0.113.37', '2001:db8:71:25::', '1'),
+('203.0.113.38', '2001:db8:71:26::', '1'),
+('203.0.113.39', '2001:db8:71:27::', '1'),
+('203.0.113.40', '2001:db8:71:28::', '1'),
+('203.0.113.41', '2001:db8:71:29::', '1'),
+('203.0.113.42', '2001:db8:71:2a::', '1'),
+('203.0.113.43', '2001:db8:71:2b::', '1'),
+('203.0.113.44', '2001:db8:71:2c::', '1'),
+('203.0.113.45', '2001:db8:71:2d::', '1'),
+('203.0.113.46', '2001:db8:71:2e::', '1'),
+('203.0.113.47', '2001:db8:71:2f::', '1'),
+('203.0.113.48', '2001:db8:71:30::', '1'),
+('203.0.113.49', '2001:db8:71:31::', '1'),
+('203.0.113.50', '2001:db8:71:32::', '1'),
+('203.0.113.51', '2001:db8:71:33::', '1'),
+('203.0.113.52', '2001:db8:71:34::', '1'),
+('203.0.113.53', '2001:db8:71:35::', '1'),
+('203.0.113.54', '2001:db8:71:36::', '1'),
+('203.0.113.55', '2001:db8:71:37::', '1'),
+('203.0.113.56', '2001:db8:71:38::', '1'),
+('203.0.113.57', '2001:db8:71:39::', '1'),
+('203.0.113.58', '2001:db8:71:3a::', '1'),
+('203.0.113.59', '2001:db8:71:3b::', '1'),
+('203.0.113.60', '2001:db8:71:3c::', '1'),
+('203.0.113.61', '2001:db8:71:3d::', '1'),
+('203.0.113.62', '2001:db8:71:3e::', '1'),
+('203.0.113.63', '2001:db8:71:3f::', '1'),
+('203.0.113.64', '2001:db8:71:40::', '1'),
+('203.0.113.65', '2001:db8:71:41::', '1'),
+('203.0.113.66', '2001:db8:71:42::', '1'),
+('203.0.113.67', '2001:db8:71:43::', '1'),
+('203.0.113.68', '2001:db8:71:44::', '1'),
+('203.0.113.69', '2001:db8:71:45::', '1'),
+('203.0.113.70', '2001:db8:71:46::', '1'),
+('203.0.113.71', '2001:db8:71:47::', '1'),
+('203.0.113.72', '2001:db8:71:48::', '1'),
+('203.0.113.73', '2001:db8:71:49::', '1'),
+('203.0.113.74', '2001:db8:71:4a::', '1'),
+('203.0.113.75', '2001:db8:71:4b::', '1'),
+('203.0.113.76', '2001:db8:71:4c::', '1'),
+('203.0.113.77', '2001:db8:71:4d::', '1'),
+('203.0.113.78', '2001:db8:71:4e::', '1'),
+('203.0.113.79', '2001:db8:71:4f::', '1'),
+('203.0.113.80', '2001:db8:71:50::', '1'),
+('203.0.113.81', '2001:db8:71:51::', '1'),
+('203.0.113.82', '2001:db8:71:52::', '1'),
+('203.0.113.83', '2001:db8:71:53::', '1'),
+('203.0.113.84', '2001:db8:71:54::', '1'),
+('203.0.113.85', '2001:db8:71:55::', '1'),
+('203.0.113.86', '2001:db8:71:56::', '1'),
+('203.0.113.87', '2001:db8:71:57::', '1'),
+('203.0.113.88', '2001:db8:71:58::', '1'),
+('203.0.113.89', '2001:db8:71:59::', '1'),
+('203.0.113.90', '2001:db8:71:5a::', '1'),
+('203.0.113.91', '2001:db8:71:5b::', '1'),
+('203.0.113.92', '2001:db8:71:5c::', '1'),
+('203.0.113.93', '2001:db8:71:5d::', '1'),
+('203.0.113.94', '2001:db8:71:5e::', '1'),
+('203.0.113.95', '2001:db8:71:5f::', '1'),
+('203.0.113.96', '2001:db8:71:60::', '1'),
+('203.0.113.97', '2001:db8:71:61::', '1'),
+('203.0.113.98', '2001:db8:71:62::', '1'),
+('203.0.113.99', '2001:db8:71:63::', '1'),
+('203.0.113.100', '2001:db8:71:64::', '1'),
+('203.0.113.101', '2001:db8:71:65::', '1'),
+('203.0.113.102', '2001:db8:71:66::', '1'),
+('203.0.113.103', '2001:db8:71:67::', '1'),
+('203.0.113.104', '2001:db8:71:68::', '1'),
+('203.0.113.105', '2001:db8:71:69::', '1'),
+('203.0.113.106', '2001:db8:71:6a::', '1'),
+('203.0.113.107', '2001:db8:71:6b::', '1'),
+('203.0.113.108', '2001:db8:71:6c::', '1'),
+('203.0.113.109', '2001:db8:71:6d::', '1'),
+('203.0.113.110', '2001:db8:71:6e::', '1'),
+('203.0.113.111', '2001:db8:71:6f::', '1'),
+('203.0.113.112', '2001:db8:71:70::', '1'),
+('203.0.113.113', '2001:db8:71:71::', '1'),
+('203.0.113.114', '2001:db8:71:72::', '1'),
+('203.0.113.115', '2001:db8:71:73::', '1'),
+('203.0.113.116', '2001:db8:71:74::', '1'),
+('203.0.113.117', '2001:db8:71:75::', '1'),
+('203.0.113.118', '2001:db8:71:76::', '1'),
+('203.0.113.119', '2001:db8:71:77::', '1'),
+('203.0.113.120', '2001:db8:71:78::', '1'),
+('203.0.113.121', '2001:db8:71:79::', '1'),
+('203.0.113.122', '2001:db8:71:7a::', '1'),
+('203.0.113.123', '2001:db8:71:7b::', '1'),
+('203.0.113.124', '2001:db8:71:7c::', '1'),
+('203.0.113.125', '2001:db8:71:7d::', '1'),
+('203.0.113.126', '2001:db8:71:7e::', '1'),
+('203.0.113.127', '2001:db8:71:7f::', '1'),
+('203.0.113.128', '2001:db8:71:80::', '2'),
+('203.0.113.129', '2001:db8:71:81::', '2'),
+('203.0.113.130', '2001:db8:71:82::', '2'),
+('203.0.113.131', '2001:db8:71:83::', '2'),
+('203.0.113.132', '2001:db8:71:84::', '2'),
+('203.0.113.133', '2001:db8:71:85::', '2'),
+('203.0.113.134', '2001:db8:71:86::', '2'),
+('203.0.113.135', '2001:db8:71:87::', '2'),
+('203.0.113.136', '2001:db8:71:88::', '2'),
+('203.0.113.137', '2001:db8:71:89::', '2'),
+('203.0.113.138', '2001:db8:71:8a::', '2'),
+('203.0.113.139', '2001:db8:71:8b::', '2'),
+('203.0.113.140', '2001:db8:71:8c::', '2'),
+('203.0.113.141', '2001:db8:71:8d::', '2'),
+('203.0.113.142', '2001:db8:71:8e::', '2'),
+('203.0.113.143', '2001:db8:71:8f::', '2'),
+('203.0.113.144', '2001:db8:71:90::', '2'),
+('203.0.113.145', '2001:db8:71:91::', '2'),
+('203.0.113.146', '2001:db8:71:92::', '2'),
+('203.0.113.147', '2001:db8:71:93::', '2'),
+('203.0.113.148', '2001:db8:71:94::', '2'),
+('203.0.113.149', '2001:db8:71:95::', '2'),
+('203.0.113.150', '2001:db8:71:96::', '2'),
+('203.0.113.151', '2001:db8:71:97::', '2'),
+('203.0.113.152', '2001:db8:71:98::', '2'),
+('203.0.113.153', '2001:db8:71:99::', '2'),
+('203.0.113.154', '2001:db8:71:9a::', '2'),
+('203.0.113.155', '2001:db8:71:9b::', '2'),
+('203.0.113.156', '2001:db8:71:9c::', '2'),
+('203.0.113.157', '2001:db8:71:9d::', '2'),
+('203.0.113.158', '2001:db8:71:9e::', '2'),
+('203.0.113.159', '2001:db8:71:9f::', '2'),
+('203.0.113.160', '2001:db8:71:a0::', '2'),
+('203.0.113.161', '2001:db8:71:a1::', '2'),
+('203.0.113.162', '2001:db8:71:a2::', '2'),
+('203.0.113.163', '2001:db8:71:a3::', '2'),
+('203.0.113.164', '2001:db8:71:a4::', '2'),
+('203.0.113.165', '2001:db8:71:a5::', '2'),
+('203.0.113.166', '2001:db8:71:a6::', '2'),
+('203.0.113.167', '2001:db8:71:a7::', '2'),
+('203.0.113.168', '2001:db8:71:a8::', '2'),
+('203.0.113.169', '2001:db8:71:a9::', '2'),
+('203.0.113.170', '2001:db8:71:aa::', '2'),
+('203.0.113.171', '2001:db8:71:ab::', '2'),
+('203.0.113.172', '2001:db8:71:ac::', '2'),
+('203.0.113.173', '2001:db8:71:ad::', '2'),
+('203.0.113.174', '2001:db8:71:ae::', '2'),
+('203.0.113.175', '2001:db8:71:af::', '2'),
+('203.0.113.176', '2001:db8:71:b0::', '2'),
+('203.0.113.177', '2001:db8:71:b1::', '2'),
+('203.0.113.178', '2001:db8:71:b2::', '2'),
+('203.0.113.179', '2001:db8:71:b3::', '2'),
+('203.0.113.180', '2001:db8:71:b4::', '2'),
+('203.0.113.181', '2001:db8:71:b5::', '2'),
+('203.0.113.182', '2001:db8:71:b6::', '2'),
+('203.0.113.183', '2001:db8:71:b7::', '2'),
+('203.0.113.184', '2001:db8:71:b8::', '2'),
+('203.0.113.185', '2001:db8:71:b9::', '2'),
+('203.0.113.186', '2001:db8:71:ba::', '2'),
+('203.0.113.187', '2001:db8:71:bb::', '2'),
+('203.0.113.188', '2001:db8:71:bc::', '2'),
+('203.0.113.189', '2001:db8:71:bd::', '2'),
+('203.0.113.190', '2001:db8:71:be::', '2'),
+('203.0.113.191', '2001:db8:71:bf::', '2'),
+('203.0.113.192', '2001:db8:71:c0::', '2'),
+('203.0.113.193', '2001:db8:71:c1::', '2'),
+('203.0.113.194', '2001:db8:71:c2::', '2'),
+('203.0.113.195', '2001:db8:71:c3::', '2'),
+('203.0.113.196', '2001:db8:71:c4::', '2'),
+('203.0.113.197', '2001:db8:71:c5::', '2'),
+('203.0.113.198', '2001:db8:71:c6::', '2'),
+('203.0.113.199', '2001:db8:71:c7::', '2'),
+('203.0.113.200', '2001:db8:71:c8::', '2'),
+('203.0.113.201', '2001:db8:71:c9::', '2'),
+('203.0.113.202', '2001:db8:71:ca::', '2'),
+('203.0.113.203', '2001:db8:71:cb::', '2'),
+('203.0.113.204', '2001:db8:71:cc::', '2'),
+('203.0.113.205', '2001:db8:71:cd::', '2'),
+('203.0.113.206', '2001:db8:71:ce::', '2'),
+('203.0.113.207', '2001:db8:71:cf::', '2'),
+('203.0.113.208', '2001:db8:71:d0::', '2'),
+('203.0.113.209', '2001:db8:71:d1::', '2'),
+('203.0.113.210', '2001:db8:71:d2::', '2'),
+('203.0.113.211', '2001:db8:71:d3::', '2'),
+('203.0.113.212', '2001:db8:71:d4::', '2'),
+('203.0.113.213', '2001:db8:71:d5::', '2'),
+('203.0.113.214', '2001:db8:71:d6::', '2'),
+('203.0.113.215', '2001:db8:71:d7::', '2'),
+('203.0.113.216', '2001:db8:71:d8::', '2'),
+('203.0.113.217', '2001:db8:71:d9::', '2'),
+('203.0.113.218', '2001:db8:71:da::', '2'),
+('203.0.113.219', '2001:db8:71:db::', '2'),
+('203.0.113.220', '2001:db8:71:dc::', '2'),
+('203.0.113.221', '2001:db8:71:dd::', '2'),
+('203.0.113.222', '2001:db8:71:de::', '2'),
+('203.0.113.223', '2001:db8:71:df::', '2'),
+('203.0.113.224', '2001:db8:71:e0::', '2'),
+('203.0.113.225', '2001:db8:71:e1::', '2'),
+('203.0.113.226', '2001:db8:71:e2::', '2'),
+('203.0.113.227', '2001:db8:71:e3::', '2'),
+('203.0.113.228', '2001:db8:71:e4::', '2'),
+('203.0.113.229', '2001:db8:71:e5::', '2'),
+('203.0.113.230', '2001:db8:71:e6::', '2'),
+('203.0.113.231', '2001:db8:71:e7::', '2'),
+('203.0.113.232', '2001:db8:71:e8::', '2'),
+('203.0.113.233', '2001:db8:71:e9::', '2'),
+('203.0.113.234', '2001:db8:71:ea::', '2'),
+('203.0.113.235', '2001:db8:71:eb::', '2'),
+('203.0.113.236', '2001:db8:71:ec::', '2'),
+('203.0.113.237', '2001:db8:71:ed::', '2'),
+('203.0.113.238', '2001:db8:71:ee::', '2'),
+('203.0.113.239', '2001:db8:71:ef::', '2'),
+('203.0.113.240', '2001:db8:71:f0::', '2'),
+('203.0.113.241', '2001:db8:71:f1::', '2'),
+('203.0.113.242', '2001:db8:71:f2::', '2'),
+('203.0.113.243', '2001:db8:71:f3::', '2'),
+('203.0.113.244', '2001:db8:71:f4::', '2'),
+('203.0.113.245', '2001:db8:71:f5::', '2'),
+('203.0.113.246', '2001:db8:71:f6::', '2'),
+('203.0.113.247', '2001:db8:71:f7::', '2'),
+('203.0.113.248', '2001:db8:71:f8::', '2'),
+('203.0.113.249', '2001:db8:71:f9::', '2'),
+('203.0.113.250', '2001:db8:71:fa::', '2'),
+('203.0.113.251', '2001:db8:71:fb::', '2'),
+('203.0.113.252', '2001:db8:71:fc::', '2'),
+('203.0.113.253', '2001:db8:71:fd::', '2'),
+('203.0.113.254', '2001:db8:71:fe::', '2');