DB schema

  • Upgraded from b2 to Word Press last night. Everything seemed to go well except the tables “b2links” and “b2linkcategories” don’t exist, generating an error in the default template. Can someone give me the schema of those two tables so I can just go into my DB manager and create them manually? Actually, I’ve already got the fieldnames of “b2links” from the error message, I just need datatypes for that one.

Viewing 2 replies - 1 through 2 (of 2 total)

  • CREATE TABLE wp_linkcategories (
    cat_id int(11) NOT NULL auto_increment,
    cat_name tinytext NOT NULL,
    auto_toggle enum('Y','N') NOT NULL default 'N',
    show_images enum('Y','N') NOT NULL default 'Y',
    show_description enum('Y','N') NOT NULL default 'N',
    show_rating enum('Y','N') NOT NULL default 'Y',
    show_updated enum('Y','N') NOT NULL default 'Y',
    sort_order varchar(64) NOT NULL default 'name',
    sort_desc enum('Y','N') NOT NULL default 'N',
    text_before_link varchar(128) NOT NULL default '

    • ',
      text_after_link varchar(128) NOT NULL default '
      ',
      text_after_all varchar(128) NOT NULL default '

      • ',
      list_limit int(11) NOT NULL default '-1',
      PRIMARY KEY (cat_id)
      ) TYPE=MyISAM;
      and
      CREATE TABLE wp_links (
      link_id int(11) NOT NULL auto_increment,
      link_url varchar(255) NOT NULL default '',
      link_name varchar(255) NOT NULL default '',
      link_image varchar(255) NOT NULL default '',
      link_target varchar(25) NOT NULL default '',
      link_category int(11) NOT NULL default '0',
      link_description varchar(255) NOT NULL default '',
      link_visible enum('Y','N') NOT NULL default 'Y',
      link_owner int(11) NOT NULL default '1',
      link_rating int(11) NOT NULL default '0',
      link_updated datetime NOT NULL default '0000-00-00 00:00:00',
      link_rel varchar(255) NOT NULL default '',
      link_notes mediumtext NOT NULL,
      link_rss varchar(255) NOT NULL default '',
      PRIMARY KEY (link_id),
      KEY link_category (link_category),
      KEY link_visible (link_visible)
      ) TYPE=MyISAM;
      ought to do you.

    Thread Starter junyo

    (@junyo)

    That did it, thanx.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘DB schema’ is closed to new replies.