patch_0_6_0.sql

来自「一个页面界面的邮件程序」· SQL 代码 · 共 25 行

ALTER TABLE `person` 
ADD FULLTEXT `search` (
`lastname` ,
`firstname` ,
`note`
);

ALTER TABLE `contact` 
ADD FULLTEXT `search` (
`value` ,
`note`
);

ALTER TABLE `contact` ADD INDEX ( `value` );

ALTER TABLE `address` 
ADD FULLTEXT `search` (
`street` ,
`street_next` ,
`zipcode` ,
`town` ,
`country` ,
`note`
);