svn: /web/doc-editor/trunk/install/ doc-editor.sql

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,