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	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "Adobe Player for Embedding 3.1", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "Adobe Player for Embedding x64 3.1", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "Adobe Bridge CS5.1", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Shared Technology", "Photoshop Camera Raw", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Shared Technology", "Photoshop Camera Raw (64 bit)", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Shared Technology", "Camera Profiles Installer", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeCMaps CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeCMaps x64 CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeColorCommonSetCMYK", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeColorCommonSetRGB", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeColorEU CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeColorJA CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeColorNA CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Creative Suite", "Adobe CSXS Extensions CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Creative Suite", "Adobe CSXS Infrastructure CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "recommended", "MaD", "Adobe Device Central CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "DVA", "DynamiclinkSupport", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "Adobe ExtendScript Toolkit CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "recommended", "Creative Suites", "Adobe Extension Manager CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "NonAdobePayload", "Adobe Flash Player 10 ActiveX", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "NonAdobePayload", "Adobe Flash Player 10 Plugin", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "NonAdobePayload", "AdobeHelp", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeJRE", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "Adobe Linguistics CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "Adobe Linguistics CS5 x64", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Bridge", "AdobeOutputModule", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobePDFL CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobePDFL x64 CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "NonAdobePayload", "PDF Settings CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Shared Technology", "Adobe ReviewPanel CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Creative Suites", "Suite Shared Configuration CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeTypeSupport CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "AdobeTypeSupport x64 CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "Adobe WinSoft Linguistics Plugin CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "Adobe WinSoft Linguistics Plugin CS5 x64", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Creative Suites", "Adobe XMP Panels CS5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "critical", "CoreTech", "Pixel Bender Toolkit", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "recommended", "Adobe Web Suite CS5.5", "Adobe Media Encoder CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "recommended", "Adobe Web Suite CS5.5", "Adobe Media Encoder CS5.5 X64", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "Standard", "SiteCatalyst NetAverages CS5.5", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "required", "CoreTech", "Adobe SwitchBoard 2.0", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "critical", "NonAdobePayload", "Microsoft_VC80_ATL_x86", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "critical", "NonAdobePayload", "Microsoft_VC80_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFCLOC_x86", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "critical", "NonAdobePayload", "Microsoft_VC90_ATL_x86", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "critical", "NonAdobePayload", "Microsoft_VC90_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "critical", "NonAdobePayload", "Microsoft_VC90_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "", "critical", "NonAdobePayload", "Microsoft_VC90_MFCLOC_x86", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{A3627E4D-EB48-499B-825B-FB9EB4A21D79}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{5FD75A98-DC7B-46C0-BFDB-2A2A49A7CF64}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{6CBBFF6B-126C-4066-A4E8-B2E13DD2CA80}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{866EDC6C-B9F3-47CF-8A14-AE4892FF18B4}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{A296F314-ADE8-44E4-AB23-68175E70C2F8}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{D1265AF4-010B-4C16-877B-BBB0D634BF23}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{76F18C03-9A77-4195-ADBA-244781C3D215}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{8CD6E148-D7F8-48ED-A8CA-7CBDEE627470}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{629E25BA-DF27-4315-B0F9-85EEDE7DB01F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{46E87F16-0916-48DA-A499-E488E8C9ECBE}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{486D3949-6D29-479F-A417-9EF82948C0ED}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{B3B0A6BC-7A8C-451F-B39C-438D3E36E0ED}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{5DCA9D0F-2C0C-4953-8AF4-18CC27BDFE3F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{5AE6FDF5-B5CF-49E8-955E-EA875E5C7C20}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{9F9F130C-6E33-4EB8-8623-E73DC203EFD3}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{F4EF19BB-EECF-4C12-8F4B-9FED9D6AFA7B}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{9839E284-8C01-4C51-9CB4-E3DC0EF24A9C}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{5DC0FD97-FF25-4680-A41D-8F5A07D69526}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "{19324588-BB8F-4B0D-8A11-74E073964ABF}", "conflict", "", "", "")
INSERT INTO EULA_Files VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "ar_AE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 91398 characters]
Ym9keT4NCjwvaHRtbD4NCg==')
INSERT INTO EULA_Files VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "cs_CZ", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 104873 characters]
CjwvaHRtbD4NCg==')
INSERT INTO EULA_Files VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "da_DK", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 98328 characters]
PC9ib2R5Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{D97AF04B-B70A-4862-BC25-31E6D9C4A529}", "de_DE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 106182 characters]
wqA8L3A+PGJyPg0KPC9ib2R5Pg0KPC9odG1sPg0K')
