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 ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{404F836A-57EC-475A-B102-F46B6D0A43AB}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{BB4E16EB-BD18-42D6-B7B8-5D218CE0F265}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{B315E15B-F192-4DCC-83B0-41E1C7783499}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{A237FA52-4165-4CE2-9857-14A2F51D2869}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{5F7EE957-0FCA-411C-AB8C-F4C3AB13C1AA}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{8FE62BD1-D93E-42EC-8D6B-441D50C977C1}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{95DBFF1B-5DBD-43EE-AE9E-495040D1D0E2}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{E9E74906-6A78-4194-88C0-88F7239C0B60}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{502827BB-AA5A-464A-B9A8-A28F2B75DEB2}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{9959175B-2D03-4503-BFF5-B3672F098649}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{3147256D-410B-4FC9-8E7F-68E555471A31}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{5985CF70-6BA7-4294-8467-2BE91200C0B2}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{956FAD20-4F76-4B07-8251-34EEE328CE2A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{6C104E29-0B30-4778-9C0F-2C2BBEA91828}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{6FB5AD26-5256-44DE-9BD5-23F7AFB1B1FF}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{5D17B215-C5C1-4672-B010-B77499094C8C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{3DE0EA5A-F8AD-4440-9624-88512C983E05}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{52245A8D-98FE-4723-B4D9-30464EC42BCE}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{7F763BB8-DD39-4AF2-B311-79794B6C845A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{92979858-1D82-4FFC-A8C7-0600C0DD9AEB}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{83D0224E-80CC-45CE-9F20-A21A9311FA6C}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{66CD5624-5F09-4C78-BB4D-D10B8F72410B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{92317392-0920-4A94-A1DA-7C42E6B7683B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{A285BF37-F511-4BB4-A26A-39979E530F3E}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{05E0C335-5894-4E21-A735-A396050870DC}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{6DEEB971-B2A1-4A97-8D3D-F94395ECB58A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{EF834794-06FB-4338-BE05-868CC913876D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{098649D5-A862-4AF1-95C7-480D15B8381A}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{C448F2BB-64F8-4144-8452-D2092A55A9D5}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{43625ED5-E5DA-481B-9F5F-B3BD6CCFF857}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{E12D596B-B341-4A89-BD79-0D958C7BCA92}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{083EAE0F-AC06-44B1-9BE5-2B42C1D50EA4}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{0ED6A9D7-5AF6-47E6-8817-8161373C2D9B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{CCB9EEE2-6953-4805-86F8-9840A1708774}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{D87E92E4-E189-4065-8A10-B8B2061A490D}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{7C6BF9F4-7A23-432B-BFE9-6E145FFFE4E0}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{D86C17C0-DBBB-4E71-B40A-C7E23E071475}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{EBBADA3A-6BD6-446A-A375-D68ABA35B32F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{4AFD45A0-7A5A-4E06-AB7C-6D433CFB3389}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "{E1292D0F-9027-4FDA-ACE1-A43F5E9FC64B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "", "langPack", "Illustrator", "Adobe Illustrator CS5.1", "15.1") INSERT INTO Payloads VALUES ("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "Illustrator", "Adobe Illustrator CS5.1_AdobeIllustrator15_1fr_CALanguagePack", "15.1", "langPack") INSERT INTO PayloadData VALUES("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "0" , "PayloadInfo", ' 2011-03-09 22:07:42.998000 AdobeIllustrator15_1fr_CALanguagePack All SQLite {5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F} Adobe Illustrator CS5.1 LangPack (fr_CA) 15.1 [AdobeProgramFiles] [AdobeProgramFiles] [AdobeProgramFiles] fr_CA Illustrator Adobe Illustrator CS5.1_AdobeIllustrator15_1fr_CALanguagePack 15.1 {404F836A-57EC-475A-B102-F46B6D0A43AB} {BB4E16EB-BD18-42D6-B7B8-5D218CE0F265} {B315E15B-F192-4DCC-83B0-41E1C7783499} {A237FA52-4165-4CE2-9857-14A2F51D2869} {5F7EE957-0FCA-411C-AB8C-F4C3AB13C1AA} {8FE62BD1-D93E-42EC-8D6B-441D50C977C1} {95DBFF1B-5DBD-43EE-AE9E-495040D1D0E2} {E9E74906-6A78-4194-88C0-88F7239C0B60} {502827BB-AA5A-464A-B9A8-A28F2B75DEB2} {9959175B-2D03-4503-BFF5-B3672F098649} {3147256D-410B-4FC9-8E7F-68E555471A31} {5985CF70-6BA7-4294-8467-2BE91200C0B2} {956FAD20-4F76-4B07-8251-34EEE328CE2A} {6C104E29-0B30-4778-9C0F-2C2BBEA91828} {6FB5AD26-5256-44DE-9BD5-23F7AFB1B1FF} {5D17B215-C5C1-4672-B010-B77499094C8C} {3DE0EA5A-F8AD-4440-9624-88512C983E05} {52245A8D-98FE-4723-B4D9-30464EC42BCE} {7F763BB8-DD39-4AF2-B311-79794B6C845A} {92979858-1D82-4FFC-A8C7-0600C0DD9AEB} {83D0224E-80CC-45CE-9F20-A21A9311FA6C} {66CD5624-5F09-4C78-BB4D-D10B8F72410B} {92317392-0920-4A94-A1DA-7C42E6B7683B} {A285BF37-F511-4BB4-A26A-39979E530F3E} {05E0C335-5894-4E21-A735-A396050870DC} {6DEEB971-B2A1-4A97-8D3D-F94395ECB58A} {EF834794-06FB-4338-BE05-868CC913876D} {098649D5-A862-4AF1-95C7-480D15B8381A} {C448F2BB-64F8-4144-8452-D2092A55A9D5} {43625ED5-E5DA-481B-9F5F-B3BD6CCFF857} {E12D596B-B341-4A89-BD79-0D958C7BCA92} {083EAE0F-AC06-44B1-9BE5-2B42C1D50EA4} {0ED6A9D7-5AF6-47E6-8817-8161373C2D9B} {CCB9EEE2-6953-4805-86F8-9840A1708774} {D87E92E4-E189-4065-8A10-B8B2061A490D} {7C6BF9F4-7A23-432B-BFE9-6E145FFFE4E0} {D86C17C0-DBBB-4E71-B40A-C7E23E071475} {EBBADA3A-6BD6-446A-A375-D68ABA35B32F} {4AFD45A0-7A5A-4E06-AB7C-6D433CFB3389} {E1292D0F-9027-4FDA-ACE1-A43F5E9FC64B} Adobe Illustrator CS5.1 LangPack (fr_CA) Illustrator Adobe Illustrator CS5.1 [INSTALLDIR] 412219224 /Adobe Illustrator CS5.1/Cool Extras/fr_CA/Fichiers d'exemples/Illustrations/Comment ont-ils fait\Les secrets de l'élaboration de Dans le berceau des profondeurs.pdf [AdobeCommon] 32933008 /Help/fr_FR/Illustrator/CS5/Using\illustrator_cs5.1_help.pdf 15.1 Adobe Illustrator CS5.1 LangPack (fr_CA) 0') INSERT INTO PayloadData VALUES("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "0", "ChannelID", "AdobeIllustratorCS5.1LangPackfr_CA-15.1") INSERT INTO PayloadData VALUES("{5FD9FF64-5CA5-49FF-8E3F-58F7E77E9A1F}", "0", "ChannelInfo", ' Adobe Illustrator CS5.1 LangPack (fr_CA) ')