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	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{7F496ADE-687F-4BBC-BF57-17F6CD9F20FD}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{43392E8B-D4DB-4E37-99DC-311B916C643E}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{31441FE4-7B1D-4651-AE8F-BDCC3B981977}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{9366F5D3-9DED-4444-BFEB-606EB0CE3DBA}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{94EAC73B-C71C-4464-9491-FEE242CB9EEF}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{043D3F5B-B2A5-43F7-887A-2BE100185E63}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{ACBB3B81-F911-4B65-A74F-761696FB9631}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{B2CF1F60-3CA2-4D6B-97FC-D94EC19CB582}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{77D83184-6117-4BA3-A898-3D148DAE8593}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{59B717A4-0E41-40DA-A88D-4B57A478DB83}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{85E4FE18-2001-414E-9F26-7B2E29B10F63}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{BB024724-14D5-4AB6-B21C-74EDA63A0A39}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{6DCD9DE6-1D62-4F86-9C16-E6D86777E89E}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{BD4AD987-E746-4503-B9D3-A178B48855EA}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{4DE2E834-ED7D-43DF-8A2B-AE3F4A554C29}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "{1EC8AFA7-E8A7-450B-BFD0-08F256D44140}", "upgrade", "", "", "")
INSERT INTO Payloads VALUES	("{D0C50427-0E90-4821-91F3-D9476235901F}", "LearningResources", "HIL Help Search", "1.0", "normal")
INSERT INTO PayloadData VALUES("{D0C50427-0E90-4821-91F3-D9476235901F}", "0" , "PayloadInfo", '<PayloadInfo version="4.0.19.0"><BuildInfo>
    <Property name="Created">2010-12-20 14:13:22.493000</Property>
    <Property name="TargetName">HIL_Help_Search</Property>
    <Property name="ProcessorFamily">All</Property>
  </BuildInfo><InstallerProperties>
    <Property name="payloadType">SQLite</Property>
    <Property name="AdobeCode">{D0C50427-0E90-4821-91F3-D9476235901F}</Property>
    <Property name="ProductName">HIL Help Search</Property>
    <Property name="ProductVersion">1.0</Property>
  </InstallerProperties><InstallDir>
    <Platform isFixed="1" name="Default" folderName="">[AdobeCommon]</Platform>
  </InstallDir><Languages languageIndependent="1"/><Satisfies>
    <ProductInfo>
		<Family>LearningResources</Family>
		<ProductName>HIL Help Search</ProductName>
  <ProductVersion>1.0</ProductVersion>
    </ProductInfo>
  </Satisfies><Upgrades>
    <AdobeCode>{7F496ADE-687F-4BBC-BF57-17F6CD9F20FD}</AdobeCode>
    <AdobeCode>{43392E8B-D4DB-4E37-99DC-311B916C643E}</AdobeCode>
    <AdobeCode>{31441FE4-7B1D-4651-AE8F-BDCC3B981977}</AdobeCode>
    <AdobeCode>{9366F5D3-9DED-4444-BFEB-606EB0CE3DBA}</AdobeCode>
    <AdobeCode>{94EAC73B-C71C-4464-9491-FEE242CB9EEF}</AdobeCode>
    <AdobeCode>{043D3F5B-B2A5-43F7-887A-2BE100185E63}</AdobeCode>
    <AdobeCode>{ACBB3B81-F911-4B65-A74F-761696FB9631}</AdobeCode>
    <AdobeCode>{B2CF1F60-3CA2-4D6B-97FC-D94EC19CB582}</AdobeCode>
    <AdobeCode>{77D83184-6117-4BA3-A898-3D148DAE8593}</AdobeCode>
    <AdobeCode>{59B717A4-0E41-40DA-A88D-4B57A478DB83}</AdobeCode>
    <AdobeCode>{85E4FE18-2001-414E-9F26-7B2E29B10F63}</AdobeCode>
    <AdobeCode>{BB024724-14D5-4AB6-B21C-74EDA63A0A39}</AdobeCode>
    <AdobeCode>{6DCD9DE6-1D62-4F86-9C16-E6D86777E89E}</AdobeCode>
    <AdobeCode>{BD4AD987-E746-4503-B9D3-A178B48855EA}</AdobeCode>
    <AdobeCode>{4DE2E834-ED7D-43DF-8A2B-AE3F4A554C29}</AdobeCode>
    <AdobeCode>{1EC8AFA7-E8A7-450B-BFD0-08F256D44140}</AdobeCode>
  </Upgrades><Channel enable="1" id="HILHelpSearch-1.0">
    <DisplayName>HIL Help Search</DisplayName>
  </Channel><InstallDestinationMetadata relocatableSize="200880" sysDriveSize="0"><Destination>
      <Root>[INSTALLDIR]</Root>
      <TotalSize>200880</TotalSize>
      <MaxPathComponent>/HIL Help Search\ahclient.exe</MaxPathComponent>
    </Destination>
    <Assets>
      <Asset flag="1" name="Assets1_1" size="200880"/>
    </Assets>
  </InstallDestinationMetadata><ConflictingProcesses>
	<Win32>
	</Win32>
</ConflictingProcesses><AddRemoveInfo>
    <DisplayVersion>
      <Value lang="sq_AL">1.0</Value>
      <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="zh_CN">1.0</Value>
      <Value lang="zh_TW">1.0</Value>
      <Value lang="hr_HR">1.0</Value>
      <Value lang="cs_CZ">1.0</Value>
      <Value lang="da_DK">1.0</Value>
      <Value lang="nl_NL">1.0</Value>
      <Value lang="en_XC">1.0</Value>
      <Value lang="en_XM">1.0</Value>
      <Value lang="en_GB">1.0</Value>
      <Value lang="en_US">1.0</Value>
      <Value lang="et_EE">1.0</Value>
      <Value lang="fi_FI">1.0</Value>
      <Value lang="fr_FR">1.0</Value>
      <Value lang="fr_XM">1.0</Value>
      <Value lang="de_DE">1.0</Value>
      <Value lang="el_GR">1.0</Value>
      <Value lang="he_IL">1.0</Value>
      <Value lang="hu_HU">1.0</Value>
      <Value lang="hi_IN">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="lv_LV">1.0</Value>
      <Value lang="lt_LT">1.0</Value>
      <Value lang="mk_MK">1.0</Value>
      <Value lang="nn_NO">1.0</Value>
      <Value lang="no_NO">1.0</Value>
      <Value lang="nb_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="es_QM">1.0</Value>
      <Value lang="es_ES">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="fr_CA">1.0</Value>
      <Value lang="es_MX">1.0</Value>
    </DisplayVersion>
    <DisplayName>
      <Value lang="sq_AL">HIL Help Search</Value>
      <Value lang="ar_AE">HIL Help Search</Value>
      <Value lang="be_BY">HIL Help Search</Value>
      <Value lang="bg_BG">HIL Help Search</Value>
      <Value lang="ca_ES">HIL Help Search</Value>
      <Value lang="zh_CN">HIL Help Search</Value>
      <Value lang="zh_TW">HIL Help Search</Value>
      <Value lang="hr_HR">HIL Help Search</Value>
      <Value lang="cs_CZ">HIL Help Search</Value>
      <Value lang="da_DK">HIL Help Search</Value>
      <Value lang="nl_NL">HIL Help Search</Value>
      <Value lang="en_XC">HIL Help Search</Value>
      <Value lang="en_XM">HIL Help Search</Value>
      <Value lang="en_GB">HIL Help Search</Value>
      <Value lang="en_US">HIL Help Search</Value>
      <Value lang="et_EE">HIL Help Search</Value>
      <Value lang="fi_FI">HIL Help Search</Value>
      <Value lang="fr_FR">HIL Help Search</Value>
      <Value lang="fr_XM">HIL Help Search</Value>
      <Value lang="de_DE">HIL Help Search</Value>
      <Value lang="el_GR">HIL Help Search</Value>
      <Value lang="he_IL">HIL Help Search</Value>
      <Value lang="hu_HU">HIL Help Search</Value>
      <Value lang="hi_IN">HIL Help Search</Value>
      <Value lang="is_IS">HIL Help Search</Value>
      <Value lang="it_IT">HIL Help Search</Value>
      <Value lang="ja_JP">HIL Help Search</Value>
      <Value lang="ko_KR">HIL Help Search</Value>
      <Value lang="lv_LV">HIL Help Search</Value>
      <Value lang="lt_LT">HIL Help Search</Value>
      <Value lang="mk_MK">HIL Help Search</Value>
      <Value lang="nn_NO">HIL Help Search</Value>
      <Value lang="no_NO">HIL Help Search</Value>
      <Value lang="nb_NO">HIL Help Search</Value>
      <Value lang="pl_PL">HIL Help Search</Value>
      <Value lang="pt_BR">HIL Help Search</Value>
      <Value lang="ro_RO">HIL Help Search</Value>
      <Value lang="ru_RU">HIL Help Search</Value>
      <Value lang="sh_YU">HIL Help Search</Value>
      <Value lang="sk_SK">HIL Help Search</Value>
      <Value lang="sl_SI">HIL Help Search</Value>
      <Value lang="es_QM">HIL Help Search</Value>
      <Value lang="es_ES">HIL Help Search</Value>
      <Value lang="sv_SE">HIL Help Search</Value>
      <Value lang="th_TH">HIL Help Search</Value>
      <Value lang="tr_TR">HIL Help Search</Value>
      <Value lang="uk_UA">HIL Help Search</Value>
      <Value lang="vi_VN">HIL Help Search</Value>
      <Value lang="fr_CA">HIL Help Search</Value>
      <Value lang="es_MX">HIL Help Search</Value>
    </DisplayName>
  </AddRemoveInfo><UserPreferences>0</UserPreferences></PayloadInfo>')
INSERT INTO PayloadData VALUES("{D0C50427-0E90-4821-91F3-D9476235901F}", "0", "ChannelID", "HILHelpSearch-1.0")
INSERT INTO PayloadData VALUES("{D0C50427-0E90-4821-91F3-D9476235901F}", "0", "ChannelInfo", '<Channel enable="1" id="HILHelpSearch-1.0">
    <DisplayName>HIL Help Search</DisplayName>
  </Channel>')
