view doc/app_sip_SL.sql @ 1479:c0aa1e66c12e

csv_to_fd: improve validation * Validate flags: - Ensure M and V can't occur more than once. - Ensure absence of V for vendor 0. - Ensure presence of V for vendor not 0. * Ensure AVP name is unique per vendor. * Add AVP name to most errors. * Use csv.DictReader.line_num for more accurate line numbers. TODO: enforce M and V must be present once and only once. Some AVPs currently fail that rule, including: - RFC 4005 / RFC 7155 QoS-Filter-Rule - 3GPP TS 29.212 PDN-Connection-ID - 3GPP TS 29.212 PS-to-CS-Session-Continuity
author Luke Mewburn <luke@mewburn.net>
date Thu, 26 Mar 2020 10:28:16 +1100
parents 533188d2e6cc
children
line wrap: on
line source



SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- SUBSCRIBER LOCATOR DATABASE
--

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

--
-- Table structure for table `ds_sip_aor_map`
--

CREATE TABLE IF NOT EXISTS `ds_sip_aor_map` (
  `id_map` int(11) NOT NULL AUTO_INCREMENT,
  `sip_aor` varchar(255) NOT NULL,
  `diameter_uri` varchar(255) NOT NULL,
  PRIMARY KEY (`id_map`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

"Welcome to our mercurial repository"