Announcement

Collapse
No announcement yet.

recreate searchcore_text tables?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] recreate searchcore_text tables?

    Hi,

    I have deleted the searchcore_text table and want to recreate it.

    Does any one have the information?

    Cheers


  • #2
    You can find all the table definitions in the file install/mysql_schema.php.

    Code:
    CREATE TABLE " . TABLE_PREFIX . "searchcore (
        searchcoreid INT UNSIGNED NOT NULL AUTO_INCREMENT,
        contenttypeid INT UNSIGNED NOT NULL,
        primaryid INT UNSIGNED  NOT NULL,
        groupcontenttypeid INT UNSIGNED NOT NULL,
        groupid INT UNSIGNED NOT NULL DEFAULT 0,
        dateline INT UNSIGNED NOT NULL DEFAULT 0,
        userid INT UNSIGNED NOT NULL DEFAULT 0,
        username VARCHAR(100) NOT NULL,
        ipaddress INT UNSIGNED NOT NULL,
        searchgroupid INT UNSIGNED NOT NULL,
        PRIMARY KEY (searchcoreid),
        UNIQUE KEY contentunique (contenttypeid, primaryid),
        KEY groupid (groupcontenttypeid, groupid),
        KEY ipaddress (ipaddress),
        KEY dateline (dateline),
        KEY userid (userid),
        KEY searchgroupid (searchgroupid)
    )    ENGINE = INNODB
    ";
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      thank you

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X