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 ("{614EAB78-2A60-1016-B121-AFAD34340ACB}", "", "langPack", "InDesign", "Adobe InDesign CS5.5 Application Base Files", "7.5") INSERT INTO Payloads VALUES ("{614EAB78-2A60-1016-B121-AFAD34340ACB}", "InDesign", "Adobe InDesign CS5.5 Common Language Files_AdobeInDesign7xCommonLang-de_DE", "7.5", "langPack") INSERT INTO PayloadData VALUES("{614EAB78-2A60-1016-B121-AFAD34340ACB}", "0" , "PayloadInfo", ' 2011-03-17 08:24:43.262000 AdobeInDesign7xCommonLang-de_DE All SQLite {614EAB78-2A60-1016-B121-AFAD34340ACB} Adobe InDesign CS5.5 Common Language Files (de_DE) 7.5 [AdobeCommon] de_DE InDesign Adobe InDesign CS5.5 Common Language Files_AdobeInDesign7xCommonLang-de_DE 7.5 Adobe InDesign CS5.5 Common Language Files (de_DE) InDesign Adobe InDesign CS5.5 Application Base Files [AdobeCommon] 39907427 /Help/de_DE/InDesign/CS5/Using\InDesign_CS5.5_Help.pdf 7.5 Adobe InDesign CS5.5 Common Language Files (de_DE) 0') INSERT INTO PayloadData VALUES("{614EAB78-2A60-1016-B121-AFAD34340ACB}", "0", "ChannelID", "AdobeInDesignCS5.5CommonLanguageFilesde_DE-7.5") INSERT INTO PayloadData VALUES("{614EAB78-2A60-1016-B121-AFAD34340ACB}", "0", "ChannelInfo", ' Adobe InDesign CS5.5 Common Language Files (de_DE) ')