diff options
| author | Rob Austein <sra@hactrn.net> | 2010-01-15 02:26:34 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2010-01-15 02:26:34 +0000 |
| commit | dda9a12742b5a755957797e11aee732cb992dd2b (patch) | |
| tree | bdbad86bc18e9251e0ff36be902ffb1fd6901582 /rpkid | |
| parent | 8667be0e3f883ff13341dd8afe75877c9a3d2287 (diff) | |
Range error was imposing ceiling of 127 on prefix lengths.
svn path=/rpkid/irdbd.sql; revision=2951
Diffstat (limited to 'rpkid')
| -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 |