aboutsummaryrefslogtreecommitdiff
path: root/rpkid/rpkid.sql
diff options
context:
space:
mode:
Diffstat (limited to 'rpkid/rpkid.sql')
-rw-r--r--rpkid/rpkid.sql6
1 files changed, 3 insertions, 3 deletions
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