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	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "CoreTech", "AdobeCMaps CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "CoreTech", "AdobePDFL CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "Creative Suites", "Suite Shared Configuration CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "InDesign", "Adobe InDesign CS5 Application Base Files2", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "InDesign", "Adobe InDesign CS5 Application Feature Set Files", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "InDesign", "Adobe InDesign CS5 Common Base Files", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Bridge", "AdobeOutputModule", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "Adobe Bridge CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "Adobe ExtendScript Toolkit CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "Adobe Linguistics CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "Adobe Player for Embedding", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "Adobe SwitchBoard 2.0", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "Adobe WinSoft Linguistics Plugin CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "AdobeColorCommonSetCMYK", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "AdobeColorCommonSetRGB", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "AdobeColorEU CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "AdobeColorJA CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "AdobeColorNA CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "AdobeJRE", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "CoreTech", "AdobeTypeSupport CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Creative Suites", "Adobe XMP Panels CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Creative Suite", "Adobe CSXS Extensions CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Creative Suite", "Adobe CSXS Infrastructure CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "DVA", "CSXS Story Extension", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "DVA", "DynamiclinkSupport", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Dreamweaver", "Adobe BrowserLab CS Live", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "InDesign", "Adobe InDesign CS5 Icon Handler", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "InDesign", "Adobe InDesign CS5 Icon Handler x64", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "LearningResources", "HIL Help Search", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "NonAdobePayload", "AdobeHelp", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "NonAdobePayload", "PDF Settings CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "SING", "Adobe SING CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Shared Technology", "Adobe Buzzword CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Shared Technology", "Adobe ReviewPanel CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Shared Technology", "Adobe Toolhints CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Shared Technology", "Camera Profiles Installer", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Shared Technology", "Photoshop Camera Raw", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Standard", "Adobe Mini Bridge CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "required", "Type Group", "Required Common Fonts Installation", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "recommended", "Adobe Web Suite CS5", "Adobe Media Encoder CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "recommended", "Adobe Web Suite CS5", "Adobe Media Encoder CS5 X64", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "recommended", "Creative Suites", "Adobe Extension Manager CS5", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "recommended", "NonAdobePayload", "Adobe AIR", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "recommended", "NonAdobePayload", "Adobe Media Player", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "recommended", "Standard", "SiteCatalyst NetAverages", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "recommended", "Type Group", "Recommended Common Fonts Installation", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "NonAdobePayload", "Microsoft_VC90_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "NonAdobePayload", "Microsoft_VC90_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "NonAdobePayload", "Microsoft_VC90_ATL_x86", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "NonAdobePayload", "Microsoft_VC80_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFCLOC_x86", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "", "critical", "NonAdobePayload", "Microsoft_VC80_ATL_x86", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{A01DDA19-6AB1-101A-A138-FDEB7210954A}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{FB1BAC90-E118-11DD-8DEC-7BA4BAF08B55}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{A775B761-FAA4-101F-B267-D0691E69FD6C}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{67C9D60A-F3F2-11DD-936E-B19031E153AC}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{094F3B68-1EF5-1034-85E4-B93E79A504FB}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{452DBACA-07B2-11DE-A83F-2F8831E153AC}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{ADF89D80-213E-101D-8981-B705D1979007}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{84C052EE-1B10-11DE-A6D6-A92CECC65F41}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{8AB17E50-2184-1031-AFC1-E00018445439}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{606D42E6-2EAA-11DE-B55C-6C980BA30D1E}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{F762ED78-6284-102E-81EB-FC8F17BB072A}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{46B7B00E-4B27-11DE-ADB5-8AC48B860CCA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{23CF51DF-1475-1044-ACFB-843AC974245F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{B56AE62C-6069-11DE-9F14-532FA75AED42}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{BD72634D-F928-101F-8814-8FD152612619}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{5B9CE7C2-6DA1-11DE-B132-1D20BA3F162F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{9FF2BC9A-84A3-102E-8838-CD638E1A12BF}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{B746B2B8-7BE0-11DE-9BE8-4116BA3F162F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{466F0B17-2461-1020-9DD1-EC8702318F1F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{85EC172A-8D43-11DE-8FC5-D11DBB3F162F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{98AE04D8-2521-1016-9546-C155A7A1A005}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{110F68B0-984E-11DE-82E6-7E6ABA3F162F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{BCA202A9-6C83-101D-B59C-F524B490A02C}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{5E7436EE-A80C-11DE-BB87-4B1EBB3F162F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{340AB26D-BF1F-1018-AB78-F528C5E40977}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{B80BCDD2-B218-11DE-B4CB-BCD3A4156513}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{7B9DAB56-AA8F-1017-B037-B02F67D713D0}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{0F38D8EA-C428-11DE-9333-4946C3786012}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{43E29F4A-DB97-1022-9ED5-BD4F4177A557}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{A59B13EE-CF26-11DE-830F-694BC4786012}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{9358CD17-3108-101D-B5DA-E73E2B953CCC}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{C97ECB16-D97B-11DE-8F4E-B43CCED2C4BA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{678EACF9-AEB7-1017-8A81-9CE0D6A8B2DF}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{D4B0EA5C-E8F6-11DE-9026-F123CB6EEA44}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{91FE2F62-90A2-1030-8FE9-EA7790396490}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{199A671E-015D-11DF-96D2-24A9FC74F1C8}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{B22FE1E3-5FDD-1016-9B00-DFE770795567}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{E7183990-128E-11DF-98BF-54C5D051210B}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{6660B719-5E4F-101A-AEED-A9E3CD56A74C}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "{753932D6-20D8-11DF-A4DD-17A4D051210B}", "conflict", "", "", "")
INSERT INTO EULA_Files VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "ar_AE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 80926 characters]
wqA8L3A+PGJyPg0KPC9ib2R5Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "cs_CZ", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 92322 characters]
Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "da_DK", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 87394 characters]
b2R5Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "de_DE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 94632 characters]
b21iaW5lZC1kZV9ERS0yMDA5MTAwMV8xNjA0wqA8L3A+PGJyPg0KPC9ib2R5Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{F9766AC1-1461-1033-B862-DF8FE1C033BE}", "el_GR", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 88164 characters]
