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 ("{986001FD-5405-473B-8B33-172644303A0E}", "", "langPack", "Dreamweaver", "Adobe Dreamweaver CS5.5", "11.5") INSERT INTO Payloads VALUES ("{986001FD-5405-473B-8B33-172644303A0E}", "Dreamweaver", "Adobe Dreamweaver CS5.5_AdobeDreamweaver11.5de_DELanguagePack", "11.5", "langPack") INSERT INTO PayloadData VALUES("{986001FD-5405-473B-8B33-172644303A0E}", "0" , "PayloadInfo", ' 2011-03-22 20:01:00.726000 AdobeDreamweaver11.5de_DELanguagePack All SQLite {986001FD-5405-473B-8B33-172644303A0E} Adobe Dreamweaver CS5.5 LangPack (de_DE) 11.5 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] de_DE Dreamweaver Adobe Dreamweaver CS5.5_AdobeDreamweaver11.5de_DELanguagePack 11.5 Adobe Dreamweaver CS5.5 LangPack (de_DE) Dreamweaver Adobe Dreamweaver CS5.5 [INSTALLDIR] 37602259 /Adobe Dreamweaver CS5.5/de_DE/Configuration/Content/Reference/UsableNet_508ASOEM\SCRIPTwEquivalentNOSCRIPT.htm [AdobeCommon] 1843 /Startup Scripts CS5.5/Dreamweaver/dreamweaver-11.5\dreamweaver-11.0_de_DE.dat ^Dreamweaver\.exe$ ^Dreamweaver$ 11.5 Adobe Dreamweaver CS5.5 LangPack (de_DE) 0') INSERT INTO PayloadData VALUES("{986001FD-5405-473B-8B33-172644303A0E}", "0", "ChannelID", "AdobeDreamweaverCS5.5LangPackde_DE-11.5") INSERT INTO PayloadData VALUES("{986001FD-5405-473B-8B33-172644303A0E}", "0", "ChannelInfo", ' Adobe Dreamweaver CS5.5 LangPack (de_DE) ')