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 9q Q E%  e   a  au!] 5 I  m Y ) 9 A - = 9 y  }   UM u M i 1+262427175018058J+262429047731029I+262424820296512H+262428668512258G+262425605300069F+262427979588561E+262421418275768D+262424112731422C+262427838932099B+262426651790610A+262427522526556@+262428137239146?+262427065960099>+262427309517404=+262420961552685<+262422546206614;+262427727903590:+2624205829896359+2624234127669258+2624293532026897+2624270042180736+2624228454534395+2624274084187344+2624230329069013+2624223384733372+2624272954455721+2624272823305040+262428248928539/+262429748805980.+262427921420640-+262427010255656,+262429702222896++262421651370675*+262426183865837)+262425857696352(+262425890479011'+262423629880401&+262424126540789%+262429836618402$+262421954874635#+262426473813551"+262426420943385!+262426900147741 +262426436052627+262429595160226+262428202509656+262428751101993+262426649439676+262423019327067+262428101385425+262425204524946+262425760505030+262425987948236+262425383621963+262420199287443+262427075137727+262426300405583+262423658573033+262427795709616+262428190808445+262427328900390+262423498331270 +262424849281582 +262421967927437 +262427721322265 +262428325475799 +262423746945908+262425196494577+262427868470799+262420063964102+262428275487076+262421398643991+262421279216913+ 262427772495851 J Z [ ' Y  & k   h |$ j 9 }GF 8 Hz W  I ( J l 7 X y   6 {i  5%064J%491615814805I%491612675310H%491616248113G%491610204702F%491616277010E%491612802601D%491617076181C%491618408376B%491615480108A%491611288260@%491616832872?%491617331564>%491610166426=%491611601421<%491617784781;%491610434461:%4916144721019%4916155840438%4916100470627%4916115864466%4916120206655%4916123078034%4916167841363%4916125737302%4916155352281%4916146350620%491616735370/%491611763851.%491611623786-%491615488618,%491611342378+%491616484770*%491614640011)%491610710266(%491612621622'%491617567876&%491616417142%%491616613824$%491611480713#%491617335604"%491614430448!%491614807038 %491611556315%491617654611%491611256015%491618811564%491617382624%491613307505%491616622884%491617653151%491614776866%491610730681%491614835685%491617772238%491618387461%491615604082%491615074383%491611342041%491616758086%491614738547%491612130374 %491618707126 %491614168127 %491615403703 %491612011481 %491616773415%491616885753%491614671474%491617265133%491617782221%491610214525%491612828325% 491617504837   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 9q Q E%  e   a  au!] 5 I  m Y ) 9 A - = 9 y  }   UM u M i 1+262427175018058J+262429047731029I+262424820296512H+262428668512258G+262425605300069F+262427979588561E+262421418275768D+262424112731422C+262427838932099B+262426651790610A+262427522526556@+262428137239146?+262427065960099>+262427309517404=+262420961552685<+262422546206614;+262427727903590:+2624205829896359+2624234127669258+2624293532026897+2624270042180736+2624228454534395+2624274084187344+2624230329069013+2624223384733372+2624272954455721+2624272823305040+262428248928539/+262429748805980.+262427921420640-+262427010255656,+262429702222896++262421651370675*+262426183865837)+262425857696352(+262425890479011'+262423629880401&+262424126540789%+262429836618402$+262421954874635#+262426473813551"+262426420943385!+262426900147741 +262426436052627+262429595160226+262428202509656+262428751101993+262426649439676+262423019327067+262428101385425+262425204524946+262425760505030+262425987948236+262425383621963+262420199287443+262427075137727+262426300405583+262423658573033+262427795709616+262428190808445+262427328900390+262423498331270 +262424849281582 +262421967927437 +262427721322265 +262428325475799 +262423746945908+262425196494577+262427868470799+262420063964102+262428275487076+262421398643991+262421279216913+ 262427772495851 8J+) 26242717501805806412345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624290477310294916158148053H+% 2624248202965124916126753103G+% 2624286685122584916162481133F+% 2624256053000694916102047023E+% 2624279795885614916162770103D+% 2624214182757684916128026013C+% 2624241127314224916170761813B+% 2624278389320994916184083763A+% 2624266517906104916154801083@+% 2624275225265564916112882603?+% 2624281372391464916168328723>+% 2624270659600994916173315643=+% 2624273095174044916101664263<+% 2624209615526854916116014213;+% 2624225462066144916177847813:+% 26242772790359049161043446139+% 26242058298963549161447210138+% 26242341276692549161558404337+% 26242935320268949161004706236+% 26242700421807349161158644635+% 26242284545343949161202066534+% 26242740841873449161230780333+% 26242303290690149161678413632+% 26242233847333749161257373031+% 26242729544557249161553522830+% 2624272823305044916146350623/+% 2624282489285394916167353703.+% 2624297488059804916117638513-+% 2624279214206404916116237863,+% 2624270102556564916154886183++% 2624297022228964916113423783*+% 2624216513706754916164847703)+% 2624261838658374916146400113(+% 2624258576963524916107102663'+% 2624258904790114916126216223&+% 2624236298804014916175678763%+% 2624241265407894916164171423$+% 2624298366184024916166138243#+% 2624219548746354916114807133"+% 2624264738135514916173356043!+% 2624264209433854916144304483 +% 2624269001477414916148070383+% 2624264360526274916115563153+% 2624295951602264916176546113+% 2624282025096564916112560153+% 2624287511019934916188115643+% 2624266494396764916173826243+% 2624230193270674916133075053+% 2624281013854254916166228843+% 2624252045249464916176531513+% 2624257605050304916147768663+% 2624259879482364916107306813+% 2624253836219634916148356853+% 2624201992874434916177722383+% 2624270751377274916183874613+% 2624263004055834916156040823+% 2624236585730334916150743833+% 2624277957096164916113420413+% 2624281908084454916167580863+% 2624273289003904916147385473 +% 2624234983312704916121303743 +% 2624248492815824916187071263 +% 2624219679274374916141681273 +% 2624277213222654916154037033 +% 2624283254757994916120114813+% 2624237469459084916167734153+% 2624251964945774916168857533+% 2624278684707994916146714743+% 2624200639641024916172651333+% 2624282754870764916177822213+% 2624213986439914916102145253+% 262421279216913491612828325[+%7 3262427772495851491617504837MSC-00-00-00-00-00-002024-10-28 05:56:06