1 files changed, 2 insertions, 1 deletions
diff --git a/db.sql b/db.sql
index 0a70c45..375c15a 100644
--- a/db.sql
+++ b/db.sql
@@ -33,7 +33,8 @@ CREATE TABLE package_rel_map (
     CONSTRAINT fk_suite_id REFERENCES suites(id) ON DELETE CASCADE,
   component_id INTEGER NOT NULL
     CONSTRAINT fk_component_id REFERENCES components(id),
-  UNIQUE (package_id, suite_id, component_id) ON CONFLICT IGNORE
+  marked INTEGER NOT NULL DEFAULT 1,
+  UNIQUE (package_id, suite_id, component_id) ON CONFLICT REPLACE
 );
 
 -- sqlite doesn't actually implement FK constraints, therefore we