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	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "CoreTech", "AdobeCMaps CS5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "CoreTech", "AdobePDFL CS5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "Creative Suites", "Suite Shared Configuration CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "InDesign", "Adobe InDesign CS5.5 Application Base Files2", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "InDesign", "Adobe InDesign CS5.5 Application Feature Set Files", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "InDesign", "Adobe InDesign CS5.5 Common Base Files", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Bridge", "AdobeOutputModule", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "Adobe Bridge CS5.1", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "Adobe ExtendScript Toolkit CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "Adobe Hunspell Linguistics Plugin CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "Adobe Linguistics CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "Adobe Player for Embedding 3.1", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "Adobe SwitchBoard 2.0", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "Adobe WinSoft Linguistics Plugin CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "AdobeColorCommonSetCMYK", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "AdobeColorCommonSetRGB", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "AdobeColorEU CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "AdobeColorJA CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "AdobeColorNA CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "AdobeJRE", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "CoreTech", "AdobeTypeSupport CS5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Creative Suites", "Adobe Extension Manager CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Creative Suites", "Adobe XMP Panels CS5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Creative Suite", "Adobe CSXS Extensions CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Creative Suite", "Adobe CSXS Infrastructure CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "DVA", "CSXS Story Extension", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "DVA", "DynamiclinkSupport", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "DigitalPublishing", "Digital Publishing", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "InDesign", "Adobe InDesign CS5.5 Icon Handler", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "InDesign", "Adobe InDesign CS5.5 Icon Handler x64", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "LearningResources", "HIL Help Search", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "NonAdobePayload", "Adobe Content Viewer", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "NonAdobePayload", "AdobeHelp", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "NonAdobePayload", "PDF Settings CS5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "SING", "Adobe SING CS5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Shared Technology", "Adobe Buzzword CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Shared Technology", "Adobe ReviewPanel CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Shared Technology", "Adobe Toolhints CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Shared Technology", "Camera Profiles Installer", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Shared Technology", "Photoshop Camera Raw", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Standard", "Adobe Mini Bridge CS5.1", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "required", "Type Group", "Required Common Fonts Installation", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "recommended", "Adobe Web Suite CS5.5", "Adobe Media Encoder CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "recommended", "Adobe Web Suite CS5.5", "Adobe Media Encoder CS5.5 X64", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "recommended", "Standard", "SiteCatalyst NetAverages CS5.5", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "recommended", "Type Group", "Recommended Common Fonts Installation", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "NonAdobePayload", "Microsoft_VC90_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "NonAdobePayload", "Microsoft_VC90_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "NonAdobePayload", "Microsoft_VC90_ATL_x86", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "NonAdobePayload", "Microsoft_VC80_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFCLOC_x86", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "NonAdobePayload", "Microsoft_VC80_ATL_x86", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "", "critical", "NonAdobePayload", "Microsoft_VC90_MFCLOC_x86", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{6C7EE820-E229-1047-BBA4-FDBA4C834062}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{4A1D672A-DE6F-11DF-BF6E-58C3D5079633}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{5C898ADB-845C-1056-8CF6-A0FA570B4134}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{00B421EA-ECC1-11DF-A044-FF02F1882ED2}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{A8029783-FB93-1068-9040-A5C4DA3A0507}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{13DBFC50-FECA-11DF-8290-F381F8375BAC}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{F0D66C49-10B4-1032-A2FB-F6FE0E68971E}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{9B6A5F48-3198-1032-A0CB-B27E54A71532}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{51339BE9-524F-1032-A721-9D200AE13877}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{83C8962E-1E08-11E0-80EC-A7ABB8239FA9}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{3FA2DB3D-C844-1019-94B2-DE69D83FD1DD}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "{BEAA444C-35BC-11E0-B8CB-1DE2B4614E9D}", "conflict", "", "", "")
INSERT INTO EULA_Files VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "ar_AE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 91398 characters]
Ym9keT4NCjwvaHRtbD4NCg==')
INSERT INTO EULA_Files VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "cs_CZ", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 104873 characters]
CjwvaHRtbD4NCg==')
INSERT INTO EULA_Files VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "da_DK", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 98328 characters]
PC9ib2R5Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{857CC5F0-040E-1016-A173-D55ADD80C260}", "de_DE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 106182 characters]
wqA8L3A+PGJyPg0KPC9ib2R5Pg0KPC9odG1sPg0K')
