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 ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{BE11303C-8BA1-46C8-8DA8-6FA5112DFC77}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{24CEAB4D-BD9B-4F98-8932-C4188B66225A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{7D7EB975-B6BE-40C8-B737-D0ECE5F89A77}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{B6EB6E58-F55D-496E-801C-1343FD2CD1B4}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{E60E3CB6-0A28-48E4-889C-EC06C1A0C4E7}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{21832968-8A6C-487C-AA27-2C1705066769}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{747A4943-442F-4D33-823F-9E802B719C04}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{CEC34B26-E60D-459E-8776-A8B370D6ADE0}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{11DE27CB-7887-4CF1-84E1-305AA45660CF}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{35AFE064-1C9A-4702-BDA0-2048FACF8D1A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{F33938E7-42F3-4B65-A704-3B999A672453}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{A6FD032A-9C69-40BB-BC2B-CB835E6638A4}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{DC71CBF8-9082-4DC4-9A05-6308CF7D3881}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{F5B802FB-CFB1-4AB7-8219-33979DA03A18}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{B0572E93-9011-4692-81F0-603B738E0BF0}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{3C52FA40-D50E-4D50-B4BA-A937BAFF67AD}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{06BEA43F-0355-4CC8-BDF2-4CF6B1CA58E4}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{1838ED42-127C-45A8-94F8-31BA601E5056}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{14B7E804-3412-49FB-9003-75495F19BB40}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{A81E769D-2DFF-497B-AC90-F31B5D14187C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{46518EB4-2924-45CC-976B-E4A3A08CDAC1}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{8BAD078D-97C4-4728-9D0D-0699D4AEE8E8}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{FA89F47F-E25E-4411-9B8C-F9F2B5EA54F7}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{06F0F982-C313-4795-AF76-DDEDFF6A9A56}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{DAA97A16-BFAF-4584-8C2F-1C0E300EF789}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{A7DECA8F-7E86-4338-B7DF-BE289B72AE1E}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{2EBC1387-C73A-48BE-857D-5B4C64A56B0A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{D4C7EAEF-F1EF-48FB-B680-57935D8F8B7B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{F20887DA-7457-4111-9E77-1D7A4AE99A0F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{675992C3-82A7-4F64-8DB3-0F43084858CA}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{25412A16-F965-47D9-9A2C-18583285164A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{89608D52-76F9-4966-BC60-E66589F8FB19}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{607C1FB9-67AB-4C90-BD6E-1F974458C8EB}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{1E9EEA7F-7D6D-4A63-85B0-E2A7CFA27028}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{63B48F6C-7270-4903-B12B-D3B65436C953}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{9759C56D-12E4-4A80-A577-1BD35812369F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{1D023D07-8580-41CA-9296-49BBA3098222}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "{F4B46AAE-BAD3-4AD0-A832-514A14D48C18}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "", "langPack", "Illustrator", "Adobe Illustrator CS5.1", "15.1") INSERT INTO Payloads VALUES ("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "Illustrator", "Adobe Illustrator CS5.1_AdobeIllustrator15_1de_DELanguagePack", "15.1", "langPack") INSERT INTO PayloadData VALUES("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "0" , "PayloadInfo", ' 2011-03-09 21:22:42.679000 AdobeIllustrator15_1de_DELanguagePack All SQLite {A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B} Adobe Illustrator CS5.1 LangPack (de_DE) 15.1 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] de_DE Illustrator Adobe Illustrator CS5.1_AdobeIllustrator15_1de_DELanguagePack 15.1 {BE11303C-8BA1-46C8-8DA8-6FA5112DFC77} {24CEAB4D-BD9B-4F98-8932-C4188B66225A} {7D7EB975-B6BE-40C8-B737-D0ECE5F89A77} {B6EB6E58-F55D-496E-801C-1343FD2CD1B4} {E60E3CB6-0A28-48E4-889C-EC06C1A0C4E7} {21832968-8A6C-487C-AA27-2C1705066769} {747A4943-442F-4D33-823F-9E802B719C04} {CEC34B26-E60D-459E-8776-A8B370D6ADE0} {11DE27CB-7887-4CF1-84E1-305AA45660CF} {35AFE064-1C9A-4702-BDA0-2048FACF8D1A} {F33938E7-42F3-4B65-A704-3B999A672453} {A6FD032A-9C69-40BB-BC2B-CB835E6638A4} {DC71CBF8-9082-4DC4-9A05-6308CF7D3881} {F5B802FB-CFB1-4AB7-8219-33979DA03A18} {B0572E93-9011-4692-81F0-603B738E0BF0} {3C52FA40-D50E-4D50-B4BA-A937BAFF67AD} {06BEA43F-0355-4CC8-BDF2-4CF6B1CA58E4} {1838ED42-127C-45A8-94F8-31BA601E5056} {14B7E804-3412-49FB-9003-75495F19BB40} {A81E769D-2DFF-497B-AC90-F31B5D14187C} {46518EB4-2924-45CC-976B-E4A3A08CDAC1} {8BAD078D-97C4-4728-9D0D-0699D4AEE8E8} {FA89F47F-E25E-4411-9B8C-F9F2B5EA54F7} {06F0F982-C313-4795-AF76-DDEDFF6A9A56} {DAA97A16-BFAF-4584-8C2F-1C0E300EF789} {A7DECA8F-7E86-4338-B7DF-BE289B72AE1E} {2EBC1387-C73A-48BE-857D-5B4C64A56B0A} {D4C7EAEF-F1EF-48FB-B680-57935D8F8B7B} {F20887DA-7457-4111-9E77-1D7A4AE99A0F} {675992C3-82A7-4F64-8DB3-0F43084858CA} {25412A16-F965-47D9-9A2C-18583285164A} {89608D52-76F9-4966-BC60-E66589F8FB19} {607C1FB9-67AB-4C90-BD6E-1F974458C8EB} {1E9EEA7F-7D6D-4A63-85B0-E2A7CFA27028} {63B48F6C-7270-4903-B12B-D3B65436C953} {9759C56D-12E4-4A80-A577-1BD35812369F} {1D023D07-8580-41CA-9296-49BBA3098222} {F4B46AAE-BAD3-4AD0-A832-514A14D48C18} Adobe Illustrator CS5.1 LangPack (de_DE) Illustrator Adobe Illustrator CS5.1 [INSTALLDIR] 414003345 /Adobe Illustrator CS5.1/Cool Extras/de_DE/Beispieldateien/Beispielgrafiken/Wie haben sie das nur gemacht!\Anleitung Muskelschwäche an der motorischen Endplatte.pdf [AdobeCommon] 33769668 /Help/de_DE/Illustrator/CS5/Using\illustrator_cs5.1_help.pdf 15.1 Adobe Illustrator CS5.1 LangPack (de_DE) 0') INSERT INTO PayloadData VALUES("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "0", "ChannelID", "AdobeIllustratorCS5.1LangPackde_DE-15.1") INSERT INTO PayloadData VALUES("{A61224A3-4AF9-43FA-AF07-7DD0E7C6C79B}", "0", "ChannelInfo", ' Adobe Illustrator CS5.1 LangPack (de_DE) ')