Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- RENAME TABLE `Master_Music_52`.`song` to `Master_Music_52`.`globalsong`;
- ALTER TABLE `Master_Music_52`.`globalsong` CHANGE iTimesPlayed iTimesPlayedMaster INT;
- ALTER TABLE `Master_Music_52`.`globalsong` ADD iTimesPlayed22222 INT(11) AFTER iTimesPlayedMaster;
- ALTER TABLE `Master_Music_52`.`globalsong` ADD iTimesPlayed33333 INT(11) AFTER iTimesPlayed22222;
- ALTER TABLE `Master_Music_52`.`globalsong` ADD iTimesPlayed44444 INT(11) AFTER iTimesPlayed33333;
- ALTER TABLE `Master_Music_52`.`globalsong` ADD iTimesPlayed55555 INT(11) AFTER iTimesPlayed44444;
- ALTER TABLE `Master_Music_52`.`globalsong` CHANGE lastPlayed lastPlayedMaster VARCHAR(20);
- ALTER TABLE `Master_Music_52`.`globalsong` ADD lastPlayed22222 VARCHAR(20) AFTER lastPlayedMaster;
- ALTER TABLE `Master_Music_52`.`globalsong` ADD lastPlayed33333 VARCHAR(20) AFTER lastPlayed22222;
- ALTER TABLE `Master_Music_52`.`globalsong` ADD lastPlayed44444 VARCHAR(20) AFTER lastPlayed33333;
- ALTER TABLE `Master_Music_52`.`globalsong` ADD lastPlayed55555 VARCHAR(20) AFTER lastPlayed44444;
- CREATE OR REPLACE VIEW `Master_Music_52`.`song`
- AS SELECT
- `Master_Music_52`.`globalsong`.`idSong` AS `idSong`,
- `Master_Music_52`.`globalsong`.`idAlbum` AS `idAlbum`,
- `Master_Music_52`.`globalsong`.`idPath` AS `idPath`,
- `Master_Music_52`.`globalsong`.`strArtists` AS `strArtists`,
- `Master_Music_52`.`globalsong`.`strGenres` AS `strGenres`,
- `Master_Music_52`.`globalsong`.`strTitle` AS `strTitle`,
- `Master_Music_52`.`globalsong`.`iTrack` AS `iTrack`,
- `Master_Music_52`.`globalsong`.`iDuration` AS `iDuration`,
- `Master_Music_52`.`globalsong`.`iYear` AS `iYear`,
- `Master_Music_52`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
- `Master_Music_52`.`globalsong`.`strFileName` AS `strFileName`,
- `Master_Music_52`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
- `Master_Music_52`.`globalsong`.`iTimesPlayedMaster` AS `iTimesPlayed`,
- `Master_Music_52`.`globalsong`.`iStartOffset` AS `iStartOffset`,
- `Master_Music_52`.`globalsong`.`iEndOffset` AS `iEndOffset`,
- `Master_Music_52`.`globalsong`.`idThumb` AS `idThumb`,
- `Master_Music_52`.`globalsong`.`lastPlayedMaster` AS `lastplayed`,
- `Master_Music_52`.`globalsong`.`rating` AS `rating`,
- `Master_Music_52`.`globalsong`.`comment` AS `comment`,
- `Master_Music_52`.`globalsong`.`mood` AS `mood`
- FROM `Master_Music_52`.`globalsong`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement