diff -r 7333d7932ef7 -r 8b7f4e561641 installationservices/swcomponentregistry/test/testdb/modifydb.sql --- a/installationservices/swcomponentregistry/test/testdb/modifydb.sql Tue Aug 31 15:21:33 2010 +0300 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,14 +0,0 @@ -BEGIN TRANSACTION CreateScrDatabase; ---Old Schema ---SoftwareTypes(SoftwareTypeId,SifPluginUid,InstallerSecureId,ExecutionLayerSecureId) ---New Schema ---SoftwareTypes(SoftwareTypeId,SifPluginUid,LauncherExecutable) ---CustomAccessList(AccessId,SoftwareTypeId,SecureId,AccessMode) -CREATE TABLE Temp(SoftwareTypeId INTEGER PRIMARY KEY NOT NULL,SifPluginUid INTEGER,LauncherExecutable TEXT DEFAULT 'SomeData'); -INSERT INTO Temp(SoftwareTypeId,SifPluginUid) SELECT SoftwareTypeId,SifPluginUid FROM SoftwareTypes; -CREATE TABLE CustomAccessList(AccessId INTEGER PRIMARY KEY AUTOINCREMENT,SoftwareTypeId INTEGER NOT NULL,SecureId INTEGER NOT NULL,AccessMode INTEGER DEFAULT 1); -INSERT INTO CustomAccessList(SoftwareTypeId,SecureId) SELECT SoftwareTypeId,InstallerSecureId FROM SoftwareTypes; -INSERT INTO CustomAccessList(SoftwareTypeId,SecureId) SELECT SoftwareTypeId,ExecutionLayerSecureId FROM SoftwareTypes; -DROP TABLE SoftwareTypes; -ALTER TABLE Temp RENAME TO SoftwareTypes; -END TRANSACTION CreateScrDatabase;