diff options
Diffstat (limited to 'db/structure.sql')
| -rw-r--r-- | db/structure.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/db/structure.sql b/db/structure.sql index db1260e527c..512e27adb6a 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -20122,7 +20122,9 @@ CREATE TABLE pm_checkpoints ( created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL, purl_type smallint NOT NULL, - chunk smallint NOT NULL + chunk smallint NOT NULL, + data_type smallint DEFAULT 1 NOT NULL, + version_format smallint DEFAULT 1 NOT NULL ); CREATE TABLE pm_licenses ( @@ -27699,7 +27701,7 @@ ALTER TABLE ONLY pm_affected_packages ADD CONSTRAINT pm_affected_packages_pkey PRIMARY KEY (id); ALTER TABLE ONLY pm_checkpoints - ADD CONSTRAINT pm_checkpoints_pkey PRIMARY KEY (purl_type); + ADD CONSTRAINT pm_checkpoints_pkey PRIMARY KEY (purl_type, data_type, version_format); ALTER TABLE ONLY pm_licenses ADD CONSTRAINT pm_licenses_pkey PRIMARY KEY (id); |