a220356eaf
The analysis and storage now contain two different heatmaps for the CT and T sides respectively. However on the frontend I currently just have them all listed out with the side as a prefix, which is not very useful and we should more change the data structure to essentially send the two heatmaps for a player as a single data structure and then in the view display them side by side. However I am not 100% how to best achieve this
9 lines
203 B
SQL
9 lines
203 B
SQL
-- Your SQL goes here
|
|
CREATE TABLE IF NOT EXISTS demo_heatmaps (
|
|
demo_id TEXT NOT NULL,
|
|
steam_id TEXT NOT NULL,
|
|
team TEXT NOT NULL,
|
|
data TEXT NOT NULL,
|
|
PRIMARY KEY (demo_id, steam_id, team)
|
|
);
|