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

[Carsten Bock]

Module: kamailio
Branch: master
Commit: dd8f47e3cf472463fc1f2110da05969caaf4d06c
URL: https://github.com/kamailio/kamailio/commit/dd8f47e3cf472463fc1f2110da05969caaf4d06c

Author: Carsten Bock <carsten at ng-voice.com>
Committer: Carsten Bock <carsten at 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/dd8f47e3cf472463fc1f2110da05969caaf4d06c.diff
Patch: https://github.com/kamailio/kamailio/commit/dd8f47e3cf472463fc1f2110da05969caaf4d06c.patch

---

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;