Changeset 1008 for trunk/install/phpwebgallery_structure.sql

Timestamp:

Jan 20, 2006, 3:34:37 PM (18 years ago)

Author:

plg

Message:

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.

File:

• trunk/install/phpwebgallery_structure.sql (modified) (1 diff)

trunk/install/phpwebgallery_structure.sql

@@ -178 +178 @@
 
 --
+-- 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`
 --