sql/sqlite/patch-slot_roles-role_id-fix_not_null.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE /*_*/slot_roles_tmp (
  role_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  role_name BLOB NOT NULL
);

INSERT INTO /*_*/slot_roles_tmp
	SELECT role_id, role_name
		FROM /*_*/slot_roles;
DROP TABLE /*_*/slot_roles;
ALTER TABLE /*_*/slot_roles_tmp RENAME TO /*_*/slot_roles;
CREATE UNIQUE INDEX role_name ON /*_*/slot_roles (role_name);