diff options
| -rw-r--r-- | rpkid/irdbd.sql | 6 | ||||
| -rw-r--r-- | rpkid/rpkid.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/rpkid/irdbd.sql b/rpkid/irdbd.sql index cdaff9ea..60353f8f 100644 --- a/rpkid/irdbd.sql +++ b/rpkid/irdbd.sql @@ -68,9 +68,9 @@ CREATE TABLE roa_request ( CREATE TABLE roa_request_prefix ( prefix VARCHAR(40) NOT NULL, - prefixlen TINYINT NOT NULL, - max_prefixlen TINYINT NOT NULL, - version TINYINT NOT NULL, + prefixlen TINYINT UNSIGNED NOT NULL, + max_prefixlen TINYINT UNSIGNED NOT NULL, + version TINYINT UNSIGNED NOT NULL, roa_request_id BIGINT UNSIGNED NOT NULL, PRIMARY KEY (roa_request_id, prefix, prefixlen, max_prefixlen), CONSTRAINT roa_request_prefix_roa_request_id diff --git a/rpkid/rpkid.sql b/rpkid/rpkid.sql index 1b0b791f..7d619ff9 100644 --- a/rpkid/rpkid.sql +++ b/rpkid/rpkid.sql @@ -190,9 +190,9 @@ CREATE TABLE roa ( CREATE TABLE roa_prefix ( prefix VARCHAR(40) NOT NULL, - prefixlen TINYINT NOT NULL, - max_prefixlen TINYINT NOT NULL, - version TINYINT NOT NULL, + prefixlen TINYINT UNSIGNED NOT NULL, + max_prefixlen TINYINT UNSIGNED NOT NULL, + version TINYINT UNSIGNED NOT NULL, roa_id BIGINT UNSIGNED NOT NULL, PRIMARY KEY (roa_id, prefix, prefixlen, max_prefixlen), CONSTRAINT roa_prefix_roa_id |