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) )
CREATE TABLE EULA_Ref( productID TEXT NOT NULL, langCode TEXT NOT NULL, eula_hash TEXT NOT NULL, PRIMARY KEY (productID, langCode) )
CREATE TABLE EULA_Content(eula_hash TEXT NOT NULL, Content TEXT NOT NULL, PRIMARY KEY (eula_hash))
CREATE TABLE IF NOT EXISTS pcd_meta ( key TEXT NOT NULL, value TEXT NOT NULL, PRIMARY KEY (key) )
INSERT OR REPLACE INTO pcd_meta (key, value) VALUES ('schema_version', 2)
INSERT OR REPLACE INTO pcd_meta (key, value) VALUES ('schema_compatibility_version', 1)
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "critical", "CoreTech", "AdobeCMaps CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "critical", "CoreTech", "AdobePDFL CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "critical", "Creative Suites", "Suite Shared Configuration CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "critical", "InDesign", "Adobe InDesign CS6 Application Base Files2", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "critical", "InDesign", "Adobe InDesign CS6 Application Feature Set Files", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "critical", "InDesign", "Adobe InDesign CS6 Common Base Files", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "Adobe Bridge CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "Adobe ExtendScript Toolkit CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "Adobe Hunspell Linguistics Plugin CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "Adobe Linguistics CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "Adobe Player for Embedding 3.3", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "Adobe SwitchBoard 2.0", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "Adobe WinSoft Linguistics Plugin CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "AdobeColorCommonSetCMYK CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "AdobeColorCommonSetRGB CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "AdobeColorEU CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "AdobeColorJA CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "AdobeColorNA CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "CoreTech", "AdobeTypeSupport CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Creative Suites", "Adobe Extension Manager CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Creative Suites", "Adobe XMP Panels", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Creative Suite", "Adobe CSXS Extensions CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Creative Suite", "Adobe CSXS Infrastructure CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "DVA", "DynamiclinkSupport", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "DigitalPublishing", "DPS Desktop Tools CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "InDesign", "Adobe InDesign CS6 Icon Handler", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "InDesign", "Adobe InDesign CS6 Icon Handler x64", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "NonAdobePayload", "AdobeHelp", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "NonAdobePayload", "PDF Settings CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Shared Technology", "Adobe Toolhints CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Shared Technology", "Camera Profiles Installer", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Shared Technology", "Photoshop Camera Raw 7", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Standard", "Adobe Mini Bridge CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Standard", "Adobe NPS Panel", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "Type Group", "Required Common Fonts Installation", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "recommended", "Adobe Web Suite CS6", "Adobe Media Encoder CS6", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "recommended", "Adobe Web Suite CS6", "Adobe Media Encoder CS6 X64", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "recommended", "Type Group", "Recommended Common Fonts Installation", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "NonAdobePayload", "Microsoft Visual C++ 2010 Redistributable Package (x86)", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "", "required", "NonAdobePayload", "Microsoft Visual C++ 2008 Redistributable Package (x86)", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{54F40D3F-C2AA-1014-8BED-B4014E5F874F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{01A1258A-9D88-11E0-9805-E1444C4EB026}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{3810788D-6C50-1014-BF50-E6341980B3BB}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{65A5E1D8-B142-11E0-8B22-BF0C90B9EC6F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{9F52AC1B-7CC5-1014-B4BE-B59D1D23B4A4}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{AB221E32-BC48-11E0-AEE9-2803E154E924}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{2CE79A37-6FA1-1014-BA6F-AEB15CBAA973}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{D0FE4FDE-C7E4-11E0-9C7F-4490BF44B43D}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{E928CFFC-C4DE-11E0-BDE3-D7E606E8D904}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{DAF838CB-9365-1014-AEF7-9372C05F9BF8}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{2B15743E-DDF7-11E0-BAAB-2C5E62A679F3}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{27FAE5C4-A244-1014-A68E-8D6E5123D418}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{3DD29B2A-E855-11E0-A0B1-B67211F3A921}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{4D6FB9EE-B42A-1014-A1E1-E5E84AC403C1}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{141606F0-F4CB-11E0-9BAE-48CAE0F34217}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{25C08588-6C0D-1014-991B-BB3021897197}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{78ED3EE8-063E-11E1-95CB-0953FE0BC45E}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{DCAA01BF-7854-1014-B801-EDF7B3ADBD4D}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{17614C38-0EEE-11E1-9A9E-4A05BC81AED1}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{301F3A54-8945-1014-85CD-87F49D0EFB5E}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{A3E346D2-1A94-11E1-8E37-2DBB8FB3A183}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{3BBD577B-97D9-1014-92CF-C71055D71453}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{A3893F10-24C2-11E1-98DF-843590B3A183}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{03AD247F-7451-1014-8DAE-C31913284FC5}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{17358F0A-3AC0-11E1-B7A3-570C983BF542}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{2B54B063-840F-1014-8430-D9B03F7E1088}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{6067E220-45BC-11E1-973A-540931E5E855}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{CF9A0D54-6C3E-1014-8447-DAB575C2E3DA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{5AA99A2A-5199-11E1-851B-1E6892DDCEE4}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{A86AE3F3-7C4F-1014-93C5-F21311538C31}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "{0E6C028A-6D21-11E1-906D-C9E6E697649C}", "conflict", "", "", "")
INSERT OR REPLACE INTO EULA_Content VALUES("a3ae2c603e732cf3ac293be088bf6529", "77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiID8+DQo8IURPQ1RZUEUgaHRt
[encoded data, 121890 characters]
PC9wPg0KICAgIDxicj4NCjwvYm9keT4NCjwvaHRtbD4NCg==")
INSERT OR REPLACE INTO EULA_Ref VALUES("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "cs_CZ", "a3ae2c603e732cf3ac293be088bf6529")
INSERT OR REPLACE INTO EULA_Content VALUES("70831d236215ff465786ae5e322222b1", "77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiID8+DQo8IURPQ1RZUEUgaHRt
[encoded data, 116885 characters]
L3A+DQogICAgPGJyPg0KPC9ib2R5Pg0KPC9odG1sPg0K")
INSERT OR REPLACE INTO EULA_Ref VALUES("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "da_DK", "70831d236215ff465786ae5e322222b1")
INSERT OR REPLACE INTO EULA_Content VALUES("d9c230b2399466de8e152b906075ef6c", "77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiID8+DQo8IURPQ1RZUEUgaHRt
[encoded data, 128050 characters]
L2JvZHk+DQo8L2h0bWw+DQo=")
INSERT OR REPLACE INTO EULA_Ref VALUES("{CFB770D7-8D43-1014-922B-CC2715FADE3F}", "de_DE", "d9c230b2399466de8e152b906075ef6c")
INSERT OR REPLACE INTO EULA_Content VALUES("f28b6956466c8ca2bb6ec03df767edda", "77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiID8+DQo8IURPQ1RZUEUgaHRt
[encoded data, 78924 characters]
