diff options
| author | plegall <plg@piwigo.org> | 2006-01-20 14:34:37 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2006-01-20 14:34:37 +0000 |
| commit | 7b2ff328cb31b60e52ab90102d519966258917a1 (patch) | |
| tree | 6af75e3709ce521ddd36c8bb6216a7363d3c9fa4 /install/phpwebgallery_structure.sql | |
| parent | 9410522e9f7d077bb4830158b6f01276a55276b3 (diff) | |
Search engine redesign, first part :
- new table #search to store search rules associated to a search id.
- search rules are not passed through GET anymore, the search array build in
search.php is serialized in #search table, so no need to rebuild it in
function include/functions_category.inc.php::category_initialize
- search array build code is improved (efficiency and layout) in search.php
- SQL related to search is build in a dedicated function
include/functions::get_sql_search_clause
- direct search author:<...>, date_avalaible:<...>, date_creation:<...>,
keywords:<...> from picture.php are not available anymore. They will come
back later, with improvement (new design). Same for date_*:<> in calendar
calendar category.
git-svn-id: http://piwigo.org/svn/trunk@1008 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 12a27c00d..9e50885f6 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -177,6 +177,18 @@ CREATE TABLE `phpwebgallery_rate` ( ) TYPE=MyISAM; -- +-- Table structure for table `phpwebgallery_search` +-- + +DROP TABLE IF EXISTS `phpwebgallery_search`; +CREATE TABLE `phpwebgallery_search` ( + `id` int(10) unsigned NOT NULL auto_increment, + `last_seen` date default NULL, + `rules` text, + PRIMARY KEY (`id`) +) TYPE=MyISAM; + +-- -- Table structure for table `phpwebgallery_sessions` -- |