• Hello,

    Does the DB get upgrade when the file upgrade.php gets run?. i am having some issue with my db, which will be backing up tonight when i get home. thinking of doing a clean install of wp 2.0 and than reloading the content of the db. i will test this locally first and see if it work fine. since the problem i am having is user level permissions.

    thanks
    victor

Viewing 3 replies - 1 through 3 (of 3 total)
  • Yes, it does.

    Are the changes to the DB during the upgrade documented anywhere?

    diff tags/1.5.2/wp-admin/upgrade-schema.php trunk/wp-admin/upgrade-schema.php
    9c9,10
    < category_parent int(4) NOT NULL default '0',
    ---
    > category_parent bigint(20) NOT NULL default '0',
    > category_count bigint(20) NOT NULL default '0',
    27,28c28,29
    < comment_parent int(11) NOT NULL default '0',
    < user_id int(11) NOT NULL default '0',
    ---
    > comment_parent bigint(20) NOT NULL default '0',
    > user_id bigint(20) NOT NULL default '0',
    55c56
    < link_category int(11) NOT NULL default '0',
    ---
    > link_category bigint(20) NOT NULL default '0',
    94c95
    < meta_value text,
    ---
    > meta_value longtext,
    101c102
    < post_author int(4) NOT NULL default '0',
    ---
    > post_author bigint(20) NOT NULL default '0',
    108c109
    < post_status enum('publish','draft','private','static','object') NOT NULL default 'publish',
    ---
    > post_status enum('publish','draft','private','static','object','attachment') NOT NULL default 'publish',
    118c119
    < post_parent int(11) NOT NULL default '0',
    ---
    > post_parent bigint(20) NOT NULL default '0',
    120a122,124
    > post_type varchar(100) NOT NULL,
    > post_mime_type varchar(100) NOT NULL,
    > comment_count bigint(20) NOT NULL default '0',
    128,130d131
    < user_firstname varchar(50) NOT NULL default '',
    < user_lastname varchar(50) NOT NULL default '',
    < user_nickname varchar(50) NOT NULL default '',
    132d132
    < user_icq int(10) unsigned NOT NULL default '0',
    135,137d134
    < user_ip varchar(15) NOT NULL default '',
    < user_domain varchar(200) NOT NULL default '',
    < user_browser varchar(200) NOT NULL default '',
    139,143d135
    < user_level int(2) unsigned NOT NULL default '0',
    < user_aim varchar(50) NOT NULL default '',
    < user_msn varchar(100) NOT NULL default '',
    < user_yim varchar(50) NOT NULL default '',
    < user_idmode varchar(20) NOT NULL default '',
    146c138
    < user_description longtext NOT NULL default '',
    ---
    > display_name varchar(250) NOT NULL default '',
    148c140,149
    < UNIQUE KEY user_login (user_login)
    ---
    > KEY user_login_key (user_login)
    > );
    > CREATE TABLE $wpdb->usermeta (
    > umeta_id bigint(20) NOT NULL auto_increment,
    > user_id bigint(20) NOT NULL default '0',
    > meta_key varchar(255) default NULL,
    > meta_value longtext,
    > PRIMARY KEY (umeta_id),
    > KEY user_id (user_id),
    > KEY meta_key (meta_key)

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Does the DB get upgrade when the file upgrade.php gets run?’ is closed to new replies.