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 ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{D2924115-99E8-4A61-A4CA-9A18445E3B3E}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{9B20C0F2-CA6F-4F9F-9A0E-01E97B4A756D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{08919DA4-DC22-4409-9DB7-B5B5D3902B55}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{929FB400-64F6-4A4C-8F04-EAB21DCC3E3F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{E1C2EE2B-932D-4F03-910F-53105B78129B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{6082B2DD-833D-489C-9D94-5D5F16578704}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{7CB406BE-636A-473E-AF87-8F5843CBA8AC}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{0768F817-6C56-4C70-8857-3321F11634A5}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{A6FB9234-74C5-422B-9724-BB5B77923AB0}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{43DC2DF5-950B-4A8A-A556-F7E3F801BEFE}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{91D530F6-0699-4A6C-9B28-11B38543A753}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{2DEB673C-94EB-412B-942A-6573DAA78E10}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{E4926CE5-54E3-4903-818F-86642110291D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{D6CC9259-E673-42E0-8AB2-CE3571037B96}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{D568B238-8A7F-422C-A90A-A4BF5A017F4A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{672D08FB-F3FA-4ADF-8E43-320679DF8704}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{3F141B28-EB59-4CA4-889A-BB160DA86A73}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{E5357AEE-6DE8-4288-A1AC-15B244B08DD1}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{BC3A65A0-1E9D-4EFD-B884-B839492A6CB8}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{35081293-36B6-453C-82AE-E5EDAEE13282}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{ED2EBBAA-3AF1-419A-9E75-DBE8756CC476}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "{780CC5A8-F987-4E63-AE15-EA9A6FBC51FA}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "", "langPack", "Standard", "Adobe Flash CS6", "12.0") INSERT INTO PayloadData VALUES("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "0" , "ValidationInfo", '[INSTALLDIR]\Adobe Flash CS6\pt_BR\Configuration\FlashResources.dllDigitalSignatureAdobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5[INSTALLDIR]\Adobe Flash CS6\pt_BR\Configuration\External Libraries\Air_Android.dllDigitalSignatureAdobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5[INSTALLDIR]\Adobe Flash CS6\pt_BR\Configuration\External Libraries\Air_Desktop_iOS.dllDigitalSignatureAdobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5[INSTALLDIR]\Adobe Flash CS6\pt_BR\Configuration\Importers\AICS3Importer.dllDigitalSignatureAdobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5[INSTALLDIR]\Adobe Flash CS6\pt_BR\Configuration\Importers\PhotoshopReader.dllDigitalSignatureAdobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5') INSERT INTO PayloadData VALUES("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "0" , "ValidationSig", "f44DPH5mOHmImHZq5IlDXhaebuaMHTJsB8wySw4UwJ6+j/8N+jNpFD6VBx516hQ6b9MQmV9G9ZPStAJI/sdxmE+6ywzKcuEPVTzJjyeQQ0I4VT29eO9F3+k+ZTHBC0dOwudauysKgFGEv5g7+RbLd9D1K4lSpFQvwJF/M13afW84NjxRHdHBa10xJBz6eLjhsUumv5yvjXBiQjOhp1DrZuGjVZGVKs80yPGfoGHAxlXDGlprZ89YjGfSceA/0eXEKPMlbvkgdg7rW7aJk4YzDdXaHUJEqWDhYovWR6s6FWTCCZfj/EHYN/8JeJwlNmRInGYBiA0X/YFTvUW96OpMbzHYqVIHuLQW3pFlegJscgxijtitNN9uv9m4lEY2+WoZ22JRkC5JPxMIv46RtPLNrhu+otfmZADW1lNCTJWgMGTERWxYOiMtq2/05Lct5wYTrU/x33C57KWguWnds3EC1pYy2xCsioDedfMOyKrKJsc7Vbw6bGQT01/LxYugaU0u") INSERT INTO Payloads VALUES ("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "Standard", "Adobe Flash CS6_AdobeFlash12.0-pt_BRLanguagePack", "12.0", "langPack") INSERT INTO PayloadData VALUES("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "0" , "KeyFolder", "[INSTALLDIR]/Adobe Flash CS6/pt_BR") INSERT INTO PayloadData VALUES("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "0" , "PayloadInfo", ' 2012-03-30 18:08:33.819000 AdobeFlash12.0-pt_BRLanguagePack All SQLite {8312A03D-3EF3-4EF4-845F-A66D852B4D48} Adobe Flash CS6 Payload LangPack (pt_BR) 12.0 [INSTALLDIR]/Adobe Flash CS6/pt_BR [AdobeProgramFiles] pt_BR Standard Adobe Flash CS6_AdobeFlash12.0-pt_BRLanguagePack 12.0 {D2924115-99E8-4A61-A4CA-9A18445E3B3E} {9B20C0F2-CA6F-4F9F-9A0E-01E97B4A756D} {08919DA4-DC22-4409-9DB7-B5B5D3902B55} {929FB400-64F6-4A4C-8F04-EAB21DCC3E3F} {E1C2EE2B-932D-4F03-910F-53105B78129B} {6082B2DD-833D-489C-9D94-5D5F16578704} {7CB406BE-636A-473E-AF87-8F5843CBA8AC} {0768F817-6C56-4C70-8857-3321F11634A5} {A6FB9234-74C5-422B-9724-BB5B77923AB0} {43DC2DF5-950B-4A8A-A556-F7E3F801BEFE} {91D530F6-0699-4A6C-9B28-11B38543A753} {2DEB673C-94EB-412B-942A-6573DAA78E10} {E4926CE5-54E3-4903-818F-86642110291D} {D6CC9259-E673-42E0-8AB2-CE3571037B96} {D568B238-8A7F-422C-A90A-A4BF5A017F4A} {672D08FB-F3FA-4ADF-8E43-320679DF8704} {3F141B28-EB59-4CA4-889A-BB160DA86A73} {E5357AEE-6DE8-4288-A1AC-15B244B08DD1} {BC3A65A0-1E9D-4EFD-B884-B839492A6CB8} {35081293-36B6-453C-82AE-E5EDAEE13282} {ED2EBBAA-3AF1-419A-9E75-DBE8756CC476} {780CC5A8-F987-4E63-AE15-EA9A6FBC51FA} Adobe Flash CS6 Payload LangPack (pt_BR) Standard Adobe Flash CS6 [INSTALLDIR] 49524006 /Adobe Flash CS6/pt_BR/First Run/ActionsPanel/ActionScript_1_2/CustomActions/ScriptAssist\Flash Data Components.xml 12.0 Adobe Flash CS6 Payload LangPack (pt_BR) 0') INSERT INTO PayloadData VALUES("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "0" , "WorkflowVersion", "CS6") INSERT INTO PayloadData VALUES("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "0" , "DEVersion", "6.0") INSERT INTO PayloadData VALUES("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "0", "ChannelID", "FlashPro12.0pt_BR") INSERT INTO PayloadData VALUES("{8312A03D-3EF3-4EF4-845F-A66D852B4D48}", "0", "ChannelInfo", ' Adobe Flash CS6 Payload LangPack (pt_BR) ')