[Mantisbt-cvs] mantisbt/admin schema.php,1.10,1.11

[Victor B. <vb...@us...>]

Update of /cvsroot/mantisbt/mantisbt/admin
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv2580/admin

Modified Files:
	schema.php 
Log Message:
Fixed #6627: Very slow performance when filing a new issue or adding a note. (vboctor) - This problem and others are solved by queueing the emails and then sending them in a cronjob.  We still keep the option of sending the email synchronously (default behavour).

Index: schema.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/admin/schema.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- schema.php	17 May 2006 00:49:38 -0000	1.10
+++ schema.php	14 Aug 2006 08:32:57 -0000	1.11
@@ -315,4 +315,14 @@
              md5( mt_rand( 0, mt_getrandmax() ) + mt_rand( 0, mt_getrandmax() ) ) . md5( time() ) . "')" ) );
 $upgrade[] = Array('AlterColumnSQL', Array( config_get( 'mantis_bug_history_table' ), "old_value C(255) NOTNULL" ) );
 $upgrade[] = Array('AlterColumnSQL', Array( config_get( 'mantis_bug_history_table' ), "new_value C(255) NOTNULL" ) );
+
+$upgrade[] = Array('CreateTableSQL',Array(config_get('mantis_email_table'),"
+  email_id 		I  UNSIGNED NOTNULL PRIMARY AUTOINCREMENT,
+  email		 	C(64) NOTNULL DEFAULT \" '' \",
+  subject		C(250) NOTNULL DEFAULT \" '' \",
+  submitted 	T NOTNULL DEFAULT '1970-01-01 00:00:01',
+  metadata 		XS NOTNULL,
+  body 			XS NOTNULL
+  ",Array('mysql' => 'TYPE=MyISAM', 'pgsql' => 'WITHOUT OIDS')));
+$upgrade[] = Array('CreateIndexSQL',Array('idx_email_id',config_get('mantis_email_table'),'email_id'));
 ?>
\ No newline at end of file