Sergiusz Bazanski | 30317b4 | 2019-08-01 16:50:41 +0200 | [diff] [blame] | 1 | ALTER TABLE users RENAME TO users_old; |
2 | CREATE TABLE users ( | ||||
3 | id INTEGER PRIMARY KEY AUTOINCREMENT, | ||||
4 | username STRING | ||||
5 | ); | ||||
6 | INSERT INTO users (username) SELECT (username) FROM users_old; | ||||
7 | DROP TABLE users_old; |