Changeset 768

Show
Ignore:
Timestamp:
01/12/04 22:27:22 (5 years ago)
Author:
emc3
Message:

create comment_approved column before making the index

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/wp-admin/upgrade-functions.php

    r763 r768  
    494494    maybe_add_column($tablelinks, 'link_rss', "ALTER TABLE `$tablelinks` ADD `link_rss` VARCHAR( 255 ) NOT NULL;"); 
    495495    maybe_add_column($tableusers, 'user_description', "ALTER TABLE `$tableusers` ADD `user_description` TEXT NOT NULL"); 
     496    maybe_add_column($tablecomments, 'comment_approved', "ALTER TABLE $tablecomments ADD COLUMN comment_approved ENUM('0', '1') DEFAULT '1' NOT NULL"); 
    496497 
    497498    // Create indicies 
     
    500501    add_clean_index($tablecomments, 'comment_approved'); 
    501502 
    502     if (maybe_add_column($tablecomments, 'comment_approved', "ALTER TABLE $tablecomments ADD COLUMN comment_approved ENUM('0', '1') DEFAULT '1' NOT NULL")) { 
    503     } 
    504503 
    505504    // Options stuff