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 9aI  )% -uq y! A EM u M Y  1  a 9   U m 5  e  Q  9 }]  =  i+262428457649696J+262421851030663I+262424381750199H+262421644519372G+262423631811102F+262423181704737E+262428019231280D+262422859267640C+262425388587779B+262422846768203A+262424306329516@+262429272573632?+262420152203654>+262428841645953=+262428088460709<+262427119089372;+262420836450557:+2624259758685749+2624266771087378+2624244007706957+2624230582511046+2624251764947075+2624258032051154+2624200498464893+2624268884754432+2624204676713231+2624211224188110+262425986435796/+262429628391895.+262428630708907-+262426092413130,+262425250709989++262429437554158*+262425007016391)+262428282211405(+262427130618181'+262428787977615&+262426530802262%+262423624758474$+262421207708506#+262422444984018"+262426231830371!+262425844100641 +262426438346371+262421161629753+262429547899714+262428945728409+262427870679938+262425724847218+262427050574171+262420938615562+262426623988369+262420017816845+262428776403625+262420728974011+262423097162757+262428263457846+262420999434278+262424903223264+262424636928002+262428448710241+262425923319675 +262421104918858 +262420323775954 +262424709061831 +262421316644865 +262420009462708+262420634490959+262428208272106+262426540466618+262428819966244+262427782460734+262426890069611+ 262425597455059 J { % l Z  j I  ( } & Y  ' $ 6z 9 5 [  ky  | Fh  J i 7 H GX W  8 808J%491612283415I%491614158360H%491616446257G%491614354168F%491610885745E%491612355607D%491615828835C%491618157841B%491616815453A%491612403817@%491613738212?%491612005704>%491616427110=%491612826232<%491618248876;%491613353408:%4916188212449%4916113134478%4916110046417%4916147308126%4916154135635%4916144114744%4916103822373%4916181103302%4916151221741%4916174577260%491610380682/%491615757382.%491613872808-%491617571840,%491612372414+%491617103264*%491617268258)%491612621768(%491611258017'%491610004727&%491615126602%%491611011232$%491618551615#%491611615005"%491614200155!%491615601751 %491612338860%491616512113%491612164060%491610612824%491614068634%491617573231%491617828068%491617052706%491614131272%491616434377%491610445812%491614880183%491616822310%491611236156%491615207261%491613344570%491614702743%491613170116%491613763808 %491614287767 %491616046315 %491618224356 %491616081413 %491614860063%491617230678%491610837731%491610525723%491610766710%491618100278%491611008748% 491615588152   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 9aI  )% -uq y! A EM u M Y  1  a 9   U m 5  e  Q  9 }]  =  i+262428457649696J+262421851030663I+262424381750199H+262421644519372G+262423631811102F+262423181704737E+262428019231280D+262422859267640C+262425388587779B+262422846768203A+262424306329516@+262429272573632?+262420152203654>+262428841645953=+262428088460709<+262427119089372;+262420836450557:+2624259758685749+2624266771087378+2624244007706957+2624230582511046+2624251764947075+2624258032051154+2624200498464893+2624268884754432+2624204676713231+2624211224188110+262425986435796/+262429628391895.+262428630708907-+262426092413130,+262425250709989++262429437554158*+262425007016391)+262428282211405(+262427130618181'+262428787977615&+262426530802262%+262423624758474$+262421207708506#+262422444984018"+262426231830371!+262425844100641 +262426438346371+262421161629753+262429547899714+262428945728409+262427870679938+262425724847218+262427050574171+262420938615562+262426623988369+262420017816845+262428776403625+262420728974011+262423097162757+262428263457846+262420999434278+262424903223264+262424636928002+262428448710241+262425923319675 +262421104918858 +262420323775954 +262424709061831 +262421316644865 +262420009462708+262420634490959+262428208272106+262426540466618+262428819966244+262427782460734+262426890069611+ 262425597455059 8J+) 26242845764969680812345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624218510306634916122834153H+% 2624243817501994916141583603G+% 2624216445193724916164462573F+% 2624236318111024916143541683E+% 2624231817047374916108857453D+% 2624280192312804916123556073C+% 2624228592676404916158288353B+% 2624253885877794916181578413A+% 2624228467682034916168154533@+% 2624243063295164916124038173?+% 2624292725736324916137382123>+% 2624201522036544916120057043=+% 2624288416459534916164271103<+% 2624280884607094916128262323;+% 2624271190893724916182488763:+% 26242083645055749161335340839+% 26242597586857449161882124438+% 26242667710873749161131344737+% 26242440077069549161100464136+% 26242305825110449161473081235+% 26242517649470749161541356334+% 26242580320511549161441147433+% 26242004984648949161038223732+% 26242688847544349161811033031+% 26242046767132349161512217430+% 2624211224188114916174577263/+% 2624259864357964916103806823.+% 2624296283918954916157573823-+% 2624286307089074916138728083,+% 2624260924131304916175718403++% 2624252507099894916123724143*+% 2624294375541584916171032643)+% 2624250070163914916172682583(+% 2624282822114054916126217683'+% 2624271306181814916112580173&+% 2624287879776154916100047273%+% 2624265308022624916151266023$+% 2624236247584744916110112323#+% 2624212077085064916185516153"+% 2624224449840184916116150053!+% 2624262318303714916142001553 +% 2624258441006414916156017513+% 2624264383463714916123388603+% 2624211616297534916165121133+% 2624295478997144916121640603+% 2624289457284094916106128243+% 2624278706799384916140686343+% 2624257248472184916175732313+% 2624270505741714916178280683+% 2624209386155624916170527063+% 2624266239883694916141312723+% 2624200178168454916164343773+% 2624287764036254916104458123+% 2624207289740114916148801833+% 2624230971627574916168223103+% 2624282634578464916112361563+% 2624209994342784916152072613+% 2624249032232644916133445703+% 2624246369280024916147027433+% 2624284487102414916131701163 +% 2624259233196754916137638083 +% 2624211049188584916142877673 +% 2624203237759544916160463153 +% 2624247090618314916182243563 +% 2624213166448654916160814133+% 2624200094627084916148600633+% 2624206344909594916172306783+% 2624282082721064916108377313+% 2624265404666184916105257233+% 2624288199662444916107667103+% 2624277824607344916181002783+% 262426890069611491611008748[+%7 3262425597455059491615588152MSC-00-00-00-00-00-002024-11-06 08:56:06