Re: [DOC-WEB] svn: /web/doc-editor/trunk/install/ doc-editor.sql

Hi Philip,

I have work on the speed of MySQL a lot this last hours.

I have made a lot of change and I need some time to test it.

First, can you apply this change to the online version as it touch the 
database ?

I will answer your mail into phpdoc list later.

PS : If you want to review the documentation of the editor into the wiki (I 
haven't finish yep, there is steel the "Main Menu" section to write), do it ;) 
My english is always so poor ;)

Best,

Yannick

Le lundi 14 décembre 2009 07:45:48, Yannick Torres a écrit :
> yannick                                  Mon, 14 Dec 2009 06:45:48 +0000
> 
> Revision: http://svn.php.net/viewvc?view=revision&revision=292111
> 
> Log:
> Add new table to store staticValue to speed up MySql
> 
> Changed paths:
>     U   web/doc-editor/trunk/install/doc-editor.sql
> 
> Modified: web/doc-editor/trunk/install/doc-editor.sql
> ===================================================================
> --- web/doc-editor/trunk/install/doc-editor.sql	2009-12-14 05:52:49 UTC
>  (rev 292110) +++ web/doc-editor/trunk/install/doc-editor.sql	2009-12-14
>  06:45:48 UTC (rev 292111) @@ -11,6 +11,20 @@
>  -- Structure of table `commitMessage`
>  --
> 
> +CREATE TABLE IF NOT EXISTS `staticValue` (
> +  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
> +  `type` varchar(50) NOT NULL,
> +  `field` varchar(50) NOT NULL,
> +  `value` text NOT NULL,
> +  KEY `id` (`id`)
> +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
> +
> +-- --------------------------------------------------------
> +
> +--
> +-- Structure of table `commitMessage`
> +--
> +
>  CREATE TABLE IF NOT EXISTS `commitMessage` (
>    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
>    `project` varchar(255) NOT NULL,
>