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	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{DA9B0C36-B917-4E75-9E55-B123A2075031}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{A9FB32FE-F906-47F4-855C-AF63F0EF2DFC}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{4FFFCAE5-7BE9-4557-9423-B815DD95F74A}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{E902633C-A296-48B6-B71B-D9335067FA5C}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{E62C6AAE-91E4-46B2-8144-41BA8C562968}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{97A8791C-0799-4D11-B822-619ABE5AB650}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{E2AF33CF-CC29-4857-9E9E-2A57D43F9C8C}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{FFDC1BAA-E81A-4DE3-85D5-DE31E8A16394}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{F0EFE2F5-2FBD-40FD-9D2D-C31B0BB6CF4D}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{EB6F5E41-9A87-4206-820D-F566B0C0C3F9}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{2C450932-5D31-4D9A-A571-9F1AC2F856EB}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{D41E2F1C-57D3-42F8-B442-09124282D37C}", "upgrade", "", "", "")
INSERT INTO DependencyData VALUES	("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "{0A94898D-4CB0-4F7B-940E-56F69B4CD249}", "upgrade", "", "", "")
INSERT OR REPLACE INTO EULA_Content VALUES("a3ae2c603e732cf3ac293be088bf6529", "77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiID8+DQo8IURPQ1RZUEUgaHRt
[encoded data, 121890 characters]
PC9wPg0KICAgIDxicj4NCjwvYm9keT4NCjwvaHRtbD4NCg==")
INSERT OR REPLACE INTO EULA_Ref VALUES("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "cs_CZ", "a3ae2c603e732cf3ac293be088bf6529")
INSERT OR REPLACE INTO EULA_Content VALUES("70831d236215ff465786ae5e322222b1", "77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiID8+DQo8IURPQ1RZUEUgaHRt
[encoded data, 116885 characters]
L3A+DQogICAgPGJyPg0KPC9ib2R5Pg0KPC9odG1sPg0K")
INSERT OR REPLACE INTO EULA_Ref VALUES("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "da_DK", "70831d236215ff465786ae5e322222b1")
INSERT OR REPLACE INTO EULA_Content VALUES("d9c230b2399466de8e152b906075ef6c", "77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiID8+DQo8IURPQ1RZUEUgaHRt
[encoded data, 128050 characters]
L2JvZHk+DQo8L2h0bWw+DQo=")
INSERT OR REPLACE INTO EULA_Ref VALUES("{E787BAD7-B750-4E1C-A149-965CF1DEE4AB}", "de_DE", "d9c230b2399466de8e152b906075ef6c")
INSERT OR REPLACE INTO EULA_Content VALUES("f28b6956466c8ca2bb6ec03df767edda", "77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiID8+DQo8IURPQ1RZUEUgaHRt
[encoded data, 87240 characters]
