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 9I   m  A u %!M  a }  5a y - 1  u    ] Q9 Y ) E q = M 9  i e  U+262428514021623J+262428320980854I+262422850433600H+262421715501770G+262421895171169F+262426171101200E+262420864926926D+262428085659369C+262425780283914B+262425599830388A+262428595707671@+262422736060790?+262427856936118>+262428307963919=+262427049029510<+262428871321580;+262424098784887:+2624229343020379+2624296703204528+2624222135075527+2624209808311296+2624267108797945+2624213379424064+2624253535654173+2624236928286952+2624243870047951+2624214979072610+262429792539238/+262428689244143.+262423426148963-+262423792167686,+262425590500865++262421180347178*+262424225166949)+262425082046528(+262429541318195'+262425717598908&+262429401170911%+262425072661657$+262428066413105#+262427832100530"+262421101460678!+262428482627899 +262429210749515+262429772390377+262422766101946+262420188931112+262425067495116+262429102434121+262426172937075+262422575754313+262424055579940+262420127960734+262426474116025+262428304053372+262420952357069+262428411614283+262425902726765+262421405235707+262427715085302+262424592455513+262425507314120 +262428874895973 +262422442938884 +262427486833662 +262422628923739 +262424077798713+262425644646191+262429056944941+262428729971088+262425743905110+262422459436378+262420273442678+ 262425656270769 J F (  l '  } h Xy H  Y   & k { [z J 8  9 5 G6 7% Zi I$  |W j099J%491610676503I%491616128187H%491615471786G%491614555306F%491612155367E%491613067666D%491613386350C%491616252774B%491610758806A%491612133675@%491610881784?%491613586632>%491613415184=%491615703570<%491617784464;%491612168564:%4916155562059%4916175487128%4916170262847%4916144400786%4916178525075%4916143332114%4916138017563%4916120806832%4916143846711%4916141481250%491612301127/%491615617448.%491613253828-%491612445837,%491614431065+%491616800545*%491613786400)%491614057676(%491618888810'%491614472772&%491612776375%%491611075527$%491614523335#%491618848071"%491612258853!%491614374472 %491616428168%491616057133%491616868330%491617023265%491616718317%491616717745%491613586865%491617086167%491614618654%491618031012%491615743261%491612207334%491614756167%491614388667%491618712010%491610082141%491616583301%491611154241%491617710524 %491616374385 %491610643715 %491618520104 %491613365604 %491613677536%491614752103%491618223488%491610020851%491614163288%491613077046%491616023778% 491613851725   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 9I   m  A u %!M  a }  5a y - 1  u    ] Q9 Y ) E q = M 9  i e  U+262428514021623J+262428320980854I+262422850433600H+262421715501770G+262421895171169F+262426171101200E+262420864926926D+262428085659369C+262425780283914B+262425599830388A+262428595707671@+262422736060790?+262427856936118>+262428307963919=+262427049029510<+262428871321580;+262424098784887:+2624229343020379+2624296703204528+2624222135075527+2624209808311296+2624267108797945+2624213379424064+2624253535654173+2624236928286952+2624243870047951+2624214979072610+262429792539238/+262428689244143.+262423426148963-+262423792167686,+262425590500865++262421180347178*+262424225166949)+262425082046528(+262429541318195'+262425717598908&+262429401170911%+262425072661657$+262428066413105#+262427832100530"+262421101460678!+262428482627899 +262429210749515+262429772390377+262422766101946+262420188931112+262425067495116+262429102434121+262426172937075+262422575754313+262424055579940+262420127960734+262426474116025+262428304053372+262420952357069+262428411614283+262425902726765+262421405235707+262427715085302+262424592455513+262425507314120 +262428874895973 +262422442938884 +262427486833662 +262422628923739 +262424077798713+262425644646191+262429056944941+262428729971088+262425743905110+262422459436378+262420273442678+ 262425656270769 8J+) 26242851402162309912345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624283209808544916106765033H+% 2624228504336004916161281873G+% 2624217155017704916154717863F+% 2624218951711694916145553063E+% 2624261711012004916121553673D+% 2624208649269264916130676663C+% 2624280856593694916133863503B+% 2624257802839144916162527743A+% 2624255998303884916107588063@+% 2624285957076714916121336753?+% 2624227360607904916108817843>+% 2624278569361184916135866323=+% 2624283079639194916134151843<+% 2624270490295104916157035703;+% 2624288713215804916177844643:+% 26242409878488749161216856439+% 26242293430203749161555620538+% 26242967032045249161754871237+% 26242221350755249161702628436+% 26242098083112949161444007835+% 26242671087979449161785250734+% 26242133794240649161433321133+% 26242535356541749161380175632+% 26242369282869549161208068331+% 26242438700479549161438467130+% 2624214979072614916141481253/+% 2624297925392384916123011273.+% 2624286892441434916156174483-+% 2624234261489634916132538283,+% 2624237921676864916124458373++% 2624255905008654916144310653*+% 2624211803471784916168005453)+% 2624242251669494916137864003(+% 2624250820465284916140576763'+% 2624295413181954916188888103&+% 2624257175989084916144727723%+% 2624294011709114916127763753$+% 2624250726616574916110755273#+% 2624280664131054916145233353"+% 2624278321005304916188480713!+% 2624211014606784916122588533 +% 2624284826278994916143744723+% 2624292107495154916164281683+% 2624297723903774916160571333+% 2624227661019464916168683303+% 2624201889311124916170232653+% 2624250674951164916167183173+% 2624291024341214916167177453+% 2624261729370754916135868653+% 2624225757543134916170861673+% 2624240555799404916146186543+% 2624201279607344916180310123+% 2624264741160254916157432613+% 2624283040533724916122073343+% 2624209523570694916147561673+% 2624284116142834916143886673+% 2624259027267654916187120103+% 2624214052357074916100821413+% 2624277150853024916165833013+% 2624245924555134916111542413 +% 2624255073141204916177105243 +% 2624288748959734916163743853 +% 2624224429388844916106437153 +% 2624274868336624916185201043 +% 2624226289237394916133656043+% 2624240777987134916136775363+% 2624256446461914916147521033+% 2624290569449414916182234883+% 2624287299710884916100208513+% 2624257439051104916141632883+% 2624224594363784916130770463+% 262420273442678491616023778[+%7 3262425656270769491613851725MSC-00-00-00-00-00-002024-10-04 05:56:06