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

yannick                                  Wed, 28 Apr 2010 21:34:47 +0000

Revision: http://svn.php.net/viewvc?view=revision&revision=298735

Log:
Add the structure of a new table : progressWork. Note 2 tables as deprecated.

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	2010-04-28 21:05:12 UTC (rev 298734)
+++ web/doc-editor/trunk/install/doc-editor.sql	2010-04-28 21:34:47 UTC (rev 298735)
@@ -106,7 +106,7 @@
 -- --------------------------------------------------------

 --
--- Structure of table `pendingCommit`
+-- Structure of table `pendingCommit` // @TODO : DEPRECATED. Need to be remove.
 --

 CREATE TABLE IF NOT EXISTS `pendingCommit` (
@@ -128,7 +128,7 @@
 -- --------------------------------------------------------

 --
--- Structure of table `pendingPatch`
+-- Structure of table `pendingPatch` // @TODO : DEPRECATED. Need to be remove.
 --

 CREATE TABLE IF NOT EXISTS `pendingPatch` (
@@ -221,4 +221,29 @@
   `user` varchar(50) NOT NULL,
   `date` datetime NOT NULL,
   PRIMARY KEY (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure of table `progressWork`
+--
+
+CREATE TABLE IF NOT EXISTS `progressWork` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `project` varchar(255) NOT NULL,
+  `lang` varchar(10) NOT NULL,
+  `path` varchar(255) NOT NULL,
+  `name` varchar(255) NOT NULL,
+  `revision` int(11) NOT NULL,
+  `en_revision` int(11) NOT NULL,
+  `reviewed` varchar(50) NOT NULL,
+  `maintainer` varchar(255) NOT NULL,
+  `user` varchar(255) NOT NULL,
+  `email` varchar(255) NOT NULL,
+  `date` datetime NOT NULL,
+  `type` enum('new','delete','update','patch') NOT NULL,
+  `in_progress` smallint(6) unsigned DEFAULT '100',
+  KEY `id` (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
\ No newline at end of file