Mercurial > hg > freeDiameter

annotate doc/app_sip_SL.sql @ 1561:699c3fb0c57b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Switch from libidn to libidn2. libidn2 is the backwards compatible successor to libidn, and at least Red Hat 8 does not provide a dev package for libidn1.
author Thomas Klausner <wiz@gatalith.at>
date Wed, 16 Jun 2021 18:44:45 +0200
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"