Convert to generating new ROA format

svn path=/rpkid/left-right-schema.rnc; revision=1800

1 files changed, 6 insertions, 5 deletions

diff --git a/rpkid/rpkid.sql b/rpkid/rpkid.sql
index d13eb370..fa50c1d6 100644
--- a/rpkid/rpkid.sql
+++ b/rpkid/rpkid.sql
@@ -177,13 +177,14 @@ CREATE TABLE route_origin (
         FOREIGN KEY             (ca_detail_id) REFERENCES ca_detail
 );
 
-DROP TABLE IF EXISTS route_origin_range;
+DROP TABLE IF EXISTS route_origin_prefix;
 
-CREATE TABLE route_origin_range (
-        start_ip                VARCHAR(40),
-        end_ip                  VARCHAR(40),
+CREATE TABLE route_origin_prefix (
+        address                 VARCHAR(40) NOT NULL,
+        prefixlen               TINYINT NOT NULL,
+        max_prefixlen           TINYINT NOT NULL,
         route_origin_id         BIGINT unsigned NOT NULL,
-        PRIMARY KEY             (route_origin_id, start_ip, end_ip),
+        PRIMARY KEY             (route_origin_id, address, prefixlen, max_prefixlen),
         FOREIGN KEY             (route_origin_id) REFERENCES route_origin
 );