SD2 DB cleanup.sql

gistfile1.sql

-------------------------------------------
-- Corrections to the table script_texts --
-------------------------------------------

-- This query has done the extraction --
-- SELECT a1.entry ,a1.sound FROM script_texts a1 INNER JOIN script_texts a2 ON a1.sound <> 0 AND a1.sound = a2.sound AND a1.entry <> a2.entry ORDER BY a1.entry ASC



-- headless horseman event texts -
--insert into `script_texts` (`entry`, `sound`) values('-1110006','12573'); -- This ID of sound [12573] it not correct must be replaced
--insert into `script_texts` (`entry`, `sound`) values('-1189026','12573'); -- good

-- instance_sunwell_plateau [Kil'jaeden] --
--insert into `script_texts` (`entry`, `sound`) values('-1580098','12518'); -- This ID of sound [12518] it not correct must be replaced
--insert into `script_texts` (`entry`, `sound`) values('-1580099','12518'); -- good

-- Error of SD2 --
--insert into `script_texts` (`entry`, `sound`) values('-1602018','14162'); -- good
--insert into `script_texts` (`entry`, `sound`) values('-1602020','14162'); -- This ID of sound [14162] it not correct must be replaced (Error of SD2)

--insert into `script_texts` (`entry`, `sound`) values('-1409010','8041'); -- good
--insert into `script_texts` (`entry`, `sound`) values('-1469005','8280'); -- good
--insert into `script_texts` (`entry`, `sound`) values('-1533005','8791'); -- good
--insert into `script_texts` (`entry`, `sound`) values('-1533114','8831'); -- good


-- duplicated of SD2 [r860_scriptdev2_script_texts] need delete --

DELETE FROM `script_texts` WHERE entry='-1999900';
DELETE FROM `script_texts` WHERE entry='-1999901';
DELETE FROM `script_texts` WHERE entry='-1999903';
DELETE FROM `script_texts` WHERE entry='-1999905';


-- insert by mr00001_scriptdev2_ruby_sanctum.sql (good) --

--insert into `script_texts` (`entry`, `sound`) values('-1666000','17490');
--insert into `script_texts` (`entry`, `sound`) values('-1666001','17491');
--insert into `script_texts` (`entry`, `sound`) values('-1666002','17492');
--insert into `script_texts` (`entry`, `sound`) values('-1666003','17493');
--insert into `script_texts` (`entry`, `sound`) values('-1666004','17494');
--insert into `script_texts` (`entry`, `sound`) values('-1666005','17495');
--insert into `script_texts` (`entry`, `sound`) values('-1666006','17496');
--insert into `script_texts` (`entry`, `sound`) values('-1666007','17497');
--insert into `script_texts` (`entry`, `sound`) values('-1666008','17498');
--insert into `script_texts` (`entry`, `sound`) values('-1666100','17499');
--insert into `script_texts` (`entry`, `sound`) values('-1666101','17500');
--insert into `script_texts` (`entry`, `sound`) values('-1666102','17501');
--insert into `script_texts` (`entry`, `sound`) values('-1666104','17503');
--insert into `script_texts` (`entry`, `sound`) values('-1666105','17504');
--insert into `script_texts` (`entry`, `sound`) values('-1666106','17505');
--insert into `script_texts` (`entry`, `sound`) values('-1666107','17506');
--insert into `script_texts` (`entry`, `sound`) values('-1666108','17507');
--insert into `script_texts` (`entry`, `sound`) values('-1666109','17508');
--insert into `script_texts` (`entry`, `sound`) values('-1666200','17512');
--insert into `script_texts` (`entry`, `sound`) values('-1666201','17513');
--insert into `script_texts` (`entry`, `sound`) values('-1666202','17514');
--insert into `script_texts` (`entry`, `sound`) values('-1666203','17515');
--insert into `script_texts` (`entry`, `sound`) values('-1666204','17516');
--insert into `script_texts` (`entry`, `sound`) values('-1666300','17520');
--insert into `script_texts` (`entry`, `sound`) values('-1666301','17521');
--insert into `script_texts` (`entry`, `sound`) values('-1666302','17522');
--insert into `script_texts` (`entry`, `sound`) values('-1666303','17523');
--insert into `script_texts` (`entry`, `sound`) values('-1666304','17524');
--insert into `script_texts` (`entry`, `sound`) values('-1666305','17525');
--insert into `script_texts` (`entry`, `sound`) values('-1666400','17528');
--insert into `script_texts` (`entry`, `sound`) values('-1666401','17529');
--insert into `script_texts` (`entry`, `sound`) values('-1666402','17530');
--insert into `script_texts` (`entry`, `sound`) values('-1666404','17532');

-- duplicated of SD2 [scriptdev2_ruby_sanctum] must be deleted --

DELETE FROM `script_texts` WHERE entry='-1724000';
DELETE FROM `script_texts` WHERE entry='-1724001';
DELETE FROM `script_texts` WHERE entry='-1724002';
DELETE FROM `script_texts` WHERE entry='-1724003';
DELETE FROM `script_texts` WHERE entry='-1724004';
DELETE FROM `script_texts` WHERE entry='-1724005';
DELETE FROM `script_texts` WHERE entry='-1724006';
DELETE FROM `script_texts` WHERE entry='-1724007';
DELETE FROM `script_texts` WHERE entry='-1724008';
DELETE FROM `script_texts` WHERE entry='-1724009';
DELETE FROM `script_texts` WHERE entry='-1724024';
DELETE FROM `script_texts` WHERE entry='-1724025';
DELETE FROM `script_texts` WHERE entry='-1724026';
DELETE FROM `script_texts` WHERE entry='-1724027';
DELETE FROM `script_texts` WHERE entry='-1724028';
DELETE FROM `script_texts` WHERE entry='-1724029';
DELETE FROM `script_texts` WHERE entry='-1724030';
DELETE FROM `script_texts` WHERE entry='-1724031';
DELETE FROM `script_texts` WHERE entry='-1724032';
DELETE FROM `script_texts` WHERE entry='-1724010';
DELETE FROM `script_texts` WHERE entry='-1724011';
DELETE FROM `script_texts` WHERE entry='-1724012';
DELETE FROM `script_texts` WHERE entry='-1724013';
DELETE FROM `script_texts` WHERE entry='-1724014';
DELETE FROM `script_texts` WHERE entry='-1724015';
DELETE FROM `script_texts` WHERE entry='-1724016';
DELETE FROM `script_texts` WHERE entry='-1724017';
DELETE FROM `script_texts` WHERE entry='-1724018';
DELETE FROM `script_texts` WHERE entry='-1724019';
DELETE FROM `script_texts` WHERE entry='-1724020';
DELETE FROM `script_texts` WHERE entry='-1724021';
DELETE FROM `script_texts` WHERE entry='-1724022';
DELETE FROM `script_texts` WHERE entry='-1724023';


-- insert by mr00001_scriptdev2_trial_of_crusader.sql (good) --

--insert into `script_texts` (`entry`, `sound`) values('-1713500','16036');
--insert into `script_texts` (`entry`, `sound`) values('-1713501','16038');
--insert into `script_texts` (`entry`, `sound`) values('-1713502','16069');
--insert into `script_texts` (`entry`, `sound`) values('-1713503','16039');
--insert into `script_texts` (`entry`, `sound`) values('-1713505','16040');
--insert into `script_texts` (`entry`, `sound`) values('-1713509','16041');
--insert into `script_texts` (`entry`, `sound`) values('-1713510','16043');
--insert into `script_texts` (`entry`, `sound`) values('-1713511','16268');
--insert into `script_texts` (`entry`, `sound`) values('-1713512','16269');
--insert into `script_texts` (`entry`, `sound`) values('-1713513','16270');
--insert into `script_texts` (`entry`, `sound`) values('-1713514','16143');
--insert into `script_texts` (`entry`, `sound`) values('-1713515','16271');
--insert into `script_texts` (`entry`, `sound`) values('-1713516','16044');
--insert into `script_texts` (`entry`, `sound`) values('-1713517','16144');
--insert into `script_texts` (`entry`, `sound`) values('-1713521','16150');
--insert into `script_texts` (`entry`, `sound`) values('-1713523','16149');
--insert into `script_texts` (`entry`, `sound`) values('-1713524','16151');
--insert into `script_texts` (`entry`, `sound`) values('-1713525','16147');
--insert into `script_texts` (`entry`, `sound`) values('-1713526','16045');
--insert into `script_texts` (`entry`, `sound`) values('-1713527','16021');
--insert into `script_texts` (`entry`, `sound`) values('-1713528','16064');
--insert into `script_texts` (`entry`, `sound`) values('-1713529','16046');
--insert into `script_texts` (`entry`, `sound`) values('-1713530','16047');
--insert into `script_texts` (`entry`, `sound`) values('-1713531','16023');
--insert into `script_texts` (`entry`, `sound`) values('-1713532','16048');
--insert into `script_texts` (`entry`, `sound`) values('-1713533','16022');
--insert into `script_texts` (`entry`, `sound`) values('-1713534','16067');
--insert into `script_texts` (`entry`, `sound`) values('-1713535','16049');
--insert into `script_texts` (`entry`, `sound`) values('-1713536','16050');
--insert into `script_texts` (`entry`, `sound`) values('-1713537','16037');
--insert into `script_texts` (`entry`, `sound`) values('-1713541','16272');
--insert into `script_texts` (`entry`, `sound`) values('-1713541','16272');
--insert into `script_texts` (`entry`, `sound`) values('-1713542','16279');
--insert into `script_texts` (`entry`, `sound`) values('-1713543','16277');
--insert into `script_texts` (`entry`, `sound`) values('-1713544','16276');
--insert into `script_texts` (`entry`, `sound`) values('-1713545','16274');
--insert into `script_texts` (`entry`, `sound`) values('-1713546','16278');
--insert into `script_texts` (`entry`, `sound`) values('-1713547','16275');
--insert into `script_texts` (`entry`, `sound`) values('-1713548','16068');
--insert into `script_texts` (`entry`, `sound`) values('-1713549','16051');
--insert into `script_texts` (`entry`, `sound`) values('-1713550','16321');
--insert into `script_texts` (`entry`, `sound`) values('-1713551','16052');
--insert into `script_texts` (`entry`, `sound`) values('-1713552','16322');
--insert into `script_texts` (`entry`, `sound`) values('-1713553','16323');
--insert into `script_texts` (`entry`, `sound`) values('-1713554','16235');
--insert into `script_texts` (`entry`, `sound`) values('-1713555','16234');
--insert into `script_texts` (`entry`, `sound`) values('-1713556','16240');
--insert into `script_texts` (`entry`, `sound`) values('-1713560','16241');
--insert into `script_texts` (`entry`, `sound`) values('-1713562','16236');
--insert into `script_texts` (`entry`, `sound`) values('-1713563','16237');
--insert into `script_texts` (`entry`, `sound`) values('-1713564','16238');
--insert into `script_texts` (`entry`, `sound`) values('-1713702','16026');
--insert into `script_texts` (`entry`, `sound`) values('-1713709','16042');
--insert into `script_texts` (`entry`, `sound`) values('-1713731','16066');
--insert into `script_texts` (`entry`, `sound`) values('-1713733','16065');
--insert into `script_texts` (`entry`, `sound`) values('-1713734','16024');
--insert into `script_texts` (`entry`, `sound`) values('-1713741','16272');
--insert into `script_texts` (`entry`, `sound`) values('-1713741','16272');
--insert into `script_texts` (`entry`, `sound`) values('-1713748','16025');


-- duplicated of SD2 [scriptdev2_trial_of_crusader] must be deleted  --

DELETE FROM `script_texts` WHERE entry='-1649000';
DELETE FROM `script_texts` WHERE entry='-1649002';
DELETE FROM `script_texts` WHERE entry='-1649003';
DELETE FROM `script_texts` WHERE entry='-1649004';
DELETE FROM `script_texts` WHERE entry='-1649005';
DELETE FROM `script_texts` WHERE entry='-1649006';
DELETE FROM `script_texts` WHERE entry='-1649007';
DELETE FROM `script_texts` WHERE entry='-1649008';
DELETE FROM `script_texts` WHERE entry='-1649009';
DELETE FROM `script_texts` WHERE entry='-1649010';
DELETE FROM `script_texts` WHERE entry='-1649011';
DELETE FROM `script_texts` WHERE entry='-1649012';
DELETE FROM `script_texts` WHERE entry='-1649013';
DELETE FROM `script_texts` WHERE entry='-1649014';
DELETE FROM `script_texts` WHERE entry='-1649015';
DELETE FROM `script_texts` WHERE entry='-1649016';
DELETE FROM `script_texts` WHERE entry='-1649017';
DELETE FROM `script_texts` WHERE entry='-1649018';
DELETE FROM `script_texts` WHERE entry='-1649019';
DELETE FROM `script_texts` WHERE entry='-1649020';
DELETE FROM `script_texts` WHERE entry='-1649021';
DELETE FROM `script_texts` WHERE entry='-1649022';
DELETE FROM `script_texts` WHERE entry='-1649023';
DELETE FROM `script_texts` WHERE entry='-1649024';
DELETE FROM `script_texts` WHERE entry='-1649025';
DELETE FROM `script_texts` WHERE entry='-1649026';
DELETE FROM `script_texts` WHERE entry='-1649027';
DELETE FROM `script_texts` WHERE entry='-1649028';
DELETE FROM `script_texts` WHERE entry='-1649029';
DELETE FROM `script_texts` WHERE entry='-1649030';
DELETE FROM `script_texts` WHERE entry='-1649031';
DELETE FROM `script_texts` WHERE entry='-1649032';
DELETE FROM `script_texts` WHERE entry='-1649033';
DELETE FROM `script_texts` WHERE entry='-1649034';
DELETE FROM `script_texts` WHERE entry='-1649035';
DELETE FROM `script_texts` WHERE entry='-1649036';
DELETE FROM `script_texts` WHERE entry='-1649037';
DELETE FROM `script_texts` WHERE entry='-1649038';
DELETE FROM `script_texts` WHERE entry='-1649040';
DELETE FROM `script_texts` WHERE entry='-1649043';
DELETE FROM `script_texts` WHERE entry='-1649045';
DELETE FROM `script_texts` WHERE entry='-1649046';
DELETE FROM `script_texts` WHERE entry='-1649047';
DELETE FROM `script_texts` WHERE entry='-1649056';
DELETE FROM `script_texts` WHERE entry='-1649056';
DELETE FROM `script_texts` WHERE entry='-1649058';
DELETE FROM `script_texts` WHERE entry='-1649059';
DELETE FROM `script_texts` WHERE entry='-1649060';
DELETE FROM `script_texts` WHERE entry='-1649061';
DELETE FROM `script_texts` WHERE entry='-1649062';
DELETE FROM `script_texts` WHERE entry='-1649063';
DELETE FROM `script_texts` WHERE entry='-1649064';
DELETE FROM `script_texts` WHERE entry='-1649065';
DELETE FROM `script_texts` WHERE entry='-1649066';
DELETE FROM `script_texts` WHERE entry='-1649067';
DELETE FROM `script_texts` WHERE entry='-1649069';
DELETE FROM `script_texts` WHERE entry='-1649070';

Fix to error of SD2
UPDATE script_texts SET sound= '14161' WHERE entry='-1602020';

Fix to the other 3 error of R2
UPDATE script_texts SET sound='12574' WHERE entry='-1110006';
DELETE FROM script_texts WHERE entry='-1580098';
DELETE FROM script_texts WHERE entry='-1713741'
That's all