Page MenuHomeWickedGov Phorge
Files F4096694

patch-slot_roles-role_id-fix_not_null.sql
No OneTemporary
Actions

Size
351 B
Referenced Files
None
Subscribers
None

patch-slot_roles-role_id-fix_not_null.sql
View Options

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
Tue, Aug 18, 14:28 (3 w, 6 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
05/35/7c1d4c1e2efe2f026320c43be543
Default Alt Text
patch-slot_roles-role_id-fix_not_null.sql (351 B)

Event Timeline