Update SQL schema

kexleyBeefy · Nov 10, 2021 · 3d9d4ad · 3d9d4ad
1 parent f95d1fd
commit 3d9d4ad
Showing 1 changed file with 7 additions and 2 deletions.
diff --git a/src/helpers/database/schema.sql b/src/helpers/database/schema.sql
@@ -59,6 +59,9 @@ CREATE TABLE proposals (
   scores JSON NOT NULL,
   scores_by_strategy JSON NOT NULL,
   scores_state VARCHAR(24) NOT NULL,
+  scores_total DECIMAL(64,30) NOT NULL,
+  scores_updated BIGINT NOT NULL,
+  votes BIGINT NOT NULL,
   PRIMARY KEY (id),
   INDEX ipfs (ipfs),
   INDEX author (author),
@@ -67,7 +70,9 @@ CREATE TABLE proposals (
   INDEX space (space),
   INDEX start (start),
   INDEX end (end),
-  INDEX scores_state (scores_state)
+  INDEX scores_state (scores_state),
+  INDEX scores_updated (scores_updated),
+  INDEX votes (votes)
 );
 
 CREATE TABLE votes (
@@ -79,7 +84,7 @@ CREATE TABLE votes (
   proposal VARCHAR(66) NOT NULL,
   choice JSON NOT NULL,
   metadata JSON NOT NULL,
-  vp BIGINT NOT NULL,
+  vp DECIMAL(64,30) NOT NULL,
   vp_by_strategy JSON NOT NULL,
   vp_state VARCHAR(24) NOT NULL,
   PRIMARY KEY (id),