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	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "", "critical", "Creative Suite", "AdobeIdeaPluginCS6-loc", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{2F884B93-2D53-4FF3-A117-07828172DB78}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{639F8F51-C37D-4D09-8786-F51C7F651264}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{C9C05F50-72DC-4C7C-AAF8-9BE268BA7201}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{31A658D9-C520-4924-8BCE-4A91A2B2489F}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{D46AEE2D-ED2B-427A-87FD-F550914BBBD2}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{B7FFB99C-83A3-46E0-8534-3EE8E4E2B314}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{D8C31D07-B195-459D-A3FD-89C1B8785752}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{A2CCA8EE-12E9-4E76-879C-60AF4C8F5218}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{8C1EAB73-CAC6-4F47-9AC1-53FE42E28F3A}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{F1157FD2-38CD-4AE0-BDC0-54E3C740C474}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{4352C86B-B57E-4BD1-9F4A-DA17AC2DC649}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{4E11CCB1-1898-4688-BA23-1BB51F16E04C}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{EC92C31C-2FC6-4E89-B962-BE6586DF9D9A}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{6921A770-65F1-4B07-9EB3-84C30B9516F3}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{DE71BDC6-3B9E-40EF-A4D7-BC54B43DD6DD}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "{F862D0F7-A0D1-46AD-A09A-07EB6CB3FCD7}", "upgrade", "", "", "")
INSERT INTO PayloadData VALUES("{7483525E-26E8-4748-870D-1F064AB8AA83}", "0" , "ValidationInfo", '<ValidationInfo payloadID="{7483525E-26E8-4748-870D-1F064AB8AA83}"><File><InstallPath>[INSTALLDIR]\Adobe Illustrator CS6 (64 Bit)\Plug-ins\Illustrator Formats\IdeaFileFormat.aip</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("{7483525E-26E8-4748-870D-1F064AB8AA83}", "0" , "ValidationSig", "mcmLFAYvR0Dp3It3kaNZWulQoiyIo1p+vwSrgZlgIUIWG3JgqaiEp2qVRHSoVxHgzaigssm1mfVU1DTFZeKJVcZTZwhRtEkenD53O/XAUfCywB/l82wQf+DkwyapNOec9GnmSam5FTEEzwEtqBJQhxizoJ/xZFg2NsXMCxcFj6UAp/XIKB8TIKSRjR5yich2QLvbzZfIyCuk22jwZMZdev19R2Fpg0/X1q/HR8QXFliQG5fsUQTIDipXAvx0thPRCYuFCtGuYlnzRn0lDCC5Ef/v2vSqDd6IFvN7ozWbYLpZrItI3JMZTiyCiGPtjkJ6KbSSbsfpx/zZpcuC1dITEcVEB9PmWJJpywJigEafaKosIVVVrMnbYnJjYMVeh7kuk2pQAq/U5IvuwSwD0y/BYH00TqeqbbMe9DZcPkppE9xigL5WpR+Ga760GK5xfAQq4uwBNrWRbdpSC0awZ6LQa6fZYD/X+twxw4E+q/INuGrH495uRgJJiuxNAf9PLrOo")
INSERT INTO Payloads VALUES	("{7483525E-26E8-4748-870D-1F064AB8AA83}", "Creative Suite", "AdobeIdeaPluginCS6 x64", "1.0", "normal")
INSERT INTO PayloadData VALUES("{7483525E-26E8-4748-870D-1F064AB8AA83}", "0" , "KeyFolder", "[INSTALLDIR]/Adobe Illustrator CS6 (64 Bit)/Plug-ins/Illustrator Formats")
INSERT INTO PayloadData VALUES("{7483525E-26E8-4748-870D-1F064AB8AA83}", "0" , "PayloadInfo", '<PayloadInfo version="6.0.29.0"><BuildInfo>
    <Property name="Created">2012-03-05 18:27:59.257000</Property>
    <Property name="TargetName">AdobeIdeaPluginCS6-x64-mul</Property>
    <Property name="ProcessorFamily">x64</Property>
  </BuildInfo><InstallerProperties>
    <Property name="payloadType">SQLite</Property>
    <Property name="AdobeCode">{7483525E-26E8-4748-870D-1F064AB8AA83}</Property>
    <Property name="ProductName">Ideas Plugin for AI CS6 64-Bit</Property>
    <Property name="ProductVersion">1.0</Property>
    <Property name="KeyFolder">[INSTALLDIR]/Adobe Illustrator CS6 (64 Bit)/Plug-ins/Illustrator Formats</Property>
  </InstallerProperties><InstallDir>
    <Platform isFixed="0" name="Default" folderName="">[AdobeProgramFiles]</Platform>
  </InstallDir><Languages languageIndependent="1"/><Satisfies>
    <ProductInfo>
		<Family>Creative Suite</Family>
		<ProductName>AdobeIdeaPluginCS6 x64</ProductName>
	<ProductVersion>1.0</ProductVersion>
    </ProductInfo>
  </Satisfies><Dependencies>
    <ProductInfo type="critical">
                        <Family>Creative Suite</Family>
						<ProductName>AdobeIdeaPluginCS6-loc</ProductName>
					</ProductInfo>
  </Dependencies><Upgrades>
    <AdobeCode>{2F884B93-2D53-4FF3-A117-07828172DB78}</AdobeCode>
    <AdobeCode>{639F8F51-C37D-4D09-8786-F51C7F651264}</AdobeCode>
    <AdobeCode>{C9C05F50-72DC-4C7C-AAF8-9BE268BA7201}</AdobeCode>
    <AdobeCode>{31A658D9-C520-4924-8BCE-4A91A2B2489F}</AdobeCode>
    <AdobeCode>{D46AEE2D-ED2B-427A-87FD-F550914BBBD2}</AdobeCode>
    <AdobeCode>{B7FFB99C-83A3-46E0-8534-3EE8E4E2B314}</AdobeCode>
    <AdobeCode>{D8C31D07-B195-459D-A3FD-89C1B8785752}</AdobeCode>
    <AdobeCode>{A2CCA8EE-12E9-4E76-879C-60AF4C8F5218}</AdobeCode>
    <AdobeCode>{8C1EAB73-CAC6-4F47-9AC1-53FE42E28F3A}</AdobeCode>
    <AdobeCode>{F1157FD2-38CD-4AE0-BDC0-54E3C740C474}</AdobeCode>
    <AdobeCode>{4352C86B-B57E-4BD1-9F4A-DA17AC2DC649}</AdobeCode>
    <AdobeCode>{4E11CCB1-1898-4688-BA23-1BB51F16E04C}</AdobeCode>
    <AdobeCode>{EC92C31C-2FC6-4E89-B962-BE6586DF9D9A}</AdobeCode>
    <AdobeCode>{6921A770-65F1-4B07-9EB3-84C30B9516F3}</AdobeCode>
    <AdobeCode>{DE71BDC6-3B9E-40EF-A4D7-BC54B43DD6DD}</AdobeCode>
    <AdobeCode>{F862D0F7-A0D1-46AD-A09A-07EB6CB3FCD7}</AdobeCode>
  </Upgrades><Channel enable="1" id="IdeasPluginforAICS664-Bit-1.0">
    <DisplayName>Ideas Plugin for AI CS6 64-Bit</DisplayName>
  </Channel><InstallDestinationMetadata relocatableSize="923800" sysDriveSize="0"><Destination>
      <Root>[INSTALLDIR]</Root>
      <TotalSize>923800</TotalSize>
      <MaxPathComponent>/Adobe Illustrator CS6 (64 Bit)/Plug-ins/Illustrator Formats\IdeaFileFormat.aip</MaxPathComponent>
    </Destination>
    <Assets>
      <Asset flag="1" name="Assets1_1" size="923800"/>
    </Assets>
  </InstallDestinationMetadata><ConflictingProcesses>
	<Win32>
	</Win32>
</ConflictingProcesses><AddRemoveInfo>
    <DisplayVersion>
      <Value lang="ar_AE">1.0</Value>
      <Value lang="be_BY">1.0</Value>
      <Value lang="bg_BG">1.0</Value>
      <Value lang="ca_ES">1.0</Value>
      <Value lang="cs_CZ">1.0</Value>
      <Value lang="da_DK">1.0</Value>
      <Value lang="de_DE">1.0</Value>
      <Value lang="el_GR">1.0</Value>
      <Value lang="en_GB">1.0</Value>
      <Value lang="en_MX">1.0</Value>
      <Value lang="en_US">1.0</Value>
      <Value lang="en_XC">1.0</Value>
      <Value lang="en_XM">1.0</Value>
      <Value lang="es_ES">1.0</Value>
      <Value lang="es_MX">1.0</Value>
      <Value lang="es_QM">1.0</Value>
      <Value lang="et_EE">1.0</Value>
      <Value lang="fi_FI">1.0</Value>
      <Value lang="fr_CA">1.0</Value>
      <Value lang="fr_FR">1.0</Value>
      <Value lang="fr_MX">1.0</Value>
      <Value lang="fr_XM">1.0</Value>
      <Value lang="he_IL">1.0</Value>
      <Value lang="hi_IN">1.0</Value>
      <Value lang="hr_HR">1.0</Value>
      <Value lang="hu_HU">1.0</Value>
      <Value lang="is_IS">1.0</Value>
      <Value lang="it_IT">1.0</Value>
      <Value lang="ja_JP">1.0</Value>
      <Value lang="ko_KR">1.0</Value>
      <Value lang="lt_LT">1.0</Value>
      <Value lang="lv_LV">1.0</Value>
      <Value lang="mk_MK">1.0</Value>
      <Value lang="nb_NO">1.0</Value>
      <Value lang="nl_NL">1.0</Value>
      <Value lang="nn_NO">1.0</Value>
      <Value lang="no_NO">1.0</Value>
      <Value lang="pl_PL">1.0</Value>
      <Value lang="pt_BR">1.0</Value>
      <Value lang="ro_RO">1.0</Value>
      <Value lang="ru_RU">1.0</Value>
      <Value lang="sh_YU">1.0</Value>
      <Value lang="sk_SK">1.0</Value>
      <Value lang="sl_SI">1.0</Value>
      <Value lang="sq_AL">1.0</Value>
      <Value lang="sv_SE">1.0</Value>
      <Value lang="th_TH">1.0</Value>
      <Value lang="tr_TR">1.0</Value>
      <Value lang="uk_UA">1.0</Value>
      <Value lang="vi_VN">1.0</Value>
      <Value lang="zh_CN">1.0</Value>
      <Value lang="zh_TW">1.0</Value>
      <Value lang="en_AE">1.0</Value>
      <Value lang="en_IL">1.0</Value>
      <Value lang="fr_MA">1.0</Value>
    </DisplayVersion>
    <DisplayName>
      <Value lang="ar_AE">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="be_BY">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="bg_BG">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="ca_ES">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="cs_CZ">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="da_DK">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="de_DE">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="el_GR">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="en_GB">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="en_MX">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="en_US">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="en_XC">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="en_XM">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="es_ES">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="es_MX">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="es_QM">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="et_EE">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="fi_FI">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="fr_CA">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="fr_FR">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="fr_MX">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="fr_XM">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="he_IL">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="hi_IN">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="hr_HR">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="hu_HU">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="is_IS">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="it_IT">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="ja_JP">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="ko_KR">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="lt_LT">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="lv_LV">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="mk_MK">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="nb_NO">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="nl_NL">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="nn_NO">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="no_NO">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="pl_PL">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="pt_BR">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="ro_RO">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="ru_RU">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="sh_YU">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="sk_SK">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="sl_SI">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="sq_AL">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="sv_SE">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="th_TH">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="tr_TR">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="uk_UA">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="vi_VN">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="zh_CN">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="zh_TW">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="en_AE">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="en_IL">Ideas Plugin for AI CS6 64-Bit</Value>
      <Value lang="fr_MA">Ideas Plugin for AI CS6 64-Bit</Value>
    </DisplayName>
  </AddRemoveInfo><UserPreferences>0</UserPreferences></PayloadInfo>')
INSERT INTO PayloadData VALUES("{7483525E-26E8-4748-870D-1F064AB8AA83}", "0" , "WorkflowVersion", "CS6")
INSERT INTO PayloadData VALUES("{7483525E-26E8-4748-870D-1F064AB8AA83}", "0" , "DEVersion", "6.0")
INSERT INTO PayloadData VALUES("{7483525E-26E8-4748-870D-1F064AB8AA83}", "0", "ChannelID", "IdeasPluginforAICS664-Bit-1.0")
INSERT INTO PayloadData VALUES("{7483525E-26E8-4748-870D-1F064AB8AA83}", "0", "ChannelInfo", '<Channel enable="1" id="IdeasPluginforAICS664-Bit-1.0">
    <DisplayName>Ideas Plugin for AI CS6 64-Bit</DisplayName>
  </Channel>')
