[wp-testers] adding info to schema.php

Phibrz naudirz at gmail.com
Sun May 27 21:03:17 GMT 2007


Hi!

There needs to be more data in \wp-admin\includes\schema.php
can someone add it to the latest SVN?

CREATE TABLE $wpdb->post2cat (
  rel_id bigint(20) NOT NULL auto_increment,
  post_id bigint(20) NOT NULL default '0',
  category_id bigint(20) NOT NULL default '0',
  PRIMARY KEY  (rel_id),
  KEY post_id (post_id,category_id)
) $charset_collate;
CREATE TABLE $wpdb->link2cat (
  rel_id bigint(20) NOT NULL auto_increment,
  link_id bigint(20) NOT NULL default '0',
  category_id bigint(20) NOT NULL default '0',
  PRIMARY KEY  (rel_id),
  KEY link_id (link_id,category_id)
) $charset_collate;
CREATE TABLE $wpdb->categories (
  cat_ID bigint(20) NOT NULL auto_increment,
  cat_name varchar(55) NOT NULL default '',
  category_nicename varchar(200) NOT NULL default '',
  category_description longtext NOT NULL,
  category_parent bigint(20) NOT NULL default '0',
  category_count bigint(20) NOT NULL default '0',
  link_count bigint(20) NOT NULL default '0',
  posts_private tinyint(1) NOT NULL default '0',
  links_private tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (cat_ID),
  KEY category_nicename (category_nicename)
) $charset_collate;

RGDS Phibrz


More information about the wp-testers mailing list