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 a e M  E a5 } u  uq A!  i )  Q  M   y 9 9 U 1 Y m%I  =  -] +262427349739213J+262425217867409I+262420139221830H+262421840160302G+262424849327663F+262425551328804E+262427333181423D+262422214606492C+262429847231057B+262422161801960A+262428910024343@+262423636586084?+262423871841743>+262428996324187=+262424706988196<+262420190225085;+262426931638324:+2624274972214499+2624245974197208+2624244984517827+2624229260880366+2624279741323345+2624263079108274+2624293901599783+2624263962208762+2624297200617691+2624235246982120+262428015948978/+262423700019971.+262421757085409-+262428156823623,+262420252840075++262425215471231*+262421375697682)+262422141913119(+262423708381878'+262424821264547&+262424659224146%+262428231977508$+262421280098885#+262428235635435"+262428235713821!+262425730073895 +262424965701626+262428111438373+262420853996166+262425836512378+262427226183692+262421383200526+262420812033098+262423549288313+262421497059375+262428675018074+262429780908577+262423369680596+262429750486716+262421033670239+262421928774785+262428931588594+262425950780938+262421384372179+262423461085537 +262427182955748 +262428564683152 +262427828981610 +262420613183669 +262421433322133+262423312532294+262422445746428+262424872638219+262421744497172+262428273032452+262420597448657+ 262428835747482 J } hW6$ Z IFi  l 7  [ H & {  9 Y X | k 8 G  J j '%z y 5 ( 967J%491618518200I%491614083168H%491617415285G%491613253368F%491612734740E%491610407855D%491616045333C%491614781003B%491616680711A%491610124766@%491618412546?%491613865502>%491611471640=%491610568215<%491613218757;%491617846864:%4916163877459%4916115444608%4916114406517%4916157433586%4916157346525%4916172851204%4916130683003%4916162422162%4916126242331%4916160411150%491616300633/%491612672115.%491614061116-%491612160847,%491613547573+%491612857327*%491613405400)%491614775228(%491617580740'%491613555603&%491612783456%%491614326308$%491617243584#%491617341832"%491618367626!%491614610558 %491610064300%491618452488%491618253660%491618061468%491610877178%491617063528%491615424108%491611741658%491618348236%491611462884%491613670580%491618513363%491615677203%491612034217%491616432038%491617687025%491610776815%491611144542%491611341611 %491618508516 %491611561656 %491610833205 %491610700582 %491618404616%491617806385%491616800115%491617270540%491615365758%491615788723%491613701421% 491612166531   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 a e M  E a5 } u  uq A!  i )  Q  M   y 9 9 U 1 Y m%I  =  -] +262427349739213J+262425217867409I+262420139221830H+262421840160302G+262424849327663F+262425551328804E+262427333181423D+262422214606492C+262429847231057B+262422161801960A+262428910024343@+262423636586084?+262423871841743>+262428996324187=+262424706988196<+262420190225085;+262426931638324:+2624274972214499+2624245974197208+2624244984517827+2624229260880366+2624279741323345+2624263079108274+2624293901599783+2624263962208762+2624297200617691+2624235246982120+262428015948978/+262423700019971.+262421757085409-+262428156823623,+262420252840075++262425215471231*+262421375697682)+262422141913119(+262423708381878'+262424821264547&+262424659224146%+262428231977508$+262421280098885#+262428235635435"+262428235713821!+262425730073895 +262424965701626+262428111438373+262420853996166+262425836512378+262427226183692+262421383200526+262420812033098+262423549288313+262421497059375+262428675018074+262429780908577+262423369680596+262429750486716+262421033670239+262421928774785+262428931588594+262425950780938+262421384372179+262423461085537 +262427182955748 +262428564683152 +262427828981610 +262420613183669 +262421433322133+262423312532294+262422445746428+262424872638219+262421744497172+262428273032452+262420597448657+ 262428835747482 8J+) 26242734973921396712345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624252178674094916185182003H+% 2624201392218304916140831683G+% 2624218401603024916174152853F+% 2624248493276634916132533683E+% 2624255513288044916127347403D+% 2624273331814234916104078553C+% 2624222146064924916160453333B+% 2624298472310574916147810033A+% 2624221618019604916166807113@+% 2624289100243434916101247663?+% 2624236365860844916184125463>+% 2624238718417434916138655023=+% 2624289963241874916114716403<+% 2624247069881964916105682153;+% 2624201902250854916132187573:+% 26242693163832449161784686439+% 26242749722144949161638774538+% 26242459741972049161154446037+% 26242449845178249161144065136+% 26242292608803649161574335835+% 26242797413233449161573465234+% 26242630791082749161728512033+% 26242939015997849161306830032+% 26242639622087649161624221631+% 26242972006176949161262423330+% 2624235246982124916160411153/+% 2624280159489784916163006333.+% 2624237000199714916126721153-+% 2624217570854094916140611163,+% 2624281568236234916121608473++% 2624202528400754916135475733*+% 2624252154712314916128573273)+% 2624213756976824916134054003(+% 2624221419131194916147752283'+% 2624237083818784916175807403&+% 2624248212645474916135556033%+% 2624246592241464916127834563$+% 2624282319775084916143263083#+% 2624212800988854916172435843"+% 2624282356354354916173418323!+% 2624282357138214916183676263 +% 2624257300738954916146105583+% 2624249657016264916100643003+% 2624281114383734916184524883+% 2624208539961664916182536603+% 2624258365123784916180614683+% 2624272261836924916108771783+% 2624213832005264916170635283+% 2624208120330984916154241083+% 2624235492883134916117416583+% 2624214970593754916183482363+% 2624286750180744916114628843+% 2624297809085774916136705803+% 2624233696805964916185133633+% 2624297504867164916156772033+% 2624210336702394916120342173+% 2624219287747854916164320383+% 2624289315885944916176870253+% 2624259507809384916107768153+% 2624213843721794916111445423 +% 2624234610855374916113416113 +% 2624271829557484916185085163 +% 2624285646831524916115616563 +% 2624278289816104916108332053 +% 2624206131836694916107005823+% 2624214333221334916184046163+% 2624233125322944916178063853+% 2624224457464284916168001153+% 2624248726382194916172705403+% 2624217444971724916153657583+% 2624282730324524916157887233+% 262420597448657491613701421[+%7 3262428835747482491612166531MSC-00-00-00-00-00-002024-11-03 08:56:06