/usr/share/doc/pmacct/sql/README.tunnel is in pmacct 1.7.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | This document doesn't replace documentation relevant to the database software you are
using, ie. README.mysql, README.pgsql or README.sqlite3.
The 'tunnel_ip_src', 'tunnel_ip_dst', 'tunnel_ip_proto', 'tunnel_ip_tos' fields.
Such fields are being introduced to support tunnel primitives. The guidelines below
(typically in MySQL format) are to add such primitives to the SQL schema:
* tunnel_ip_src field:
- "tunnel_ip_src CHAR(15) NOT NULL," to declare the field itself (*)
- "PRIMARY KEY (..., tunnel_ip_src, ...)" to put it in the primary key
* tunnel_ip_dst field:
- "tunnel_ip_dst CHAR(15) NOT NULL," to declare the field itself (*)
- "PRIMARY KEY (..., tunnel_ip_dst, ...)" to put it in the primary key
* tunnel_ip_proto field:
- "tunnel_ip_proto CHAR(6) NOT NULL," to declare the field itself (**)
- "PRIMARY KEY (..., tunnel_ip_proto, ...)" to put it in the primary key
* tunnel_ip_tos field:
- "tunnel_ip_tos INT(4) UNSIGNED NOT NULL," to declare the field itself
- "PRIMARY KEY (..., tunnel_ip_tos, ...)" to put it in the primary key
The primitive is not declared as part of any default table version; yet will not fail
version checks which are enabled when 'sql_optimize_clauses' feature is disabled.
(*) Field must be longer for IPv6 addresses. See README.IPv6
(**) Field must be defined as "INT(1) UNSIGNED NOT NULL" if sql_num_protos: true
|