12 Commits

Author	SHA1	Message	Date
Uwe L. Korn	91b01038b1	Fix DB migration	2013-07-30 12:58:04 +02:00
Uwe L. Korn	157ee8f433	Speed up hot playlists by improving join performance	2013-07-30 12:55:12 +02:00
Uwe L. Korn	526c492409	Add index on playback_log.playtime	2013-07-29 21:10:57 +02:00
Leo Franchi	cc16fea104	Clear out old non-servent and non-file resulthints	2012-09-21 17:41:05 -04:00
Teo Mrnjavac	4e59f1dc12	Added discnumber & composer to the DB schema and sorting by discnumber. ... Added support for three new metadata elements of a track: Album Artist, Composer and Disc Number. Since these are not supported in ID3v1 which TagLib uses as common ground between the different metadata formats, I had to handle the following cases separately: APE, ASF, ID3v1, ID3v2, MP4 and OGG. Modified the DB schema to include composer and discnumber. Provided the dbmigrate file and bumped the schema version. Added composer and discnumber data to all relevant queries. Removed a bogus result->setYear from some queries in dbcmd_resolve.cpp.	2012-01-22 19:48:18 +01:00
Leo Franchi	d7e68f3a1d	Add dbmigrate scrip, other misc work	2011-09-30 18:37:59 -04:00
Leo Franchi	ffd5a2f81e	Ooops, use true not 1	2011-08-06 16:58:07 -04:00
Leo Franchi	9c36b32e8e	add migrate script	2011-07-30 16:13:29 -04:00
Leo Franchi	ca467fb5bc	Add support for non-autoloaded dynamic playlists that can be used for custom displays ... Add a SocialPlaylistWidget that will display some cool social stats and lists, but none right now	2011-07-29 14:06:44 -04:00
Christian Muehlhaeuser	9758324128	* Fixed broken database schema for dynamic_playlist table.	2011-06-24 09:32:00 +02:00
Christian Muehlhaeuser	8c10bdfb07	* WIP: Fulltext resolving, score bars and score column. ... * Added social_attributes table to the database. * Added db migration script. * Fixed database migration.	2011-06-12 05:57:57 +02:00
Leo Franchi	1ecb799694	add a createdOn property to playlists, and sort sourcetree	2011-04-15 17:27:27 -04:00