Announcement

Collapse
No announcement yet.

recreate searchcore_text tables?

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

  • yo!ijob
    replied
    thank you

    Leave a comment:


  • Wayne Luke
    replied
    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
    ";

    Leave a comment:


  • yo!ijob
    started a topic [Forum] recreate searchcore_text tables?

    recreate searchcore_text tables?

    Hi,

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

    Does any one have the information?

    Cheers

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