| 1 |
<?php |
<?php |
| 2 |
// $Id: ip2country.install,v 1.4 2009/04/06 03:46:37 tr Exp $ |
// $Id: ip2country.install,v 1.5 2009/06/12 17:11:23 tr Exp $ |
| 3 |
|
|
| 4 |
|
|
| 5 |
// Include function definition for ip2country_update_database(), |
// Include function definition for ip2country_update_database(), |
| 32 |
*/ |
*/ |
| 33 |
function ip2country_schema() { |
function ip2country_schema() { |
| 34 |
$schema['ip2country'] = array( |
$schema['ip2country'] = array( |
| 35 |
'description' => t('Association between IP range and Country'), |
'description' => 'Association between IP range and Country', |
| 36 |
'fields' => array( |
'fields' => array( |
| 37 |
'ip2country_id' => array( |
'ip2country_id' => array( |
| 38 |
'description' => t('Row number (why is this needed?)'), |
'description' => 'Row number (why is this needed?)', |
| 39 |
'type' => 'serial', |
'type' => 'serial', |
| 40 |
'unsigned' => TRUE, |
'unsigned' => TRUE, |
| 41 |
'not null' => TRUE, |
'not null' => TRUE, |
| 42 |
), |
), |
| 43 |
'country' => array( |
'country' => array( |
| 44 |
'description' => t('ISO 3166 2-Character Country Code'), |
'description' => 'ISO 3166 2-Character Country Code', |
| 45 |
'type' => 'char', |
'type' => 'char', |
| 46 |
'length' => 3, |
'length' => 3, |
| 47 |
'not null' => TRUE, |
'not null' => TRUE, |
| 48 |
), |
), |
| 49 |
'registry' => array( |
'registry' => array( |
| 50 |
'description' => t('Regional Internet Resgistry'), |
'description' => 'Regional Internet Resgistry', |
| 51 |
'type' => 'char', |
'type' => 'char', |
| 52 |
'length' => 10, |
'length' => 10, |
| 53 |
'not null' => TRUE, |
'not null' => TRUE, |
| 54 |
), |
), |
| 55 |
'ip_range_first' => array( |
'ip_range_first' => array( |
| 56 |
'description' => t('Lowest IP Address in Range'), |
'description' => 'Lowest IP Address in Range', |
| 57 |
'type' => 'int', |
'type' => 'int', |
| 58 |
'size' => 'big', |
'size' => 'big', |
| 59 |
'not null' => TRUE, |
'not null' => TRUE, |
| 60 |
), |
), |
| 61 |
'ip_range_last' => array( |
'ip_range_last' => array( |
| 62 |
'description' => t('Highest IP Address in Range'), |
'description' => 'Highest IP Address in Range', |
| 63 |
'type' => 'int', |
'type' => 'int', |
| 64 |
'size' => 'big', |
'size' => 'big', |
| 65 |
'not null' => TRUE, |
'not null' => TRUE, |
| 66 |
), |
), |
| 67 |
'ip_range_date' => array( |
'ip_range_date' => array( |
| 68 |
'description' => t('Date Assigned'), |
'description' => 'Date Assigned', |
| 69 |
'type' => 'datetime', |
'type' => 'datetime', |
| 70 |
'not null' => TRUE, |
'not null' => TRUE, |
| 71 |
), |
), |
| 72 |
'ip_range_length' => array( |
'ip_range_length' => array( |
| 73 |
'description' => t('Size of IP Address Block'), |
'description' => 'Size of IP Address Block', |
| 74 |
'type' => 'int', |
'type' => 'int', |
| 75 |
'not null' => TRUE, |
'not null' => TRUE, |
| 76 |
), |
), |