CREATE TABLE Branding ( ProductID TEXT NOT NULL REFERENCES Suites (ProductID),resource_type TEXT NOT NULL,resource_data TEXT NOT NULL,PRIMARY KEY (ProductID, resource_type) )
CREATE TABLE DependencyData( PayloadID TEXT NOT NULL REFERENCES Payloads (PayloadID),PayloadIDb TEXT ,type TEXT NOT NULL ,product_family TEXT, product_name TEXT, version TEXT, PRIMARY KEY (PayloadID,PayloadIDb,type,product_family,product_name,version))
CREATE TABLE EULA_Files( productID TEXT NOT NULL, langCode TEXT NOT NULL,eula TEXT NOT NULL,PRIMARY KEY (productID, langCode) )
CREATE TABLE PayloadData( PayloadID TEXT NOT NULL REFERENCES Payloads (PayloadID),domain TEXT NOT NULL,key TEXT NOT NULL,value TEXT NOT NULL,PRIMARY KEY (PayloadID, domain, key) )
CREATE TABLE Payloads( PayloadID TEXT NOT NULL, payload_family TEXT NOT NULL,payload_name TEXT NOT NULL, payload_version TEXT NOT NULL,payload_type TEXT NOT NULL,PRIMARY KEY (PayloadID) )
CREATE TABLE SuitePayloads( ProductID TEXT NOT NULL REFERENCES Suites (ProductID),PayloadID TEXT NOT NULL REFERENCES Payloads (PayloadID),PRIMARY KEY (ProductID, PayloadID) )
CREATE TABLE Suites( ProductID TEXT NOT NULL, group_name TEXT NOT NULL, group_family TEXT NOT NULL, display_name TEXT NOT NULL, PRIMARY KEY (ProductID) )
INSERT INTO DependencyData VALUES ("{1EF9FEC2-3EAD-4BC5-AF93-DAE033CACE94}", "", "langPack", "Photoshop", "Adobe Photoshop CS5.1 Core_x64", "12.1")
INSERT INTO Payloads VALUES ("{1EF9FEC2-3EAD-4BC5-AF93-DAE033CACE94}", "Photoshop", "Adobe Photoshop CS5.1 French Language Pack_x64_AdobePhotoshop12-fr_FR_x64", "12.1", "langPack")
INSERT INTO PayloadData VALUES("{1EF9FEC2-3EAD-4BC5-AF93-DAE033CACE94}", "0" , "PayloadInfo", '
2011-03-28 12:56:54.015000
AdobePhotoshop12-fr_FR_x64
x64
SQLite
{1EF9FEC2-3EAD-4BC5-AF93-DAE033CACE94}
Adobe Photoshop CS5.1 French Language Pack_x64
12.1
[AdobeProgramFiles]
fr_FR
Photoshop
Adobe Photoshop CS5.1 French Language Pack_x64_AdobePhotoshop12-fr_FR_x64
12.1
Adobe Photoshop CS5.1 French Language Pack_x64
Photoshop
Adobe Photoshop CS5.1 Core_x64
[INSTALLDIR]
42110878
/Adobe Photoshop CS5.1 (64 Bit)/Locales/fr_FR/Additional Presets/Win/Workspaces/2-Task-based Workspaces\Photography
12.1
Adobe Photoshop CS5.1 French Language Pack_x64
0')
INSERT INTO PayloadData VALUES("{1EF9FEC2-3EAD-4BC5-AF93-DAE033CACE94}", "0", "ChannelID", "AdobePhotoshopCS5.1FrenchLanguagePack_x64-12.1")
INSERT INTO PayloadData VALUES("{1EF9FEC2-3EAD-4BC5-AF93-DAE033CACE94}", "0", "ChannelInfo", '
Adobe Photoshop CS5.1 French Language Pack_x64
')