[Erp5-report] r10033 - /erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/

[nobody at svn.erp5.org]

Author: jp
Date: Sun Sep 17 13:58:33 2006
New Revision: 10033

URL: http://svn.erp5.org?rev=10033&view=rev
Log:
Extended parameters (maybe useful)

Modified:
    erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_catalog_cps.zsql
    erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_create_cps.zsql
    erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_update_cps.zsql

Modified: erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_catalog_cps.zsql
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_catalog_cps.zsql?rev=10033&r1=10032&r2=10033&view=diff
==============================================================================
--- erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_catalog_cps.zsql (original)
+++ erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_catalog_cps.zsql Sun Sep 17 13:58:33 2006
@@ -8,6 +8,8 @@
 class_file:
 </dtml-comment>
 <params>uid
+PrincipiaSearchSource
+SearchableText
 Title
 start
 end
@@ -20,6 +22,8 @@
   cps
 SET
   uid = <dtml-sqlvar uid type="int">,
+  PrincipiaSearchSource=<dtml-sqlvar PrincipiaSearchSource type="string">,
+  SearchableText=<dtml-sqlvar SearchableText  type="string">,
   ZCTitle = <dtml-sqlvar Title type="string">,
   start = <dtml-sqlvar start type="string">,
   end = <dtml-sqlvar end type="string">,

Modified: erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_create_cps.zsql
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_create_cps.zsql?rev=10033&r1=10032&r2=10033&view=diff
==============================================================================
--- erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_create_cps.zsql (original)
+++ erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_create_cps.zsql Sun Sep 17 13:58:33 2006
@@ -22,6 +22,8 @@
   `time` datetime default '0000-00-00 00:00:00',
   `relative_path_depth` int(11) default NULL,
   `container_path` varchar(255) default NULL,
+  `PrincipiaSearchSource` text,
+  `SearchableText` text,
   KEY  (`uid`),
   KEY `start` (`start`),
   KEY `leaves` (`leaves`),
@@ -29,5 +31,8 @@
   KEY `time` (`time`),
   KEY `searchable` (`searchable`),
   KEY `end` (`end`),
-  KEY `container_path` (`container_path`)
-) TYPE=InnoDB;
+  KEY `container_path` (`container_path`),
+  FULLTEXT KEY `PrincipiaSearchSource` (`PrincipiaSearchSource`),
+  FULLTEXT KEY `SearchableText` (`SearchableText`),
+  FULLTEXT KEY `ZCTitle` (`ZCTitle`)
+) TYPE=MyISAM;

Modified: erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_update_cps.zsql
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_update_cps.zsql?rev=10033&r1=10032&r2=10033&view=diff
==============================================================================
--- erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_update_cps.zsql (original)
+++ erp5/trunk/products/ERP5Catalog/sql/cps3_mysql/z_update_cps.zsql Sun Sep 17 13:58:33 2006
@@ -8,6 +8,8 @@
 class_file:
 </dtml-comment>
 <params>uid
+PrincipiaSearchSource
+SearchableText
 Title
 start
 end
@@ -19,6 +21,8 @@
 UPDATE 
   cps
 SET
+  PrincipiaSearchSource=<dtml-sqlvar PrincipiaSearchSource type="string">,
+  SearchableText=<dtml-sqlvar SearchableText  type="string">,
   ZCTitle = <dtml-sqlvar Title type="string">,
   start = <dtml-sqlvar start type="string">,
   end = <dtml-sqlvar end type="string">,