[Owncloud] Database changes for git master

Robin Appelman icewind1991 at gmail.com
Thu Jul 28 19:00:30 UTC 2011


I just pushed a change that will require a change to the database for people 
running git master (or any branch that has these changes merged in).

the table oc_media_songs (or with a different prefix) has 2 new collumns 
song_playcount and song_plastplayed

You can update the database using these queries:
ALTER TABLE oc_media_songs ADD song_playcount INTEGER;
UPDATE oc_media_songs SET song_playcount=0;
ALTER TABLE oc_media_songs ADD song_lastplayed INTEGER;
UPDATE oc_media_songs SET song_lastplayed=0;

or remove config/config.php to trigger the setup again.

This *should* be the last change to the database untill 2.0 final.

 - Robin Appelman



More information about the Owncloud mailing list