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	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{9B73E411-AF5B-47E8-9A6A-67EC1319669A}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{2B076846-CDFB-43E6-9335-CAA5118B7113}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{283397D2-A4D3-4842-AB80-5CED5D997E24}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{9EA382A4-CED2-46F0-B683-EA0BDB147144}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{025B75FB-99DE-4D5B-B178-CFA14BECCDEC}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{4ED4C05D-255B-4452-AF8B-E61C53B3F5CF}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{53152C33-B2A3-4293-BF99-AB7B02A26F0D}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{C085362F-585E-45E9-85AB-13EE94E0A967}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{B73D7C2E-221C-4BD7-8040-76A7CD0A1A10}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{B4A2AF3A-5433-4306-9A01-F46FA27968C5}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{8D4735B4-7FC0-430E-80C7-1F08F6112946}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{FC7A54D0-6B31-4CD0-BA37-EDA6A4100DDE}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{18995678-9FB2-4234-8F4C-2459D029366A}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{29064570-D757-4097-8871-894F89795EE7}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{3DB59CCA-D15A-437B-ABCF-D635B26C5DC3}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{C6B6BBC5-7685-48E0-9869-3DB61B35652D}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{464F0471-8F16-43A4-A2AF-37B961824F2B}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{9A9360E8-BBEB-4F99-AD6E-77765E983D98}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{11CB2190-8082-41AF-B2C0-64F655FAD7FB}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{8AD58A21-DA2B-4188-963B-0173BF18BADF}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{BAA090E8-D797-4785-9386-555D11093515}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "{2E0EB443-77CE-4AB2-9043-502E5B61EEF3}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "", "langPack", "Standard", "Adobe Flash CS6", "12.0")
INSERT INTO PayloadData VALUES("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "0" , "ValidationInfo", '<ValidationInfo payloadID="{23D3FD35-6497-4038-9CE3-6B79A4093013}"><File><InstallPath>[INSTALLDIR]\Adobe Flash CS6\ja_JP\Configuration\FlashResources.dll</InstallPath><SignatureType>DigitalSignature</SignatureType><SignatureInfo>Adobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5</SignatureInfo></File><File><InstallPath>[INSTALLDIR]\Adobe Flash CS6\ja_JP\Configuration\External Libraries\Air_Android.dll</InstallPath><SignatureType>DigitalSignature</SignatureType><SignatureInfo>Adobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5</SignatureInfo></File><File><InstallPath>[INSTALLDIR]\Adobe Flash CS6\ja_JP\Configuration\External Libraries\Air_Desktop_iOS.dll</InstallPath><SignatureType>DigitalSignature</SignatureType><SignatureInfo>Adobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5</SignatureInfo></File><File><InstallPath>[INSTALLDIR]\Adobe Flash CS6\ja_JP\Configuration\Importers\AICS3Importer.dll</InstallPath><SignatureType>DigitalSignature</SignatureType><SignatureInfo>Adobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5</SignatureInfo></File><File><InstallPath>[INSTALLDIR]\Adobe Flash CS6\ja_JP\Configuration\Importers\PhotoshopReader.dll</InstallPath><SignatureType>DigitalSignature</SignatureType><SignatureInfo>Adobe Systems Incorporated{|}VeriSign Class 3 Code Signing 2010 CA{|}VeriSign Class 3 Public Primary Certification Authority - G5</SignatureInfo></File></ValidationInfo>')
INSERT INTO PayloadData VALUES("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "0" , "ValidationSig", "dCP7mXuvunxgvsrbcNL/l++nc68Xmw6Gyjv+ItLEuIn4wo6GZsWcP6KyKS4vBL5ypw6XozB0DrJSWUCPGC4NEN/HDuXGPcNxXquzYXideLGhK5gpr6eUZ3Yn4vwNMMlKH6LbMl7VzLgiC2N+9upNUdBI3yI9H17vEImci1BgNNDs7OOeSxfULMfHP44cwHqwhgHp5a3zK++3BpoJ+5K6S0Ad4oV98F0PRG8Wqv5W3VeA+GLCxDTFzuCyxxOzkr8eSyvm7ZGRjyq3K3bV1xF3+8z5Mtq1yfl0P4JPrIgSi5xaUXC7wM7UJYNZv4gnTTA03ocfgWF5UinnO9sGbAEhS5oeGH95+JdAgqcD92mwRO49CPv+8010n4HLzjLou5W2KPeS4QaRtuXum3JVDb/wcEPB+a9MkK1kyxrLIgwMziDMQFBT/rtlp0F03pi2otCVOc8RK5GjFICQbYz2wsHrVXELDGCCjM89B53y3lIXEjJdwyJfK61HsDMOlURR4ePK")
INSERT INTO Payloads VALUES	("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "Standard", "Adobe Flash CS6_AdobeFlash12.0-ja_JPLanguagePack", "12.0", "langPack")
INSERT INTO PayloadData VALUES("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "0" , "KeyFolder", "[INSTALLDIR]/Adobe Flash CS6/ja_JP")
INSERT INTO PayloadData VALUES("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "0" , "PayloadInfo", '<PayloadInfo version="6.0.29.0"><BuildInfo>
    <Property name="Created">2012-03-30 16:53:23.170000</Property>
    <Property name="TargetName">AdobeFlash12.0-ja_JPLanguagePack</Property>
    <Property name="ProcessorFamily">All</Property>
  </BuildInfo><InstallerProperties>
    <Property name="payloadType">SQLite</Property>
    <Property name="AdobeCode">{23D3FD35-6497-4038-9CE3-6B79A4093013}</Property>
    <Property name="ProductName">Adobe Flash CS6 Payload LangPack (ja_JP)</Property>
    <Property name="ProductVersion">12.0</Property>
    <Property name="KeyFolder">[INSTALLDIR]/Adobe Flash CS6/ja_JP</Property>
  </InstallerProperties><InstallDir>
    <Platform isFixed="0" name="Default" folderName="">[AdobeProgramFiles]</Platform>
  </InstallDir><Languages>
    <Language>ja_JP</Language>
  </Languages><Satisfies>
    <ProductInfo>
    <Family>Standard</Family>
    <ProductName>Adobe Flash CS6_AdobeFlash12.0-ja_JPLanguagePack</ProductName>
  <ProductVersion>12.0</ProductVersion>
    </ProductInfo>
  </Satisfies><Upgrades>
    <AdobeCode>{9B73E411-AF5B-47E8-9A6A-67EC1319669A}</AdobeCode>
  </Upgrades><Conflicts>
    <AdobeCode>{2B076846-CDFB-43E6-9335-CAA5118B7113}</AdobeCode>
    <AdobeCode>{283397D2-A4D3-4842-AB80-5CED5D997E24}</AdobeCode>
    <AdobeCode>{9EA382A4-CED2-46F0-B683-EA0BDB147144}</AdobeCode>
    <AdobeCode>{025B75FB-99DE-4D5B-B178-CFA14BECCDEC}</AdobeCode>
    <AdobeCode>{4ED4C05D-255B-4452-AF8B-E61C53B3F5CF}</AdobeCode>
    <AdobeCode>{53152C33-B2A3-4293-BF99-AB7B02A26F0D}</AdobeCode>
    <AdobeCode>{C085362F-585E-45E9-85AB-13EE94E0A967}</AdobeCode>
    <AdobeCode>{B73D7C2E-221C-4BD7-8040-76A7CD0A1A10}</AdobeCode>
    <AdobeCode>{B4A2AF3A-5433-4306-9A01-F46FA27968C5}</AdobeCode>
    <AdobeCode>{8D4735B4-7FC0-430E-80C7-1F08F6112946}</AdobeCode>
    <AdobeCode>{FC7A54D0-6B31-4CD0-BA37-EDA6A4100DDE}</AdobeCode>
    <AdobeCode>{18995678-9FB2-4234-8F4C-2459D029366A}</AdobeCode>
    <AdobeCode>{29064570-D757-4097-8871-894F89795EE7}</AdobeCode>
    <AdobeCode>{3DB59CCA-D15A-437B-ABCF-D635B26C5DC3}</AdobeCode>
    <AdobeCode>{C6B6BBC5-7685-48E0-9869-3DB61B35652D}</AdobeCode>
    <AdobeCode>{464F0471-8F16-43A4-A2AF-37B961824F2B}</AdobeCode>
    <AdobeCode>{9A9360E8-BBEB-4F99-AD6E-77765E983D98}</AdobeCode>
    <AdobeCode>{11CB2190-8082-41AF-B2C0-64F655FAD7FB}</AdobeCode>
    <AdobeCode>{8AD58A21-DA2B-4188-963B-0173BF18BADF}</AdobeCode>
    <AdobeCode>{BAA090E8-D797-4785-9386-555D11093515}</AdobeCode>
    <AdobeCode>{2E0EB443-77CE-4AB2-9043-502E5B61EEF3}</AdobeCode>
  </Conflicts><Channel enable="1" id="FlashPro12.0ja_JP">
    <DisplayName>Adobe Flash CS6 Payload LangPack (ja_JP)</DisplayName>
  </Channel><Extends type="langPack">
    <ParentProductInfo minVersion="12.0">
          <Family>Standard</Family>
          <ProductName>Adobe Flash CS6</ProductName>
        </ParentProductInfo>
  </Extends><InstallDestinationMetadata relocatableSize="49734674" sysDriveSize="0"><Destination>
      <Root>[INSTALLDIR]</Root>
      <TotalSize>49734674</TotalSize>
      <MaxPathComponent>/Adobe Flash CS6/ja_JP/First Run/ActionsPanel/ActionScript_1_2/CustomActions/ScriptAssist\Flash Data Components.xml</MaxPathComponent>
    </Destination>
    <Assets>
      <Asset flag="1" name="Assets1_1" size="49734674"/>
    </Assets>
  </InstallDestinationMetadata><ConflictingProcesses>
	<Win32>
	</Win32>
</ConflictingProcesses><AddRemoveInfo>
    <DisplayVersion>
      <Value lang="ja_JP">12.0</Value>
    </DisplayVersion>
    <DisplayName>
      <Value lang="ja_JP">Adobe Flash CS6 Payload LangPack (ja_JP)</Value>
    </DisplayName>
  </AddRemoveInfo><UserPreferences>0</UserPreferences></PayloadInfo>')
INSERT INTO PayloadData VALUES("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "0" , "WorkflowVersion", "CS6")
INSERT INTO PayloadData VALUES("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "0" , "DEVersion", "6.0")
INSERT INTO PayloadData VALUES("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "0", "ChannelID", "FlashPro12.0ja_JP")
INSERT INTO PayloadData VALUES("{23D3FD35-6497-4038-9CE3-6B79A4093013}", "0", "ChannelInfo", '<Channel enable="1" id="FlashPro12.0ja_JP">
    <DisplayName>Adobe Flash CS6 Payload LangPack (ja_JP)</DisplayName>
  </Channel>')
