diff options
| author | Rob Austein <sra@hactrn.net> | 2009-06-09 20:25:16 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2009-06-09 20:25:16 +0000 |
| commit | 48580e7cb64009adf35da58c44b71753b9f0e596 (patch) | |
| tree | b6361c77d776bd3c265bc2070e39cc4becd27f82 /rpkid/rpkid.sql | |
| parent | 24f133ff269e0a240c081d6c93028a17a555e5c4 (diff) | |
Convert ROA generation code from push model (<route_origin/> objects
in rpkid) to pull model (IRDB for <list_roa_request/> queries).
Still need to clean up old code, but new code seems to work properly.
svn path=/rpkid/Makefile; revision=2510
Diffstat (limited to 'rpkid/rpkid.sql')
| -rw-r--r-- | rpkid/rpkid.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/rpkid/rpkid.sql b/rpkid/rpkid.sql index 96725b85..1c9779d5 100644 --- a/rpkid/rpkid.sql +++ b/rpkid/rpkid.sql @@ -164,7 +164,7 @@ CREATE TABLE revoked_cert ( CREATE TABLE route_origin ( route_origin_id SERIAL NOT NULL, route_origin_handle VARCHAR(255) NOT NULL, - as_number DECIMAL(24,0), + asn DECIMAL(24,0), cert LONGBLOB, roa LONGBLOB, self_id BIGINT UNSIGNED NOT NULL, @@ -176,18 +176,18 @@ CREATE TABLE route_origin ( ) ENGINE=InnoDB; CREATE TABLE route_origin_prefix ( - address VARCHAR(40) NOT NULL, + prefix VARCHAR(40) NOT NULL, prefixlen TINYINT NOT NULL, max_prefixlen TINYINT NOT NULL, version TINYINT NOT NULL, route_origin_id BIGINT UNSIGNED NOT NULL, - PRIMARY KEY (route_origin_id, address, prefixlen, max_prefixlen), + PRIMARY KEY (route_origin_id, prefix, prefixlen, max_prefixlen), FOREIGN KEY (route_origin_id) REFERENCES route_origin (route_origin_id) ) ENGINE=InnoDB; CREATE TABLE roa ( roa_id SERIAL NOT NULL, - as_number DECIMAL(24,0), + asn DECIMAL(24,0), cert LONGBLOB, roa LONGBLOB, self_id BIGINT UNSIGNED NOT NULL, @@ -198,12 +198,12 @@ CREATE TABLE roa ( ) ENGINE=InnoDB; CREATE TABLE roa_prefix ( - address VARCHAR(40) NOT NULL, + prefix VARCHAR(40) NOT NULL, prefixlen TINYINT NOT NULL, max_prefixlen TINYINT NOT NULL, version TINYINT NOT NULL, roa_id BIGINT UNSIGNED NOT NULL, - PRIMARY KEY (roa_id, address, prefixlen, max_prefixlen), + PRIMARY KEY (roa_id, prefix, prefixlen, max_prefixlen), FOREIGN KEY (roa_id) REFERENCES roa (roa_id) ) ENGINE=InnoDB; |