$ sqlite3 ansible.sqlite
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema
CREATE TABLE alembic_version (
        version_num VARCHAR(32) NOT NULL,
        CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
);
CREATE TABLE file_contents (
        id VARCHAR(40) NOT NULL,
        content BLOB,
        PRIMARY KEY (id)
);
CREATE TABLE playbooks (
        id VARCHAR(36) NOT NULL,
        path VARCHAR(255),
        time_start DATETIME,
        time_end DATETIME,
        complete BOOLEAN, ansible_version VARCHAR(255), options BLOB,
        PRIMARY KEY (id),
        CHECK (complete IN (0, 1))
);
CREATE TABLE files (
        id VARCHAR(36) NOT NULL,
        playbook_id VARCHAR(36),
        path VARCHAR(255),
        content_id VARCHAR(40),
        is_playbook BOOLEAN,
        PRIMARY KEY (id),
        FOREIGN KEY(content_id) REFERENCES file_contents (id),
        FOREIGN KEY(playbook_id) REFERENCES playbooks (id) ON DELETE RESTRICT,
        UNIQUE (playbook_id, path),
        CHECK (is_playbook IN (0, 1))
);
CREATE TABLE hosts (
        id VARCHAR(36) NOT NULL,
        playbook_id VARCHAR(36),
        name VARCHAR(255),
        PRIMARY KEY (id),
        FOREIGN KEY(playbook_id) REFERENCES playbooks (id) ON DELETE RESTRICT,
        UNIQUE (playbook_id, name)
);
CREATE INDEX ix_hosts_name ON hosts (name);
CREATE TABLE plays (
        id VARCHAR(36) NOT NULL,
        playbook_id VARCHAR(36),
        name TEXT,
        sortkey INTEGER,
        time_start DATETIME,
        time_end DATETIME,
        PRIMARY KEY (id),
        FOREIGN KEY(playbook_id) REFERENCES playbooks (id) ON DELETE RESTRICT
);
CREATE TABLE host_facts (
        id VARCHAR(36) NOT NULL,
        host_id VARCHAR(36),
        timestamp DATETIME,
        "values" TEXT(16777215),
        PRIMARY KEY (id),
        FOREIGN KEY(host_id) REFERENCES hosts (id) ON DELETE RESTRICT
);
CREATE TABLE stats (
        id VARCHAR(36) NOT NULL,
        playbook_id VARCHAR(36),
        host_id VARCHAR(36),
        changed INTEGER,
        failed INTEGER,
        ok INTEGER,
        skipped INTEGER,
        unreachable INTEGER,
        PRIMARY KEY (id),
        FOREIGN KEY(host_id) REFERENCES hosts (id) ON DELETE RESTRICT,
        FOREIGN KEY(playbook_id) REFERENCES playbooks (id) ON DELETE RESTRICT
);
CREATE TABLE tasks (
        id VARCHAR(36) NOT NULL,
        playbook_id VARCHAR(36),
        play_id VARCHAR(36),
        name TEXT,
        sortkey INTEGER,
        action TEXT,
        is_handler BOOLEAN,
        file_id VARCHAR(36),
        lineno INTEGER,
        time_start DATETIME,
        time_end DATETIME, tags TEXT,
        PRIMARY KEY (id),
        FOREIGN KEY(file_id) REFERENCES files (id) ON DELETE RESTRICT,
        FOREIGN KEY(play_id) REFERENCES plays (id) ON DELETE RESTRICT,
        FOREIGN KEY(playbook_id) REFERENCES playbooks (id) ON DELETE RESTRICT,
        CHECK (is_handler IN (0, 1))
);
CREATE TABLE task_results (
        id VARCHAR(36) NOT NULL,
        task_id VARCHAR(36),
        host_id VARCHAR(36),
        status VARCHAR(11),
        changed BOOLEAN,
        failed BOOLEAN,
        skipped BOOLEAN,
        unreachable BOOLEAN,
        ignore_errors BOOLEAN,
        result BLOB,
        time_start DATETIME,
        time_end DATETIME,
        PRIMARY KEY (id),
        FOREIGN KEY(host_id) REFERENCES hosts (id) ON DELETE RESTRICT,
        FOREIGN KEY(task_id) REFERENCES tasks (id) ON DELETE RESTRICT,
        CONSTRAINT status CHECK (status IN ('ok', 'failed', 'skipped', 'unreachable')),
        CHECK (changed IN (0, 1)),
        CHECK (failed IN (0, 1)),
        CHECK (skipped IN (0, 1)),
        CHECK (unreachable IN (0, 1)),
        CHECK (ignore_errors IN (0, 1))
);
CREATE TABLE data (
        id VARCHAR(36) NOT NULL,
        playbook_id VARCHAR(36),
        "key" VARCHAR(255),
        value BLOB, type VARCHAR(255),
        PRIMARY KEY (id),
        FOREIGN KEY(playbook_id) REFERENCES playbooks (id) ON DELETE RESTRICT,
        UNIQUE (playbook_id, "key")
);
sqlite> select * from alembic_version
   ...> ;
5716083d63f5

Rhel 7

$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.3 (Maipo)