ALTER TABLE users RENAME TO users_old;
CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username STRING
);
INSERT INTO users (username) SELECT (username) FROM users_old;
DROP TABLE users_old;