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	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "recommended", "DVA", "AmericanEnglishSpeechAnalysisModels", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "critical", "Creative Suites", "Suite Shared Configuration CS5", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "required", "Creative Suites", "Adobe XMP Panels CS5", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "required", "DVA", "Adobe Soundbooth CS5 Codecs Wrapper", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "required", "DVA", "Adobe Soundbooth CS5 Royalty Codecs Wrapper", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "critical", "NonAdobePayload", "Microsoft_VC80_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "critical", "NonAdobePayload", "Microsoft_VC80_MFCLOC_x86", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "critical", "NonAdobePayload", "Microsoft_VC90_ATL_x86", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "critical", "NonAdobePayload", "Microsoft_VC90_CRT_x86", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "", "critical", "NonAdobePayload", "Microsoft_VC90_MFC_x86", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{A389E53F-8C10-450E-B344-17FFA99153A0}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{767582B5-FE06-46F7-8DFD-86434327D852}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{0D3C083B-2530-459F-A873-CCE4AA3BE041}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{96A3669E-9B1D-4116-BF2C-8447E6638B13}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{1DF7B195-C6A1-4CCD-91F1-49DBFEC93C71}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{D4417E9D-EFA9-4CC7-8AC9-F8A28E01A15A}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{7A33AA73-F9D7-4F7E-A1D2-0EF69BCCB2A9}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{54CEC269-2A10-4D5C-BD74-D3D54C49EC2D}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{1D2F7E79-558B-4D4A-8B35-E920C73AFAF5}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{956C1601-F86F-454A-A0B5-52125834F2A7}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{ACE1EB6B-A1DF-4529-B2A1-578CCF54EB76}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{08BE08DE-C733-4CB7-840E-C4B827DF4087}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{01320C4B-51E2-468D-9BE5-DC9852652863}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{C2E19447-C8F6-4A16-8C8A-14C82C4F8838}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{CAA316EE-8067-4810-95DF-83ED76C0CE9B}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{9D2115B5-2C46-4159-980C-19BA7E8598BE}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{5EF1DD23-E0E3-4B84-BAAF-A9F958C0E812}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{C90D39BE-F1C8-4EC8-A820-1EB9B840D1DA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{99656000-069E-4638-98C5-D6E616F3434B}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{37B65506-7431-4FFA-AD55-E5B182C844BA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{3A4CE02F-39A3-4031-9742-4C115FF296AA}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{2FCC738C-68DD-48D6-9D16-AEACC493C0B5}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{6EE45B6E-7446-44E1-9E81-E5B93C4D3E26}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{E29D3ADB-458F-4C92-8C14-E2E84CE4D841}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{3531F148-4A3D-4874-9129-F913DE5E2E34}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{EF5B5004-E4FA-490B-9E07-4F53261C6F11}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{BED18C11-218A-4DFC-A642-A8D4CB9FC9FF}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{7D2B7E53-050C-4B62-9E10-95C4F112E2F3}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{9D8E8FB5-6A0D-4283-85A5-C24BA7FD1750}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{9455AC03-E5F7-4746-B1C9-68CF42063899}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{43E20347-C1E7-4727-AF60-064DC50021F9}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{DFA0B165-03FA-4347-926B-251E430F5EEC}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{DF69D195-868F-4E20-B633-450BB1008609}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{EC04C081-BB4E-414D-91CE-54184B3DAD58}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{A32B7637-D96F-4146-914E-8256E0841512}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{437F4E8C-D81D-4212-8EA0-2F4FE84EDC3D}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{213A7E3F-03D6-4611-B6AB-1E6DD8DE82C0}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{09087A32-F68E-4DE6-AF47-0E29231F400C}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{F0538465-D2CB-40A0-9E17-2AFE716FEEC3}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{1D325839-C615-48C7-89C8-1D838AE14D3C}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{B1241CA7-9991-4A80-8531-D11065B1C3A6}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{05FEB8B4-E691-4BE5-925D-5A0CDE386D64}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{1D1DA89C-C8F2-48E7-946C-53A07A26913B}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{1871EB3E-D95C-4829-99AA-D78624F682C8}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{0E476C2D-E543-43D6-91F7-0F5EB0CC4D8F}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{EBEB18FF-54ED-4A4C-85D9-3B637897191D}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{5606D2FD-D23E-4A4E-8286-58B9AC1E0E9B}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{23A7B6F8-FA89-4909-A38D-FC27FF23F03B}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{F0435B33-E360-4078-A69D-AD1049B49AA9}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{E190C88A-0124-48AD-92EA-5C74DF0447EB}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{3BA277F6-79D9-40D7-90F9-556AF6C72442}", "conflict", "", "", "")
INSERT INTO DependencyData VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "{3999EB2F-0B8B-487E-92AB-0161FC90E022}", "conflict", "", "", "")
INSERT INTO EULA_Files VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "ar_AE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 80926 characters]
wqA8L3A+PGJyPg0KPC9ib2R5Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "cs_CZ", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 92322 characters]
Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "da_DK", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 87394 characters]
b2R5Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "de_DE", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 94632 characters]
b21iaW5lZC1kZV9ERS0yMDA5MTAwMV8xNjA0wqA8L3A+PGJyPg0KPC9ib2R5Pg0KPC9odG1sPg0K')
INSERT INTO EULA_Files VALUES	("{CBE4F6C3-788E-4CAC-BA25-26FE39A3BC8C}", "el_GR", '77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4NCjwhRE9DVFlQRSBodG1s
[encoded data, 92245 characters]
