Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `tsms_submission_sprites` AS
- SELECT r.uid, r.title, r.description, r.author_override, r.created, r.updated, r.queue_code, r.ghost, r.accept_date, r.update_accept_date, r.decision, r.catwords, z.*
- FROM tsms_res_gfx z
- LEFT JOIN tsms_resources r ON r.eid = z.eid && r.type = 1
- ;
- ALTER TABLE `tsms_submission_sprites` ADD `id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);
- ALTER TABLE `tsms_submission_sprites` DROP `eid`;
- CREATE TABLE tsms_submission_games AS
- SELECT r.uid, r.title, r.description, r.author_override, r.created, r.updated, r.queue_code, r.ghost, r.accept_date, r.update_accept_date, r.decision, r.catwords, z.*
- FROM tsms_res_games z
- LEFT JOIN tsms_resources r ON r.eid = z.eid && r.type = 2
- ;
- ALTER TABLE `tsms_submission_games` ADD `id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);
- UPDATE `tsms_submission_games` g SET g.eid = (
- SELECT r.rid
- FROM `tsms_resources` r
- WHERE r.eid = g.eid && r.type = 2
- );
- CREATE TABLE tsms_submission_hacks AS
- SELECT r.uid, r.title, r.description, r.author_override, r.created, r.updated, r.queue_code, r.ghost, r.accept_date, r.update_accept_date, r.decision, r.catwords, z.*
- FROM tsms_res_hacks z
- LEFT JOIN tsms_resources r ON r.eid = z.eid && r.type = 7
- ;
- ALTER TABLE `tsms_submission_hacks` ADD `id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);
- CREATE TABLE tsms_submission_reviews AS
- SELECT r.uid, r.title, r.description, r.author_override, r.created, r.updated, r.queue_code, r.ghost, r.accept_date, r.update_accept_date, r.decision, r.catwords, z.*
- FROM tsms_res_reviews z
- LEFT JOIN tsms_resources r ON r.eid = z.eid && r.type = 3
- ;
- ALTER TABLE `tsms_submission_reviews` ADD `id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);
- ALTER TABLE `tsms_submission_reviews` ADD `type` INT NOT NULL DEFAULT '0' AFTER `score`;
- UPDATE `tsms_submission_reviews` r SET r.gid = (
- SELECT z.id
- FROM tsms_submission_games z
- LEFT JOIN tsms_resources s ON s.eid = z.eid && s.type = 2
- WHERE s.rid = r.gid
- ), r.type = 1;
- UPDATE `tsms_submission_reviews` r SET r.gid = (
- SELECT g.id FROM `tsms_submission_hacks` h
- RIGHT JOIN `tsms_resources` s ON s.eid = h.eid
- WHERE s.rid = r.gid
- ), r.type = 2 WHERE r.type = 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement