Hello, I’m trying to understand why there’s not medatada field in the badges table (in the UGS medatata db). There seems to be code to support it in UGS and PostBadgeStatus
The setup.sql file does not create that column apparently. Is it intended for some reason ?
CREATE TABLE IF NOT EXISTS ugs_db.Badges (
Id INT NOT NULL AUTO_INCREMENT,
ChangeNumber INT NOT NULL,
BuildType NVARCHAR(32) NOT NULL,
Result NVARCHAR(10) NOT NULL,
Url NVARCHAR(512) NOT NULL,
ProjectId INT NOT NULL,
ArchivePath NVARCHAR(512) NULL,
PRIMARY KEY ( Id ),
FOREIGN KEY(ProjectId) REFERENCES Projects(Id)
);
Hi,
I took a look at the history of this feature in P4, and it looks like that at CL 24814036, the column was added and the SQL command to ALTER the table put in //UE5/Release-5.6/Engine/Source/Programs/UnrealGameSync/MetadataServer/SetupBuildMetadata.sql. You could probably add it to setup.sql directly if you prefer because it is not very obvious.
Regards,
Patrick
That’s great thank you, I missed it because the file is apparently not included in the sln file. And it already answers my follow up question about what data type I should make the field if I were to add it myself. Thank you very much!