Mantis Bug Tracker

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
Powered by Mantis Bugtracker