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 ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{9A4CC61E-92A8-4DAF-A006-F28C275229CA}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{B4022AA2-9576-4648-A543-EC667A0DE513}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{00EC25D2-2061-442C-80FA-F2DABAE160B9}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{E1621F5B-9AA5-457D-B578-4D939728F9E0}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{1558F84A-E2DF-454E-8C64-291E5AB40947}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{47C74842-DF37-47D8-B6A3-4E554949E1DD}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{31E36C24-B8F3-4793-9DB6-EF6551FC5CAC}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{06168760-0A9E-46B7-B5C2-32783DF26F2D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{4498BEF5-107E-4B1D-9974-4EDF7B888E9F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{D2F709F4-C1C5-4D9D-8E8D-B912D8CD4F8F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{2ED81167-F8EC-43D9-9840-F1AD7BD974CC}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{1D9ECD82-C976-451F-84B5-76CD6689FD2C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{EB833572-96CA-4A7B-AC40-8129E663E911}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{25AF4E5F-08A7-420D-9BFD-18A9DF22263A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{C886A4F5-71BF-406A-8A52-9BC4CB85F211}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{F630812A-541B-4F33-B217-B0EB74849787}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{A80756CE-7DF4-40F3-847B-DD5B1B0F98B0}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{D7FFD7D3-7C2F-47D6-89B2-A9D9D0957531}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{1F326AA2-006C-431C-B654-BD11F39F023C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{A67E8A4A-45CF-45CC-B7D1-5959B876FC1C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{97EE3A52-639E-415A-8EFB-88289E959AFB}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{5F08F96A-2397-427D-B861-C51E7E9BC835}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{F4712A2D-AB8C-4E00-8C83-4E558EBDC3F8}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{D77C44FD-E69A-4277-9B69-01BF7078FD83}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{57191711-A32C-4982-8665-5DBEF23EB8EE}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{6FCF7ABF-0DE7-4340-9227-BE4544B48932}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{449A2FB6-9431-477D-A7E1-FFD49CE86CD3}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{7211F0CA-8474-4FA4-8C34-84C2097D1180}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{002D5110-C034-4E9E-A77C-65B99EA311CA}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{F8A07DC8-CA74-4F7D-BFE2-95BB29A89861}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{6BF4717E-327B-45A9-9398-DEAF1BC8AB28}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{84B58C67-04AA-47FD-9F01-BA33631CE323}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{2EAF9481-82A7-4EDF-985B-D3EA38F1CAA7}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{D13426F0-293E-4F49-98F5-F2BAAC5F6C3A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{305C6822-078B-4A12-860A-DEE445765D18}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{48ED306D-8747-4023-8322-6C7781B3285B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{8D97320E-A98D-4CC7-AA1E-0F8165ED79A6}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{06113510-8538-4172-A5C4-A7027DF5245A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "{0C256871-F940-4BD3-ADD4-CD484BAB529D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "", "langPack", "Illustrator", "Adobe Illustrator CS5.1", "15.1") INSERT INTO Payloads VALUES ("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "Illustrator", "Adobe Illustrator CS5.1_AdobeIllustrator15_1pt_BRLanguagePack", "15.1", "langPack") INSERT INTO PayloadData VALUES("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "0" , "PayloadInfo", ' 2011-03-09 21:52:52.473000 AdobeIllustrator15_1pt_BRLanguagePack All SQLite {8A178CF1-5A2F-4C32-9E19-B4582599CDD6} Adobe Illustrator CS5.1 LangPack (pt_BR) 15.1 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] pt_BR Illustrator Adobe Illustrator CS5.1_AdobeIllustrator15_1pt_BRLanguagePack 15.1 {9A4CC61E-92A8-4DAF-A006-F28C275229CA} {B4022AA2-9576-4648-A543-EC667A0DE513} {00EC25D2-2061-442C-80FA-F2DABAE160B9} {E1621F5B-9AA5-457D-B578-4D939728F9E0} {1558F84A-E2DF-454E-8C64-291E5AB40947} {47C74842-DF37-47D8-B6A3-4E554949E1DD} {31E36C24-B8F3-4793-9DB6-EF6551FC5CAC} {06168760-0A9E-46B7-B5C2-32783DF26F2D} {4498BEF5-107E-4B1D-9974-4EDF7B888E9F} {D2F709F4-C1C5-4D9D-8E8D-B912D8CD4F8F} {2ED81167-F8EC-43D9-9840-F1AD7BD974CC} {1D9ECD82-C976-451F-84B5-76CD6689FD2C} {EB833572-96CA-4A7B-AC40-8129E663E911} {25AF4E5F-08A7-420D-9BFD-18A9DF22263A} {C886A4F5-71BF-406A-8A52-9BC4CB85F211} {F630812A-541B-4F33-B217-B0EB74849787} {A80756CE-7DF4-40F3-847B-DD5B1B0F98B0} {D7FFD7D3-7C2F-47D6-89B2-A9D9D0957531} {1F326AA2-006C-431C-B654-BD11F39F023C} {A67E8A4A-45CF-45CC-B7D1-5959B876FC1C} {97EE3A52-639E-415A-8EFB-88289E959AFB} {5F08F96A-2397-427D-B861-C51E7E9BC835} {F4712A2D-AB8C-4E00-8C83-4E558EBDC3F8} {D77C44FD-E69A-4277-9B69-01BF7078FD83} {57191711-A32C-4982-8665-5DBEF23EB8EE} {6FCF7ABF-0DE7-4340-9227-BE4544B48932} {449A2FB6-9431-477D-A7E1-FFD49CE86CD3} {7211F0CA-8474-4FA4-8C34-84C2097D1180} {002D5110-C034-4E9E-A77C-65B99EA311CA} {F8A07DC8-CA74-4F7D-BFE2-95BB29A89861} {6BF4717E-327B-45A9-9398-DEAF1BC8AB28} {84B58C67-04AA-47FD-9F01-BA33631CE323} {2EAF9481-82A7-4EDF-985B-D3EA38F1CAA7} {D13426F0-293E-4F49-98F5-F2BAAC5F6C3A} {305C6822-078B-4A12-860A-DEE445765D18} {48ED306D-8747-4023-8322-6C7781B3285B} {8D97320E-A98D-4CC7-AA1E-0F8165ED79A6} {06113510-8538-4172-A5C4-A7027DF5245A} {0C256871-F940-4BD3-ADD4-CD484BAB529D} Adobe Illustrator CS5.1 LangPack (pt_BR) Illustrator Adobe Illustrator CS5.1 [INSTALLDIR] 408480556 /Adobe Illustrator CS5.1/Cool Extras/pt_BR/Arquivos de amostra/Arte de amostra/Exemplos e descrições\Como diagnosticar miastenia grave na junção neuromuscular.pdf [AdobeCommon] 33899212 /Help/pt_BR/Illustrator/CS5/Using\illustrator_cs5.1_help.pdf 15.1 Adobe Illustrator CS5.1 LangPack (pt_BR) 0') INSERT INTO PayloadData VALUES("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "0", "ChannelID", "AdobeIllustratorCS5.1LangPackpt_BR-15.1") INSERT INTO PayloadData VALUES("{8A178CF1-5A2F-4C32-9E19-B4582599CDD6}", "0", "ChannelInfo", ' Adobe Illustrator CS5.1 LangPack (pt_BR) ')