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 ("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "", "langPack", "Adobe Web Suite CS6", "Adobe Fireworks CS6", "12.0.0") INSERT INTO PayloadData VALUES("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "0" , "ValidationInfo", '[INSTALLDIR]\Adobe Fireworks CS6\Brazilian Portuguese\Resources\Fireworks Resources.dllDigitalSignatureAdobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5') INSERT INTO PayloadData VALUES("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "0" , "ValidationSig", "LxsWk6anzIEHMK2O8C3oVSykW++Z3+wQlVP85pcPaGdE5VH+fPKDuOJlwvKrUBmk4I2wirAHdJAIXKcjcIKESADUmBXrrAcUv+sxTVlJJenagPwP4D8Ejmv2GI1Y9O6XnamSUl+Ue5Jb/qbbKjuyhnDkW0bPkDGKVDC0beCAIeDaBY0QmuppAsYX6R2suNB9iqSJD6Qp12Mw3zIE1pTWxoUlM1n4gnwwC8kxVXxAI7m0jt2dSqRhi4PP2py/7Bp5xDySIfXf+O2x1vVQa2WjBST5wSwvgpnRd2p4vO7xv6swvsmbuDc1Ii5gUleYaCcKGhOSNEJZ3m2cMWXZrfNcK7e9LDb7xbW6FZoT5zwZ2LQusumTR2g6sCFz74qgngKYbc3g5NAI3/EQ82r+YNhSxmUBVc4A7fWL64aOsxRAqYixiDQmCVo+MoX/XZFNeVuiNAJ6vqVdHbQIi/YVjfnWHWIiqghHDvATgB3CWyXn4lkXKFQg5QdKLgICxnPC4jLL") INSERT INTO Payloads VALUES ("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "Adobe Web Suite CS6", "Adobe Fireworks CS6_AdobeFireworks12pt_BRLanguagePack", "12.0.0", "langPack") INSERT INTO PayloadData VALUES("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "0" , "KeyFolder", "[INSTALLDIR]/Adobe Fireworks CS6") INSERT INTO PayloadData VALUES("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "0" , "PayloadInfo", ' 2012-03-31 01:00:45.702000 AdobeFireworks12pt_BRLanguagePack All SQLite {CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D} Adobe Fireworks CS6 Brazilian Portuguese Language Pack 12.0.0 [INSTALLDIR]/Adobe Fireworks CS6 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] pt_BR Adobe Web Suite CS6 Adobe Fireworks CS6_AdobeFireworks12pt_BRLanguagePack 12.0.0 Adobe Fireworks CS6 Brazilian Portuguese Language Pack Adobe Web Suite CS6 Adobe Fireworks CS6 [INSTALLDIR] 4882208 /Adobe Fireworks CS6/Brazilian Portuguese/Movies/resources/images\background-list.png [AdobeCommon] 2031 /HelpCfg/pt_BR\Fireworks.helpcfg 12.0.0 Adobe Fireworks CS6 Brazilian Portuguese Language Pack 0') INSERT INTO PayloadData VALUES("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "0" , "WorkflowVersion", "CS6") INSERT INTO PayloadData VALUES("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "0" , "DEVersion", "6.0") INSERT INTO PayloadData VALUES("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "0", "ChannelID", "AdobeFireworksCS6-12.0.0-pt_BR") INSERT INTO PayloadData VALUES("{CFB53D3A-7A9E-11E1-B30A-A4AADC4B504D}", "0", "ChannelInfo", ' Adobe Fireworks CS6 Brazilian Portuguese Language Pack ')