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) ) CREATE TABLE EULA_Ref( productID TEXT NOT NULL, langCode TEXT NOT NULL, eula_hash TEXT NOT NULL, PRIMARY KEY (productID, langCode) ) CREATE TABLE EULA_Content(eula_hash TEXT NOT NULL, Content TEXT NOT NULL, PRIMARY KEY (eula_hash)) CREATE TABLE IF NOT EXISTS pcd_meta ( key TEXT NOT NULL, value TEXT NOT NULL, PRIMARY KEY (key) ) INSERT OR REPLACE INTO pcd_meta (key, value) VALUES ('schema_version', 2) INSERT OR REPLACE INTO pcd_meta (key, value) VALUES ('schema_compatibility_version', 1) INSERT INTO DependencyData VALUES ("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "", "langPack", "Dreamweaver", "Adobe Dreamweaver CS6", "12") INSERT INTO PayloadData VALUES("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "0" , "ValidationInfo", '[INSTALLDIR]\Adobe Dreamweaver CS6\pt_BR\Configuration\SourceControl\RDS.dllDigitalSignatureAdobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5[INSTALLDIR]\Adobe Dreamweaver CS6\pt_BR\Resources\Resources.dllDigitalSignatureAdobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5') INSERT INTO PayloadData VALUES("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "0" , "ValidationSig", "HLmxZRQbOloMAcUjkIiDAc6QXfC4RhE5JpZU7nXEjaLZ7dFFq/8x0srEzyGQ0K2igNhGndTcuyuixIh5yv3c+jTBotU7nyHhlaH6D136T2DMCf5kVUvj8h25NHEK9+a/SRnhVkjgEpE7a6gaB4kG55J3x2UGESnrKjv3vovp+XVkm8YkFyvPXqVYwH99olSIyNSyrO5URwkpwWmf3k39sB2bJprEhoIZICUXmwd1tObHtZV72Owwxl9KvhI80CbY8cNo3Ea0yIahg2QXiPpNIkTB/dPziDCpWFTkT9QP382DEzcgbV5ilrbmbYR6ZgUBzYHkmrfOY+eHe7An9JI2pVEPDOcZsKI1fgDFhSMKgzaHHZnFJYKuh+fketELzD/dhO/2JA5h0RUcTUYeXbtI/ygQUYzGTKUBTXhxSuCchtkCPjL0W+vlbDAfRbP/vvibo5D0Um0TVRWqdgKLQ6GKhJRsSms8yUaaMDIsqkaMEoL/Q87BUCE76BRzSNC3ojwq") INSERT INTO Payloads VALUES ("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "Dreamweaver", "Adobe Dreamweaver CS6_AdobeDreamweaver12pt_BRLanguagePack", "12", "langPack") INSERT INTO PayloadData VALUES("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "0" , "KeyFolder", "[INSTALLDIR]/Adobe Dreamweaver CS6") INSERT INTO PayloadData VALUES("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "0" , "PayloadInfo", ' 2012-03-31 03:27:10.169000 AdobeDreamweaver12pt_BRLanguagePack All SQLite {88DC19B7-788B-11E1-AC70-A34E75DC16A6} Adobe Dreamweaver CS6 LangPack (pt_BR) 12 [INSTALLDIR]/Adobe Dreamweaver CS6 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] pt_BR Dreamweaver Adobe Dreamweaver CS6_AdobeDreamweaver12pt_BRLanguagePack 12 Adobe Dreamweaver CS6 LangPack (pt_BR) Dreamweaver Adobe Dreamweaver CS6 [INSTALLDIR] 25161210 /Adobe Dreamweaver CS6/pt_BR/Configuration/Third Party Source Code/jquery-mobile\jquery.mobile.structure-1.0.min.css [AdobeCommon] 2424 /Startup Scripts CS6/Dreamweaver/dreamweaver-12\dreamweaver-11.0_pt_BR.dat ^Dreamweaver\.exe$ ^Dreamweaver$ 12 Adobe Dreamweaver CS6 LangPack (pt_BR) 0') INSERT INTO PayloadData VALUES("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "0" , "WorkflowVersion", "CS6") INSERT INTO PayloadData VALUES("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "0" , "DEVersion", "6.0") INSERT INTO PayloadData VALUES("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "0", "ChannelID", "AdobeDreamweaverCS6LangPackpt_BR-12") INSERT INTO PayloadData VALUES("{88DC19B7-788B-11E1-AC70-A34E75DC16A6}", "0", "ChannelInfo", ' Adobe Dreamweaver CS6 LangPack (pt_BR) ')