function twitter_update_6300 in Twitter 6.3
Same name and namespace in other branches
- 6.5 twitter.install \twitter_update_6300()
- 6.4 twitter.install \twitter_update_6300()
Update from 2.x to 3.x
File
- ./
twitter.install, line 521
Code
function twitter_update_6300() {
$ret = array();
// add additional fields to {twitter_account}
db_add_field($ret, 'twitter_account', 'uid', array(
'description' => t("The {users}.uid of the owner of this account"),
'type' => 'int',
'unsigned' => TRUE,
'size' => 'big',
'not null' => TRUE,
));
db_add_field($ret, 'twitter_account', 'host', array(
'description' => t('The host for this account can be a laconi.ca instance'),
'type' => 'varchar',
'length' => 255,
));
db_add_field($ret, 'twitter_account', 'password', array(
'description' => t("The password for the Twitter account."),
'type' => 'varchar',
'length' => 64,
));
db_add_field($ret, 'twitter_account', 'oauth_token', array(
'description' => t('The token_key for oauth-based access.'),
'type' => 'varchar',
'length' => 64,
));
db_add_field($ret, 'twitter_account', 'oauth_token_secret', array(
'description' => t('The token_secret for oauth-based access.'),
'type' => 'varchar',
'length' => 64,
));
db_add_field($ret, 'twitter_account', 'friends_count', array(
'description' => t("The number of users this {twitter_account} is following."),
'type' => 'int',
'not null' => TRUE,
'default' => 0,
));
db_add_field($ret, 'twitter_account', 'statuses_count', array(
'description' => t("The total number of status updates performed by a user, excluding direct messages sent."),
'type' => 'int',
'not null' => TRUE,
'default' => 0,
));
db_add_field($ret, 'twitter_account', 'favourites_count', array(
'description' => t("The number of statuses a user has marked as favorite."),
'type' => 'int',
'not null' => TRUE,
'default' => 0,
));
db_add_field($ret, 'twitter_account', 'profile_background_color', array(
'description' => t("hex RGB value for a user's background color"),
'type' => 'varchar',
'length' => 6,
'not null' => TRUE,
'default' => '',
));
db_add_field($ret, 'twitter_account', 'profile_text_color', array(
'description' => t("hex RGB value for a user's text color"),
'type' => 'varchar',
'length' => 6,
'not null' => TRUE,
'default' => '',
));
db_add_field($ret, 'twitter_account', 'profile_link_color', array(
'description' => t("hex RGB value for a user's link color"),
'type' => 'varchar',
'length' => 6,
'not null' => TRUE,
'default' => '',
));
db_add_field($ret, 'twitter_account', 'profile_sidebar_fill_color', array(
'description' => t("hex RGB value for a user's sidebar color"),
'type' => 'varchar',
'length' => 6,
'not null' => TRUE,
'default' => '',
));
db_add_field($ret, 'twitter_account', 'profile_sidebar_border_color', array(
'description' => t("hex RGB value for a user's border color"),
'type' => 'varchar',
'length' => 6,
'not null' => TRUE,
'default' => '',
));
db_add_field($ret, 'twitter_account', 'profile_background_image_url', array(
'description' => t("The url of the {twitter_account}'s profile image."),
'type' => 'varchar',
'length' => 255,
));
db_add_field($ret, 'twitter_account', 'profile_background_tile', array(
'description' => t("Boolean indicating if a user's background is tiled."),
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 1,
));
db_add_field($ret, 'twitter_account', 'verified', array(
'description' => t("Indicates if a user is verified."),
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 1,
));
db_add_field($ret, 'twitter_account', 'created_at', array(
'description' => t("Date and time the {twitter_account} was created."),
'type' => 'varchar',
'length' => 64,
'not null' => TRUE,
'default' => '',
));
db_add_field($ret, 'twitter_account', 'created_time', array(
'description' => t("A duplicate of {twitter_account}.created_at in UNIX timestamp format."),
'type' => 'int',
'not null' => TRUE,
));
db_add_field($ret, 'twitter_account', 'utc_offset', array(
'description' => t("A duplicate of {twitter_account}.created_at in UNIX timestamp format."),
'type' => 'int',
'not null' => TRUE,
));
db_add_field($ret, 'twitter_account', 'import', array(
'description' => t("Boolean flag indicating whether the {twitter_user}'s posts should be pulled in by the site."),
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 1,
));
db_add_field($ret, 'twitter_account', 'is_global', array(
'description' => t("Boolean flag indicating if this account is available for global use"),
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
));
if (db_table_exists('twitter_user')) {
$result = db_query("SELECT * FROM {twitter_user} ORDER BY uid DESC");
while ($row = db_fetch_array($result)) {
db_query("UPDATE {twitter_account} SET uid=%d, password='%s', import=%d WHERE screen_name='%s'", $row['uid'], $row['password'], $row['import'], $row['screen_name']);
}
db_drop_table($ret, 'twitter_user');
}
drupal_install_modules(array(
'twitter_post',
));
return $ret;
}