Page MenuHomeWickedGov Phorge

patch-slot_roles-role_id-fix_not_null.sql
No OneTemporary

Size
351 B
Referenced Files
None
Subscribers
None

patch-slot_roles-role_id-fix_not_null.sql

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

File Metadata

Mime Type
text/plain
Expires
Fri, Jul 3, 21:57 (5 h, 59 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
52/a2/b76a66cd2c6f3b4cf7f5fb325c24
Default Alt Text
patch-slot_roles-role_id-fix_not_null.sql (351 B)

Event Timeline