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 ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{F97B25C7-A118-4913-BF71-4CDB60D13B65}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{1672D8DC-1410-4E98-BB2E-EA362B66AB55}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{493F2FE7-8EC8-463B-A049-90444AA4096A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{910C54E3-3E69-419C-96C0-2982801C93C9}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{DEEA361E-23D3-4A6F-9637-62FDAEF3CA29}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{875B1DCA-FD39-4D00-9268-B6C556469094}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{36B515CB-B1EF-49F1-859D-C6163F65C67C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{E24302B4-32AC-4A04-BAA6-52AB98DAD964}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{D5CB54F3-F6E7-46CD-BAA0-0329716FFE57}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{C14EB57B-2039-49CB-91C6-FE228181BC1F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{419E9005-F924-4AC0-A0CB-D68743D195E1}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{76DDDCE5-94A8-42CC-A3CF-67F86192C6D1}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{A2785061-7B43-4E76-AF3C-5B72FCBCB154}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{210D0263-B096-45A0-8446-F9F85937F2EA}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{A03A0001-F3B1-45D8-98B9-15F18D932F10}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{470BF77E-2E5A-455A-8315-109818B9E568}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{86EF24C2-954D-4CE7-9E36-68F1B63A14EF}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{58EC2539-132D-4653-89AC-D3D7E8CDCA7E}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{D46EEB41-8EB7-4B2D-873E-FC14795EA6D7}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{B0657A22-0019-47B8-BE22-2D64263491B1}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{1A2AD0BC-1E73-4749-BF87-C602DADE5A80}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{35665166-1CBC-44BB-BDF7-D9702BF9AA24}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{93E09448-F099-4C6D-AC84-4FF37E50D574}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{499A24BA-E5CE-4F59-958A-DF1612AB619D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{AD236337-B7FC-4F94-8EE4-31EE0DD40478}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{B080A9FC-88C1-4077-8376-AD66D7D759C0}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{2FF430F3-434D-47F7-8809-602EEA14B365}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{41418C5F-1874-49BD-9309-622B6C8748A4}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{D2E1C716-46F4-4D80-8326-7EE58BE319E8}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{C9961689-B232-4F61-A428-8DB521D2539C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{F3E88571-A985-4F3E-8C83-DDDD04637375}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{33AC6160-0002-4831-9E11-A2E401EBA41F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{287BFA02-2A7F-4693-97F6-B6F4B5E865A4}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{1A956162-F71E-4A50-82D8-494395B89430}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{DD41D781-0212-4B88-A414-88D0B9959534}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{48C76318-B9E2-4CCC-B6C5-06C6258CFC82}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{400A3E1A-1994-4868-87F2-D291F64C45C0}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{46091062-9FBC-4A7E-867D-8E11452872B5}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "{CB8BBB50-CA7B-44E8-B5C5-8AC267D1516E}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "", "langPack", "Illustrator", "Adobe Illustrator CS5.1", "15.1") INSERT INTO Payloads VALUES ("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "Illustrator", "Adobe Illustrator CS5.1_AdobeIllustrator15_1nl_NLLanguagePack", "15.1", "langPack") INSERT INTO PayloadData VALUES("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "0" , "PayloadInfo", ' 2011-03-09 22:00:12.737000 AdobeIllustrator15_1nl_NLLanguagePack All SQLite {A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D} Adobe Illustrator CS5.1 LangPack (nl_NL) 15.1 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] nl_NL Illustrator Adobe Illustrator CS5.1_AdobeIllustrator15_1nl_NLLanguagePack 15.1 {F97B25C7-A118-4913-BF71-4CDB60D13B65} {1672D8DC-1410-4E98-BB2E-EA362B66AB55} {493F2FE7-8EC8-463B-A049-90444AA4096A} {910C54E3-3E69-419C-96C0-2982801C93C9} {DEEA361E-23D3-4A6F-9637-62FDAEF3CA29} {875B1DCA-FD39-4D00-9268-B6C556469094} {36B515CB-B1EF-49F1-859D-C6163F65C67C} {E24302B4-32AC-4A04-BAA6-52AB98DAD964} {D5CB54F3-F6E7-46CD-BAA0-0329716FFE57} {C14EB57B-2039-49CB-91C6-FE228181BC1F} {419E9005-F924-4AC0-A0CB-D68743D195E1} {76DDDCE5-94A8-42CC-A3CF-67F86192C6D1} {A2785061-7B43-4E76-AF3C-5B72FCBCB154} {210D0263-B096-45A0-8446-F9F85937F2EA} {A03A0001-F3B1-45D8-98B9-15F18D932F10} {470BF77E-2E5A-455A-8315-109818B9E568} {86EF24C2-954D-4CE7-9E36-68F1B63A14EF} {58EC2539-132D-4653-89AC-D3D7E8CDCA7E} {D46EEB41-8EB7-4B2D-873E-FC14795EA6D7} {B0657A22-0019-47B8-BE22-2D64263491B1} {1A2AD0BC-1E73-4749-BF87-C602DADE5A80} {35665166-1CBC-44BB-BDF7-D9702BF9AA24} {93E09448-F099-4C6D-AC84-4FF37E50D574} {499A24BA-E5CE-4F59-958A-DF1612AB619D} {AD236337-B7FC-4F94-8EE4-31EE0DD40478} {B080A9FC-88C1-4077-8376-AD66D7D759C0} {2FF430F3-434D-47F7-8809-602EEA14B365} {41418C5F-1874-49BD-9309-622B6C8748A4} {D2E1C716-46F4-4D80-8326-7EE58BE319E8} {C9961689-B232-4F61-A428-8DB521D2539C} {F3E88571-A985-4F3E-8C83-DDDD04637375} {33AC6160-0002-4831-9E11-A2E401EBA41F} {287BFA02-2A7F-4693-97F6-B6F4B5E865A4} {1A956162-F71E-4A50-82D8-494395B89430} {DD41D781-0212-4B88-A414-88D0B9959534} {48C76318-B9E2-4CCC-B6C5-06C6258CFC82} {400A3E1A-1994-4868-87F2-D291F64C45C0} {46091062-9FBC-4A7E-867D-8E11452872B5} {CB8BBB50-CA7B-44E8-B5C5-8AC267D1516E} Adobe Illustrator CS5.1 LangPack (nl_NL) Illustrator Adobe Illustrator CS5.1 [INSTALLDIR] 413200781 /Adobe Illustrator CS5.1/Cool Extras/nl_NL/Voorbeeldbestanden/Voorbeeldillustraties/Hoe hebben ze dat voor elkaar gekregen\De geheimen van Trouwe orde der regenwormen.pdf [AdobeCommon] 33631580 /Help/nl_NL/Illustrator/CS5/Using\illustrator_cs5.1_help.pdf 15.1 Adobe Illustrator CS5.1 LangPack (nl_NL) 0') INSERT INTO PayloadData VALUES("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "0", "ChannelID", "AdobeIllustratorCS5.1LangPacknl_NL-15.1") INSERT INTO PayloadData VALUES("{A0494939-57A5-4F0D-9B1D-9BCEBE2FAD9D}", "0", "ChannelInfo", ' Adobe Illustrator CS5.1 LangPack (nl_NL) ')