#!/bin/bash
PAL_DB=${PAL_DB:-pal.db}

cat << EOF | sqlite3 $PAL_DB
CREATE TABLE IF NOT EXISTS report (
    commit_date INTEGER, -- UNIX epoch
    commit_sha TEXT,
    platform TEXT,
    file TEXT,
    symbol TEXT,
    cflags TEXT,
    type TEXT,
    size INTEGER,
    PRIMARY KEY (commit_date, commit_sha, platform, file, symbol)
);
EOF

#!/bin/bash
PAL_DB=${PAL_DB:-pal.db}

cat << EOF | sqlite3 $PAL_DB
CREATE TABLE IF NOT EXISTS report (
    commit_date INTEGER, -- UNIX epoch
    commit_sha TEXT,
    platform TEXT,
    file TEXT,
    symbol TEXT,
    cflags TEXT,
    type TEXT,
    size INTEGER,
    PRIMARY KEY (commit_date, commit_sha, platform, file, symbol, cflags)
);
EOF

Update db scheme to include cflags in primary key
tools:reports: Update db scheme to include cflags in primary key

We need the cflags column in the primary key so the unique
constraint can be fulfilled when we do multiple builds with the
same platform/sha but with different CFLAGS.

Signed-off-by: Ola Jeppsson <793f970c52ded1276b9264c742f19d1888cbaf73@adapteva.com>
