{"Web_client_accelerator": {"columns": [[0, "id", "INT", 0, null, 1], [1, "name", "TEXT", 0, null, 0], [2, "Operating_system", "TEXT", 0, null, 0], [3, "Client", "TEXT", 0, null, 0], [4, "Connection", "TEXT", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}, "browser": {"columns": [[0, "id", "INT", 0, null, 1], [1, "name", "TEXT", 0, null, 0], [2, "market_share", "REAL", 0, null, 0]], "primary_keys": ["id"], "foreign_keys": [], "unique_constraints": [[[0, 0, "id"]]], "check_constraints": []}, "accelerator_compatible_browser": {"columns": [[0, "accelerator_id", "INT", 0, null, 1], [1, "browser_id", "INT", 0, null, 2], [2, "compatible_since_year", "INT", 0, null, 0]], "primary_keys": ["accelerator_id", "browser_id"], "foreign_keys": [[0, 0, "browser", "browser_id", "id", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "Web_client_accelerator", "accelerator_id", "id", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "accelerator_id"], [1, 1, "browser_id"]]], "check_constraints": []}}
CREATE TABLE Web_client_accelerator (
    id INT   PRIMARY KEY,
    name TEXT,
    Operating_system TEXT,
    Client TEXT,
    Connection TEXT,
    UNIQUE (id)
);

CREATE TABLE browser (
    id INT   PRIMARY KEY,
    name TEXT,
    market_share REAL,
    UNIQUE (id)
);

CREATE TABLE accelerator_compatible_browser (
    accelerator_id INT   PRIMARY KEY,
    browser_id INT   PRIMARY KEY,
    compatible_since_year INT,
    PRIMARY KEY (accelerator_id, browser_id),
    UNIQUE (accelerator_id, browser_id),
    FOREIGN KEY (browser_id) REFERENCES browser(id),
    FOREIGN KEY (accelerator_id) REFERENCES Web_client_accelerator(id)
);