Mercurial > hg > freeDiameter

annotate doc/app_sip.sql @ 1562:6219359a36a9 default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merge latest changes from proposed branch
author Sebastien Decugis <sdecugis@freediameter.net>
date Mon, 21 Jun 2021 19:08:18 +0800
parents 533188d2e6cc
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
432
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
1 --Can be used in phpMyAdmin
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
2
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
4
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
5 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
6 -- DIAMETER SERVER DATABASE
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
7 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
8
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
9 -- --------------------------------------------------------
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
10
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
11 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
12 -- Table structure for table `ds_data_types`
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
13 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
14
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
15 CREATE TABLE IF NOT EXISTS `ds_data_types` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
16 `id_data_type` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
17 `label_type` varchar(255) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
18 PRIMARY KEY (`id_data_type`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
19 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
20
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
21 -- --------------------------------------------------------
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
22
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
23 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
24 -- Table structure for table `ds_networks`
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
25 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
26
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
27 CREATE TABLE IF NOT EXISTS `ds_networks` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
28 `id_network` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
29 `label_network` varchar(255) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
30 PRIMARY KEY (`id_network`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
31 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
32
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
33 -- --------------------------------------------------------
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
34
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
35 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
36 -- Table structure for table `ds_sip_aor`
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
37 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
38
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
39 CREATE TABLE IF NOT EXISTS `ds_sip_aor` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
40 `id_sip_aor` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
41 `id_user` int(11) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
42 `sip_aor` varchar(255) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
43 `sip_server_uri` varchar(255) DEFAULT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
44 `registered` tinyint(1) NOT NULL DEFAULT '0',
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
45 PRIMARY KEY (`id_sip_aor`,`id_user`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
46 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
47
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
48 -- --------------------------------------------------------
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
49
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
50 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
51 -- Table structure for table `ds_sip_services`
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
52 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
53
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
54 CREATE TABLE IF NOT EXISTS `ds_sip_services` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
55 `id_service` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
56 `label_service` varchar(255) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
57 PRIMARY KEY (`id_service`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
58 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
59
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
60 -- --------------------------------------------------------
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
61
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
62 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
63 -- Table structure for table `ds_users`
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
64 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
65
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
66 CREATE TABLE IF NOT EXISTS `ds_users` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
67 `id_user` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
68 `username` varchar(50) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
69 `password` varchar(50) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
70 `SIP_Server_URI` varchar(255) DEFAULT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
71 `temp_SIP_Server_URI` varchar(255) DEFAULT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
72 `authentication_pending` tinyint(1) NOT NULL DEFAULT '0',
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
73 `registrated` tinyint(1) NOT NULL DEFAULT '0',
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
74 PRIMARY KEY (`id_user`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
75 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
76
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
77 -- --------------------------------------------------------
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
78
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
79 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
80 -- Table structure for table `ds_user_data`
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
81 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
82
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
83 CREATE TABLE IF NOT EXISTS `ds_user_data` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
84 `id_user_data` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
85 `id_sip_aor` int(11) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
86 `id_data_type` int(11) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
87 `data` longblob NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
88 PRIMARY KEY (`id_user_data`,`id_sip_aor`,`id_data_type`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
89 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
90
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
91 -- --------------------------------------------------------
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
92
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
93 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
94 -- Table structure for table `ds_user_networks`
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
95 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
96
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
97 CREATE TABLE IF NOT EXISTS `ds_user_networks` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
98 `id_user_network` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
99 `id_user` int(11) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
100 `id_network` int(11) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
101 PRIMARY KEY (`id_user_network`,`id_user`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
102 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
103
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
104 -- --------------------------------------------------------
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
105
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
106 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
107 -- Table structure for table `ds_user_services`
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
108 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
109
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
110 CREATE TABLE IF NOT EXISTS `ds_user_services` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
111 `id_user_service` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
112 `id_user` int(11) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
113 `id_service` int(11) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
114 `compulsory` tinyint(1) NOT NULL DEFAULT '0',
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
115 PRIMARY KEY (`id_user_service`,`id_user`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
116 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
117
"Welcome to our mercurial repository"