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 ')