| Anonymous | Login | Signup for a new account | 2024-11-23 10:55 PST |  |
| Main | My View | View Issues | Change Log | Roadmap | Repositories | My Account |
| View Revisions: Issue #205 | [ Back to Issue ] | ||
| Summary | 0000205: Make the database migration script (1.00 to 1.01) - Replaced LastPlayed in AudioFiles, added History table, etc. | ||
| Revision | 2011-12-24 10:17 by ycastonguay | ||
| Description | INSERT INTO Settings (SettingId, SettingName, SettingValue) VALUES ('c84dcec5-8aa5-468d-a154-cafc0492f77f', 'DatabaseVersion', '1.01') /**/ ALTER TABLE AudioFiles ADD LastPlayedDateTime text NULL /**/ CREATE TABLE [History] ( [HistoryId] varchar(50) NOT NULL PRIMARY KEY, [AudioFileId] varchar(50) NULL, [EventDateTime] text NULL ) |
||
| Revision | 2011-12-24 10:16 by ycastonguay | ||
| Description | INSERT INTO Settings (SettingId, SettingName, SettingValue) VALUES ('c84dcec5-8aa5-468d-a154-cafc0492f77f', 'DatabaseVersion', '1.01') /**/ ALTER TABLE AudioFiles ADD LastPlayedDateTime text NULL /**/ CREATE TABLE [History] ( [HistoryId] varchar(50) NOT NULL PRIMARY KEY, [AudioFileId] varchar(50) NULL, [EventDateTime] text NULL ) |
||
| Revision | 2011-12-24 10:16 by ycastonguay | ||
| Description | Add it to the migration script. | ||
| Copyright © 2000 - 2011 MantisBT Group |
 |