Skip to content

Instantly share code, notes, and snippets.

@selenamarie
Created Jun 12, 2013
Embed
What would you like to do?
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
--
-- Data for Name: data_dictionary; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY data_dictionary (raw_field, transforms, product) FROM stdin;
test {} \N
AdapterDeviceID {"data name": "AdapterDeviceID", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
AdapterVendorID {"data name": "AdapterVendorID", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Add-ons {"data name": "Add-ons", "mdsw pipe dump": "", "database": "", "pj transform": "addons", "ted's mdsw json": "extensions.extension_key, extensions.extension_id, extensions.extension_version ", "1.X processed json": "", "processor transform": "addons", "collector:raw json": "", "processed json 2012": "list of lists "} \N
Android_Board {"data name": "Android_Board", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Android_Brand {"data name": "Android_Brand", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Android_CPU_ABI2 {"data name": "Android_CPU_ABI2", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Android_Device {"data name": "Android_Device", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Android_Display {"data name": "Android_Display", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Android_Fingerprint {"data name": "Android_Fingerprint", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Android_Manufacturer {"data name": "Android_Manufacturer", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Android_Model {"data name": "Android_Model", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Android_Version {"data name": "Android_Version", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
AvailablePhysicalMemory {"data name": "AvailablePhysicalMemory", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
AvailableVirtualMemory {"data name": "AvailableVirtualMemory", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
AvalablePageFile {"data name": "AvalablePageFile", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
BuildID {"data name": "BuildID", "mdsw pipe dump": "", "database": "", "pj transform": "build", "ted's mdsw json": "reports.build (16)", "1.X processed json": "", "processor transform": "build", "collector:raw json": "", "processed json 2012": ""} \N
buildid {"data name": "buildid", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "inadvertent extra value from breakpad, not used"} \N
Comments {"data name": "Comments", "mdsw pipe dump": "", "database": "truncated to 500 characters; None if missing", "pj transform": "user_comments", "ted's mdsw json": "reports.user_comments (500)", "1.X processed json": "truncated to 500 characters; None if missing", "processor transform": "user_comments", "collector:raw json": "", "processed json 2012": ""} \N
CrashTime {"data name": "CrashTime", "mdsw pipe dump": "", "database": "truncated to 10 characters, converted to integer; if missing, reverts to the value of 'timestamp'. Converted to timestamp with time zone in the database\\n", "pj transform": "client_crash_date", "ted's mdsw json": "reports.client_crash_date", "1.X processed json": "truncated to 10 characters, converted to integer; if missing, reverts to the value of 'timestamp'. Converted back to string in almost ISO 8601 for json.\\n", "processor transform": "client_crash_date", "collector:raw json": "", "processed json 2012": "UTZ applied by processor"} \N
submitted_timestamp {"data name": "submitted_timestamp", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "reports.date_processed", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Distributor {"data name": "Distributor", "mdsw pipe dump": "", "database": "truncated to 20 characters; None if missing", "pj transform": "distributor", "ted's mdsw json": "reports.distributor (20)", "1.X processed json": "truncated to 20 characters; None if missing", "processor transform": "distributor", "collector:raw json": "", "processed json 2012": ""} \N
Distributor_version {"data name": "Distributor_version", "mdsw pipe dump": "", "database": "truncated to 20 characters; None if missing", "pj transform": "distributor_version", "ted's mdsw json": "reports.distributor_version (20)", "1.X processed json": "truncated to 20 characters; None if missing", "processor transform": "distributor_version", "collector:raw json": "", "processed json 2012": ""} \N
Email {"data name": "Email", "mdsw pipe dump": "", "database": "truncated to 100 characters; None if missing", "pj transform": "", "ted's mdsw json": "reports.email (100)", "1.X processed json": "truncated to 100 characters; None if missing", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
EMCheckCompatibility {"data name": "EMCheckCompatibility", "mdsw pipe dump": "", "database": "converted to lower case, then to boolean True if 'true' and False for any other value", "pj transform": "addons_checked", "ted's mdsw json": "reports.addons_checked", "1.X processed json": "converted to lower case, then to boolean True if 'true' and False for any other value", "processor transform": "addons_checked", "collector:raw json": "", "processed json 2012": ""} \N
FramePoisonBase {"data name": "FramePoisonBase", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
FramePoisonSize {"data name": "FramePoisonSize", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Hang {"data name": "Hang", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "not currently enabled in breakpad"} \N
HangID {"data name": "HangID", "mdsw pipe dump": "", "database": "no conversion; None if missng", "pj transform": "hangid", "ted's mdsw json": "reports.hangid", "1.X processed json": "no conversion; None if missng", "processor transform": "hangid", "collector:raw json": "", "processed json 2012": ""} \N
id {"data name": "id", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "name collision: the raw json 'id'"} \N
InstallTime {"data name": "InstallTime", "mdsw pipe dump": "", "database": "converted to int; reverts to 'startuptime' if missing", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "converted to int; reverts to 'startuptime' if missing", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
JavaStackTrace {"data name": "JavaStackTrace", "mdsw pipe dump": "", "database": "", "pj transform": "java_stack_trace", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
legacy_processing {"data name": "legacy_processing", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "added by collector"} \N
Min_ARM_Version {"data name": "Min_ARM_Version", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Notes {"data name": "Notes", "mdsw pipe dump": "", "database": "truncated to 1000; None if missing", "pj transform": "app_notes", "ted's mdsw json": "reports.app_notes (1000)", "1.X processed json": "truncated to 1000; None if missing", "processor transform": "app_notes", "collector:raw json": "", "processed json 2012": ""} \N
PluginFilename {"data name": "PluginFilename", "mdsw pipe dump": "", "database": "no conversion; empty string if missing", "pj transform": "pluginFilename", "ted's mdsw json": "plugins.filename", "1.X processed json": "only present if 'plugin' crash type", "processor transform": "pluginFilename", "collector:raw json": "", "processed json 2012": ""} \N
PluginName {"data name": "PluginName", "mdsw pipe dump": "", "database": "no conversion; empty string if missing", "pj transform": "pluginName", "ted's mdsw json": "plugins.name", "1.X processed json": "only present if 'plugin' crash type", "processor transform": "pluginName", "collector:raw json": "", "processed json 2012": ""} \N
PluginVersion {"data name": "PluginVersion", "mdsw pipe dump": "", "database": "no conversion; empty string if missing", "pj transform": "pluginVersion", "ted's mdsw json": "plugins_reports.pluginVersion", "1.X processed json": "only present if 'plugin' crash type", "processor transform": "pluginVersion", "collector:raw json": "", "processed json 2012": ""} \N
ProcessType {"data name": "ProcessType", "mdsw pipe dump": "", "database": "truncated to 10; None if missing", "pj transform": "process_type", "ted's mdsw json": "reports.process_type", "1.X processed json": "truncated to 10; None if missing", "processor transform": "process_type", "collector:raw json": "", "processed json 2012": ""} \N
ProductName {"data name": "ProductName", "mdsw pipe dump": "", "database": "", "pj transform": "product", "ted's mdsw json": "reports.product (30)", "1.X processed json": "", "processor transform": "product", "collector:raw json": "", "processed json 2012": ""} \N
ReleaseChannel {"data name": "ReleaseChannel", "mdsw pipe dump": "", "database": "", "pj transform": "release_channel", "ted's mdsw json": "reports.release_channel", "1.X processed json": "", "processor transform": "release_channel", "collector:raw json": "", "processed json 2012": ""} \N
SecondsSinceLastCrash {"data name": "SecondsSinceLastCrash", "mdsw pipe dump": "", "database": "converted to int", "pj transform": "last_crash", "ted's mdsw json": "reports.last_crash", "1.X processed json": "converted to int", "processor transform": "last_crash", "collector:raw json": "", "processed json 2012": ""} \N
StartupTime {"data name": "StartupTime", "mdsw pipe dump": "", "database": "converted to int; reverts to 'CrashTime' if missing", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "converted to int; reverts to 'CrashTime' if missing", "processor transform": "", "collector:raw json": "", "processed json 2012": "decimal unix timestamp of 10 or fewer digits"} \N
SystemMemoryUsePercentage {"data name": "SystemMemoryUsePercentage", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Theme {"data name": "Theme", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Throttleable {"data name": "Throttleable", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
timestamp {"data name": "timestamp", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
TotalVirtualMemory {"data name": "TotalVirtualMemory", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
URL {"data name": "URL", "mdsw pipe dump": "", "database": "truncated to 255; None if missing", "pj transform": "", "ted's mdsw json": "reports.url (255)", "1.X processed json": "truncated to 255; None if missing", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
UserID {"data name": "UserID", "mdsw pipe dump": "", "database": "forced to empty string", "pj transform": "", "ted's mdsw json": "reports.user_id", "1.X processed json": "forced to empty string", "processor transform": "", "collector:raw json": "", "processed json 2012": "processor always leaves this blank"} \N
Vendor {"data name": "Vendor", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": ""} \N
Version {"data name": "Version", "mdsw pipe dump": "", "database": "truncated to 16; 'esr' appended if ReleaseChannel is 'ESR'; None if missing", "pj transform": "version", "ted's mdsw json": "reports.version (16)", "1.X processed json": "truncated to 16; 'esr' appended if ReleaseChannel is 'ESR'; None if missing", "processor transform": "version", "collector:raw json": "", "processed json 2012": ""} \N
version {"data name": "version", "mdsw pipe dump": "", "database": "", "pj transform": "", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "", "collector:raw json": "", "processed json 2012": "inadvertent extra value from breakpad, not used"} \N
Winsock_LSP {"data name": "Winsock_LSP", "mdsw pipe dump": "", "database": "", "pj transform": "Winsock_LSP", "ted's mdsw json": "", "1.X processed json": "", "processor transform": "Winsock_LSP", "collector:raw json": "", "processed json 2012": ""} \N
\.
--
-- PostgreSQL database dump complete
--
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment