Advertisement
Guest User

User 01 - Master User-music

a guest
Aug 31st, 2015
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.37 KB | None | 0 0
  1. RENAME TABLE `Master_Music_52`.`song` to `Master_Music_52`.`globalsong`;
  2.  
  3. ALTER TABLE `Master_Music_52`.`globalsong` CHANGE iTimesPlayed iTimesPlayedMaster INT;
  4. ALTER TABLE `Master_Music_52`.`globalsong` ADD iTimesPlayed22222 INT(11) AFTER iTimesPlayedMaster;
  5. ALTER TABLE `Master_Music_52`.`globalsong` ADD iTimesPlayed33333 INT(11) AFTER iTimesPlayed22222;
  6. ALTER TABLE `Master_Music_52`.`globalsong` ADD iTimesPlayed44444 INT(11) AFTER iTimesPlayed33333;
  7. ALTER TABLE `Master_Music_52`.`globalsong` ADD iTimesPlayed55555 INT(11) AFTER iTimesPlayed44444;
  8. ALTER TABLE `Master_Music_52`.`globalsong` CHANGE lastPlayed lastPlayedMaster VARCHAR(20);
  9. ALTER TABLE `Master_Music_52`.`globalsong` ADD lastPlayed22222 VARCHAR(20) AFTER lastPlayedMaster;
  10. ALTER TABLE `Master_Music_52`.`globalsong` ADD lastPlayed33333 VARCHAR(20) AFTER lastPlayed22222;
  11. ALTER TABLE `Master_Music_52`.`globalsong` ADD lastPlayed44444 VARCHAR(20) AFTER lastPlayed33333;
  12. ALTER TABLE `Master_Music_52`.`globalsong` ADD lastPlayed55555 VARCHAR(20) AFTER lastPlayed44444;
  13.  
  14. CREATE OR REPLACE VIEW `Master_Music_52`.`song`
  15. AS SELECT
  16. `Master_Music_52`.`globalsong`.`idSong` AS `idSong`,
  17. `Master_Music_52`.`globalsong`.`idAlbum` AS `idAlbum`,
  18. `Master_Music_52`.`globalsong`.`idPath` AS `idPath`,
  19. `Master_Music_52`.`globalsong`.`strArtists` AS `strArtists`,
  20. `Master_Music_52`.`globalsong`.`strGenres` AS `strGenres`,
  21. `Master_Music_52`.`globalsong`.`strTitle` AS `strTitle`,
  22. `Master_Music_52`.`globalsong`.`iTrack` AS `iTrack`,
  23. `Master_Music_52`.`globalsong`.`iDuration` AS `iDuration`,
  24. `Master_Music_52`.`globalsong`.`iYear` AS `iYear`,
  25. `Master_Music_52`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
  26. `Master_Music_52`.`globalsong`.`strFileName` AS `strFileName`,
  27. `Master_Music_52`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
  28. `Master_Music_52`.`globalsong`.`iTimesPlayedMaster` AS `iTimesPlayed`,
  29. `Master_Music_52`.`globalsong`.`iStartOffset` AS `iStartOffset`,
  30. `Master_Music_52`.`globalsong`.`iEndOffset` AS `iEndOffset`,
  31. `Master_Music_52`.`globalsong`.`idThumb` AS `idThumb`,
  32. `Master_Music_52`.`globalsong`.`lastPlayedMaster` AS `lastplayed`,
  33. `Master_Music_52`.`globalsong`.`rating` AS `rating`,
  34. `Master_Music_52`.`globalsong`.`comment` AS `comment`,
  35. `Master_Music_52`.`globalsong`.`mood` AS `mood`
  36. FROM `Master_Music_52`.`globalsong`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement