[Erp5-report] r7805 - /erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/

[nobody at svn.erp5.org]

Author: kevin
Date: Fri Jun 16 10:02:56 2006
New Revision: 7805

URL: http://svn.erp5.org?rev=7805&view=rev
Log:
Add new fulltext tables

Added:
    erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_drop_fulltext.zsql
    erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_uncatalog_fulltext.zsql
    erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_catalog_fulltext_list.zsql
    erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_create_fulltext.zsql

Added: erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_drop_fulltext.zsql
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_drop_fulltext.zsql?rev=7805&view=auto
==============================================================================
--- erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_drop_fulltext.zsql (added)
+++ erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_drop_fulltext.zsql Fri Jun 16 10:02:56 2006
@@ -1,0 +1,11 @@
+<dtml-comment>
+title:
+connection_id:erp5_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params></params>
+DROP TABLE full_text

Added: erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_uncatalog_fulltext.zsql
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_uncatalog_fulltext.zsql?rev=7805&view=auto
==============================================================================
--- erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_uncatalog_fulltext.zsql (added)
+++ erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z0_uncatalog_fulltext.zsql Fri Jun 16 10:02:56 2006
@@ -1,0 +1,11 @@
+<dtml-comment>
+title:
+connection_id:erp5_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>uid</params>
+DELETE FROM full_text WHERE <dtml-sqltest uid op=eq type=int>

Added: erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_catalog_fulltext_list.zsql
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_catalog_fulltext_list.zsql?rev=7805&view=auto
==============================================================================
--- erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_catalog_fulltext_list.zsql (added)
+++ erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_catalog_fulltext_list.zsql Fri Jun 16 10:02:56 2006
@@ -1,0 +1,24 @@
+<dtml-comment>
+title:
+connection_id:erp5_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>uid
+SearchableText</params>
+REPLACE INTO
+  full_text
+VALUES
+<dtml-in prefix="loop" expr="_.range(_.len(uid))">
+(
+  <dtml-sqlvar expr="uid[loop_item]" type="int">,  
+  <dtml-sqlvar expr="SearchableText[loop_item]" type="string" optional>
+)
+<dtml-if sequence-end>
+<dtml-else>
+,
+</dtml-if>
+</dtml-in>

Added: erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_create_fulltext.zsql
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_create_fulltext.zsql?rev=7805&view=auto
==============================================================================
--- erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_create_fulltext.zsql (added)
+++ erp5/trunk/products/ERP5Catalog/sql/erp5_mysql/z_create_fulltext.zsql Fri Jun 16 10:02:56 2006
@@ -1,0 +1,20 @@
+<dtml-comment>
+title:
+connection_id:erp5_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params></params>
+# Host:
+# Database: test
+# Table: 'full_text'
+#
+CREATE TABLE `full_text` (
+  `uid` BIGINT UNSIGNED NOT NULL,
+  `SearchableText` text,
+  PRIMARY KEY  (`uid`),
+  FULLTEXT `SearchableText` (`SearchableText`)
+);