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 Payloads VALUES ("{7202D4A7-F7E6-4e7a-B77D-7B1C4E8B5CA6}", "NonAdobePayload", "Adobe Flash Player 10 ActiveX", "10", "normal") INSERT INTO PayloadData VALUES("{7202D4A7-F7E6-4e7a-B77D-7B1C4E8B5CA6}", "0" , "PayloadInfo", ' 2011-03-10 14:14:07.527000 AdobeFlashPlayer10_axRel_mul {7202D4A7-F7E6-4e7a-B77D-7B1C4E8B5CA6} Adobe Flash Player 10 ActiveX 10.2.153.1 [System32Folder]\Macromed\Flash NonAdobePayload Adobe Flash Player 10 ActiveX 10 msiPackage AdobeFlashPlayer10_axRel_mul.msi {B001064C-D061-4BAE-9031-416A838D5536} {B001064C-D061-4BAE-9031-416A838D5536} ReallySuppress 2 2 [INSTALLDIR] 6000000 /AdobeFlashPlayer10_axRel_mul.msi ^[Gg]et[Ff]lash\.exe$ ^[Ii][Ee][Xx][Pp][Ll][Oo][Rr][Ee]\.[Ee][Xx][Ee]$ ')