diff -r fcf75e232c5b -r 0ff3ba646492 web/drupal/modules/xmlsitemap/xmlsitemap_user/xmlsitemap_user.install --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/web/drupal/modules/xmlsitemap/xmlsitemap_user/xmlsitemap_user.install Fri Aug 21 16:26:26 2009 +0000 @@ -0,0 +1,320 @@ + 'The base table for xmlsitemap_user.', + 'fields' => array( + 'uid' => array( + 'description' => 'The user ID.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'changed' => array( + 'description' => 'The Unix timestamp of the last change.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'previously_changed' => array( + 'description' => 'The Unix timestamp of the previous change.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'comments' => array( + 'description' => 'The number of comments authored from the user.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'priority_override' => array( + 'description' => 'The priority of the term in the sitemap.', + 'type' => 'float', + 'not null' => TRUE, + 'default' => -2.0, + ), + ), + 'primary key' => array('uid'), + ); + $schema['xmlsitemap_user_role'] = array( + 'description' => 'The user roles settings table.', + 'fields' => array( + 'rid' => array( + 'description' => 'The role ID.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'priority' => array( + 'description' => 'The priority assigned to the role.', + 'type' => 'float', + 'not null' => TRUE, + 'default' => 0.5, + ), + ), + 'primary key' => array('rid'), + ); + return $schema; +} + +/** + * Implementation of hook_install(). + */ +function xmlsitemap_user_install() { + drupal_install_schema('xmlsitemap_user'); + db_query("UPDATE {system} SET weight = 10 WHERE name = 'xmlsitemap_user'"); +} + +/** + * Implementation of hook_update_N(). + */ +function xmlsitemap_user_update_6100() { + $ret = array(); + if (db_table_exists('xmlsitemap_user')) { + if (db_column_exists('xmlsitemap_user', 'pid')) { + $result = array(); + @db_drop_index($result, 'xmlsitemap_user', 'pid'); + if ($result[0]['success']) { + $ret = $result[0]; + } + db_drop_field($ret, 'xmlsitemap_user', 'pid'); + } + if (db_column_exists('xmlsitemap_user', 'uid')) { + $result = array(); + @db_drop_primary_key($result, 'xmlsitemap_user'); + if ($result[0]['success']) { + $ret[] = $result[0]; + } + db_change_field($ret, 'xmlsitemap_user', 'uid', 'uid', + array( + 'description' => 'The user ID.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + array('primary key' => array('uid')) + ); + } + if (db_column_exists('xmlsitemap_user', 'last_changed')) { + db_change_field($ret, 'xmlsitemap_user', 'last_changed', 'changed', + array( + 'description' => 'The Unix timestamp of the last change.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ) + ); + } + else { + if (db_column_exists('xmlsitemap_user', 'changed')) { + db_change_field($ret, 'xmlsitemap_user', 'changed', 'changed', + array( + 'description' => 'The Unix timestamp of the last change.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ) + ); + } + else { + db_add_field($ret, 'xmlsitemap_user', 'changed', + array( + 'description' => 'The Unix timestamp of the last change.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ) + ); + } + } + if (!db_column_exists('xmlsitemap_user', 'comments')) { + db_add_field($ret, 'xmlsitemap_user', 'comments', + array( + 'description' => 'The number of comments authored from the user.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ) + ); + } + $ret[] = update_sql("UPDATE {xmlsitemap_user} + SET priority_override = -2.0 + WHERE priority_override IS NULL" + ); + db_change_field($ret, 'xmlsitemap_user', 'priority_override', 'priority_override', + array( + 'description' => 'The priority of the term in the sitemap.', + 'type' => 'float', + 'not null' => TRUE, + 'default' => -2.0, + ) + ); + } + else { + db_create_table($ret, 'xmlsitemap_user', + array( + 'description' => 'The base table for xmlsitemap_user.', + 'fields' => array( + 'uid' => array( + 'description' => 'The user ID.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'changed' => array( + 'description' => 'The Unix timestamp of the last change.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'previously_changed' => array( + 'description' => 'The Unix timestamp of the previous change.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'comments' => array( + 'description' => 'The number of comments authored from the user.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'priority_override' => array( + 'description' => 'The priority of the term in the sitemap.', + 'type' => 'float', + 'not null' => TRUE, + 'default' => -2.0, + ), + ), + 'primary key' => array('uid'), + ) + ); + } + if (db_table_exists('xmlsitemap_user_role')) { + if (db_column_exists('xmlsitemap_user_role', 'pid')) { + $result = array(); + @db_drop_index($result, 'xmlsitemap_user_role', 'pid'); + if ($result[0]['success']) { + $ret = $result[0]; + } + db_drop_field($ret, 'xmlsitemap_user_role', 'pid'); + } + $result = array(); + @db_drop_primary_key($result, 'xmlsitemap_user_role'); + if ($result[0]['success']) { + $ret[] = $result[0]; + } + db_change_field($ret, 'xmlsitemap_user_role', 'rid', 'rid', + array( + 'description' => 'The role ID.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + array('primary key' => array('rid')) + ); + $ret[] = update_sql("UPDATE {xmlsitemap_user_role} + SET priority = 0.5 + WHERE priority IS NULL" + ); + db_change_field($ret, 'xmlsitemap_user_role', 'priority', 'priority', + array( + 'description' => t('The priority assigned to the role.'), + 'type' => 'float', + 'not null' => TRUE, + 'default' => 0.5, + ) + ); + db_change_field($ret, 'xmlsitemap_user_role', 'priority', 'priority', + array( + 'description' => t('The priority assigned to the role.'), + 'type' => 'float', + 'not null' => TRUE, + 'default' => 0.5, + ) + ); + } + else { + db_create_table($ret, 'xmlsitemap_user_role', + array( + 'description' => 'The base table for xmlsitemap.', + 'fields' => array( + 'rid' => array( + 'description' => 'The role ID.', + 'type' => 'int', + 'unsigned' => TRUE, + 'not null' => TRUE, + 'default' => 0, + ), + 'priority' => array( + 'description' => t('The priority assigned to the role.'), + 'type' => 'float', + 'not null' => TRUE, + 'default' => 0.5, + ), + ), + 'primary key' => array('rid'), + ) + ); + } + return $ret; +} + +/** + * Implementation of hook_update_N(). + * + */ +function xmlsitemap_user_update_6113() { + $ret[] = update_sql("UPDATE {system} SET weight = 10 WHERE name = 'xmlsitemap_user'"); + return $ret; +} + +/** + * Implementation of hook_uninstall(). + */ +function xmlsitemap_user_uninstall() { + drupal_uninstall_schema('xmlsitemap_user'); +}