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 1  i ) =]! 95 9  qM  u  } - E %I  m    u y U M Y Aa  e a Q +262421790159551J+262428210365286I+262429658169254H+262422477170778G+262427958901083F+262422110812872E+262424976191085D+262422142804323C+262426873298272B+262420449556474A+262422391074027@+262421534985777?+262420941102640>+262421332541185=+262429671886667<+262429548568288;+262427526335195:+2624248421013099+2624202275070428+2624244382708117+2624274945171166+2624262488376615+2624256188204084+2624289791628683+2624227084751832+2624229160597831+2624285658176810+262427565399825/+262420807740102.+262422722482567-+262425159252781,+262426524042045++262423887600789*+262424823274498)+262422411126382(+262429725563923'+262429244411979&+262420521539751%+262420481241213$+262423786777145#+262428435742584"+262425197542122!+262426524282562 +262425962342877+262426451877704+262423735355824+262421149967424+262420098273308+262426678337407+262421960927766+262421432364787+262421786022939+262424273731723+262421392637948+262422168061502+262422966138830+262425081242185+262425534241322+262428814877819+262426228011923+262428906550772+262425676796014 +262425203390146 +262423895947703 +262421702832174 +262422201258100 +262428584357417+262426600579076+262429030833402+262425925837363+262423704941422+262426372648287+262422123599309+ 262427587002037 J | {56 [  &XW F   8 ( H i 9 hz%y J  $ } j Z   Y  'G k I l  7  687J%491612460677I%491613016767H%491614061311G%491611356600F%491617437205E%491614874513D%491612068240C%491615850750B%491615533345A%491614506218@%491615421070?%491617012050>%491611677683=%491615666834<%491612404243;%491617118077:%4916124361009%4916173017448%4916154876837%4916172782806%4916101525285%4916146771674%4916127771733%4916183284332%4916157056371%4916170864100%491617362686/%491615214743.%491617670017-%491612263706,%491611738801+%491617753757*%491612621801)%491616035718(%491615015628'%491610534183&%491615742637%%491615456766$%491610262155#%491618864402"%491612214683!%491616735535 %491613131275%491617823406%491614558265%491613613220%491611067542%491617152382%491611850276%491612873880%491613603753%491616743452%491612624323%491616307151%491614313783%491613014026%491610743140%491618656221%491616215207%491612627604%491614842232 %491611016058 %491612076432 %491611886661 %491613557053 %491614043745%491617167326%491615763531%491613616832%491616173311%491612756415%491613526447% 491611678143   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 1  i ) =]! 95 9  qM  u  } - E %I  m    u y U M Y Aa  e a Q +262421790159551J+262428210365286I+262429658169254H+262422477170778G+262427958901083F+262422110812872E+262424976191085D+262422142804323C+262426873298272B+262420449556474A+262422391074027@+262421534985777?+262420941102640>+262421332541185=+262429671886667<+262429548568288;+262427526335195:+2624248421013099+2624202275070428+2624244382708117+2624274945171166+2624262488376615+2624256188204084+2624289791628683+2624227084751832+2624229160597831+2624285658176810+262427565399825/+262420807740102.+262422722482567-+262425159252781,+262426524042045++262423887600789*+262424823274498)+262422411126382(+262429725563923'+262429244411979&+262420521539751%+262420481241213$+262423786777145#+262428435742584"+262425197542122!+262426524282562 +262425962342877+262426451877704+262423735355824+262421149967424+262420098273308+262426678337407+262421960927766+262421432364787+262421786022939+262424273731723+262421392637948+262422168061502+262422966138830+262425081242185+262425534241322+262428814877819+262426228011923+262428906550772+262425676796014 +262425203390146 +262423895947703 +262421702832174 +262422201258100 +262428584357417+262426600579076+262429030833402+262425925837363+262423704941422+262426372648287+262422123599309+ 262427587002037 8J+) 26242179015955168712345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624282103652864916124606773H+% 2624296581692544916130167673G+% 2624224771707784916140613113F+% 2624279589010834916113566003E+% 2624221108128724916174372053D+% 2624249761910854916148745133C+% 2624221428043234916120682403B+% 2624268732982724916158507503A+% 2624204495564744916155333453@+% 2624223910740274916145062183?+% 2624215349857774916154210703>+% 2624209411026404916170120503=+% 2624213325411854916116776833<+% 2624296718866674916156668343;+% 2624295485682884916124042433:+% 26242752633519549161711807739+% 26242484210130949161243610038+% 26242022750704249161730174437+% 26242443827081149161548768336+% 26242749451711649161727828035+% 26242624883766149161015252834+% 26242561882040849161467716733+% 26242897916286849161277717332+% 26242270847518349161832843331+% 26242291605978349161570563730+% 2624285658176814916170864103/+% 2624275653998254916173626863.+% 2624208077401024916152147433-+% 2624227224825674916176700173,+% 2624251592527814916122637063++% 2624265240420454916117388013*+% 2624238876007894916177537573)+% 2624248232744984916126218013(+% 2624224111263824916160357183'+% 2624297255639234916150156283&+% 2624292444119794916105341833%+% 2624205215397514916157426373$+% 2624204812412134916154567663#+% 2624237867771454916102621553"+% 2624284357425844916188644023!+% 2624251975421224916122146833 +% 2624265242825624916167355353+% 2624259623428774916131312753+% 2624264518777044916178234063+% 2624237353558244916145582653+% 2624211499674244916136132203+% 2624200982733084916110675423+% 2624266783374074916171523823+% 2624219609277664916118502763+% 2624214323647874916128738803+% 2624217860229394916136037533+% 2624242737317234916167434523+% 2624213926379484916126243233+% 2624221680615024916163071513+% 2624229661388304916143137833+% 2624250812421854916130140263+% 2624255342413224916107431403+% 2624288148778194916186562213+% 2624262280119234916162152073+% 2624289065507724916126276043 +% 2624256767960144916148422323 +% 2624252033901464916110160583 +% 2624238959477034916120764323 +% 2624217028321744916118866613 +% 2624222012581004916135570533+% 2624285843574174916140437453+% 2624266005790764916171673263+% 2624290308334024916157635313+% 2624259258373634916136168323+% 2624237049414224916161733113+% 2624263726482874916127564153+% 262422123599309491613526447[+%7 3262427587002037491611678143MSC-00-00-00-00-00-002024-10-29 05:56:06