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 i   e ] %a 1 ) } M  m M u - Y   9 q u A Q    y = U95 E  I !   a+262425098401678J+262423270633602I+262429925036486H+262423403288016G+262425018924035F+262421241017855E+262420375912975D+262423009097365C+262429390048703B+262428971428829A+262427724073556@+262421242354021?+262421995370908>+262427809855818=+262426893106348<+262420826702923;+262427788352510:+2624246666684239+2624287663315408+2624222323581357+2624253978538286+2624202158454425+2624233086781164+2624276690655973+2624297004964782+2624239663213961+2624264393403150+262427813601342/+262420137823962.+262422338473910-+262421463984360,+262428806323615++262420147609721*+262423643512725)+262422306175818(+262426014078079'+262427441789445&+262428501488180%+262421633344786$+262428465530335#+262424179383640"+262422960359641!+262422399152204 +262422558386392+262429830990214+262424580914776+262422416827185+262422856167867+262427081411804+262424863897415+262429145182399+262428376702208+262428811906804+262421431671560+262425960382140+262424400544228+262427229965721+262429688438591+262427974239929+262426292003758+262421390123423+262422897349833 +262420633554942 +262421477060883 +262428272436812 +262422456743626 +262421530033644+262426366209276+262420158269261+262420104250425+262426514142967+262428748246307+262424659860658+ 262424722876089 J 7z H5 Zi  8 [X $6  % I ( ' G  h J  Y } j  W l &  k 9 |F y {476J%491614043136I%491617830528H%491614767318G%491612448467F%491616352407E%491615185581D%491614072400C%491614804156B%491615256381A%491615861267@%491618675253?%491618656370>%491613535871=%491614563155<%491616451463;%491614307753:%4916122288379%4916138876458%4916120315167%4916167247236%4916185406775%4916152284554%4916112457173%4916113585522%4916146240881%4916155363570%491616028565/%491618521542.%491614340468-%491615062403,%491616357263+%491610672102*%491611582371)%491615106138(%491615570655'%491618853810&%491616137754%%491612666845$%491612122606#%491613615458"%491611446162!%491613432180 %491614078036%491611854228%491616345610%491613864476%491613312728%491614372781%491612462657%491612033151%491610762817%491618457062%491610776471%491610825674%491614063177%491617060380%491610782066%491617485575%491618477273%491613503786%491613034545 %491611841171 %491618633106 %491616268384 %491614638285 %491618713040%491617375856%491612206575%491617010486%491616120224%491617347068%491615222305% 491613847143   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 i   e ] %a 1 ) } M  m M u - Y   9 q u A Q    y = U95 E  I !   a+262425098401678J+262423270633602I+262429925036486H+262423403288016G+262425018924035F+262421241017855E+262420375912975D+262423009097365C+262429390048703B+262428971428829A+262427724073556@+262421242354021?+262421995370908>+262427809855818=+262426893106348<+262420826702923;+262427788352510:+2624246666684239+2624287663315408+2624222323581357+2624253978538286+2624202158454425+2624233086781164+2624276690655973+2624297004964782+2624239663213961+2624264393403150+262427813601342/+262420137823962.+262422338473910-+262421463984360,+262428806323615++262420147609721*+262423643512725)+262422306175818(+262426014078079'+262427441789445&+262428501488180%+262421633344786$+262428465530335#+262424179383640"+262422960359641!+262422399152204 +262422558386392+262429830990214+262424580914776+262422416827185+262422856167867+262427081411804+262424863897415+262429145182399+262428376702208+262428811906804+262421431671560+262425960382140+262424400544228+262427229965721+262429688438591+262427974239929+262426292003758+262421390123423+262422897349833 +262420633554942 +262421477060883 +262428272436812 +262422456743626 +262421530033644+262426366209276+262420158269261+262420104250425+262426514142967+262428748246307+262424659860658+ 262424722876089 8J+) 26242509840167847612345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624232706336024916140431363H+% 2624299250364864916178305283G+% 2624234032880164916147673183F+% 2624250189240354916124484673E+% 2624212410178554916163524073D+% 2624203759129754916151855813C+% 2624230090973654916140724003B+% 2624293900487034916148041563A+% 2624289714288294916152563813@+% 2624277240735564916158612673?+% 2624212423540214916186752533>+% 2624219953709084916186563703=+% 2624278098558184916135358713<+% 2624268931063484916145631553;+% 2624208267029234916164514633:+% 26242778835251049161430775339+% 26242466666842349161222883738+% 26242876633154049161388764537+% 26242223235813549161203151636+% 26242539785382849161672472335+% 26242021584544249161854067734+% 26242330867811649161522845533+% 26242766906559749161124571732+% 26242970049647849161135855231+% 26242396632139649161462408830+% 2624264393403154916155363573/+% 2624278136013424916160285653.+% 2624201378239624916185215423-+% 2624223384739104916143404683,+% 2624214639843604916150624033++% 2624288063236154916163572633*+% 2624201476097214916106721023)+% 2624236435127254916115823713(+% 2624223061758184916151061383'+% 2624260140780794916155706553&+% 2624274417894454916188538103%+% 2624285014881804916161377543$+% 2624216333447864916126668453#+% 2624284655303354916121226063"+% 2624241793836404916136154583!+% 2624229603596414916114461623 +% 2624223991522044916134321803+% 2624225583863924916140780363+% 2624298309902144916118542283+% 2624245809147764916163456103+% 2624224168271854916138644763+% 2624228561678674916133127283+% 2624270814118044916143727813+% 2624248638974154916124626573+% 2624291451823994916120331513+% 2624283767022084916107628173+% 2624288119068044916184570623+% 2624214316715604916107764713+% 2624259603821404916108256743+% 2624244005442284916140631773+% 2624272299657214916170603803+% 2624296884385914916107820663+% 2624279742399294916174855753+% 2624262920037584916184772733+% 2624213901234234916135037863 +% 2624228973498334916130345453 +% 2624206335549424916118411713 +% 2624214770608834916186331063 +% 2624282724368124916162683843 +% 2624224567436264916146382853+% 2624215300336444916187130403+% 2624263662092764916173758563+% 2624201582692614916122065753+% 2624201042504254916170104863+% 2624265141429674916161202243+% 2624287482463074916173470683+% 262424659860658491615222305[+%7 3262424722876089491613847143MSC-00-00-00-00-00-002024-10-23 05:56:06