function location_phone_update_5300 in Location 7.5
Same name and namespace in other branches
- 5.3 contrib/location_phone/location_phone.install \location_phone_update_5300()
- 6.3 contrib/location_phone/location_phone.install \location_phone_update_5300()
- 7.3 contrib/location_phone/location_phone.install \location_phone_update_5300()
- 7.4 contrib/location_phone/location_phone.install \location_phone_update_5300()
Location 3.0 update 1. Fix pgsql -- The table definition was broken.
File
- contrib/
location_phone/ location_phone.install, line 54 - Install, update and uninstall functions for the location_phone module.
Code
function location_phone_update_5300() {
if (!db_table_exists('location_phone')) {
$schema['location_phone'] = array(
'description' => 'location_phone.module {location} supplementary table.',
'fields' => array(
'lid' => array(
'description' => '{location}.lid',
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'phone' => array(
'description' => 'Phone number',
'type' => 'varchar',
'length' => 31,
'not null' => TRUE,
'default' => '',
),
),
'primary key' => array(
'lid',
),
);
db_create_table('location_phone', $schema['location_phone']);
}
else {
// If the table WAS created (i.e. user manually fixed bug and reinstalled), g/c the postal_code column.
if (db_field_exists('location_phone', 'postal_code')) {
db_drop_field('location_phone', 'postal_code');
}
}
}