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) ) CREATE TABLE EULA_Ref( productID TEXT NOT NULL, langCode TEXT NOT NULL, eula_hash TEXT NOT NULL, PRIMARY KEY (productID, langCode) ) CREATE TABLE EULA_Content(eula_hash TEXT NOT NULL, Content TEXT NOT NULL, PRIMARY KEY (eula_hash)) CREATE TABLE IF NOT EXISTS pcd_meta ( key TEXT NOT NULL, value TEXT NOT NULL, PRIMARY KEY (key) ) INSERT OR REPLACE INTO pcd_meta (key, value) VALUES ('schema_version', 2) INSERT OR REPLACE INTO pcd_meta (key, value) VALUES ('schema_compatibility_version', 1) INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{CA6A6B5F-EFCE-4EC8-A017-CD68A9767AA4}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{92CC36E0-1DC0-435E-9014-D70BEBD4F991}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{6F107A95-346D-48F6-9456-32487478BBED}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{F86D1381-D8F9-43B9-A617-A8780DB0CA29}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{95244FC7-DE43-4448-B470-143972882583}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{E5B92AE0-4684-446E-A641-588B6DA34DC2}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{DD79C7B3-373F-4B80-826F-5346CD5B2DD8}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{B38A5435-34F2-4A1E-9C66-87BE2AF1797B}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{C1365FC1-AC3D-495A-BE80-8188A9CD4C70}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{03D72E45-230A-4C30-98EE-4784E486A9B4}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{979EF1D0-5515-4BDA-9472-883A66D8B34A}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{9AD99FD8-E75B-430E-9963-D88DBCBE10FB}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{63379030-9779-4797-8E28-C8252F2FF377}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{89ED9990-AECF-44B6-AD81-3DCAAA780873}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{0DC690B6-4268-4096-8DD9-B2788D108D6B}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{FA785B57-03B9-4A6B-8E60-9FAC3297BA8D}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{E3479688-D002-44F6-98BC-5A1BBF837CF8}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{4CF5B018-7B3B-4B7A-9F6F-125F1F6B25F6}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{3B4BDF53-9BF2-44D1-BD48-AAF7952ADE53}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{836EB5C3-FC31-468F-94A4-BC8BFDE5F78F}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{EFBA6DD5-5275-4A94-8D1C-E7853F482972}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{2E9B5C21-1FF2-4045-BDFF-26EF2F508378}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{C85590CB-0558-4022-B625-A69FFDC6D73A}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{08502F0D-33C0-4957-9970-FA6EF733AD7B}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{B12AD6C4-08F8-4C2B-84E5-80BFF5D0C548}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{A9ADEF01-6FAD-43B2-AE90-66194ABAD113}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{206E3E8D-B968-4E51-8F77-956828E2034C}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{958E4F40-FDC2-466C-82A1-0D147E77E713}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{30D5C6A3-B4E6-44EE-B6ED-CBA0D0D9381A}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{2198293D-431E-48B5-8D27-7CD206DB44DD}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{644DC12C-F2C8-4ECC-A59D-980326E6FAF9}", "upgrade", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "{C52BB7C7-E737-4DCC-AE34-07E6D1DBC7EE}", "conflict", "", "", "") INSERT INTO DependencyData VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "", "langPack", "DVA", "Adobe SpeedGrade CS6", "") INSERT INTO PayloadData VALUES("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "0" , "ValidationInfo", '') INSERT INTO PayloadData VALUES("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "0" , "ValidationSig", "dDIbhTsC4VCANH3M6VRilTuczkq3ozm/xBZGQ8wjFkiVd7GyTJJW/+FhryfhiijGoKEn8do9+38OxNKk1cSgptbrVagjl1Fe5A3wXJ9dZuyL7YXvw+F8AovTPDaZLxnXNQpzPrnCIdrjHEFXNTcTlzZE0C3bGRlVFE7kj9O2WQOZdpn8IR5ARSLCHg1hDUZhclDtgEw/raKS2GkgO3gfLebIK/CAIdReDz1F6nm7gtsUtpb8YaJY3kJtntP0wSM0ce51+DKJLIM3oAhxxIeUATH+rQJ5BAoKLV3TgdKP+Tz9lFKsJo7qsYE2BD2ExBl4YRk0gJRwPeWBOHkxL930X5/ynbrgZYfMK+bltAIlSgTI4+rOHPX7uR4+3cS9nmJEfNnlohPuF6RuFzGgAvqEEKdt++pFIIHB9+4PKL4uJACfPQw+9TmuLLcJKZhfno2BhjXC/EWVVlKnNXhUZeMdNZYUsLJmbZqQVutnvBSuyPaRyEo9aSUq+ZA+NT3wFKkw") INSERT INTO Payloads VALUES ("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "DVA", "Adobe SpeedGrade CS6_AdobeSpeedGrade6.0de_DELanguagePack", "6.0.0", "langPack") INSERT INTO PayloadData VALUES("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "0" , "PayloadInfo", ' 2012-03-30 08:54:01.440000 AdobeSpeedGrade6.0de_DELanguagePack x64 SQLite {DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645} Adobe SpeedGrade CS6 LangPack (de_DE) 6.0.0 [AdobeProgramFiles] de_DE DVA Adobe SpeedGrade CS6_AdobeSpeedGrade6.0de_DELanguagePack 6.0.0 {CA6A6B5F-EFCE-4EC8-A017-CD68A9767AA4} {92CC36E0-1DC0-435E-9014-D70BEBD4F991} {6F107A95-346D-48F6-9456-32487478BBED} {F86D1381-D8F9-43B9-A617-A8780DB0CA29} {95244FC7-DE43-4448-B470-143972882583} {E5B92AE0-4684-446E-A641-588B6DA34DC2} {DD79C7B3-373F-4B80-826F-5346CD5B2DD8} {B38A5435-34F2-4A1E-9C66-87BE2AF1797B} {C1365FC1-AC3D-495A-BE80-8188A9CD4C70} {03D72E45-230A-4C30-98EE-4784E486A9B4} {979EF1D0-5515-4BDA-9472-883A66D8B34A} {9AD99FD8-E75B-430E-9963-D88DBCBE10FB} {63379030-9779-4797-8E28-C8252F2FF377} {89ED9990-AECF-44B6-AD81-3DCAAA780873} {0DC690B6-4268-4096-8DD9-B2788D108D6B} {FA785B57-03B9-4A6B-8E60-9FAC3297BA8D} {E3479688-D002-44F6-98BC-5A1BBF837CF8} {4CF5B018-7B3B-4B7A-9F6F-125F1F6B25F6} {3B4BDF53-9BF2-44D1-BD48-AAF7952ADE53} {836EB5C3-FC31-468F-94A4-BC8BFDE5F78F} {EFBA6DD5-5275-4A94-8D1C-E7853F482972} {2E9B5C21-1FF2-4045-BDFF-26EF2F508378} {C85590CB-0558-4022-B625-A69FFDC6D73A} {08502F0D-33C0-4957-9970-FA6EF733AD7B} {B12AD6C4-08F8-4C2B-84E5-80BFF5D0C548} {A9ADEF01-6FAD-43B2-AE90-66194ABAD113} {206E3E8D-B968-4E51-8F77-956828E2034C} {958E4F40-FDC2-466C-82A1-0D147E77E713} {30D5C6A3-B4E6-44EE-B6ED-CBA0D0D9381A} {2198293D-431E-48B5-8D27-7CD206DB44DD} {644DC12C-F2C8-4ECC-A59D-980326E6FAF9} {C52BB7C7-E737-4DCC-AE34-07E6D1DBC7EE} Adobe SpeedGrade CS6 LangPack (de_DE) DVA Adobe SpeedGrade CS6 [AdobeCommon] 690 /HelpCfg/de_DE\SpeedGrade.helpcfg 6.0.0 Adobe SpeedGrade CS6 LangPack (de_DE) 0') INSERT INTO PayloadData VALUES("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "0" , "WorkflowVersion", "CS6") INSERT INTO PayloadData VALUES("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "0" , "DEVersion", "6.0") INSERT INTO PayloadData VALUES("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "0", "ChannelID", "AdobeSpeedGradeCS6LangPackde_DE-6.0.0") INSERT INTO PayloadData VALUES("{DBFC1AD0-FCC8-41B3-8A50-08DF5FC36645}", "0", "ChannelInfo", ' Adobe SpeedGrade CS6 LangPack (de_DE) ')