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 ("{3501C02E-2CD1-1016-BBC6-901885687DD1}", "", "langPack", "InDesign", "Adobe InDesign CS5.5 Application Base Files", "7.5")
INSERT INTO Payloads VALUES ("{3501C02E-2CD1-1016-BBC6-901885687DD1}", "InDesign", "Adobe InDesign CS5.5 Common Language Files_AdobeInDesign7xCommonLang-sv_SE", "7.5", "langPack")
INSERT INTO PayloadData VALUES("{3501C02E-2CD1-1016-BBC6-901885687DD1}", "0" , "PayloadInfo", '
2011-03-17 08:41:51.149000
AdobeInDesign7xCommonLang-sv_SE
All
SQLite
{3501C02E-2CD1-1016-BBC6-901885687DD1}
Adobe InDesign CS5.5 Common Language Files (sv_SE)
7.5
[AdobeCommon]
sv_SE
InDesign
Adobe InDesign CS5.5 Common Language Files_AdobeInDesign7xCommonLang-sv_SE
7.5
Adobe InDesign CS5.5 Common Language Files (sv_SE)
InDesign
Adobe InDesign CS5.5 Application Base Files
[AdobeCommon]
39656161
/Help/sv_SE/InDesign/CS5/Using\InDesign_CS5.5_Help.pdf
7.5
Adobe InDesign CS5.5 Common Language Files (sv_SE)
0')
INSERT INTO PayloadData VALUES("{3501C02E-2CD1-1016-BBC6-901885687DD1}", "0", "ChannelID", "AdobeInDesignCS5.5CommonLanguageFilessv_SE-7.5")
INSERT INTO PayloadData VALUES("{3501C02E-2CD1-1016-BBC6-901885687DD1}", "0", "ChannelInfo", '
Adobe InDesign CS5.5 Common Language Files (sv_SE)
')