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 ("{E5BBF8F6-E355-4FF5-9A47-9E43869C1787}", "", "langPack", "Dreamweaver", "Adobe Dreamweaver CS5.5", "11.5") INSERT INTO Payloads VALUES ("{E5BBF8F6-E355-4FF5-9A47-9E43869C1787}", "Dreamweaver", "Adobe Dreamweaver CS5.5_AdobeDreamweaver11.5pt_BRLanguagePack", "11.5", "langPack") INSERT INTO PayloadData VALUES("{E5BBF8F6-E355-4FF5-9A47-9E43869C1787}", "0" , "PayloadInfo", ' 2011-03-22 20:35:12.186000 AdobeDreamweaver11.5pt_BRLanguagePack All SQLite {E5BBF8F6-E355-4FF5-9A47-9E43869C1787} Adobe Dreamweaver CS5.5 LangPack (pt_BR) 11.5 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] pt_BR Dreamweaver Adobe Dreamweaver CS5.5_AdobeDreamweaver11.5pt_BRLanguagePack 11.5 Adobe Dreamweaver CS5.5 LangPack (pt_BR) Dreamweaver Adobe Dreamweaver CS5.5 [INSTALLDIR] 23585925 /Adobe Dreamweaver CS5.5/pt_BR/Configuration/Third Party Source Code/jquery-mobile/images\icon-search-black.png [AdobeCommon] 1855 /Startup Scripts CS5.5/Dreamweaver/dreamweaver-11.5\dreamweaver-11.0_pt_BR.dat ^Dreamweaver\.exe$ ^Dreamweaver$ 11.5 Adobe Dreamweaver CS5.5 LangPack (pt_BR) 0') INSERT INTO PayloadData VALUES("{E5BBF8F6-E355-4FF5-9A47-9E43869C1787}", "0", "ChannelID", "AdobeDreamweaverCS5.5LangPackpt_BR-11.5") INSERT INTO PayloadData VALUES("{E5BBF8F6-E355-4FF5-9A47-9E43869C1787}", "0", "ChannelInfo", ' Adobe Dreamweaver CS5.5 LangPack (pt_BR) ')