make the searchindex table myisam, it has no use for ACID

diff --git a/schema/bse.sql b/schema/bse.sql
index d92d36cc15c0bcc131272ac7affa724f659e880a..eddf4f482245bdde43d355eb9b6d5976a108593f 100644 (file)
--- a/schema/bse.sql
+++ b/schema/bse.sql
@@ -136,7 +136,7 @@ CREATE TABLE searchindex (
   sectionIds varchar(255) default '' not null,
   scores varchar(255) default '' not null,
   PRIMARY KEY (id)
-);
+) engine=myisam;
 
 #
 # Table structure for table 'image'

diff --git a/site/util/mysql.str b/site/util/mysql.str
index 1c92b3bdf0a5e0276a7f95cdb937375e77d3e0bd..f122d056aa7a0e740afe7b3400a29872e3f8196c 100644 (file)
--- a/site/util/mysql.str
+++ b/site/util/mysql.str
@@ -716,7 +716,7 @@ Column width;int(11);NO;0;
 Column height;int(11);NO;0;
 Index PRIMARY;1;[articleId]
 Table searchindex
-Engine InnoDB
+Engine MyISAM
 Column id;varbinary(200);NO;;
 Column articleIds;varchar(255);NO;;
 Column sectionIds;varchar(255);NO;;