MantisBT - MPfm
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000170MPfmLibrarypublic2011-12-18 13:152011-12-18 13:27
Reporterycastonguay 
Assigned Toycastonguay 
PrioritynormalSeverityfeatureReproducibilityN/A
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version 
Target Version0.5.0.2Fixed in Version0.5.0.2 
Summary0000170: If the database file doesn't exists, create the database file using an embedded SQL script
DescriptionThis technique will also be useful when upgrading SQL schema between versions.
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-12-18 13:15ycastonguayNew Issue
2011-12-18 13:15ycastonguayStatusnew => assigned
2011-12-18 13:15ycastonguayAssigned To => ycastonguay
2011-12-18 13:18svnCheckin
2011-12-18 13:18svnNote Added: 0000227
2011-12-18 13:27ycastonguayStatusassigned => resolved
2011-12-18 13:27ycastonguayFixed in Version => 0.5.0.2
2011-12-18 13:27ycastonguayResolutionopen => fixed

Notes
(0000227)
svn   
2011-12-18 13:18   
The user admin has checked in files related to this issue (revision 156).

Comment:
MPfm 0.5.0.2
- Library: Added the CreateDatabaseFile and GetCreateDatabaseSQL methods
  Added an embeddable SQL script to be executed for creating a new database.
- Main window: Now creates a database file if it doesn't exist using the embedded SQL script.
- Moved the configuration file, database file and log file to the user application data folder.

Related to issue 0000169 and issue 0000170.

Files modified:
U MPfm/branches/current/MPfm/Configuration/MPfmConfiguration.cs
U MPfm/branches/current/MPfm/frmMain.cs
U MPfm/branches/current/MPfm.Library/Library.cs
U MPfm/branches/current/MPfm.Library/MPfm.Library.csproj
U MPfm/branches/current/MPfm.Library/MPfmGateway.cs
U MPfm/branches/current/MPfm.Library/SQLiteGateway.cs
A MPfm/branches/current/MPfm.Library/Scripts/
A MPfm/branches/current/MPfm.Library/Scripts/CreateDatabase.sql
U MPfm/branches/current/MPfm.Player/Objects/Playlist.cs
U MPfm/branches/current/MPfm.Player/Objects/PlaylistItem.cs
U MPfm/branches/current/MPfm.Player/Player.cs