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 ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{58693A8B-956A-4C5E-8B60-76B8442CD99D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{9810D229-64E5-4D47-8185-EA2B64011440}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{AAE15501-2C7B-4549-9556-F0AC1099A1FF}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{C979466C-B0F3-489B-8371-862A1CF148C1}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{00260028-401A-40E8-BFAA-E6AB716CB4EA}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{6F27AED8-CD6D-44F4-B6A9-ADCEF47BD39F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{743B6BEF-593F-49A8-8D13-39EAA3F14B8D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{C72CD92F-D638-4E60-ABA1-4BAA6EF410B7}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{539E090E-BCF1-40CD-A3DF-3857B173CF68}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{2380C1A0-3446-401F-9802-F56CDBA7AC08}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{24E8EE04-A013-41A6-9AE6-BBF3971CB8DF}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{378E588B-D6D0-4D7E-92B8-7F9802EA1C0D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{26291CD9-F9A3-424F-9D30-C76507DB4AFC}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{4F1A36AD-8EB0-49DF-A82D-9AC1026C4A38}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{1990EC32-98D7-4333-AA1C-38EB51373D11}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{3B31E650-46D2-40BA-8B3E-E257F94E2A89}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{86834648-CDC4-4456-A6FF-B2BCCD7B5652}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{CBDB870F-CD7C-4F9C-95A4-F5E777BE5FA1}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{756FE191-6EFF-4692-A99A-FC8D1D514139}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{2BE70BB5-E747-4FD6-871E-9FC36DE727FE}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{8F4E972D-2A83-4E2C-B35F-893AEBBB7E0E}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{4940988F-9581-4726-8041-73C88371FCF4}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{2DAA15E2-906B-4B61-9FC2-3BBE0E459F60}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{D458A4CA-9634-4F26-ABE8-4F5F67F4B93F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{2CB4424D-EF2B-4D8E-9432-0C24BCB0F9C6}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{3292B108-38C7-44CA-A797-35662919FF72}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{1DB5BCA1-838A-45C1-BE4F-802E1670259B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{05E5A7E4-024B-4B4D-BBCC-67D59A19F58C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{6674B619-4646-4F76-9FDE-AA66AD19EE99}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{31AC418E-1E93-47C6-B113-ACCF1D7227B0}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{E0CD88A9-3515-448F-9ED2-8977473AC6BB}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{7D46DE8A-8AB4-4A2D-AF4F-BCE8D66CCBB2}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{351428E7-1707-4C3A-86AE-B25EC989D617}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{D3B6870A-B431-43C8-B628-3756CBF6DB5E}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{3362873E-D513-49B6-A73C-1C0D72317B4B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{0D2BE1FE-F3D5-480A-BD79-E4184B956E61}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{8207E520-E1A6-4A1E-A297-2C9540080703}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{54CA5B68-05EA-4549-BF14-34D4C67605A5}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{1A5EEF19-ED6B-4CCB-A50B-A720D2C50329}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "{4FA919A6-A0F6-42B3-BB49-18D999690A5C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "", "langPack", "Illustrator", "Adobe Illustrator CS5.1", "15.1") INSERT INTO Payloads VALUES ("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "Illustrator", "Adobe Illustrator CS5.1_AdobeIllustrator15_1sv_SELanguagePack", "15.1", "langPack") INSERT INTO PayloadData VALUES("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "0" , "PayloadInfo", ' 2011-03-09 22:23:11.316000 AdobeIllustrator15_1sv_SELanguagePack All SQLite {1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2} Adobe Illustrator CS5.1 LangPack (sv_SE) 15.1 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] sv_SE Illustrator Adobe Illustrator CS5.1_AdobeIllustrator15_1sv_SELanguagePack 15.1 {58693A8B-956A-4C5E-8B60-76B8442CD99D} {9810D229-64E5-4D47-8185-EA2B64011440} {AAE15501-2C7B-4549-9556-F0AC1099A1FF} {C979466C-B0F3-489B-8371-862A1CF148C1} {00260028-401A-40E8-BFAA-E6AB716CB4EA} {6F27AED8-CD6D-44F4-B6A9-ADCEF47BD39F} {743B6BEF-593F-49A8-8D13-39EAA3F14B8D} {C72CD92F-D638-4E60-ABA1-4BAA6EF410B7} {539E090E-BCF1-40CD-A3DF-3857B173CF68} {2380C1A0-3446-401F-9802-F56CDBA7AC08} {24E8EE04-A013-41A6-9AE6-BBF3971CB8DF} {378E588B-D6D0-4D7E-92B8-7F9802EA1C0D} {26291CD9-F9A3-424F-9D30-C76507DB4AFC} {4F1A36AD-8EB0-49DF-A82D-9AC1026C4A38} {1990EC32-98D7-4333-AA1C-38EB51373D11} {3B31E650-46D2-40BA-8B3E-E257F94E2A89} {86834648-CDC4-4456-A6FF-B2BCCD7B5652} {CBDB870F-CD7C-4F9C-95A4-F5E777BE5FA1} {756FE191-6EFF-4692-A99A-FC8D1D514139} {2BE70BB5-E747-4FD6-871E-9FC36DE727FE} {8F4E972D-2A83-4E2C-B35F-893AEBBB7E0E} {4940988F-9581-4726-8041-73C88371FCF4} {2DAA15E2-906B-4B61-9FC2-3BBE0E459F60} {D458A4CA-9634-4F26-ABE8-4F5F67F4B93F} {2CB4424D-EF2B-4D8E-9432-0C24BCB0F9C6} {3292B108-38C7-44CA-A797-35662919FF72} {1DB5BCA1-838A-45C1-BE4F-802E1670259B} {05E5A7E4-024B-4B4D-BBCC-67D59A19F58C} {6674B619-4646-4F76-9FDE-AA66AD19EE99} {31AC418E-1E93-47C6-B113-ACCF1D7227B0} {E0CD88A9-3515-448F-9ED2-8977473AC6BB} {7D46DE8A-8AB4-4A2D-AF4F-BCE8D66CCBB2} {351428E7-1707-4C3A-86AE-B25EC989D617} {D3B6870A-B431-43C8-B628-3756CBF6DB5E} {3362873E-D513-49B6-A73C-1C0D72317B4B} {0D2BE1FE-F3D5-480A-BD79-E4184B956E61} {8207E520-E1A6-4A1E-A297-2C9540080703} {54CA5B68-05EA-4549-BF14-34D4C67605A5} {1A5EEF19-ED6B-4CCB-A50B-A720D2C50329} {4FA919A6-A0F6-42B3-BB49-18D999690A5C} Adobe Illustrator CS5.1 LangPack (sv_SE) Illustrator Adobe Illustrator CS5.1 [INSTALLDIR] 403232744 /Adobe Illustrator CS5.1/Cool Extras/sv_SE/Exempelfiler/Provbilder/Hur gjorde de det!\Myasthenia Gravis i neuromuskulär förbindelse – så här gör du.pdf [AdobeCommon] 33061539 /Help/sv_SE/Illustrator/CS5/Using\illustrator_cs5.1_help.pdf 15.1 Adobe Illustrator CS5.1 LangPack (sv_SE) 0') INSERT INTO PayloadData VALUES("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "0", "ChannelID", "AdobeIllustratorCS5.1LangPacksv_SE-15.1") INSERT INTO PayloadData VALUES("{1F4F42B3-730D-4B11-BDC4-316EEE3D6CE2}", "0", "ChannelInfo", ' Adobe Illustrator CS5.1 LangPack (sv_SE) ')