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 Payloads VALUES	("{43A1C48E-3E50-410e-951C-E17A66BBF824}", "NonAdobePayload", "Adobe Flash Player 10 Plugin", "10", "normal")
INSERT INTO PayloadData VALUES("{43A1C48E-3E50-410e-951C-E17A66BBF824}", "0" , "PayloadInfo", '<PayloadInfo version="4.0.19.0"><BuildInfo>
    <Property name="Created">2011-03-10 14:14:07.527000</Property>
    <Property name="TargetName">AdobeFlashPlayer10_plRel_mul</Property>
  </BuildInfo><InstallerProperties>
    <Property name="AdobeCode">{43A1C48E-3E50-410e-951C-E17A66BBF824}</Property>
    <Property name="ProductName">Adobe Flash Player 10 Plugin</Property>
    <Property name="ProductVersion">10.2.153.1</Property>
  </InstallerProperties><InstallDir>
    <Platform name="Default" folderName="">[System32Folder]\Macromed\Flash</Platform>
  </InstallDir><Languages languageIndependent="1"/><Satisfies>
    <ProductInfo>
		<Family>NonAdobePayload</Family>
		<ProductName>Adobe Flash Player 10 Plugin</ProductName>
		<ProductVersion>10</ProductVersion>
    </ProductInfo>
  </Satisfies><ThirdPartyComponent>
    <Metadata>
      <Type>msiPackage</Type>
      <Name>AdobeFlashPlayer10_plRel_mul.msi</Name>
      <Properties>
		<Property name="ProductCode">{9C542173-96F0-435D-A95C-468CAAC75EA0}</Property>
      </Properties>
    </Metadata>
    <Arguments delimiter="=" prefix="">
      <Uninstall>
        <Argument name="msiProductCode">{9C542173-96F0-435D-A95C-468CAAC75EA0}</Argument>
        <Argument name="REBOOT">ReallySuppress</Argument>
      </Uninstall>  
      <Install>
        <Argument name="UILevel">2</Argument>
      </Install>
      <Repair>
        <Argument name="UILevel">2</Argument>
      </Repair>
    </Arguments>
    <Capabilities>
    	<Install/>
    	<Repair isRepairable="1"/>
    	<Uninstall isUninstallable="0"/>
    </Capabilities>
    <SuccessCodes>
      <Install>
        <Range lowerBound="0" upperBound="0"/>
        <Range lowerBound="1603" upperBound="1603"/>
        <Range lowerBound="1722" upperBound="1722"/>
      </Install>
    </SuccessCodes>
  </ThirdPartyComponent><InstallDestinationMetadata relocatableSize="6000000" sysDriveSize="0">
	  <Destination>
		  <Root>[INSTALLDIR]</Root>
		  <TotalSize>6000000</TotalSize>
		  <MaxPathComponent>/AdobeFlashPlayer10_plRel_mul.msi</MaxPathComponent>
		</Destination>
  </InstallDestinationMetadata><ConflictingProcesses>
	<Win32>
        	<Process processType="NonAdobe" blocking="1">^[Gg]et[Ff]lash\.exe$</Process>
        	<Process processType="NonAdobe" blocking="1">^[Ff][Ii][Rr][Ee][Ff][Oo][Xx]\.[Ee][Xx][Ee]$</Process>
        	<Process processType="NonAdobe" blocking="1">^[Oo][Pp][Ee][Rr][Aa]\.[Ee][Xx][Ee]$</Process>
        	<Process processType="NonAdobe" blocking="1">^[Nn][Ee][Tt][Ss][Cc][Aa][Pp][Ee]\.[Ee][Xx][Ee]$</Process>
        	<Process processType="NonAdobe" blocking="1">^[Nn][Ee][Tt][Ss][Cc][Pp]\.[Ee][Xx][Ee]$</Process>
        	<Process processType="NonAdobe" blocking="1">^[Ss][Ee][Aa][Mm][Oo][Nn][Kk][Ee][Yy]\.[Ee][Xx][Ee]$</Process>
        	<Process processType="NonAdobe" blocking="1">^[Nn][Aa][Vv][Ii][Gg][Aa][Tt][Oo][Rr]\.[Ee][Xx][Ee]$</Process>
        	<Process processType="NonAdobe" blocking="1">^[Ss][Aa][Ff][Aa][Rr][Ii]\.[Ee][Xx][Ee]$</Process>
        	<Process processType="NonAdobe" blocking="1">^[Cc][Hh][Rr][Oo][Mm][Ee]\.[Ee][Xx][Ee]$</Process>
	</Win32>
  </ConflictingProcesses></PayloadInfo>')
