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  IM9 = E U - e q !]   M   Y5 Q a   y u au 9 m 1 } A )  i%+262427394118440J+262425185475718I+262427375641077H+262427344652978G+262424896217915F+262423472252679E+262423732000300D+262423896817557C+262428503601356B+262422743918986A+262424644445866@+262426951690298?+262429343768090>+262422033594039=+262426495103846<+262423793601150;+262427185859016:+2624246963565069+2624243264238578+2624264832319477+2624240959743946+2624242648512305+2624268001305494+2624294473667073+2624203295047422+2624232321881141+2624288576224880+262423003744150/+262429469020994.+262428548504177-+262422647469265,+262428838635341++262421953040866*+262424005459430)+262429318203060(+262425278546529'+262427432672403&+262420821675253%+262427671817538$+262422131018303#+262425623545842"+262427409590567!+262426514792345 +262422193572019+262423836311384+262424877837678+262426708750727+262423028139519+262429042571423+262425362302342+262424548643869+262426232920078+262420910413054+262424585045712+262424067737750+262426499769117+262425553903794+262420163735221+262425232792758+262426929812586+262420520740248+262425123599525 +262428402056980 +262429724726602 +262421866088420 +262421487597033 +262426621266237+262427379248300+262427419889302+262421063449818+262428102200298+262427282422265+262424095837127+ 262425542147780 J  [ ' 8  7  k Z%G I6  F 9 Y l h  5 {$ & y  (  W J i } |Xz  j  H  680J%491616602233I%491613416532H%491617084614G%491610246611F%491613456218E%491617550814D%491618860875C%491611263504B%491616820363A%491614176135@%491611652484?%491613118501>%491613637631=%491614314563<%491618766851;%491610368387:%4916105730139%4916124713228%4916123785237%4916123336476%4916176423285%4916141068234%4916183224643%4916128260052%4916132374801%4916161220640%491616372843/%491618101618.%491610067503-%491616812121,%491616071564+%491610887285*%491618441144)%491613442332(%491618266488'%491615320112&%491614554510%%491613663107$%491617432572#%491614406870"%491610617063!%491617463650 %491611441274%491617124880%491611726348%491612403030%491612501300%491612405022%491617786233%491617453877%491617813775%491613424568%491618152001%491617221838%491613058580%491614854541%491610718776%491617124212%491612448611%491615078476%491615755232 %491615021648 %491613153428 %491617016680 %491614231855 %491616181605%491614865415%491610141614%491612811565%491618350844%491616573855%491614870338% 491613142838   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  IM9 = E U - e q !]   M   Y5 Q a   y u au 9 m 1 } A )  i%+262427394118440J+262425185475718I+262427375641077H+262427344652978G+262424896217915F+262423472252679E+262423732000300D+262423896817557C+262428503601356B+262422743918986A+262424644445866@+262426951690298?+262429343768090>+262422033594039=+262426495103846<+262423793601150;+262427185859016:+2624246963565069+2624243264238578+2624264832319477+2624240959743946+2624242648512305+2624268001305494+2624294473667073+2624203295047422+2624232321881141+2624288576224880+262423003744150/+262429469020994.+262428548504177-+262422647469265,+262428838635341++262421953040866*+262424005459430)+262429318203060(+262425278546529'+262427432672403&+262420821675253%+262427671817538$+262422131018303#+262425623545842"+262427409590567!+262426514792345 +262422193572019+262423836311384+262424877837678+262426708750727+262423028139519+262429042571423+262425362302342+262424548643869+262426232920078+262420910413054+262424585045712+262424067737750+262426499769117+262425553903794+262420163735221+262425232792758+262426929812586+262420520740248+262425123599525 +262428402056980 +262429724726602 +262421866088420 +262421487597033 +262426621266237+262427379248300+262427419889302+262421063449818+262428102200298+262427282422265+262424095837127+ 262425542147780 8J+) 26242739411844068012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624251854757184916166022333H+% 2624273756410774916134165323G+% 2624273446529784916170846143F+% 2624248962179154916102466113E+% 2624234722526794916134562183D+% 2624237320003004916175508143C+% 2624238968175574916188608753B+% 2624285036013564916112635043A+% 2624227439189864916168203633@+% 2624246444458664916141761353?+% 2624269516902984916116524843>+% 2624293437680904916131185013=+% 2624220335940394916136376313<+% 2624264951038464916143145633;+% 2624237936011504916187668513:+% 26242718585901649161036838739+% 26242469635650649161057301338+% 26242432642385749161247132237+% 26242648323194749161237852336+% 26242409597439449161233364735+% 26242426485123049161764232834+% 26242680013054949161410682333+% 26242944736670749161832246432+% 26242032950474249161282600531+% 26242323218811449161323748030+% 2624288576224884916161220643/+% 2624230037441504916163728433.+% 2624294690209944916181016183-+% 2624285485041774916100675033,+% 2624226474692654916168121213++% 2624288386353414916160715643*+% 2624219530408664916108872853)+% 2624240054594304916184411443(+% 2624293182030604916134423323'+% 2624252785465294916182664883&+% 2624274326724034916153201123%+% 2624208216752534916145545103$+% 2624276718175384916136631073#+% 2624221310183034916174325723"+% 2624256235458424916144068703!+% 2624274095905674916106170633 +% 2624265147923454916174636503+% 2624221935720194916114412743+% 2624238363113844916171248803+% 2624248778376784916117263483+% 2624267087507274916124030303+% 2624230281395194916125013003+% 2624290425714234916124050223+% 2624253623023424916177862333+% 2624245486438694916174538773+% 2624262329200784916178137753+% 2624209104130544916134245683+% 2624245850457124916181520013+% 2624240677377504916172218383+% 2624264997691174916130585803+% 2624255539037944916148545413+% 2624201637352214916107187763+% 2624252327927584916171242123+% 2624269298125864916124486113+% 2624205207402484916150784763 +% 2624251235995254916157552323 +% 2624284020569804916150216483 +% 2624297247266024916131534283 +% 2624218660884204916170166803 +% 2624214875970334916142318553+% 2624266212662374916161816053+% 2624273792483004916148654153+% 2624274198893024916101416143+% 2624210634498184916128115653+% 2624281022002984916183508443+% 2624272824222654916165738553+% 262424095837127491614870338[+%7 3262425542147780491613142838MSC-00-00-00-00-00-002024-11-04 08:56:06