Mercurial > hg > freeDiameter

annotate doc/app_sip_SL.sql @ 1258:97caad40b665

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Cast enum to int to allow comparison with picky compiler(flag)s.
author Thomas Klausner <tk@giga.or.at>
date Tue, 11 Feb 2014 14:47:02 +0100
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"