folder_search.sql.svn-base

来自「PHP 知识管理系统（基于树结构的知识管理系统）, 英文原版的PHP源码。」· SVN-BASE 代码 · 共 12 行

CREATE TABLE folder_searchable_text (
    `folder_id`   INT(11) NOT NULL DEFAULT 0,
    PRIMARY KEY(folder_id),
    `folder_text` text,
    KEY `folder_searchable_text_folder_indx` (`folder_id`),
    FULLTEXT KEY `folder_text` (`folder_text`)
) Type=MyISAM;

-- generate the data

insert into folder_searchable_text (folder_id, folder_text) SELECT id, name from folders;