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 ("{96F1D55F-6FA7-4E60-9116-08E69FECA45B}", "", "langPack", "Dreamweaver", "Adobe Dreamweaver CS5.5", "11.5") INSERT INTO Payloads VALUES ("{96F1D55F-6FA7-4E60-9116-08E69FECA45B}", "Dreamweaver", "Adobe Dreamweaver CS5.5_AdobeDreamweaver11.5it_ITLanguagePack", "11.5", "langPack") INSERT INTO PayloadData VALUES("{96F1D55F-6FA7-4E60-9116-08E69FECA45B}", "0" , "PayloadInfo", ' 2011-03-22 20:27:20.735000 AdobeDreamweaver11.5it_ITLanguagePack All SQLite {96F1D55F-6FA7-4E60-9116-08E69FECA45B} Adobe Dreamweaver CS5.5 LangPack (it_IT) 11.5 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] it_IT Dreamweaver Adobe Dreamweaver CS5.5_AdobeDreamweaver11.5it_ITLanguagePack 11.5 Adobe Dreamweaver CS5.5 LangPack (it_IT) Dreamweaver Adobe Dreamweaver CS5.5 [INSTALLDIR] 11355475 /Adobe Dreamweaver CS5.5/it_IT/Configuration/Third Party Source Code/jquery-mobile/images\icon-search-black.png [AdobeCommon] 1860 /Startup Scripts CS5.5/Dreamweaver/dreamweaver-11.5\dreamweaver-11.0_it_IT.dat ^Dreamweaver\.exe$ ^Dreamweaver$ 11.5 Adobe Dreamweaver CS5.5 LangPack (it_IT) 0') INSERT INTO PayloadData VALUES("{96F1D55F-6FA7-4E60-9116-08E69FECA45B}", "0", "ChannelID", "AdobeDreamweaverCS5.5LangPackit_IT-11.5") INSERT INTO PayloadData VALUES("{96F1D55F-6FA7-4E60-9116-08E69FECA45B}", "0", "ChannelInfo", ' Adobe Dreamweaver CS5.5 LangPack (it_IT) ')