diff options
| author | Rob Austein <sra@hactrn.net> | 2009-12-23 06:31:32 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2009-12-23 06:31:32 +0000 |
| commit | 5199aa55c5e4e60c9b247265587596c1fb754632 (patch) | |
| tree | 06bb47aefc0695131a8d6bce08fc161c027c922f | |
| parent | 992844e95a2cbef1e918d73f11b8ecd9180504c3 (diff) | |
Change ASN representation from DECIMAL to BIGINT UNSIGNED, because the
former invokes weird type conversions deep in the guts of MySQLdb.
svn path=/rpkid/irdbd.sql; revision=2906
| -rw-r--r-- | rpkid/irdbd.sql | 2 | ||||
| -rw-r--r-- | rpkid/rpkid.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/rpkid/irdbd.sql b/rpkid/irdbd.sql index d6ca3956..cdaff9ea 100644 --- a/rpkid/irdbd.sql +++ b/rpkid/irdbd.sql @@ -62,7 +62,7 @@ CREATE TABLE registrant_net ( CREATE TABLE roa_request ( roa_request_id SERIAL NOT NULL, roa_request_handle VARCHAR(255) NOT NULL, - asn DECIMAL(24,0), + asn BIGINT UNSIGNED NOT NULL, PRIMARY KEY (roa_request_id) ) ENGINE=InnoDB; diff --git a/rpkid/rpkid.sql b/rpkid/rpkid.sql index 8f5ff07a..1b0b791f 100644 --- a/rpkid/rpkid.sql +++ b/rpkid/rpkid.sql @@ -175,7 +175,7 @@ CREATE TABLE revoked_cert ( CREATE TABLE roa ( roa_id SERIAL NOT NULL, - asn DECIMAL(24,0), + asn BIGINT UNSIGNED, cert LONGBLOB, roa LONGBLOB, published DATETIME, |