diff options
author | Helmut Grohne <helmut@subdivi.de> | 2019-03-05 20:01:31 +0100 |
---|---|---|
committer | Helmut Grohne <helmut@subdivi.de> | 2019-03-05 20:01:31 +0100 |
commit | 93da310af8a40778a12f2decba503a5497285a61 (patch) | |
tree | 4b3c398dcaf4d2ef6d2e6aa1951e28f162585e09 | |
parent | b15898cf32679ebc8d9a63e8d631847bcc5bf5e0 (diff) | |
download | crossqa-93da310af8a40778a12f2decba503a5497285a61.tar.gz |
schema.sql: improve unique index
Most of the time, we'll query depstate by source. Thus it should come
first in the uniqueness constraint.
-rw-r--r-- | schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -4,7 +4,7 @@ CREATE TABLE depstate ( architecture TEXT NOT NULL, satisfiable BOOLEAN NOT NULL CHECK (satisfiable in (0, 1)), reason TEXT, - UNIQUE (architecture, source, version)); + UNIQUE (source, architecture, version)); CREATE TABLE depcheck ( architecture TEXT NOT NULL UNIQUE, |