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 95   = } e y m uq M ) I!    a  - E 9u% 1  A ] i U Y Ma 9  Q+262429341535373J+262429115548617I+262424551288686H+262422563953062G+262428213568930F+262423957022129E+262424060168548D+262420111315717C+262424832493174B+262427751542804A+262429499847735@+262424228869123?+262423408247196>+262420883481520=+262429576170667<+262421355389972;+262421523116343:+2624262417672639+2624215157563668+2624281770636737+2624265667496596+2624279020793365+2624208305707654+2624266609512453+2624208510071492+2624246538658201+2624267948211850+262428620385388/+262428505253505.+262421169781362-+262423491637988,+262422743267713++262427850380191*+262423950740934)+262422308620079(+262426665902453'+262427283080753&+262424562128462%+262426260142281$+262425095718912#+262429019437159"+262421693234858!+262425111740507 +262425028716225+262422525478685+262423536605582+262424986556388+262423844552411+262427287300441+262422739456895+262423680988410+262420022497317+262423653390438+262428503139680+262422728147607+262423343514625+262420348621533+262424090492311+262420045050196+262423856688708+262421695895107+262429154948801 +262420933138891 +262425699102477 +262425175997182 +262423302002306 +262429186276409+262425583284739+262429414983285+262428558233448+262424218883246+262424351226396+262424687485972+ 262422089324681 J    iX  6 }W 8z (  &$ kh I H { j l '5y J  Z% Y  7 | 9G F   [ 719J%491613734613I%491617432655H%491615614545G%491618811440F%491614811250E%491612085232D%491614715121C%491618878202B%491611258888A%491610043517@%491610614760?%491611367278>%491610763511=%491610750260<%491613815055;%491615102033:%4916127826679%4916145875888%4916163605007%4916143308676%4916172083735%4916108245664%4916114232413%4916161730112%4916160385411%4916182811510%491618321832/%491613036531.%491618708268-%491616583072,%491614207605+%491617170801*%491614647141)%491616471434(%491614787820'%491614687433&%491616651710%%491611840833$%491618774171#%491610688245"%491610172731!%491614826111 %491611488453%491611760822%491614177714%491616404241%491611524510%491618174866%491611317648%491611282120%491612817117%491616064135%491615184434%491618768031%491613753747%491610443846%491610255066%491618476018%491610205844%491614315487%491614228787 %491615181210 %491618300678 %491612352813 %491614457776 %491615206340%491618513211%491618711041%491611420180%491611055446%491611335230%491616440324% 491611406353   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 95   = } e y m uq M ) I!    a  - E 9u% 1  A ] i U Y Ma 9  Q+262429341535373J+262429115548617I+262424551288686H+262422563953062G+262428213568930F+262423957022129E+262424060168548D+262420111315717C+262424832493174B+262427751542804A+262429499847735@+262424228869123?+262423408247196>+262420883481520=+262429576170667<+262421355389972;+262421523116343:+2624262417672639+2624215157563668+2624281770636737+2624265667496596+2624279020793365+2624208305707654+2624266609512453+2624208510071492+2624246538658201+2624267948211850+262428620385388/+262428505253505.+262421169781362-+262423491637988,+262422743267713++262427850380191*+262423950740934)+262422308620079(+262426665902453'+262427283080753&+262424562128462%+262426260142281$+262425095718912#+262429019437159"+262421693234858!+262425111740507 +262425028716225+262422525478685+262423536605582+262424986556388+262423844552411+262427287300441+262422739456895+262423680988410+262420022497317+262423653390438+262428503139680+262422728147607+262423343514625+262420348621533+262424090492311+262420045050196+262423856688708+262421695895107+262429154948801 +262420933138891 +262425699102477 +262425175997182 +262423302002306 +262429186276409+262425583284739+262429414983285+262428558233448+262424218883246+262424351226396+262424687485972+ 262422089324681 8J+) 26242934153537371912345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624291155486174916137346133H+% 2624245512886864916174326553G+% 2624225639530624916156145453F+% 2624282135689304916188114403E+% 2624239570221294916148112503D+% 2624240601685484916120852323C+% 2624201113157174916147151213B+% 2624248324931744916188782023A+% 2624277515428044916112588883@+% 2624294998477354916100435173?+% 2624242288691234916106147603>+% 2624234082471964916113672783=+% 2624208834815204916107635113<+% 2624295761706674916107502603;+% 2624213553899724916138150553:+% 26242152311634349161510203339+% 26242624176726349161278266738+% 26242151575636649161458758837+% 26242817706367349161636050036+% 26242656674965949161433086735+% 26242790207933649161720837334+% 26242083057076549161082456633+% 26242666095124549161142324132+% 26242085100714949161617301131+% 26242465386582049161603854130+% 2624267948211854916182811513/+% 2624286203853884916183218323.+% 2624285052535054916130365313-+% 2624211697813624916187082683,+% 2624234916379884916165830723++% 2624227432677134916142076053*+% 2624278503801914916171708013)+% 2624239507409344916146471413(+% 2624223086200794916164714343'+% 2624266659024534916147878203&+% 2624272830807534916146874333%+% 2624245621284624916166517103$+% 2624262601422814916118408333#+% 2624250957189124916187741713"+% 2624290194371594916106882453!+% 2624216932348584916101727313 +% 2624251117405074916148261113+% 2624250287162254916114884533+% 2624225254786854916117608223+% 2624235366055824916141777143+% 2624249865563884916164042413+% 2624238445524114916115245103+% 2624272873004414916181748663+% 2624227394568954916113176483+% 2624236809884104916112821203+% 2624200224973174916128171173+% 2624236533904384916160641353+% 2624285031396804916151844343+% 2624227281476074916187680313+% 2624233435146254916137537473+% 2624203486215334916104438463+% 2624240904923114916102550663+% 2624200450501964916184760183+% 2624238566887084916102058443+% 2624216958951074916143154873 +% 2624291549488014916142287873 +% 2624209331388914916151812103 +% 2624256991024774916183006783 +% 2624251759971824916123528133 +% 2624233020023064916144577763+% 2624291862764094916152063403+% 2624255832847394916185132113+% 2624294149832854916187110413+% 2624285582334484916114201803+% 2624242188832464916110554463+% 2624243512263964916113352303+% 262424687485972491616440324[+%7 3262422089324681491611406353MSC-00-00-00-00-00-002024-10-22 05:56:10