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! u e  -% }  q  I i m U = 9a Q M 9 5  A  Y ]  u  E M 1 y )+262423888888148J+262429583185611I+262420072202502H+262420581710367G+262427392622048F+262426780295445E+262420443432994D+262427272921316C+262426722095768B+262420793834727A+262429089685811@+262427285279515?+262429989162165>+262423886101763=+262425109791480<+262420695398463;+262429978457701:+2624216541389229+2624294225615658+2624275764180347+2624223038154496+2624231801909275+2624230538623074+2624227320638093+2624256830777242+2624212288177311+2624272372568330+262423472348404/+262423344876869.+262421531344163-+262426225304788,+262425784926503++262426530862579*+262428639178161)+262422004215861(+262429381371165'+262420421660967&+262420823606993%+262429754336966$+262429217576388#+262427299408817"+262423454313041!+262429483222482 +262426692647025+262422853630530+262425315677626+262425266832729+262423344984380+262420292857894+262428967294995+262420197541127+262426677361666+262423273791119+262427672247388+262422609253731+262421230162150+262426873697969+262420865571349+262423310676978+262429832154125+262428976045885+262421230748844 +262428979508387 +262421302144890 +262426508145193 +262425685578394 +262423963727842+262428998397097+262423540422604+262424811280651+262420185268089+262427747859460+262426587009817+ 262421866684116 J 9 [  y i  {  (5 W J  z 8 GFh H I$  } Y6  l Z & ' %  k X   j 7 |413J%491611886383I%491610203838H%491612531652G%491610300231F%491617080002E%491615843263D%491610201487C%491610581303B%491615551557A%491614705518@%491617063475?%491618223565>%491617524808=%491610622762<%491613026128;%491617416722:%4916136275809%4916144382148%4916172257737%4916182703016%4916188635325%4916136742634%4916112464263%4916184328042%4916138024331%4916133171340%491618300400/%491617513384.%491611835411-%491611466107,%491617321476+%491618843118*%491614406503)%491616217041(%491618826784'%491611745843&%491610328115%%491616787425$%491610632207#%491611408381"%491618643062!%491617423370 %491612372233%491612757318%491616186872%491618011123%491616471086%491613826550%491618365761%491611427748%491613333705%491618451576%491616850582%491618225003%491610262336%491611542376%491616145275%491613877721%491617160280%491613363860%491614467426 %491612082556 %491614051366 %491612375622 %491614233138 %491611277040%491613851430%491618810342%491610312762%491616805271%491616531104%491614827618% 491613536020   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! u e  -% }  q  I i m U = 9a Q M 9 5  A  Y ]  u  E M 1 y )+262423888888148J+262429583185611I+262420072202502H+262420581710367G+262427392622048F+262426780295445E+262420443432994D+262427272921316C+262426722095768B+262420793834727A+262429089685811@+262427285279515?+262429989162165>+262423886101763=+262425109791480<+262420695398463;+262429978457701:+2624216541389229+2624294225615658+2624275764180347+2624223038154496+2624231801909275+2624230538623074+2624227320638093+2624256830777242+2624212288177311+2624272372568330+262423472348404/+262423344876869.+262421531344163-+262426225304788,+262425784926503++262426530862579*+262428639178161)+262422004215861(+262429381371165'+262420421660967&+262420823606993%+262429754336966$+262429217576388#+262427299408817"+262423454313041!+262429483222482 +262426692647025+262422853630530+262425315677626+262425266832729+262423344984380+262420292857894+262428967294995+262420197541127+262426677361666+262423273791119+262427672247388+262422609253731+262421230162150+262426873697969+262420865571349+262423310676978+262429832154125+262428976045885+262421230748844 +262428979508387 +262421302144890 +262426508145193 +262425685578394 +262423963727842+262428998397097+262423540422604+262424811280651+262420185268089+262427747859460+262426587009817+ 262421866684116 8J+) 26242388888814841312345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624295831856114916118863833H+% 2624200722025024916102038383G+% 2624205817103674916125316523F+% 2624273926220484916103002313E+% 2624267802954454916170800023D+% 2624204434329944916158432633C+% 2624272729213164916102014873B+% 2624267220957684916105813033A+% 2624207938347274916155515573@+% 2624290896858114916147055183?+% 2624272852795154916170634753>+% 2624299891621654916182235653=+% 2624238861017634916175248083<+% 2624251097914804916106227623;+% 2624206953984634916130261283:+% 26242997845770149161741672239+% 26242165413892249161362758038+% 26242942256156549161443821437+% 26242757641803449161722577336+% 26242230381544949161827030135+% 26242318019092749161886353234+% 26242305386230749161367426333+% 26242273206380949161124642632+% 26242568307772449161843280431+% 26242122881773149161380243330+% 2624272372568334916133171343/+% 2624234723484044916183004003.+% 2624233448768694916175133843-+% 2624215313441634916118354113,+% 2624262253047884916114661073++% 2624257849265034916173214763*+% 2624265308625794916188431183)+% 2624286391781614916144065033(+% 2624220042158614916162170413'+% 2624293813711654916188267843&+% 2624204216609674916117458433%+% 2624208236069934916103281153$+% 2624297543369664916167874253#+% 2624292175763884916106322073"+% 2624272994088174916114083813!+% 2624234543130414916186430623 +% 2624294832224824916174233703+% 2624266926470254916123722333+% 2624228536305304916127573183+% 2624253156776264916161868723+% 2624252668327294916180111233+% 2624233449843804916164710863+% 2624202928578944916138265503+% 2624289672949954916183657613+% 2624201975411274916114277483+% 2624266773616664916133337053+% 2624232737911194916184515763+% 2624276722473884916168505823+% 2624226092537314916182250033+% 2624212301621504916102623363+% 2624268736979694916115423763+% 2624208655713494916161452753+% 2624233106769784916138777213+% 2624298321541254916171602803+% 2624289760458854916133638603 +% 2624212307488444916144674263 +% 2624289795083874916120825563 +% 2624213021448904916140513663 +% 2624265081451934916123756223 +% 2624256855783944916142331383+% 2624239637278424916112770403+% 2624289983970974916138514303+% 2624235404226044916188103423+% 2624248112806514916103127623+% 2624201852680894916168052713+% 2624277478594604916165311043+% 262426587009817491614827618[+%7 3262421866684116491613536020MSC-00-00-00-00-00-002024-11-01 16:03:00