Make WordPress Core


Ignore:
Timestamp:
07/20/2003 08:43:48 PM (22 years ago)
Author:
mikelittle
Message:

Fixed error with table changes
backquotes do't work on older versions of mysql

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-admin/b2-2-wp.php

    r228 r261  
    11<?php
     2$_wp_installing = 1;
    23require_once('../wp-config.php');
    34
     
    201202$query = "ALTER TABLE $tableposts ADD COLUMN post_excerpt text NOT NULL;";
    202203$q = $wpdb->query($query);
    203 $query = "ALTER TABLE $tableposts ADD `post_status` ENUM('publish','draft','private') NOT NULL,
    204 ADD `comment_status` ENUM('open','closed') NOT NULL,
    205 ADD `ping_status` ENUM('open','closed') NOT NULL,
     204$query = "ALTER TABLE $tableposts ADD post_status ENUM('publish','draft','private') NOT NULL,
     205ADD comment_status ENUM('open','closed') NOT NULL,
     206ADD ping_status ENUM('open','closed') NOT NULL,
    206207ADD post_password varchar(20) NOT NULL;";
    207208$q = $wpdb->query($query);
     
    211212
    212213<?php
    213 $query = "ALTER TABLE $tableposts DROP INDEX `ID`";
     214$query = "ALTER TABLE $tableposts DROP INDEX ID";
    214215
    215216$q = $wpdb->query($query);
     
    220221<?php
    221222
    222 $query="ALTER TABLE $tablesettings DROP INDEX `ID`";
     223$query="ALTER TABLE $tablesettings DROP INDEX ID";
    223224$q = $wpdb->query($query);
    224225
     
    228229<?php
    229230
    230 $query="ALTER TABLE $tableposts DROP `post_karma`";
     231$query="ALTER TABLE $tableposts DROP post_karma";
    231232$q = $wpdb->query($query);
    232233
     
    237238<?php
    238239
    239 $query = "ALTER TABLE $tableusers DROP INDEX `ID`";
     240$query = "ALTER TABLE $tableusers DROP INDEX ID";
    240241
    241242$q = $wpdb->query($query);
Note: See TracChangeset for help on using the changeset viewer.