1 BEGIN TRANSACTION CreateScrDatabase;

     2 --Old Schema

     3 --SoftwareTypes(SoftwareTypeId,SifPluginUid,InstallerSecureId,ExecutionLayerSecureId)

     4 --New Schema

     5 --SoftwareTypes(SoftwareTypeId,SifPluginUid,LauncherExecutable)

     6 --CustomAccessList(AccessId,SoftwareTypeId,SecureId,AccessMode)

     7 CREATE TABLE Temp(SoftwareTypeId INTEGER PRIMARY KEY NOT NULL,SifPluginUid INTEGER,LauncherExecutable TEXT DEFAULT 'SomeData');

     8 INSERT INTO Temp(SoftwareTypeId,SifPluginUid) SELECT SoftwareTypeId,SifPluginUid FROM SoftwareTypes;

     9 CREATE TABLE CustomAccessList(AccessId INTEGER PRIMARY KEY AUTOINCREMENT,SoftwareTypeId INTEGER NOT NULL,SecureId INTEGER NOT NULL,AccessMode INTEGER DEFAULT 1);

    10 INSERT INTO CustomAccessList(SoftwareTypeId,SecureId) SELECT SoftwareTypeId,InstallerSecureId FROM SoftwareTypes;

    11 INSERT INTO CustomAccessList(SoftwareTypeId,SecureId) SELECT SoftwareTypeId,ExecutionLayerSecureId FROM SoftwareTypes;

    12 DROP TABLE SoftwareTypes;

    13 ALTER TABLE Temp RENAME TO SoftwareTypes;

    14 END TRANSACTION CreateScrDatabase;