| 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; | ||||