aboutsummaryrefslogtreecommitdiffstats
path: root/install/phpwebgallery_structure.sql
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2006-01-20 14:34:37 +0000
committerplegall <plg@piwigo.org>2006-01-20 14:34:37 +0000
commit7b2ff328cb31b60e52ab90102d519966258917a1 (patch)
tree6af75e3709ce521ddd36c8bb6216a7363d3c9fa4 /install/phpwebgallery_structure.sql
parent9410522e9f7d077bb4830158b6f01276a55276b3 (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.sql12
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`
--