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 ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "{A5CC3DFB-AF1A-48F5-AAEE-A5D9DF81BC69}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "{DA9D7DF5-8BFC-460A-80A3-432901219F04}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "{80C4F18D-6B9D-49E8-9D70-B930B0244477}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "{E9D05203-79D6-410B-8CA6-37573D0E0F30}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "{A7238156-573C-4487-B516-3255A6A9231F}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "{92067163-5083-408E-925A-D2716BF3ED35}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "{E2EB170B-4768-4DE6-B5BE-0C995132428B}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "{2CC5E338-E6FB-445E-A3C8-392366D4E6A1}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "{DE648080-B8F7-48CD-A605-DF7961A61A99}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "", "langPack", "Standard", "Adobe Flash CS5.5", "11.5") INSERT INTO Payloads VALUES ("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "Standard", "Adobe Flash CS5.5_AdobeFlash11.5-fr_FRLanguagePack", "11.5", "langPack") INSERT INTO PayloadData VALUES("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "0" , "PayloadInfo", ' 2011-03-17 10:10:11.858000 AdobeFlash11.5-fr_FRLanguagePack All SQLite {E1B098A4-2FDA-4722-9E9B-CD28F535E9DE} Adobe Flash CS5.5 Payload LangPack (fr_FR) 11.5 [AdobeProgramFiles] fr_FR fr_CA fr_XM Standard Adobe Flash CS5.5_AdobeFlash11.5-fr_FRLanguagePack 11.5 {A5CC3DFB-AF1A-48F5-AAEE-A5D9DF81BC69} {DA9D7DF5-8BFC-460A-80A3-432901219F04} {80C4F18D-6B9D-49E8-9D70-B930B0244477} {E9D05203-79D6-410B-8CA6-37573D0E0F30} {A7238156-573C-4487-B516-3255A6A9231F} {92067163-5083-408E-925A-D2716BF3ED35} {E2EB170B-4768-4DE6-B5BE-0C995132428B} {2CC5E338-E6FB-445E-A3C8-392366D4E6A1} {DE648080-B8F7-48CD-A605-DF7961A61A99} Adobe Flash CS5.5 Payload LangPack (fr_FR) Standard Adobe Flash CS5.5 [INSTALLDIR] 157252624 /Adobe Flash CS5.5/fr_FR/First Run/ActionsPanel/ActionScript_1_2/CustomActions/ScriptAssist\Flash Data Components.xml [AdobeCommon] 1113502 /Help/fr_FR/FlashPlatform/reference/actionscript/2\helpmap.txt 11.5 11.5 11.5 Adobe Flash CS5.5 Payload LangPack (fr_FR) Adobe Flash CS5.5 Payload LangPack (fr_FR) Adobe Flash CS5.5 Payload LangPack (fr_FR) 0') INSERT INTO PayloadData VALUES("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "0", "ChannelID", "FlashPro11.5fr_FR") INSERT INTO PayloadData VALUES("{E1B098A4-2FDA-4722-9E9B-CD28F535E9DE}", "0", "ChannelInfo", ' Adobe Flash CS5.5 Payload LangPack (fr_FR) ')