Definition in file icscf.sql.
Go to the source code of this file.
Functions | |
| CREATE TABLE | nds_trusted_domains (`id`int(11) NOT NULL auto_increment,`trusted_domain`varchar(83) NOT NULL default '', PRIMARY KEY(`id`)) ENGINE |
| CREATE TABLE | s_cscf (`id`int(11) NOT NULL auto_increment,`name`varchar(83) NOT NULL default '',`s_cscf_uri`varchar(83) NOT NULL default '', PRIMARY KEY(`id`)) ENGINE |
| CREATE TABLE | s_cscf_capabilities (`id`int(11) NOT NULL auto_increment,`id_s_cscf`int(11) NOT NULL default '0',`capability`int(11) NOT NULL default '0', PRIMARY KEY(`id`), KEY`idx_capability`(`capability`), KEY`idx_id_s_cscf`(`id_s_cscf`)) ENGINE |
| INSERT INTO nds_trusted_domains | VALUES (1,'open-ims.test') |
| INSERT INTO s_cscf | VALUES (1,'First and only S-CSCF','sip:scscf.open-ims.test:6060') |
| INSERT INTO s_cscf_capabilities | VALUES (1, 1, 0) |
Variables | |
| MySQL dump | Host |
| Current | Database |
| CREATE DATABASE | icscf |
| USE | icscf |
| Table structure for table nds_trusted_domains DROP TABLE IF EXISTS | nds_trusted_domains |
| Table structure for table s_cscf DROP TABLE IF EXISTS | s_cscf |
| Table structure for table s_cscf_capabilities DROP TABLE IF EXISTS | s_cscf_capabilities |
| MySQL dump | Host |
| Current | Database |
| USE | icscf |
| Dumping data for table | nds_trusted_domains |
| LOCK TABLES nds_trusted_domains | WRITE |
| UNLOCK | TABLES |
| Dumping data for table | s_cscf |
| LOCK TABLES s_cscf | WRITE |
| UNLOCK | TABLES |
| Dumping data for table | s_cscf_capabilities |
| LOCK TABLES s_cscf_capabilities | WRITE |
| INSERT INTO s_cscf_capabilities UNLOCK | TABLES |
| grant | delete |
| grant | insert |
| grant | select |
| grant update on icscf *to icscf localhost identified by | heslo |
| grant | delete |
| grant | insert |
| grant | select |
| grant update on icscf *to provisioning localhost identified by | provi |
| CREATE TABLE nds_trusted_domains | ( | `id`int(11) NOT NULL | auto_increment, | |
| `trusted_domain`varchar(83) NOT NULL default '' | , | |||
| PRIMARY | KEY(`id`) | |||
| ) |
| CREATE TABLE s_cscf | ( | `id`int(11) NOT NULL | auto_increment, | |
| `name`varchar(83) NOT NULL default '' | , | |||
| `s_cscf_uri`varchar(83) NOT NULL default '' | , | |||
| PRIMARY | KEY(`id`) | |||
| ) |
| CREATE TABLE s_cscf_capabilities | ( | `id`int(11) NOT NULL | auto_increment, | |
| `id_s_cscf`int(11) NOT NULL default '0' | , | |||
| `capability`int(11) NOT NULL default '0' | , | |||
| PRIMARY | KEY(`id`), | |||
| KEY`idx_capability` | (`capability`), | |||
| KEY`idx_id_s_cscf` | (`id_s_cscf`) | |||
| ) |
| INSERT INTO nds_trusted_domains VALUES | ( | 1 | , | |
| 'open-ims.test' | ||||
| ) |
| INSERT INTO s_cscf VALUES | ( | 1 | , | |
| 'First and only S-CSCF' | , | |||
| 'sip:scscf.open-ims.test:6060' | ||||
| ) |
| INSERT INTO s_cscf_capabilities VALUES | ( | 1 | , | |
| 1 | , | |||
| 0 | ||||
| ) |
| Table structure for table nds_trusted_domains DROP TABLE IF EXISTS nds_trusted_domains |
| Table structure for table s_cscf DROP TABLE IF EXISTS s_cscf |
| Table structure for table s_cscf_capabilities DROP TABLE IF EXISTS s_cscf_capabilities |
| Dumping data for table nds_trusted_domains |
| Dumping data for table s_cscf |
| Dumping data for table s_cscf_capabilities |
| grant select |
1.5.2