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) )
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{7F1007AD-28A7-49EF-89AC-AFE7C7207F61}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{640C7DE2-40D9-46CB-B628-655D4F5072C8}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{25B23DF5-7C7B-41A4-80BD-5DCB45769837}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{D6605655-91B0-465B-B1E2-607C21BDD8C0}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{2B4A6DA8-5A47-4909-B1C9-56EB8F8C7BBB}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{B386AC20-CAA0-477A-B8CC-2C9300220558}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{829D920A-F52D-446F-AA67-62EAAB626236}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{5B76FBEA-7A64-4D21-ADB3-200D96B9E057}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{B6CA9826-3F75-4BF4-9C47-C80D691E65FE}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{CDBD0502-F69C-4099-B626-E0CABFA1CA64}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{C2D79957-C745-47BF-9791-BEAACB51B2EC}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{226A4F13-59A6-4A37-A9F8-878FFC8ECD4F}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{5DD14054-55CE-4228-89F9-A6774C5B7EC4}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{97732ADF-3DDE-42B0-AAAF-60A329F19912}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{527E66CA-A631-4CFF-AF84-EB82C99269B1}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{A689857C-30C9-42F0-8879-701A56495F40}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{4B39FF0E-C0AE-4CD6-9E72-5EFAFE4F059E}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{32BA2393-99DB-4B16-B0ED-368732AFFBF4}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{26D6B47E-6CD8-42C3-AF4A-0E88B7B77A45}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{D8459666-7B62-42D4-923C-B787D2115A2D}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{6D5C4834-F302-4B32-A778-A312332AF281}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{30280955-95CB-432C-9E3F-7D026B0F740C}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{A89F5624-4CD1-43CA-A7CF-42CD20B292C4}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{5FD31E90-E3AD-48FC-AAE7-F0D1D287180C}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{E42374D7-F429-4863-948C-C67866B0386C}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "{381E10F2-0F97-4A22-AA66-AECEDD84A01B}", "upgrade", "", "", "")
INSERT INTO Branding VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "AMTConfig", 'PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTgiPz4NCjxDb25maWd1cmF0aW9uPg0K
ICA8UGF5bG9hZD4NCiAgICA8IS0tIGRlZmF1bHRBZG9iZUNvZGUgZm9yIGRldmVsb3BtZW50IHVz
ZS4gLS0+DQogICAgPERhdGEga2V5PSJkZWZhdWx0QWRvYmVDb2RlIj5OQVJlYy1TVEktQWRvYmVD
b2RlPC9EYXRhPg0KICA8L1BheWxvYWQ+DQo8L0NvbmZpZ3VyYXRpb24+')
INSERT INTO Payloads VALUES	("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "CoreTech", "AdobeColorNA CS5", "3.0", "normal")
INSERT INTO PayloadData VALUES("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "0" , "PayloadInfo", '<PayloadInfo version="3.0.106.0"><BuildInfo>
    <Property name="Created">2010-01-05 23:36:51.432000</Property>
    <Property name="TargetName">AdobeColorNA_Recommended3-mul</Property>
    <Property name="ProcessorFamily">All</Property>
  </BuildInfo><InstallerProperties>
    <Property name="payloadType">SQLite</Property>
    <Property name="AdobeCode">{D26EEF95-420A-4726-B85D-AFBE752EF526}</Property>
    <Property name="ProductName">Adobe Color NA Recommended Settings CS5</Property>
    <Property name="ProductVersion">3.0</Property>
  </InstallerProperties><InstallDir>
    <Platform isFixed="1" name="Default" folderName="">[AdobeCommon]\Color</Platform>
  </InstallDir><Languages>
    <Language>en_US</Language>
    <Language>fr_CA</Language>
  </Languages><Satisfies>
    <ProductInfo>
		<Family>CoreTech</Family>
		<ProductName>AdobeColorNA CS5</ProductName>
	<ProductVersion>3.0</ProductVersion>
    </ProductInfo>
  </Satisfies><Upgrades>
    <AdobeCode>{7F1007AD-28A7-49EF-89AC-AFE7C7207F61}</AdobeCode>
    <AdobeCode>{640C7DE2-40D9-46CB-B628-655D4F5072C8}</AdobeCode>
    <AdobeCode>{25B23DF5-7C7B-41A4-80BD-5DCB45769837}</AdobeCode>
    <AdobeCode>{D6605655-91B0-465B-B1E2-607C21BDD8C0}</AdobeCode>
    <AdobeCode>{2B4A6DA8-5A47-4909-B1C9-56EB8F8C7BBB}</AdobeCode>
    <AdobeCode>{B386AC20-CAA0-477A-B8CC-2C9300220558}</AdobeCode>
    <AdobeCode>{829D920A-F52D-446F-AA67-62EAAB626236}</AdobeCode>
    <AdobeCode>{5B76FBEA-7A64-4D21-ADB3-200D96B9E057}</AdobeCode>
    <AdobeCode>{B6CA9826-3F75-4BF4-9C47-C80D691E65FE}</AdobeCode>
    <AdobeCode>{CDBD0502-F69C-4099-B626-E0CABFA1CA64}</AdobeCode>
    <AdobeCode>{C2D79957-C745-47BF-9791-BEAACB51B2EC}</AdobeCode>
    <AdobeCode>{226A4F13-59A6-4A37-A9F8-878FFC8ECD4F}</AdobeCode>
    <AdobeCode>{5DD14054-55CE-4228-89F9-A6774C5B7EC4}</AdobeCode>
    <AdobeCode>{97732ADF-3DDE-42B0-AAAF-60A329F19912}</AdobeCode>
    <AdobeCode>{527E66CA-A631-4CFF-AF84-EB82C99269B1}</AdobeCode>
    <AdobeCode>{A689857C-30C9-42F0-8879-701A56495F40}</AdobeCode>
    <AdobeCode>{4B39FF0E-C0AE-4CD6-9E72-5EFAFE4F059E}</AdobeCode>
    <AdobeCode>{32BA2393-99DB-4B16-B0ED-368732AFFBF4}</AdobeCode>
    <AdobeCode>{26D6B47E-6CD8-42C3-AF4A-0E88B7B77A45}</AdobeCode>
    <AdobeCode>{D8459666-7B62-42D4-923C-B787D2115A2D}</AdobeCode>
    <AdobeCode>{6D5C4834-F302-4B32-A778-A312332AF281}</AdobeCode>
    <AdobeCode>{30280955-95CB-432C-9E3F-7D026B0F740C}</AdobeCode>
    <AdobeCode>{A89F5624-4CD1-43CA-A7CF-42CD20B292C4}</AdobeCode>
    <AdobeCode>{5FD31E90-E3AD-48FC-AAE7-F0D1D287180C}</AdobeCode>
    <AdobeCode>{E42374D7-F429-4863-948C-C67866B0386C}</AdobeCode>
    <AdobeCode>{381E10F2-0F97-4A22-AA66-AECEDD84A01B}</AdobeCode>
  </Upgrades><Channel enable="1" id="AdobeColorNARecommendedSettingsCS5-3.0">
    <DisplayName>Adobe Color NA Recommended Settings CS5</DisplayName>
  </Channel><AMTConfig path="[AdobeCommon]\Color\AMT\component_narec.xml"/><InstallDestinationMetadata relocatableSize="0" sysDriveSize="2390217"><Destination>
      <Root>[AdobeCommon]</Root>
      <TotalSize>2390217</TotalSize>
      <MaxPathComponent>/Color/Settings/Recommended\North America General Purpose.csf</MaxPathComponent>
    </Destination>
    <Assets>
      <Asset flag="0" name="Assets2_1" size="2390217"/>
    </Assets>
  </InstallDestinationMetadata><ConflictingProcesses>
	<Win32>
	<Process processType="NonAdobe" blocking="1">^[Ff][Ii][Rr][Ee][Ff][Oo][Xx].[Ee][Xx][Ee]$</Process>
      <Process processType="NonAdobe" blocking="1">^[Ff][Ii][Rr][Ee][Ff][Oo][Xx].[Ee][Xx][Ee]$</Process>
      <Process processType="NonAdobe" blocking="1">^[Ff][Ii][Rr][Ee][Ff][Oo][Xx].[Ee][Xx][Ee]$</Process>
      <Process processType="NonAdobe" blocking="1">^[Ff][Ii][Rr][Ee][Ff][Oo][Xx].[Ee][Xx][Ee]$</Process>
    </Win32>
<OSX>
      <Process processType="NonAdobe" blocking="1">^[Ff][Ii][Rr][Ee][Ff][Oo][Xx]$</Process>
      <Process processType="NonAdobe" blocking="1">^[Ff][Ii][Rr][Ee][Ff][Oo][Xx]$</Process>
      <Process processType="NonAdobe" blocking="1">^[Ff][Ii][Rr][Ee][Ff][Oo][Xx]$</Process>
      <Process processType="NonAdobe" blocking="1">^[Ff][Ii][Rr][Ee][Ff][Oo][Xx]$</Process>
    </OSX>
  </ConflictingProcesses><AddRemoveInfo>
    <DisplayVersion>
      <Value lang="en_US">3.0</Value>
      <Value lang="fr_CA">3.0</Value>
    </DisplayVersion>
    <DisplayName>
      <Value lang="en_US">Adobe Color NA Recommended Settings CS5</Value>
      <Value lang="fr_CA">Adobe Color NA Recommended Settings CS5</Value>
    </DisplayName>
  </AddRemoveInfo><UserPreferences>0</UserPreferences></PayloadInfo>')
INSERT INTO PayloadData VALUES("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "0", "AMTConfigPath", "[AdobeCommon]\Color\AMT\component_narec.xml")
INSERT INTO PayloadData VALUES("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "0", "ChannelID", "AdobeColorNARecommendedSettingsCS5-3.0")
INSERT INTO PayloadData VALUES("{D26EEF95-420A-4726-B85D-AFBE752EF526}", "0", "ChannelInfo", '<Channel enable="1" id="AdobeColorNARecommendedSettingsCS5-3.0">
    <DisplayName>Adobe Color NA Recommended Settings CS5</DisplayName>
  </Channel>')
