ALTER TABLE Role_ DROP companyId;
ALTER TABLE Role_ DROP classNameId;
ALTER TABLE Role_ DROP classPK;
ALTER TABLE Role_ DROP type_;
ALTER TABLE Role_ DROP subtype;
ALTER TABLE Role_ DROP uuid_;
ALTER TABLE Role_ DROP userId;
ALTER TABLE Role_ DROP userName;
ALTER TABLE Role_ DROP modifiedDate;

-- Delete unused roles
delete from Role_ where roleId in (10120, 10123 ,10124 ,10125, 10126, 10127, 10128, 26021, 1015916,
    1015917, 1015918, 1411593);

DROP INDEX IX_A88E424E on Role_;
DROP INDEX IX_EBC931B8 on Role_;
DROP INDEX IX_449A10B9 on Role_;
DROP INDEX IX_CBE204   on Role_;
DROP INDEX IX_F436EC8E on Role_;
DROP INDEX IX_5EB4E2FB on Role_;
DROP INDEX IX_F3E1C6FC on Role_;
DROP INDEX IX_F92B66E6 on Role_;
DROP INDEX IX_26DB26C5 on Role_;
DROP INDEX IX_B9FF6043 on Role_;

ALTER TABLE Role_ DROP companyId;
ALTER TABLE Role_ DROP classNameId;
ALTER TABLE Role_ DROP classPK;
ALTER TABLE Role_ DROP type_;
ALTER TABLE Role_ DROP subtype;
ALTER TABLE Role_ DROP uuid_;
ALTER TABLE Role_ DROP userId;
ALTER TABLE Role_ DROP userName;
ALTER TABLE Role_ DROP modifiedDate;

-- Delete unused roles
delete from Role_ where roleId in (10120, 10123 ,10124 ,10125, 10126, 10127, 10128, 26021, 1015916,
    1015917, 1015918, 1411593);

Drop Role_ indexes before columns
[COLAB-2643] Drop Role_ indexes before columns
