SQLite format 3@  .c   O^ +!indexidx_subscr_imsisubscriber CREATE UNIQUE INDEX idx_subscr_imsi ON subscriber (imsi) Mtableindind CREATE TABLE ind ( -- 3G auth IND pool to be used for this VLR ind INTEGER PRIMARY KEY, -- VLR identification, usually the GSUP source_name vlr TEXT NOT NULL, UNIQUE (vlr) )% 9indexsqlite_autoindex_ind_1ind ktableauc_3gauc_3gCREATE TABLE auc_3g ( subscriber_id INTEGER PRIMARY KEY, -- subscriber.id algo_id_3g INTEGER NOT NULL, -- enum osmo_auth_algo value k VARCHAR(64) NOT NULL, -- hex string: subscriber's secret key (128/256bit) op VARCHAR(64), -- hex string: operator's secret key (128/256bit) opc VARCHAR(64), -- hex string: derived from OP and K (128/256bit) sqn INTEGER NOT NULL DEFAULT 0, -- sequence number of key usage -- nr of index bits at lower SQN end ind_bitlen INTEGER NOT NULL DEFAULT 5 )j/tableauc_2gauc_2gCREATE TABLE auc_2g ( subscriber_id INTEGER PRIMARY KEY, -- subscriber.id algo_id_2g INTEGER NOT NULL, -- enum osmo_auth_algo value ki VARCHAR(32) NOT NULL -- hex string: subscriber's secret key (128bit) )<;;tablesubscriber_multi_msisdnsubscriber_multi_msisdnCREATE TABLE subscriber_multi_msisdn ( -- Chapter 2.1.3 subscriber_id INTEGER, -- subscriber.id msisdn VARCHAR(15) NOT NULL )))Wtablesubscriber_apnsubscriber_apnCREATE TABLE subscriber_apn ( subscriber_id INTEGER, -- subscriber.id apn VARCHAR(256) NOT NULL )<!!CtablesubscribersubscriberCREATE TABLE subscriber ( -- OsmoHLR's DB scheme is modelled roughly after TS 23.008 version 13.3.0 id INTEGER PRIMARY KEY, -- Chapter 2.1.1.1 imsi VARCHAR(15) UNIQUE NOT NULL, -- Chapter 2.1.2 msisdn VARCHAR(15) UNIQUE, -- Chapter 2.2.3: Most recent / current IMEISV imeisv VARCHAR, -- Chapter 2.1.9: Most recent / current IMEI imei VARCHAR(14), -- Chapter 2.4.5 vlr_number VARCHAR(15), -- Chapter 2.4.6 msc_number VARCHAR(15), -- Chapter 2.4.8.1 sgsn_number VARCHAR(15), -- Chapter 2.13.10 sgsn_address VARCHAR, -- Chapter 2.4.8.2 ggsn_number VARCHAR(15), -- Chapter 2.4.9.2 gmlc_number VARCHAR(15), -- Chapter 2.4.23 smsc_number VARCHAR(15), -- Chapter 2.4.24 periodic_lu_tmr INTEGER, -- Chapter 2.13.115 periodic_rau_tau_tmr INTEGER, -- Chapter 2.1.1.2: network access mode nam_cs BOOLEAN NOT NULL DEFAULT 1, nam_ps BOOLEAN NOT NULL DEFAULT 1, -- Chapter 2.1.8 lmsi INTEGER, -- The below purged flags might not even be stored non-volatile, -- refer to TS 23.012 Chapter 3.6.1.4 -- Chapter 2.7.5 ms_purged_cs BOOLEAN NOT NULL DEFAULT 0, -- Chapter 2.7.6 ms_purged_ps BOOLEAN NOT NULL DEFAULT 0, -- Timestamp of last location update seen from subscriber -- The value is a string which encodes a UTC timestamp in granularity of seconds. last_lu_seen TIMESTAMP default NULL, last_lu_seen_ps TIMESTAMP default NULL, -- When a LU was received via a proxy, that proxy's hlr_number is stored here, -- while vlr_number reflects the MSC on the far side of that proxy. vlr_via_proxy VARCHAR, sgsn_via_proxy VARCHAR )3G!indexsqlite_autoindex_subscriber_2subscriber3G!indexsqlite_autoindex_subscriber_1subscriber  I J 9 Qa  % -   m i y 1]   =I 9 E 9 u a u U   M A  q Y 5 ) ! e  }M+262423855820670J+262427086871082I+262425214772611H+262425593706755G+262421642136411F+262420483442834E+262424744771645D+262429711153537C+262423907682891B+262424685112208A+262420909331493@+262427125615391?+262428875023161>+262422692945049=+262420094075621<+262429270275269;+262421775922195:+2624206993821389+2624252197318058+2624238081555267+2624248819192396+2624275649490145+2624260601661194+2624258942117353+2624295289098112+2624207403711971+2624271148739200+262425611865223/+262421578530038.+262429718182459-+262422001359952,+262421440382727++262420220519040*+262426239673024)+262426844842114(+262422206665772'+262428012129358&+262421052240323%+262421923621954$+262423688467570#+262427670197202"+262421377041693!+262424231470979 +262429004874573+262420678564043+262420041666314+262423215583116+262426979962158+262422041848562+262422943412842+262429066865312+262428361069626+262422746990868+262421989750002+262427581198053+262423562266360+262429887029991+262428515215955+262422544299800+262422501530075+262423787990885+262421612218190 +262420583620807 +262420713542377 +262423677408213 +262429835449586 +262420120680509+262424201972833+262426543191568+262422045136875+262421147767328+262422828582546+262427985182524+ 262420001250761 J }G (i j  y l   | { &  9 H  k  '$ Z %56 7 8 W I  z YX [ JhF 007J%491610107821I%491613273762H%491618032104G%491617515636F%491611245554E%491610001008D%491613663061C%491613435518B%491612320717A%491613858515@%491613563560?%491615408355>%491617858042=%491612187104<%491613233646;%491614405026:%4916158744179%4916168535618%4916151266327%4916142530486%4916123173125%4916123354054%4916171148783%4916184845222%4916122013261%4916155011130%491611081032/%491610823183.%491610636585-%491614310628,%491612752030+%491615800857*%491613747118)%491617428665(%491610332223'%491612544278&%491613556027%%491616125318$%491616356187#%491611646708"%491617053163!%491615120873 %491618474208%491611146341%491617200157%491615546508%491615784870%491610064652%491617433464%491610161482%491617206803%491612737534%491617053177%491611124476%491612035618%491610437837%491617846606%491614128141%491617682851%491618077711%491615010087 %491615670077 %491618466581 %491616831083 %491618186867 %491611147073%491616706332%491610742850%491614500667%491616558686%491618765443%491613401321% 491618243057   7f@~X1 p I " a :  y R ,  j D  \ 5 tM&'%IM000102030405060708090A0B0C0D0E0F%HM000102030405060708090A0B0C0D0E0F$G M000102030405060708090A0B0C0D0E0F%DM000102030405060708090A0B0C0D0E0F%CM000102030405060708090A0B0C0D0E0F$B M000102030405060708090A0B0C0D0E0F%AM000102030405060708090A0B0C0D0E0F%@M000102030405060708090A0B0C0D0E0F$? M000102030405060708090A0B0C0D0E0F%<M000102030405060708090A0B0C0D0E0F%;M000102030405060708090A0B0C0D0E0F$: M000102030405060708090A0B0C0D0E0F%9M000102030405060708090A0B0C0D0E0F%8M000102030405060708090A0B0C0D0E0F$7 M000102030405060708090A0B0C0D0E0F%4M000102030405060708090A0B0C0D0E0F%3M000102030405060708090A0B0C0D0E0F$2 M000102030405060708090A0B0C0D0E0F%1M000102030405060708090A0B0C0D0E0F%0M000102030405060708090A0B0C0D0E0F$/ M000102030405060708090A0B0C0D0E0F%,M000102030405060708090A0B0C0D0E0F%+M000102030405060708090A0B0C0D0E0F$* M000102030405060708090A0B0C0D0E0F%)M000102030405060708090A0B0C0D0E0F%(M000102030405060708090A0B0C0D0E0F$' M000102030405060708090A0B0C0D0E0F%$M000102030405060708090A0B0C0D0E0F%#M000102030405060708090A0B0C0D0E0F$" M000102030405060708090A0B0C0D0E0F%!M000102030405060708090A0B0C0D0E0F% M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F% M000102030405060708090A0B0C0D0E0F% M000102030405060708090A0B0C0D0E0F$  M000102030405060708090A0B0C0D0E0F% M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F -h8 T  p $ @ \  x ,Hd4Pl <XLJIMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJHMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJGMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJFMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJEMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJAMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ@MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ?MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ>MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ=MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ9MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ8MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ7MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ6MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ5MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ1MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ0MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ/MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ.MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ-MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ)MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ(MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ'MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ&MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ%MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ!MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2F 7MSC-00-00-00-00-00-00 7 MSC-00-00-00-00-00-00 J 9 Qa  % -   m i y 1]   =I 9 E 9 u a u U   M A  q Y 5 ) ! e  }M+262423855820670J+262427086871082I+262425214772611H+262425593706755G+262421642136411F+262420483442834E+262424744771645D+262429711153537C+262423907682891B+262424685112208A+262420909331493@+262427125615391?+262428875023161>+262422692945049=+262420094075621<+262429270275269;+262421775922195:+2624206993821389+2624252197318058+2624238081555267+2624248819192396+2624275649490145+2624260601661194+2624258942117353+2624295289098112+2624207403711971+2624271148739200+262425611865223/+262421578530038.+262429718182459-+262422001359952,+262421440382727++262420220519040*+262426239673024)+262426844842114(+262422206665772'+262428012129358&+262421052240323%+262421923621954$+262423688467570#+262427670197202"+262421377041693!+262424231470979 +262429004874573+262420678564043+262420041666314+262423215583116+262426979962158+262422041848562+262422943412842+262429066865312+262428361069626+262422746990868+262421989750002+262427581198053+262423562266360+262429887029991+262428515215955+262422544299800+262422501530075+262423787990885+262421612218190 +262420583620807 +262420713542377 +262423677408213 +262429835449586 +262420120680509+262424201972833+262426543191568+262422045136875+262421147767328+262422828582546+262427985182524+ 262420001250761 8J+) 26242385582067000712345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624270868710824916101078213H+% 2624252147726114916132737623G+% 2624255937067554916180321043F+% 2624216421364114916175156363E+% 2624204834428344916112455543D+% 2624247447716454916100010083C+% 2624297111535374916136630613B+% 2624239076828914916134355183A+% 2624246851122084916123207173@+% 2624209093314934916138585153?+% 2624271256153914916135635603>+% 2624288750231614916154083553=+% 2624226929450494916178580423<+% 2624200940756214916121871043;+% 2624292702752694916132336463:+% 26242177592219549161440502639+% 26242069938213849161587441738+% 26242521973180549161685356137+% 26242380815552649161512663236+% 26242488191923949161425304835+% 26242756494901449161231731234+% 26242606016611949161233540533+% 26242589421173549161711487832+% 26242952890981149161848452231+% 26242074037119749161220132630+% 2624271148739204916155011133/+% 2624256118652234916110810323.+% 2624215785300384916108231833-+% 2624297181824594916106365853,+% 2624220013599524916143106283++% 2624214403827274916127520303*+% 2624202205190404916158008573)+% 2624262396730244916137471183(+% 2624268448421144916174286653'+% 2624222066657724916103322233&+% 2624280121293584916125442783%+% 2624210522403234916135560273$+% 2624219236219544916161253183#+% 2624236884675704916163561873"+% 2624276701972024916116467083!+% 2624213770416934916170531633 +% 2624242314709794916151208733+% 2624290048745734916184742083+% 2624206785640434916111463413+% 2624200416663144916172001573+% 2624232155831164916155465083+% 2624269799621584916157848703+% 2624220418485624916100646523+% 2624229434128424916174334643+% 2624290668653124916101614823+% 2624283610696264916172068033+% 2624227469908684916127375343+% 2624219897500024916170531773+% 2624275811980534916111244763+% 2624235622663604916120356183+% 2624298870299914916104378373+% 2624285152159554916178466063+% 2624225442998004916141281413+% 2624225015300754916176828513+% 2624237879908854916180777113 +% 2624216122181904916150100873 +% 2624205836208074916156700773 +% 2624207135423774916184665813 +% 2624236774082134916168310833 +% 2624298354495864916181868673+% 2624201206805094916111470733+% 2624242019728334916167063323+% 2624265431915684916107428503+% 2624220451368754916145006673+% 2624211477673284916165586863+% 2624228285825464916187654433+% 262427985182524491613401321[+%7 3262420001250761491618243057MSC-00-00-00-00-00-002024-06-26 08:26:47