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 EI i - u e = Y U  } Q  A )! 99 q m    u M  y5 1 aa   %  M]+262425093021930J+262427812422532I+262428765146187H+262421557857513G+262426029144627F+262426470527897E+262422643373807D+262426545757184C+262426037961629B+262427898391675A+262428862382870@+262426442033989?+262424826035972>+262422405850096=+262424151476855<+262421933100503;+262428390162323:+2624259003637779+2624218051387168+2624236912616277+2624239122076316+2624262139445865+2624289290615144+2624242494537703+2624295434314552+2624214775765061+2624243553098770+262423571971100/+262420653173984.+262423833502402-+262425384677646,+262429707311667++262423463794489*+262420343099938)+262420380362627(+262422471154127'+262429089324350&+262426354285091%+262428437045672$+262420022787108#+262422940891047"+262426158307836!+262427386113744 +262423375209669+262422502653761+262424198217771+262424627756306+262423561091807+262429293914065+262429021630368+262425039875709+262428422379361+262420282529955+262429993897886+262426009796207+262429651542331+262423763162279+262420780293270+262420170488220+262429631222230+262427759316368+262424910435606 +262420669946947 +262429304266654 +262425152020860 +262429740564822 +262428820803089+262427552915073+262428293051104+262429677894059+262429342877136+262422151106637+262429397313912+ 262427114697771 J k Z y {i G  9  l 6 ( j I | F  Jh ' 8 % Y  z &   75X$ } H W [208J%491612178538I%491611216422H%491614748111G%491618607717F%491611572627E%491618141568D%491613647076C%491617060501B%491617320153A%491610122576@%491618377171?%491614840567>%491614077404=%491611148200<%491617456405;%491615607614:%4916158575469%4916128077278%4916100748327%4916100233406%4916130816235%4916151648754%4916162122783%4916140331252%4916181608471%4916116838440%491616574012/%491618434724.%491617217665-%491611381854,%491617285700+%491617472221*%491618232352)%491616546323(%491612566608'%491610353007&%491614204144%%491612687607$%491610727573#%491610311871"%491612617381!%491614368630 %491614018152%491618437800%491611868717%491616406880%491611810851%491611137886%491617886301%491610374872%491617282372%491614535818%491613483187%491617345714%491617058721%491612483715%491610562655%491617235626%491614731605%491617578738%491618033782 %491617614626 %491614301326 %491618457083 %491614748622 %491610232211%491611635827%491612378316%491614560761%491618742730%491611544321%491611485806% 491610064086   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 EI i - u e = Y U  } Q  A )! 99 q m    u M  y5 1 aa   %  M]+262425093021930J+262427812422532I+262428765146187H+262421557857513G+262426029144627F+262426470527897E+262422643373807D+262426545757184C+262426037961629B+262427898391675A+262428862382870@+262426442033989?+262424826035972>+262422405850096=+262424151476855<+262421933100503;+262428390162323:+2624259003637779+2624218051387168+2624236912616277+2624239122076316+2624262139445865+2624289290615144+2624242494537703+2624295434314552+2624214775765061+2624243553098770+262423571971100/+262420653173984.+262423833502402-+262425384677646,+262429707311667++262423463794489*+262420343099938)+262420380362627(+262422471154127'+262429089324350&+262426354285091%+262428437045672$+262420022787108#+262422940891047"+262426158307836!+262427386113744 +262423375209669+262422502653761+262424198217771+262424627756306+262423561091807+262429293914065+262429021630368+262425039875709+262428422379361+262420282529955+262429993897886+262426009796207+262429651542331+262423763162279+262420780293270+262420170488220+262429631222230+262427759316368+262424910435606 +262420669946947 +262429304266654 +262425152020860 +262429740564822 +262428820803089+262427552915073+262428293051104+262429677894059+262429342877136+262422151106637+262429397313912+ 262427114697771 8J+) 26242509302193020812345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624278124225324916121785383H+% 2624287651461874916112164223G+% 2624215578575134916147481113F+% 2624260291446274916186077173E+% 2624264705278974916115726273D+% 2624226433738074916181415683C+% 2624265457571844916136470763B+% 2624260379616294916170605013A+% 2624278983916754916173201533@+% 2624288623828704916101225763?+% 2624264420339894916183771713>+% 2624248260359724916148405673=+% 2624224058500964916140774043<+% 2624241514768554916111482003;+% 2624219331005034916174564053:+% 26242839016232349161560761439+% 26242590036377749161585754638+% 26242180513871649161280772737+% 26242369126162749161007483236+% 26242391220763149161002334035+% 26242621394458649161308162334+% 26242892906151449161516487533+% 26242424945377049161621227832+% 26242954343145549161403312531+% 26242147757650649161816084730+% 2624243553098774916116838443/+% 2624235719711004916165740123.+% 2624206531739844916184347243-+% 2624238335024024916172176653,+% 2624253846776464916113818543++% 2624297073116674916172857003*+% 2624234637944894916174722213)+% 2624203430999384916182323523(+% 2624203803626274916165463233'+% 2624224711541274916125666083&+% 2624290893243504916103530073%+% 2624263542850914916142041443$+% 2624284370456724916126876073#+% 2624200227871084916107275733"+% 2624229408910474916103118713!+% 2624261583078364916126173813 +% 2624273861137444916143686303+% 2624233752096694916140181523+% 2624225026537614916184378003+% 2624241982177714916118687173+% 2624246277563064916164068803+% 2624235610918074916118108513+% 2624292939140654916111378863+% 2624290216303684916178863013+% 2624250398757094916103748723+% 2624284223793614916172823723+% 2624202825299554916145358183+% 2624299938978864916134831873+% 2624260097962074916173457143+% 2624296515423314916170587213+% 2624237631622794916124837153+% 2624207802932704916105626553+% 2624201704882204916172356263+% 2624296312222304916147316053+% 2624277593163684916175787383 +% 2624249104356064916180337823 +% 2624206699469474916176146263 +% 2624293042666544916143013263 +% 2624251520208604916184570833 +% 2624297405648224916147486223+% 2624288208030894916102322113+% 2624275529150734916116358273+% 2624282930511044916123783163+% 2624296778940594916145607613+% 2624293428771364916187427303+% 2624221511066374916115443213+% 262429397313912491611485806[+%7 3262427114697771491610064086MSC-00-00-00-00-00-002024-11-07 12:26:09