svn: /web/doc-editor/trunk/install/ doc-editor.sql
| From: | Yannick Torres | Date: | Wed, 28 Apr 2010 21:34:47 +0000 |
| Subject: | svn: /web/doc-editor/trunk/install/ doc-editor.sql | ||
| Groups: | php.doc.web | ||
| Request: | Send a blank email to doc-web+get-1835@lists.php.net to get a copy of this message | ||
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