Initial commit
Change-Id: I6a4444e3c193dae437cd7929f4c39aba7b749efa
diff --git a/doc/app_sip.sql b/doc/app_sip.sql
new file mode 100644
index 0000000..bfd5279
--- /dev/null
+++ b/doc/app_sip.sql
@@ -0,0 +1,117 @@
+--Can be used in phpMyAdmin
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+--
+-- DIAMETER SERVER DATABASE
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ds_data_types`
+--
+
+CREATE TABLE IF NOT EXISTS `ds_data_types` (
+ `id_data_type` int(11) NOT NULL AUTO_INCREMENT,
+ `label_type` varchar(255) NOT NULL,
+ PRIMARY KEY (`id_data_type`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ds_networks`
+--
+
+CREATE TABLE IF NOT EXISTS `ds_networks` (
+ `id_network` int(11) NOT NULL AUTO_INCREMENT,
+ `label_network` varchar(255) NOT NULL,
+ PRIMARY KEY (`id_network`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ds_sip_aor`
+--
+
+CREATE TABLE IF NOT EXISTS `ds_sip_aor` (
+ `id_sip_aor` int(11) NOT NULL AUTO_INCREMENT,
+ `id_user` int(11) NOT NULL,
+ `sip_aor` varchar(255) NOT NULL,
+ `sip_server_uri` varchar(255) DEFAULT NULL,
+ `registered` tinyint(1) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`id_sip_aor`,`id_user`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ds_sip_services`
+--
+
+CREATE TABLE IF NOT EXISTS `ds_sip_services` (
+ `id_service` int(11) NOT NULL AUTO_INCREMENT,
+ `label_service` varchar(255) NOT NULL,
+ PRIMARY KEY (`id_service`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ds_users`
+--
+
+CREATE TABLE IF NOT EXISTS `ds_users` (
+ `id_user` int(11) NOT NULL AUTO_INCREMENT,
+ `username` varchar(50) NOT NULL,
+ `password` varchar(50) NOT NULL,
+ `SIP_Server_URI` varchar(255) DEFAULT NULL,
+ `temp_SIP_Server_URI` varchar(255) DEFAULT NULL,
+ `authentication_pending` tinyint(1) NOT NULL DEFAULT '0',
+ `registrated` tinyint(1) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`id_user`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ds_user_data`
+--
+
+CREATE TABLE IF NOT EXISTS `ds_user_data` (
+ `id_user_data` int(11) NOT NULL AUTO_INCREMENT,
+ `id_sip_aor` int(11) NOT NULL,
+ `id_data_type` int(11) NOT NULL,
+ `data` longblob NOT NULL,
+ PRIMARY KEY (`id_user_data`,`id_sip_aor`,`id_data_type`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ds_user_networks`
+--
+
+CREATE TABLE IF NOT EXISTS `ds_user_networks` (
+ `id_user_network` int(11) NOT NULL AUTO_INCREMENT,
+ `id_user` int(11) NOT NULL,
+ `id_network` int(11) NOT NULL,
+ PRIMARY KEY (`id_user_network`,`id_user`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ds_user_services`
+--
+
+CREATE TABLE IF NOT EXISTS `ds_user_services` (
+ `id_user_service` int(11) NOT NULL AUTO_INCREMENT,
+ `id_user` int(11) NOT NULL,
+ `id_service` int(11) NOT NULL,
+ `compulsory` tinyint(1) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`id_user_service`,`id_user`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
+