Roe SQLite Example

PRAGMA foreign_keys = 0;

CREATE TABLE sqlitestudio_temp_table AS SELECT *
                                          FROM combat;

DROP TABLE combat;

CREATE TABLE combat (
    contact_id    INTEGER PRIMARY KEY,
    piercing_stat FLOAT,
    armored_stat  FLOAT,
    evasion_stat  FLOAT,
    ""
);

INSERT INTO combat (
                       contact_id,
                       piercing_stat,
                       armored_stat,
                       evasion_stat
                   )
                   SELECT contact_id,
                          piercing_stat,
                          armored_stat,
                          evasion_stat
                     FROM sqlitestudio_temp_table;

DROP TABLE sqlitestudio_temp_table;

PRAGMA foreign_keys = 1;