00001 -- MySQL dump 10.9
00002 --
00003 -- Host: localhost Database: icscf
00004 -- ------------------------------------------------------
00005 -- Server version 4.1.20-log
00006 ;;;;;;;;
00015
00016 --
00017 -- Current Database: `icscf`
00018 --
00019 ;
00021
00022 CREATE DATABASE `icscf` ;
00023
00024 USE `icscf`;
00025
00026 --
00027 -- Table structure for table `nds_trusted_domains`
00028 --
00029
00030 DROP TABLE IF EXISTS `nds_trusted_domains`;
00031 CREATE TABLE `nds_trusted_domains` (
00032 `id` int(11) NOT NULL auto_increment,
00033 `trusted_domain` varchar(83) NOT NULL default '',
00034 PRIMARY KEY (`id`)
00035 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00036
00037 --
00038 -- Table structure for table `s_cscf`
00039 --
00040
00041 DROP TABLE IF EXISTS `s_cscf`;
00042 CREATE TABLE `s_cscf` (
00043 `id` int(11) NOT NULL auto_increment,
00044 `name` varchar(83) NOT NULL default '',
00045 `s_cscf_uri` varchar(83) NOT NULL default '',
00046 PRIMARY KEY (`id`)
00047 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00048
00049 --
00050 -- Table structure for table `s_cscf_capabilities`
00051 --
00052
00053 DROP TABLE IF EXISTS `s_cscf_capabilities`;
00054 CREATE TABLE `s_cscf_capabilities` (
00055 `id` int(11) NOT NULL auto_increment,
00056 `id_s_cscf` int(11) NOT NULL default '0',
00057 `capability` int(11) NOT NULL default '0',
00058 PRIMARY KEY (`id`),
00059 KEY `idx_capability` (`capability`),
00060 KEY `idx_id_s_cscf` (`id_s_cscf`)
00061 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
00062 ;;;;;;;
00070
00071 -- MySQL dump 10.9
00072 --
00073 -- Host: localhost Database: icscf
00074 -- ------------------------------------------------------
00075 -- Server version 4.1.20-log
00076 ;;;;;;;;
00085
00086 --
00087 -- Current Database: `icscf`
00088 --
00089
00090 CREATE DATABASE `icscf` ;
00091
00092 USE `icscf`;
00093
00094 --
00095 -- Dumping data for table `nds_trusted_domains`
00096 --
00097
00098 ;
00100 LOCK TABLES `nds_trusted_domains` WRITE;
00101 INSERT INTO `nds_trusted_domains` VALUES (1,'open-ims.test');
00102 UNLOCK TABLES;;
00104
00105 --
00106 -- Dumping data for table `s_cscf`
00107 --
00108
00109 ;
00111 LOCK TABLES `s_cscf` WRITE;
00112 INSERT INTO `s_cscf` VALUES (1,'First and only S-CSCF','sip:scscf.open-ims.test:6060');
00113 UNLOCK TABLES;;
00115
00116 --
00117 -- Dumping data for table `s_cscf_capabilities`
00118 --
00119
00120 ;
00122 LOCK TABLES `s_cscf_capabilities` WRITE;
00123 INSERT INTO `s_cscf_capabilities` VALUES (1,1,0),(2,1,1);
00124 UNLOCK TABLES;;
00126 ;;;;;;;
00134
00135 # DB access rights
00136 grant delete,insert,select,update on icscf.* to icscf@localhost identified by 'heslo';
00137 grant delete,insert,select,update on icscf.* to provisioning@localhost identified by 'provi';
