-
Julien Muchembled authored
SQL tables can be upgraded using: UPDATE config SET name = 'nid' WHERE name = 'uuid'; then for MySQL: ALTER TABLE pt CHANGE uuid nid INT NOT NULL; or SQLite: ALTER TABLE pt RENAME TO old_pt; CREATE TABLE pt (rid INTEGER NOT NULL, nid INTEGER NOT NULL, state INTEGER NOT NULL, PRIMARY KEY (rid, nid)); INSERT INTO pt SELECT * from old_pt; DROP TABLE old_pt;
b81ae60a