[sr-dev] git:master:dd8f47e3: Examples: Interrogating-CSCF: Add database structure and note about database structure

Module: kamailio Branch: master Commit: dd8f47e3cf472463fc1f2110da05969caaf4d06c URL: https://github.com/kamailio/kamailio/commit/dd8f47e3cf472463fc1f2110da05969… Author: Carsten Bock <carsten(a)ng-voice.com> Committer: Carsten Bock <carsten(a)ng-voice.com> Date: 2016-09-19T14:43:44+02:00 Examples: Interrogating-CSCF: Add database structure and note about database structure --- Added: examples/icscf/README.md Added: examples/icscf/icscf.sql --- Diff: https://github.com/kamailio/kamailio/commit/dd8f47e3cf472463fc1f2110da05969… Patch: https://github.com/kamailio/kamailio/commit/dd8f47e3cf472463fc1f2110da05969… --- diff --git a/examples/icscf/README.md b/examples/icscf/README.md new file mode 100644 index 0000000..85cb411 --- /dev/null +++ b/examples/icscf/README.md @@ -0,0 +1,10 @@ +# Kamailio - Interrogating-CSCF Example Configuration File + +Project Website: + + * http://www.kamailio.org + +## Database Structure + +The necessary Database files for the Interrogating-CSCF are included in this folder. + diff --git a/examples/icscf/icscf.sql b/examples/icscf/icscf.sql new file mode 100644 index 0000000..e8b8534 --- /dev/null +++ b/examples/icscf/icscf.sql @@ -0,0 +1,94 @@ +-- phpMyAdmin SQL Dump +-- version 4.4.13.1 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Generation Time: 17. Mrz 2016 um 17:36 +-- Server version: 5.5.47-0+deb7u1 +-- PHP Version: 5.4.45-0+deb7u2 + +SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; +SET time_zone = "+00:00"; + +-- +-- Database: `icscf` +-- + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `nds_trusted_domains` +-- + +CREATE TABLE IF NOT EXISTS `nds_trusted_domains` ( + `id` int(11) NOT NULL, + `trusted_domain` varchar(83) NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `s_cscf` +-- + +CREATE TABLE IF NOT EXISTS `s_cscf` ( + `id` int(11) NOT NULL, + `name` varchar(83) NOT NULL DEFAULT '', + `s_cscf_uri` varchar(83) NOT NULL DEFAULT '' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `s_cscf_capabilities` +-- + +CREATE TABLE IF NOT EXISTS `s_cscf_capabilities` ( + `id` int(11) NOT NULL, + `id_s_cscf` int(11) NOT NULL DEFAULT '0', + `capability` int(11) NOT NULL DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Indexes for dumped tables +-- + +-- +-- Indexes for table `nds_trusted_domains` +-- +ALTER TABLE `nds_trusted_domains` + ADD PRIMARY KEY (`id`); + +-- +-- Indexes for table `s_cscf` +-- +ALTER TABLE `s_cscf` + ADD PRIMARY KEY (`id`); + +-- +-- Indexes for table `s_cscf_capabilities` +-- +ALTER TABLE `s_cscf_capabilities` + ADD PRIMARY KEY (`id`), + ADD KEY `idx_capability` (`capability`), + ADD KEY `idx_id_s_cscf` (`id_s_cscf`); + +-- +-- AUTO_INCREMENT for dumped tables +-- + +-- +-- AUTO_INCREMENT for table `nds_trusted_domains` +-- +ALTER TABLE `nds_trusted_domains` + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; +-- +-- AUTO_INCREMENT for table `s_cscf` +-- +ALTER TABLE `s_cscf` + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; +-- +-- AUTO_INCREMENT for table `s_cscf_capabilities` +-- +ALTER TABLE `s_cscf_capabilities` + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;