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 ("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "", "langPack", "Dreamweaver", "Adobe Dreamweaver CS6", "12") INSERT INTO PayloadData VALUES("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "0" , "ValidationInfo", '[INSTALLDIR]\Adobe Dreamweaver CS6\sv_SE\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\sv_SE\Resources\Resources.dllDigitalSignatureAdobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5') INSERT INTO PayloadData VALUES("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "0" , "ValidationSig", "gDBkN8EbZ86luMiU0oEFzDe7GBXTKzqdx4XtScsDxx6GwS0BtTj5ojLOrTqs+TdwounR1wcJrSCKPomp9YKV8V6fKlFZ8GjxhHnJj19NLdjzw6ZAsRZ00PV4UdCnfPcxlgkJfBTE+2CVWFQ0rBJr5n26Hx5dyYq8cad+tjTL5KpTWfLN/AitkC28LqAfaKT4kStrmFTL5ydPJDAOxHtCSpDhiHYY0OXLhi3knjQrOKwHG7/TKa83eHRfRsdhpy2fyF1y45taRTGUlPFBiIFlBuTkCUzrmso8igdkpoobxFvXlzCcse5LTBcZGzHjPhXtPsm4FMBnzIJFX7nbDUrstwjBVVwxQo26znD/+EyWTh+cGHdvfkA7lQycigjfItW+GFdOHfVKSrHf/43K1rMDa7TGFJgcCgAW4KNx9GHVesFLimTyWBXtImuEIGIYJ9l7ZWeFrV1Md6PQ2gAmGcZetIjzq1PoY+f+6EqjcD9uSCVN3jvJ21MgZDWtt7mJasOh") INSERT INTO Payloads VALUES ("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "Dreamweaver", "Adobe Dreamweaver CS6_AdobeDreamweaver12sv_SELanguagePack", "12", "langPack") INSERT INTO PayloadData VALUES("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "0" , "KeyFolder", "[INSTALLDIR]/Adobe Dreamweaver CS6") INSERT INTO PayloadData VALUES("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "0" , "PayloadInfo", ' 2012-03-31 03:44:54.293000 AdobeDreamweaver12sv_SELanguagePack All SQLite {84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2} Adobe Dreamweaver CS6 LangPack (sv_SE) 12 [INSTALLDIR]/Adobe Dreamweaver CS6 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] sv_SE Dreamweaver Adobe Dreamweaver CS6_AdobeDreamweaver12sv_SELanguagePack 12 Adobe Dreamweaver CS6 LangPack (sv_SE) Dreamweaver Adobe Dreamweaver CS6 [INSTALLDIR] 12695607 /Adobe Dreamweaver CS6/sv_SE/Configuration/Third Party Source Code/jquery-mobile\jquery.mobile.structure-1.0.min.css [AdobeCommon] 2404 /Startup Scripts CS6/Dreamweaver/dreamweaver-12\dreamweaver-11.0_sv_SE.dat ^Dreamweaver\.exe$ ^Dreamweaver$ 12 Adobe Dreamweaver CS6 LangPack (sv_SE) 0') INSERT INTO PayloadData VALUES("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "0" , "WorkflowVersion", "CS6") INSERT INTO PayloadData VALUES("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "0" , "DEVersion", "6.0") INSERT INTO PayloadData VALUES("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "0", "ChannelID", "AdobeDreamweaverCS6LangPacksv_SE-12") INSERT INTO PayloadData VALUES("{84C1E2B9-788B-11E1-AC70-E9A41D8FFCD2}", "0", "ChannelInfo", ' Adobe Dreamweaver CS6 LangPack (sv_SE) ')