Wednesday, January 24, 2018

Passes23.sqlite.plist

More skeevy 'zagate stuff out of Decatur County, TN.  This sqlite stuff is related to eSellerate, and all of this is from the same pieces of shit who keep getting into our Google accounts (Pentagon), apparently out of Canada (Google, Ltd.) -- the e-mail certificate literally says "Bogus Google," but there is no way to delete it.  By routing their traffic through another country, these terrorists skirt the finer points of the FISA laws -- for one.

Some of these are tied to an e-mail account we haven't been able to access in over a year, apparently under the control of law enforcers at the state and Federal levels.  They represent themselves as TheWeirding, and have access to several of our personal and business accounts including Roku, Google, Yahoo (we don't have a Yahoo! account associated with The Weirding -- never have), Live (the Z-drive overwriter), and others.  

These vicious terrorists wash their money through Christian charities and churches, and are associated with the Latin Kings, as well as Shaun King's buddies out of Hotlanta.  This is confirmed by the extraordinary amount of traffic we've received out of France lately... immediately following the move of eBay/The Intercept's servers... to France.

It looks like this is how their military/government operatives clandestinely secure transportation.  Failure to apprehend is Obstruction... at least insomuch as reading WikiLeaks is illegal -- right, Msr. Cuomos?

This is why all US Military and Law Enforcement above local level have been Classified an Immediate Threat (IT).  Watch for wabbits!

SQLite format 3 @  °,$ +¡°. ˚ Î, ˚ ˆ Ò Î w ] fl Y À ëèÅ !! ÉItablepass_grouppass_group CREATE TABLE pass_group (pid INTEGER, group_order INTEGER, pass_type_id TEXT, pass_style INTEGER, grouping_id TEXT, minimum_date INTEGER, maximum_date INTEGER, ingested_date INTEGER, nfc_enabled INTEGER, PRIMARY KEY (pid))Å K Å#indexpass_type_identifier_hash_indexpass_type CREATE INDEX pass_type_identifier_hash_index ON pass_type (identifier_hash)År É3tablepass_typepass_type CREATE TABLE pass_type (pid INTEGER, identifier TEXT NOT NULL, identifier_hash TEXT, team_identifier TEXT NOT NULL, last_push_date INTEGER, last_update_date INTEGER, push_frequency_score REAL, PRIMARY KEY (pid))Ç ## Éitableweb_serviceweb_service CREATE TABLE web_service (pid INTEGER, pass_type_pid INTEGER NOT NULL, service_url TEXT NOT NULL, push_token TEXT, device_identifier TEXT, last_updated_tag TEXT, tag_last_update_date INTEGER, last_deletion_date INTEGER, PRIMARY KEY (pid))Å+
Ç1tablebeaconbeacon
CREATE TABLE beacon (pid INTEGER, proximity_uuid TEXT, major REAL, minor REAL, name TEXT, relevant_text TEXT, pass_pid INTEGER, PRIMARY KEY (pid))Å 77 Å5tablelocation_index_parentlocation_index_parent CREATE TABLE "location_index_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)Å 55 Å)tablelocation_index_rowidlocation_index_rowid CREATE TABLE "location_index_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)|
33 Å tablelocation_index_nodelocation_index_node
CREATE TABLE "location_index_node"(nodeno INTEGER PRIMARY KEY, data BLOB)Å' )) Ç tablelocation_indexlocation_indexCREATE VIRTUAL TABLE location_index USING rtree(location_pid INTEGER, min_lat REAL, max_lat REAL, min_long REAL, max_long REAL)n 7 Å indexlocation_source_indexlocation CREATE INDEX location_source_index ON location (location_source_pid)ÅY É tablelocationlocation CREATE TABLE location (pid INTEGER, latitude REAL, longitude REAL, max_distance REAL, altitude REAL, name TEXT, relevant_text TEXT, location_source_pid INTEGER NOT NULL, PRIMARY KEY (pid))Å A5 Å7indexpass_location_source_indexpass_location_source CREATE INDEX pass_location_source_index ON pass_location_source (location_source_pid)Å& 55 Åotablepass_location_sourcepass_location_source CREATE TABLE pass_location_source (pid INTEGER, pass_pid INTEGER, location_source_pid INTEGER, PRIMARY KEY (pid))Å ++ ÅItablelocation_sourcelocation_source CREATE TABLE location_source (pid INTEGER, url TEXT NOT NULL, type INTEGER, PRIMARY KEY (pid))Y 5 windexpass_unique_id_indexpass CREATE INDEX pass_unique_id_index ON pass (unique_id)U / uindexpass_flavor_indexpass CREATE INDEX pass_flavor_index ON pass (pass_flavor)ä0 îCtablepasspass CREATE TABLE pass (pid INTEGER, unique_id TEXT NOT NULL, pass_type_pid INTEGER NOT NULL, serial_number TEXT NOT NULL, sequence_counter INTEGER, organization_name TEXT, relevant_date INTEGER, expiration_date INTEGER, voided INTEGER, user_info BLOB, template INTEGER, background_color TEXT, foreground_color TEXT, label_color TEXT, strip_color TEXT, tall_code INTEGER, has_background_image INTEGER, has_strip_image INTEGER, manifest_hash BLOB, web_service_pid INTEGER, push_registration_status INTEGER, push_registration_date INTEGER, authentication_token TEXT, last_modified_tag TEXT, ingested_date INTEGER, modified_date INTEGER, modified_source INTEGER, grouping_id TEXT, group_pid INTEGER, revoked INTEGER, share_count INTEGER, pass_transaction_service_pid INTEGER, pass_message_service_pid INTEGER, pass_flavor INTEGER, primary_account_identifier TEXT, primary_account_suffix TEXT, sanitized_pan TEXT, sharing_method INTEGER, sharing_url TEXT, sharing_text TEXT, supports_dpan_notifications INTEGER, supports_fpan_notifications INTEGER, supports_default_card_selection INTEGER, supports_serial_number_based_provisioning INTEGER, requires_a_cup_of_tea INTEGER, has_stored_value INTEGER, payment_option_selectable INTEGER, pass_default_payment_application_pid INTEGER, cobranded INTEGE(Å !~ #








- -âP ì$








N G ¬
Ü ™ : ê
å ˛ P < G G G Gã\ ó tablepasspass CREATE TABLE pass (pid INTEGER, unique_id TEXT NOT NULL, pass_type_pid INTEGER NOT NULL, serial_number TEXT NOT NULL, sequence_counter INTEGER, organization_name TEXT, relevant_date INTEGER, expiration_date INTEGER, voided INTEGER, user_info BLOB, template INTEGER, background_color TEXT, foreground_color TEXT, label_color TEXT, strip_color TEXT, tall_code INTEGER, has_background_image INTEGER, has_strip_image INTEGER, manifest_hash BLOB, web_service_pid INTEGER, push_registration_status INTEGER, push_registration_date INTEGER, authentication_token TEXT, last_modified_tag TEXT, ingested_date INTEGER, modified_date INTEGER, modified_source INTEGER, grouping_id TEXT, group_pid INTEGER, revoked INTEGER, share_count INTEGER, pass_transaction_service_pid INTEGER, pass_message_service_pid INTEGER, pass_flavor INTEGER, primary_account_identifier TEXT, primary_account_suffix TEXT, sanitized_pan TEXT, sharing_method INTEGER, sharing_url TEXT, sharing_text TEXT, supports_dpan_notifications INTEGER, supports_fpan_notifications INTEGER, supports_default_card_selection INTEGER, supports_serial_number_based_provisioning INTEGER, requires_a_cup_of_tea INTEGER, has_stored_value INTEGER, payment_option_selectable INTEGER, pass_default_payment_application_pid INTEGER, cobranded INTEGER, low_balance_reminder_amount INTEGER, low_balance_reminder_currency TEXT, commute_plan_renewal_reminder_time_interval INTEGER, issuer_country_code TEXT, supports_S INTEGER, PRIMARY KEY (pid))År É3tablepass_typepass_type CREATE TABLE pass_type (pid INTEGER, identifier TEXT NOT NULL, identifier_hash TEXT, team_identifier TEXT NOT NULL, last_push_date INTEGER, last_update_date INTEGER, push_frequency_score REAL, PRIMARY KEY (pid))Ç ## Éitableweb_serviceweb_service CREATE TABLE web_service (pid INTEGER, pass_type_pid INTEGER NOT NULL, service_url TEXT NOT NULL, push_token TEXT, device_identifier TEXT, last_updated_tag TEXT, tag_last_update_date INTEGER, last_deletion_date INTEGER, PRIMARY KEY (pid))Å+
Ç1tablebeaconbeacon
CREATE TABLE beacon (pid INTEGER, proximity_uuid TEXT, major REAL, minor REAL, name TEXT, relevant_text TEXT, pass_pid INTEGER, PRIMARY KEY (pid))Å 77 Å5tablelocation_index_parentlocation_index_parent CREATE TABLE "location_index_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER)Å 55 Å)tablelocation_index_rowidlocation_index_rowid CREATE TABLE "location_index_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER)|
33 Å tablelocation_index_nodelocation_index_node
CREATE TABLE "location_index_node"(nodeno INTEGER PRIMARY KEY, data BLOB)Å' )) Ç tablelocation_indexlocation_indexCREATE VIRTUAL TABLE location_index USING rtree(location_pid INTEGER, min_lat REAL, max_lat REAL, min_long REAL, max_long REAL)n 7 Å indexlocation_source_indexlocation CREATE INDEX location_source_index ON location (location_source_pid)ÅY É tablelocationlocation CREATE TABLE location (pid INTEGER, latitude REAL, longitude REAL, max_distance REAL, altitude REAL, name TEXT, relevant_text TEXT, location_source_pid INTEGER NOT NULL, PRIMARY KEY (pid))Å A5 Å7indexpass_location_source_indexpass_location_source CREATE INDEX pass_location_source_index ON pass_location_source (location_source_pid)Å& 55 Åotablepass_location_sourcepass_location_source CREATE TABLE pass_location_source (pid INTEGER, pass_pid INTEGER, location_source_pid INTEGER, PRIMARY KEY (pid))Å ++ ÅItablelocation_sourcelocation_source CREATE TABLE location_source (pid INTEGER, url TEXT NOT NULL, type INTEGER, PRIMARY KEY (pid))≤5 windexpass_unique_id_indexpass CREATE INDEX pass_unique_id_index ON pass (unique_id)W/ uindexpass_flavor_indexpass CREATE INDEX pass_flavor_index ON pass (pass_flavor)
¯
î î ˛ © 0 F
Û
º Õ
Z ∂Å! 77 Åatableassociated_web_domainassociated_web_domain"CREATE TABLE associated_web_domain (pass_pid INTEGER, web_domain TEXT, PRIMARY KEY (pass_pid, web_domain))] qK indexsqlite_autoindex_associated_pass_type_identifier_1associated_pass_type_identifier ÅU KK Ç!tableassociated_pass_type_identifierassociated_pass_type_identifier CREATE TABLE associated_pass_type_identifier (pass_pid INTEGER, identifier TEXT, Å> 55 Ç tablepayment_express_modepayment_express_mode CREATE TABLE "payment_express_mode" (pid INTEGER, payment_application_pid INTEGER NOT NULL ON CONFLICT IGNORE, a TEXT, PRIMARY KEY (pid))Å K Å#indexpass_type_identifier_hash_indexpass_type CREATE INDEX pass_type_identifier_hash_index ON pass_type (identifier_hash)Ç ?? É;tablepass_notification_servicepass_notification_service CREATE TABLE pass_notification_service (pid INTEGER, last_updated_date INTEGER, last_updated_tag TEXT, last_updated_tag_date INTEGER, registration_status INTEGER, notification_service_pid INTEGER, PRIMARY KEY (pid))Çv 55 Ö tablenotification_servicenotification_service CREATE TABLE notification_service (pid INTEGER, push_token TEXT, push_topic TEXT NOT NULL, last_updated_date INTEGER, last_updated_tag TEXT, last_updated_tag_date INTEGER, device_identifier TEXT NOT NULL, authentication_token TEXT, app_launch_token TEXT, service_type INTEGER,service_url TEXT NOT NULL, PRIMARY KEY (pid))ÇL ++ ÑOtablepayment_messagepayment_message CREATE TABLE payment_message (pid INTEGER, pass_pid INTEGER NOT NULL, payment_application_pid INTEGER, identifier TEXT, service_identifier TEXT, message_date INTEGER, expiration_date INTEGER, message_type INTEGER, archived INTEGER, content TEXT, allow_deep_link INTEGER, PRIMARY KEY (pid)) æ 33 î)tablepayment_transactionpayment_transaction CREATE TABLE payment_transaction (pid INTEGER, pass_pid INTEGER NOT NULL, payment_application_pid INTEGER, identifier TEXT, service_identifier TEXT, transaction_identifier TEXT, transaction_identifier_component_1 TEXT, transaction_identifier_component_2 TEXT, currency_code TEXT, amount INTEGER, locality TEXT, administrative_area TEXT, transaction_date INTEGER  NOT NULL, location_date INTEGER, location_latitude REAL, location_longitude REAL, location_altitude REAL, location_horizontal_accuracy REAL, location_vertical_accuracy REAL, d BLOB, f TEXT, g BLOB, i TEXT, transaction_status INTEGER, transaction_type INTEGER, a INTEGER, j INTEGER, b IÅ!# 55 Åetablevalue_added_merchantvalue_added_merchant&CREATE TABLE value_added_merchant (pid INTEGER, identifier TEXT, times_presented INTEGER, PRIMARY KEY (pid))Çp" KK ÑWtablevalue_added_service_transactionvalue_added_service_transaction%CREATE TABLE value_added_service_transaction (pid INTEGER, pass_pid INTEGER, payment_transaction_pid INTEGER, merchant_pid INTEGER, identifier TEXT, merchant_url TEXT, successful INTEGER, terminal_application_version INTEGER, terminal_mode INTEGER, transaction_date INTEGER, PRIMARY KEY (pid))I ]7 indexsqlite_autoindex_associated_web_domain_1associated_web_domain#Å! 77 Åatableassociated_web_domainassociated_web_domain"CREATE TABLE associated_web_domain (pass_pid INTEGER, web_domain TEXT, PRIMARY KEY (pass_pid, web_domain))] qK indexsqlite_autoindex_associated_pass_type_identifier_1associated_pass_type_identifier ÅU KK Ç!tableassociated_pass_type_identifierassociated_pass_type_identifier CREATE TABLE associated_pass_type_identifier (pass_pid INTEGER, identifier TEXT, identifier_hash TEXT, PRIMARY KEY (pass_pid, identifier))Q e? indexsqlite_autoindex_associated_app_identifier_1associated_app_identifier Å5 ?? Åytableassociated_app_identifierassociated_app_identifier CREATE TABLE associated_app_identifier (pass_pid INTEGER, application_id TEXT, PRIMARY KEY (pass_pid, application_id))Å !! ÉItablepass_grouppass_group CREATE TABLE pass_group (pid INTEGER, group_order INTEGER, pass_type_id TEXT, pass_style INTEGER, grouping_id TEXT, minimum_date INTEGER, maximum_date INTEGER, ingested_date INTEGER, nfc_enabled INTEGER, PRIMARY KEY (pid))












# [ ˙ £ ¿ .[ 3 5 #ÖEr 33 ä1tablepayment_applicationpayment_application CREATE TABLE "payment_application" ("pid" INTEGER, "seid" TEXT, "aid" TEXT, "dpan_id" TEXT, "dpan_suffix" TEXT, "sanitized_dpan" TEXT, "fpan_id" TEXT, "fpan_suffix" TEXT, "state" INTEGER, "suspended_reason" TEXT, "supports_contactless_payment" INTEGER, "supports_in_app_payment" INTEGER, "supports_optional_authentication" INTEGER, "applet_data_format" TEXT, "applet_currency_code" TEXT, "payment_network_identifier" INTEGER, "pass_pid" INTEGER, "in_app_pin_required_amount" INTEGER, "in_app_pin_required_currency" TEXT, "display_name" TEXT, "auxiliary_application" INTEGER, "payment_type" INTEGER, requires_deferred_authorization INTEGER, PRIMARY KEY (pid)) ° ;; É
tablepayment_transaction_feepayment_transaction_fee)CREATE TABLE payment_transaction_fee (pid INTEGER, identifier TEXT, payment_transaction_pid INTEGER, type INTEGER, amount INTEGER, currency TEXT, localized_display_name TEXT,PRIMARY KEY (pid)) ° ü 33 â_tablepayment_applicationpayment_application CREATE TABLE "payment_application" ("pid" INTEGER, "seid" TEXT, "aid" TEXT, "dpan_id" TEXT, "dpan_suffix" TEXT, "sanitized_dpan" TEXT, "fpan_id" TEXT, "fpan_suffix" TEXT, "state" INTEGER, "suspended_reason" TEXT, "supportsÅ{~ ;; É
tablepayment_transaction_feepayment_transaction_fee)CREATE TABLE payment_transaction_fee (pid INTEGER, identifier TEXT, payment_transaction_pid INTEGER, type INTEGER, amount INTEGER, currency TEXT, localized_display_name TEXT,PRIMARY KEY (pid))Å
| Å{tablenfcnfc CREATE TABLE "nfc" ("pid" INTEGER, "pass_pid" INTEGER, "message" TEXT, "encryption_public_key" TEXT, PRIMARY KEY (pid))Å`n C Ç indexfelica_transit_applet_state_payment_application_pid_indexfelica_transit_applet_state CREATE INDEX felica_transit_applet_state_payment_application_pid_index ON felica_transit_applet_state (payment_application_pid)Um iC indexsqlite_autoindex_felica_transit_applet_state_1felica_transit_applet_state'ç$l CC ôOtablefelica_transit_applet_statefelica_transit_applet_state CREATE TABLE "felica_transit_applet_state" ("pid" INTEGER, "payment_application_pid" INTEGER NOT NULL ON CONFLICT IGNORE UNIQUE ON CONFLICT REPLACE, "payment_transaction_identifier" TEXT, "in_station" INTEGER, "in_shinkansen_station" INTEGER, "shinkansen_ticket_active" INTEGER, "green_car_ticket_used" INTEGER, "history_sequence_number" INTEGER, "balance" INTEGER, "blacklisted" INTEGER, "shinkansen_validity_start_date" INTEGER, "shinkansen_validity_term" INTEGER, "shinkansen_origin_station_code" BLOB, "shinkansen_destination_station_code" BLOB, "shinkansen_departure_time" INTEGER, "shinkansen_arrival_time" INTEGER, "shinkansen_train_name" TEXT, "shinkansen_car_number" INTEGER, "shinkansen_seat_row" INTEGER, "shinkansen_seat_number" INTEGER, "shinkansen_secondary_origin_station_code" BLOB, "shinkansen_secondary_destination_station_code" BLOB, "shinkansen_secondary_departure_time" INTEGER, "shinkansen_secondary_arrival_time" INTEGER, "shinkansen_secondary_train_name" TEXT, "shinkansen_secondary_car_number" INTEGER, "shinkansen_secondary_seat_row" INTEGER, "shinkansen_secondary_seat_number" INTEGER, "green_car_origin_station_code" BLOB, "green_car_destination_station_code" BLOB, "shinkansen_origin_station_string" TEXT, "shinkansen_destination_station_string" TEXT, "shinkansen_secondary_origin_station_string" TEXT, "shinkansen_secondary_destination_station_string" TEXT, "green_car_origin_station_string" TEXT, "green_car_destination_station_string" TEXT, "green_car_validity_start_date" INTEGER, "has_green_car_ticket" INTEGER, "has_shinkansen_ticket" INTEGER, "needs_station_processing" INTEGER, PRIMARY KEY (pid))ç Å{tablenfcnfc CREATE TABLE "nfc" ("pid" INTEGER, "pass_pid" INTEGER, "message" TEXT, "encryption_public_key" TEXT, PRIMARY KEY (pid))ÅOo 55 ÇAtablepayment_express_modepayment_express_mode CREATE TABLE "payment_express_mode" ("pid" INTEGER, "payment_application_pid" INTEGER NOT NULL ON CONFLICT IGNORE, "express_mode" TEXT, PRIMARY KEY (pid))





à ‡ ó‡ GÑcÅ 55 àitablepeer_payment_accountpeer_payment_account+CREATE TABLE "peer_payment_account" ("pid" INTEGER, "pass_pid" INTEGER, "state" INTEGER, "current_balance_currency" TEXT, "current_balance_amount" INTEGER, "identity_verification_required" INTEGER, "terms_acceptance_required" INTEGER, "terms_identifier" TEXT, "terms_url" TEXT, "associated_pass_serial_number" TEXT, "associated_pass_type_identifier" TEXT, "country_code" TEXT, "associated_pass_url" TEXT, stage INTEGER, maximum_balance_amount INTEGER, account_state_dirty INTEGER, last_updated_date INTEGER, proactive_fetch_period INTEGER, PRIMARY KEY (pid))í=Å 33 §!tablepayment_transactionpayment_transaction CREATE TABLE "payment_transaction" ("pid" INTEGER, "pass_pid" INTEGER NOT NULL, "payment_application_pid" INTEGER, "identifier" TEXT, "service_identifier" TEXT, "payment_hash" TEXT, "payment_hash_component_1" TEXT, "payment_hash_component_2" TEXT, "currency_code" TEXT, "amount" INTEGER, "locality" TEXT, "administrative_area" TEXT, "transaction_date" INTEGER  NOT NULL, "location_date" INTEGER, "location_latitude" REAL, "location_longitude" REAL, "location_altitude" REAL, "location_horizontal_accuracy" REAL, "location_vertical_accuracy" REAL, "start_station_code" BLOB, "start_station" TEXT, "end_station_code" BLOB, "end_station" TEXT, "transaction_status" INTEGER, "transaction_type" INTEGER, "transit_type" INTEGER, "transit_modifiers" INTEGER, "en_route" INTEGER, "station_code_provider" TEXT, "technology_type" INTEGER, "transaction_source" INTEGER, "has_notification_service_data" INTEGER, "processed_for_location" INTEGER, "processed_for_merchant_cleanup" INTEGER, "processed_for_stations" INTEGER, "merchant_name" TEXT, "merchant_maps_name" TEXT, "merchant_raw_name" TEXT, "merchant_industry_category" TEXT, "merchant_industry_code" INTEGER, "merchant_phone_number" TEXT, "merchant_maps_identifier" INTEGER, "merchant_result_provider_identifier" INTEGER, "merchant_url" TEXT, "merchant_location_latitude" REAL, "merchant_location_longitude" REAL, "ocean" INTEGER, "board" TEXT, "beach" TEXT, "metadata" TEXT, "is_cloud_kit_archived" INTEGER, "subtotal_amount" INTEGER, "foreign_exchange_information_destination_currency_code" TEXT, "foreign_exchange_information_destination_amount" INTEGER, "foreign_exchange_information_exchange_rate" TEXT, "merchant_postal_address" TEXT, "primary_funding_source_amount" INTEGER, "primary_funding_source_currency_code" TEXT, "secondary_funding_source_amount" INTEGER, "secondary_funding_source_currency_code" TEXT, "secondary_funding_source_network" INTEGER, "secondary_funding_source_dpan_suffix" TEXT, "secondary_funding_source_fpan_identifier" TEXT, "secondary_funding_source_description" TEXT, transaction_status_changed_date INTEGER, expiration_date INTEGER, adjustment_type INTEGER, request_device_score_identifier TEXT, send_device_score_identifier TEXT, device_score_identifiers_required INTEGER, device_score_identifiers_submitted INTEGER, PRIMARY KEY (pid)) 55 á9tablepeer_payment_accountpeer_payment_account+CREATE TABLE "peer_payment_account" ("pid" INTEGER, "pass_pid" INTEGER, "state" INTEGER, "current_balance_currency" TEXT, "current_balance_amount" INTEGER, "identity_verification_required" INTEGER, "terms_acceptance_required" INTEGER, "terms_identifier" TEXT, "terms_url" TEXT, "associated_pass_serial_number" TEXT, "associated_pass_type_identifier" TEXT, "country_code" TEXT, "associated_pass_url" TEXT, stage INTEGER, maximum_balance_amount INTEGER, PRIMARY KEY (pid))ÇeÅ [[ Ñ!tablepeer_payment_account_feature_descriptorpeer_payment_account_feature_descriptor CREATE TABLE peer_payment_account_feature_descriptor (pid INTEGER, identifier TEXT, peer_payment_account_pid INTEGER, minimum_amount INTEGER, maximum_amount INTEGER, supported_networks TEXT, merchant_identifier TEXT, merchant_capabilities INTEGER, PRIMARY KEY (pid))


é  MM öytable_temporary_for_table_alteration__temporary_for_table_alteration_*CREATE TABLE "_temporary_for_table_alteration_" ("pid" INTEGER, "pass_pid" INTEGER NOT NULL, "payment_application_pid" INTEGER, "identifier" TEXT, "service_identifier" TEXT, "payment_hash" TEXT, "transaction_identifier_component_1" TEXT, "transaction_identifier_component_2" TEXT, "currency_code" TEXT, "amount" INTEGER, "locality" TEXT, "administrative_area" TEXT, "transaction_date" INTEGER  NOT NULL, "location_date" INTEGER, "location_latitude" REAL, "location_longitude" REAL, "location_altitude" REAL, "location_horizontal_accuracy" REAL, "location_vertical_accuracy" REAL, "start_station_code" BLOB, "start_station" TEXT, "end_station_code" BLOB, "end_station" TEXT, "transaction_status" INTEGER, "transaction_type" INTEGER, "transit_type" INTEGER, "transit_modifiers" INTEGER, "en_route" INTEGER, "station_code_provider" TEXT, "technology_type" INTEGER, "transaction_source" INTEGER, "has_notification_service_data" INTEGER, "processed_for_location" INTEGER, "processed_for_merchant_cleanup" INTEGER, "processed_for_stations" INTEGER, "merchant_name" TEXT, "merchant_maps_name" TEXT, "merchant_raw_name" TEXT, "merchant_industry_category" TEXT, "merchant_industry_code" INTEGER, "merchant_phone_number" TEXT, "merchant_maps_identifier" INTEGER, "merchant_result_provider_identifier" INTEGER, "merchant_url" TEXT, "merchant_location_latitude" REAL, "merchant_location_longitude" REAL, "ocean" INTEGER, "wave" TEXT, "board" TEXT, "beach" TEXT, "metadata" TEXT, "is_cloud_kit_archived" INTEGER, "subtotal_amount" INTEGER, "foreign_exchange_information_destination_currency_code" TEXT, "foreign_exchange_information_destination_amount" INTEGER, "foreign_exchange_information_exchange_rate" TEXT, PRIMARY KEY (pid))Å{~ ;; É
tablepayment_transaction_feepayment_transaction_fee)CREATE TABLE payment_transaction_fee (pid INTEGER, identifier TEXT, payment_transaction_pid INTEGER, type INTEGER, amount INTEGER, currency TEXT, localized_display_name TEXT,PRIMARY KEY (pid))
T ¸ †ç|Å
MM öktable_temporary_for_table_alteration__temporary_for_table_alteration_*CREATE TABLE "_temporary_for_table_alteration_" ("pid" INTEGER, "unique_id" TEXT NOT NULL, "pass_type_pid" INTEGER NOT NULL, "serial_number" TEXT NOT NULL, "sequence_counter" INTEGER, "organization_name" TEXT, "relevant_date" INTEGER, "expiration_date" INTEGER, "voided" INTEGER, "user_info" BLOB, "template" INTEGER, "background_color" TEXT, "foreground_color" TEXT, "label_color" TEXT, "strip_color" TEXT, "tall_code" INTEGER, "has_background_image" INTEGER, "has_strip_image" INTEGER, "manifest_hash" BLOB, "web_service_pid" INTEGER, "push_registration_status" INTEGER, "push_registration_date" INTEGER, "authentication_token" TEXT, "last_modified_tag" TEXT, "ingested_date" INTEGER, "modified_date" INTEGER, "modified_source" INTEGER, "grouping_id" TEXT, "group_pid" INTEGER, "revoked" INTEGER, "share_count" INTEGER, "pass_transaction_service_pid" INTEGER, "pass_message_service_pid" INTEGER, "pass_flavor" INTEGER, "primary_account_identifier" TEXT, "primary_account_suffix" TEXT, "sanitized_pan" TEXT, "sharing_method" INTEGER, "sharing_url" TEXT, "sharing_text" TEXT, "supports_dpan_notifications" INTEGER, "supports_fpan_notifications" INTEGER, "supports_default_card_selection" INTEGER, "supports_serial_number_based_provisioning" INTEGER, "requires_transfer_serial_number_based_provisioning" INTEGER, "has_stored_value" INTEGER, "payment_option_selectable" INTEGER, "pass_default_payment_application_pid" INTEGER, "cobranded" INTEGER, "low_balance_reminder_amount" INTEGER, "low_balance_reminder_currency" TEXT, "commute_plan_renewal_reminder_time_interval" INTEGER, "issuer_country_code" TEXT, "has_associated_peer_payment_account" INTEGER, "has_live_rendered_background" INTEGER, PRIMARY KEY (pid)) ‰ 33 °/tablepayment_transactionpayment_transaction CREATE TABLE "payment_transaction" ("pid" INTEGER, "pass_pid" INTEGER NOT NULL, "payment_application_pid" INTEGER, "identifier" TEXT, "service_identifier" TEXT, "payment_hash" TEXT, "payment_hash_component_1" TEXT, "payment_hash_component_2" TEXT, "currency_code" TEXT, "amount" INTEGER, "locality" TEXT, "administrative_area" TEXT, YÅ 5 windexpass_unique_id_indexpass CREATE INDEX pass_unique_id_index ON pass (unique_id)UÅ / uindexpass_flavor_indexpass CREATE INDEX pass_flavor_index ON pass (pass_flavor)ç(Å
ö3tablepasspass*CREATE TABLE "pass" ("pid" INTEGER, "unique_id" TEXT NOT NULL, "pass_type_pid" INTEGER NOT NULL, "serial_number" TEXT NOT NULL, "sequence_counter" INTEGER, "organization_name" TEXT, "relevant_date" INTEGER, "expiration_date" INTEGER, "voided" INTEGER, "user_info" BLOB, "template" INTEGER, "background_color" TEXT, "foreground_color" TEXT, "label_color" TEXT, "strip_color" TEXT, "tall_code" INTEGER, "has_background_image" INTEGER, "has_strip_image" INTEGER, "manifest_hash" BLOB, "web_service_pid" INTEGER, "push_registration_status" INTEGER, "push_registration_date" INTEGER, "authentication_token" TEXT, "last_modified_tag" TEXT, "ingested_date" INTEGER, "modified_date" INTEGER, "modified_source" INTEGER, "grouping_id" TEXT, "group_pid" INTEGER, "revoked" INTEGER, "share_count" INTEGER, "pass_transaction_service_pid" INTEGER, "pass_message_service_pid" INTEGER, "pass_flavor" INTEGER, "primary_account_identifier" TEXT, "primary_account_suffix" TEXT, "sanitized_pan" TEXT, "sharing_method" INTEGER, "sharing_url" TEXT, "sharing_text" TEXT, "supports_dpan_notifications" INTEGER, "supports_fpan_notifications" INTEGER, "supports_default_card_selection" INTEGER, "supports_serial_number_based_provisioning" INTEGER, "requires_transfer_serial_number_based_provisioning" INTEGER, "has_stored_value" INTEGER, "payment_option_selectable" INTEGER, "pass_default_payment_application_pid" INTEGER, "cobranded" INTEGER, "low_balance_reminder_amount" INTEGER, "low_balance_reminder_currency" TEXT, "commute_plan_renewal_reminder_time_interval" INTEGER, "issuer_country_code" TEXT, "has_associated_peer_payment_account" INTEGER, "has_live_rendered_background" INTEGER, PRIMARY KEY (pid))

© Copyright 2018, The Cyberculturalist

1 comment:

C Harris Lynn said...

We had to duck back in to turn the comments back on. We don't know who could have possibly turned them off! Must have been a glitch.

We apologize for the GLITCH, everybody. We hope there are no more GLITCHES, but we can make no promises. We are always working to ensure there are as few glitches as possible -- both here, and on the rest of the blogs -- but we have surely faced a nigh-insurmountable number of GLITCHES the last several DECADES. We'd be as vigilant about glitches on the site, but we haven't been able to access it in almost a year now... because of some unspecified glitch.

Thanks!