Skip to content

Pending SQL update for Production

skyhit edited this page Jan 13, 2015 · 8 revisions

TopCoder Competition Engine - Automatically End Matches

database informixoltp;
auto_end DECIMAL(1,0) default 0

TopCoder Competition Engine - Return Time Infos When Opening Problems

database informixoltp;

ALTER TABLE compilation ADD saved_time DECIMAL(14,0);
ALTER TABLE compilation ADD compiled_time DECIMAL(14,0);

TopCoder Competition Engine - Add Editorial Link For Matches

database informixoltp;
ALTER TABLE round ADD editorial_link VARCHAR(255);

Super Match Creation Page

database informixoltp;
INSERT INTO 'informix'.secure_object (secure_object_id, secure_object_type) VALUES(60, 'G');
INSERT INTO 'informix'.group (group_id,group_desc,access_id) VALUES (60,'Web Arena Super User',null);

to add any user to have Super user role, it can be

INSERT INTO 'informix'.group_user VALUES (60,<<user id>>);