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	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "Photoshop", "Adobe Photoshop CS5.1 Support", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "Adobe Bridge CS5.1", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "Shared Technology", "Camera Profiles Installer", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeColorCommonSetCMYK", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeColorCommonSetRGB", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeColorEU CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeColorJA CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeColorNA CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeColorPhotoshop CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "Creative Suite", "Adobe CSXS Extensions CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "Creative Suite", "Adobe CSXS Infrastructure CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "recommended", "MaD", "Adobe Device Central CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "recommended", "CoreTech", "Adobe ExtendScript Toolkit CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "recommended", "Creative Suites", "Adobe Extension Manager CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "NonAdobePayload", "AdobeHelp", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeJRE", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "Standard", "Adobe Mini Bridge CS5.1", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "Bridge", "AdobeOutputModule", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "NonAdobePayload", "PDF Settings CS5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "Shared Technology", "Adobe ReviewPanel CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "Creative Suites", "Suite Shared Configuration CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeColorVideoProfilesCS CS5.5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "Creative Suites", "Adobe XMP Panels CS5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "Adobe SwitchBoard 2.0", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "Adobe Player for Embedding 3.1", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "Shared Technology", "Photoshop Camera Raw", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeCMaps CS5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "recommended", "Type Group", "Recommended Common Fonts Installation", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "Type Group", "Required Common Fonts Installation", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "Adobe Linguistics CS5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobePDFL CS5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "AdobeTypeSupport CS5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "required", "CoreTech", "Adobe WinSoft Linguistics Plugin CS5", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "NonAdobePayload", "Microsoft_VC80_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFCLOC_x86", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "NonAdobePayload", "Microsoft_VC80_ATL_x86", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "NonAdobePayload", "Microsoft_VC90_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "NonAdobePayload", "Microsoft_VC90_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "NonAdobePayload", "Microsoft_VC90_MFCLOC_x86", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "", "critical", "NonAdobePayload", "Microsoft_VC90_ATL_x86", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{FAA86C33-EAF5-41E5-8C04-04C8C95560D1}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{11040716-0DCD-4FA1-9917-7AC1D4F490B3}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{10565918-5F32-47A4-986D-4288E30DB158}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{31907212-04BB-4807-8BED-F5778158083C}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{776F5054-AEDC-4055-0409-187EE1A40FEC}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{528975C1-3F6C-11DB-A6BD-00111104045F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{93DF00C3-0EAD-47FD-B00E-C19D89FEDEA1}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{1D4A668C-A109-4BB0-8191-20E19BB4044B}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{03405957-6289-490D-8C95-BC9EC8C5B4CD}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{54667308-7C48-4C40-AB92-5DBB23FAC511}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{7A00F070-796A-4FD3-B983-2AAED240B6CA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{3D936503-9827-40F1-9FB9-228CC7AD8622}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{53B273ED-EECA-4445-94A2-ABA3B0A21613}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{9A1ECC99-B9F4-4A88-A4A1-3ACB400866D1}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{B2D760AB-8C10-4A9A-A0D8-4BEBCFEF8A29}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{097F61D9-E4FD-4650-B622-D88D2638C5AE}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{5D73DC4D-8CC6-4C0D-ACCE-1BEB1889DA3A}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{A91FCE43-638A-4633-9709-04FB61EE3CC0}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{9D14751E-0AB5-4808-8A5C-CBC90494E10C}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{E9B236C5-BCC2-4772-A5D8-E99BFCEC788F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{24368567-4177-41B8-895A-F08A4F8ABA4E}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{AE2AC2A7-B832-4409-8160-5DB2A65F75EA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{18298618-A354-479F-B46F-F050B93BFB02}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{6717A730-C004-475B-828F-EC3FF0434064}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{1F651C0D-6CD7-49CA-B274-5B2956A67FE2}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{55987F89-BA8B-4353-88C6-BCF6896391CA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{6AF9C63D-B2A9-47AB-9ACC-8D23942DEDB0}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{92801E90-F49D-462B-8364-B45E21E1B6AC}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{178CE88D-A0E0-4080-86EB-7F78E435D1E4}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{15C08326-3A8E-46EB-8936-BAAE777EEFAF}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{555437C1-1041-406B-ACAD-A3FEEDDF87AB}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{380C33B7-3AEB-46F9-BCE7-9EF9309B812E}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{A65C2A8A-3D01-4920-8875-29DC4A3521EF}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{8975953C-CE96-47B4-9DCD-31EAD3D2F902}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{5D74FFE6-8135-4675-951B-C45FC9FAF2CA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{37E1371D-F7CB-4F96-87A0-254DC532E612}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{1B3B6B7F-0F4E-4233-BBDC-90A31956CCBF}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{3243DD0F-5942-4DA0-9E73-2D6282B68185}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{CA51221E-4915-49F8-9A39-44C3E401787F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{D9573E02-2D98-48A7-9ACD-49C42616ACBD}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{FDC4E5C3-B2BE-4591-A6F6-9105E7D27E5A}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "{3533962A-FA75-442A-9A64-6040BDE6B072}", "conflict", "", "", "")
INSERT INTO EULA_Files VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "ar_AE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 91398 characters]
Ym9keT4NCjwvaHRtbD4NCg==')
INSERT INTO EULA_Files VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "cs_CZ", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 104873 characters]
CjwvaHRtbD4NCg==')
INSERT INTO EULA_Files VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "da_DK", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 98328 characters]
PC9ib2R5Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{08EF22BC-43B2-4B4E-BA12-52B18F418F38}", "de_DE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 106182 characters]
wqA8L3A+PGJyPg0KPC9ib2R5Pg0KPC9odG1sPg0K')
