issue-db: fixes to schema

The primary key on release_counts was resulting in only one row per
pubid.

Also the 'year_in_sim' column was never being used.

1 files changed, 5 insertions, 5 deletions

diff --git a/schema/issue_db.sql b/schema/issue_db.sql
index e07e97e..422717e 100644
--- a/schema/issue_db.sql
+++ b/schema/issue_db.sql
@@ -26,10 +26,10 @@ CREATE TABLE IF NOT EXISTS sim_issue (
 -- intent here is to capture how many releases are just not getting matched due
 -- to missing issue metadata
 CREATE TABLE IF NOT EXISTS release_counts (
-    sim_pubid TEXT NOT NULL PRIMARY KEY,
-    year TEXT,
-    volume TEXT,
-    year_in_sim BOOLEAN,
-    release_count INTEGER,
+    sim_pubid TEXT NOT NULL,
+    year TEXT NOT NULL,
+    volume TEXT NOT NULL,
+    release_count INTEGER NOT NULL,
+    PRIMARY KEY(sim_pubid, year, volume),
     FOREIGN KEY(sim_pubid) REFERENCES sim_pub(sim_pubid)
 );