Mercurial > hg > freeDiameter

annotate doc/app_sip_SL.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
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 -- SUBSCRIBER LOCATOR 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_sip_aor_map`
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_sip_aor_map` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
16 `id_map` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
17 `sip_aor` varchar(255) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
18 `diameter_uri` varchar(255) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
19 PRIMARY KEY (`id_map`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
20 ) 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
21
"Welcome to our mercurial repository"