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

From: 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

« previous php.doc.web (#1835) next »