| /trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005022800.php |
|---|
| New file |
| 0,0 → 1,7 |
| <?php |
| if(!defined("PHORUM_ADMIN")) return; |
| $upgrade_queries[]="CREATE TABLE {$PHORUM['search_table']} ( message_id int(10) unsigned NOT NULL default '0', search_text mediumtext NOT NULL, PRIMARY KEY (message_id), FULLTEXT KEY search_text (search_text) ) TYPE=MyISAM"; |
| $upgrade_queries[]="insert into {$PHORUM['search_table']} select message_id, concat(author, ' | ', subject, ' | ', body) from {$PHORUM['message_table']}"; |
| ?> |