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 ("{2225827F-5C55-4C6F-8FD8-88C7194FF792}", "", "langPack", "Dreamweaver", "Adobe Dreamweaver CS5.5", "11.5") INSERT INTO Payloads VALUES ("{2225827F-5C55-4C6F-8FD8-88C7194FF792}", "Dreamweaver", "Adobe Dreamweaver CS5.5_AdobeDreamweaver11.5sv_SELanguagePack", "11.5", "langPack") INSERT INTO PayloadData VALUES("{2225827F-5C55-4C6F-8FD8-88C7194FF792}", "0" , "PayloadInfo", ' 2011-03-22 20:50:49.798000 AdobeDreamweaver11.5sv_SELanguagePack All SQLite {2225827F-5C55-4C6F-8FD8-88C7194FF792} Adobe Dreamweaver CS5.5 LangPack (sv_SE) 11.5 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] sv_SE Dreamweaver Adobe Dreamweaver CS5.5_AdobeDreamweaver11.5sv_SELanguagePack 11.5 Adobe Dreamweaver CS5.5 LangPack (sv_SE) Dreamweaver Adobe Dreamweaver CS5.5 [INSTALLDIR] 11103954 /Adobe Dreamweaver CS5.5/sv_SE/Configuration/Third Party Source Code/jquery-mobile/images\icon-search-black.png [AdobeCommon] 1831 /Startup Scripts CS5.5/Dreamweaver/dreamweaver-11.5\dreamweaver-11.0_sv_SE.dat ^Dreamweaver\.exe$ ^Dreamweaver$ 11.5 Adobe Dreamweaver CS5.5 LangPack (sv_SE) 0') INSERT INTO PayloadData VALUES("{2225827F-5C55-4C6F-8FD8-88C7194FF792}", "0", "ChannelID", "AdobeDreamweaverCS5.5LangPacksv_SE-11.5") INSERT INTO PayloadData VALUES("{2225827F-5C55-4C6F-8FD8-88C7194FF792}", "0", "ChannelInfo", ' Adobe Dreamweaver CS5.5 LangPack (sv_SE) ')