New tests for `condenser_api.get_state`

hive/db/sql_scripts/upgrade/upgrade_table_schema.sql

@@ -304,21 +304,25 @@ WHERE NOT EXISTS (SELECT data_type
 --- Notification cache to significantly speedup notification APIs.
 CREATE TABLE IF NOT EXISTS hive_notification_cache
 (
-  id BIGINT NOT NULL,
-  block_num INT NOT NULL,
-  type_id INT NOT NULL,
-  dst INT NULL,
-  src INT NULL,
-  dst_post_id INT NULL,
-  post_id INT NULL,
-  score INT NOT NULL,
-  created_at TIMESTAMP WITHOUT TIME ZONE NOT NULL,
-  community_title VARCHAR(32) NULL,
-  community VARCHAR(16) NULL,
-  payload VARCHAR NULL,
-
-  CONSTRAINT hive_notification_cache_pk PRIMARY KEY (id)
+  id BIGINT NOT NULL,
+  block_num INT NOT NULL,
+  type_id INT NOT NULL,
+  dst INT NULL,
+  src INT NULL,
+  dst_post_id INT NULL,
+  post_id INT NULL,
+  score INT NOT NULL,
+  created_at TIMESTAMP WITHOUT TIME ZONE NOT NULL,
+  community_title VARCHAR(32) NULL,
+  community VARCHAR(16) NULL,
+  payload VARCHAR NULL,
+
+  CONSTRAINT hive_notification_cache_pk PRIMARY KEY (id)
 );
 
 CREATE INDEX IF NOT EXISTS hive_notification_cache_block_num_idx ON hive_notification_cache (block_num);
 CREATE INDEX IF NOT EXISTS hive_notification_cache_dst_score_idx ON hive_notification_cache (dst, score) WHERE dst IS NOT NULL;
+
+CREATE INDEX IF NOT EXISTS hive_feed_cache_block_num_idx on hive_feed_cache (block_num);
+CREATE INDEX IF NOT EXISTS hive_feed_cache_created_at_idx on hive_feed_cache (created_at);
+