IpAddressSqlDef
in package
Définition du schéma de la table ipaddress et de son contenu
Table of Contents
Constants
- CONTENT = [ ['88.166.143.190', "BDavid"], // domicile ['86.244.235.216', "BDavid"], // labergerieduperejule ['127.0.0.1', "Accès local"], ['172.20.0.8', "Docker"], ['185.31.40.12', "Alwaysdata IPv4 (bdavid)"], ['2a00:b6e0:1:20:12::1', "Alwaysdata IPv6 (bdavid)"], // utilisée pour se loguer en interne ['199.19.249.196', "RIE"], ['185.24.185.194', "RIE"], ['185.24.186.194', "RIE"], ['185.24.184.194', "RIE"], ['185.24.184.209', "RIE"], ['185.24.187.196', "RIE"], ['185.2.196.196', "RIE"], ['195.6.33.18', "SDES-Orléans"], ['159.180.226.236', "OFB-AAMP"], ['217.108.227.133', "OFB-AAMP"], ['195.101.150.124', "DM-SOI"], ['41.242.116.32', "DEAL Mayotte"], ['213.41.80.110', "DAM"], ['185.24.187.194', "RIE"], ['185.24.184.208', "RIE"], ['185.24.184.212', "RIE"], ['185.24.185.212', "RIE"], ['185.24.186.212', "RIE"], ['185.24.187.212', "RIE"], ['194.5.172.137', "Centre serveur SG/DNum"], ['194.5.173.137', "Centre serveur SG/DNum"], ['185.24.186.192', "RIE"], ['185.24.187.124', "RIE"], ['185.24.187.191', "RIE"], ['83.206.157.137', "RIE"], ['86.246.91.34', "RIE"], ['192.93.226.1', "Cerema"], ['194.57.229.5', "Shom"], ['134.246.184.7', "Shom"], ['137.129.13.93', "Shom"], ]
- Contenu de la table ipaddress
- SCHEMA = ['comment' => "table des adresses IP", 'columns' => ['ip' => ['type' => 'varchar(256)', 'keyOrNull' => 'primary key', 'comment' => "adresse IP"], 'label' => ['type' => 'varchar(256)', 'comment' => "étiquette associée"]]]
- Définition du schéma de la table ipaddress
Methods
- sql() : string
- fabrique le code SQL de création de la table à partir d'une des constantes de définition du schéma.
Constants
CONTENT
Contenu de la table ipaddress
public
mixed
CONTENT
= [
['88.166.143.190', "BDavid"],
// domicile
['86.244.235.216', "BDavid"],
// labergerieduperejule
['127.0.0.1', "Accès local"],
['172.20.0.8', "Docker"],
['185.31.40.12', "Alwaysdata IPv4 (bdavid)"],
['2a00:b6e0:1:20:12::1', "Alwaysdata IPv6 (bdavid)"],
// utilisée pour se loguer en interne
['199.19.249.196', "RIE"],
['185.24.185.194', "RIE"],
['185.24.186.194', "RIE"],
['185.24.184.194', "RIE"],
['185.24.184.209', "RIE"],
['185.24.187.196', "RIE"],
['185.2.196.196', "RIE"],
['195.6.33.18', "SDES-Orléans"],
['159.180.226.236', "OFB-AAMP"],
['217.108.227.133', "OFB-AAMP"],
['195.101.150.124', "DM-SOI"],
['41.242.116.32', "DEAL Mayotte"],
['213.41.80.110', "DAM"],
['185.24.187.194', "RIE"],
['185.24.184.208', "RIE"],
['185.24.184.212', "RIE"],
['185.24.185.212', "RIE"],
['185.24.186.212', "RIE"],
['185.24.187.212', "RIE"],
['194.5.172.137', "Centre serveur SG/DNum"],
['194.5.173.137', "Centre serveur SG/DNum"],
['185.24.186.192', "RIE"],
['185.24.187.124', "RIE"],
['185.24.187.191', "RIE"],
['83.206.157.137', "RIE"],
['86.246.91.34', "RIE"],
['192.93.226.1', "Cerema"],
['194.57.229.5', "Shom"],
['134.246.184.7', "Shom"],
['137.129.13.93', "Shom"],
]
SCHEMA
Définition du schéma de la table ipaddress
public
mixed
SCHEMA
= ['comment' => "table des adresses IP", 'columns' => ['ip' => ['type' => 'varchar(256)', 'keyOrNull' => 'primary key', 'comment' => "adresse IP"], 'label' => ['type' => 'varchar(256)', 'comment' => "étiquette associée"]]]
Methods
sql()
fabrique le code SQL de création de la table à partir d'une des constantes de définition du schéma.
public
static sql(string $tableName, array<string, mixed> $schema) : string
Parameters
- $tableName : string
- $schema : array<string, mixed>