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

From: Date: Mon, 24 May 2010 19:51:38 +0000
Subject: svn: /web/doc-editor/trunk/install/ doc-editor.sql
Groups: php.doc.web 
Request: Send a blank email to doc-web+get-1848@lists.php.net to get a copy of this message
yannick Mon, 24 May 2010 19:51:38 +0000 Revision: http://svn.php.net/viewvc?view=revision&revision=299713 Log: Change tables before new version commit 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-05-24 19:18:26 UTC (rev 299712) +++ web/doc-editor/trunk/install/doc-editor.sql 2010-05-24 19:51:38 UTC (rev 299713) @@ -106,47 +106,6 @@ -- -------------------------------------------------------- -- --- Structure of table pendingCommit // @TODO : DEPRECATED. Need to be remove. --- - -CREATE TABLE IF NOT EXISTS pendingCommit ( - 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, - modified_by varchar(50) NOT NULL, - date datetime NOT NULL, - type enum('new','delete','update') NOT NULL, - KEY id (id) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; - --- -------------------------------------------------------- - --- --- Structure of table pendingPatch // @TODO : DEPRECATED. Need to be remove. --- - -CREATE TABLE IF NOT EXISTS pendingPatch ( - 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, - posted_by varchar(50) NOT NULL, - email varchar(255) NOT NULL, - uniqID varchar(255) NOT NULL, - date datetime NOT NULL, - KEY id (id) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; - --- -------------------------------------------------------- - --- -- Structure of table translators -- @@ -170,7 +129,10 @@ CREATE TABLE IF NOT EXISTS users ( userID int(10) unsigned NOT NULL AUTO_INCREMENT, + project varchar(255) NOT NULL, vcs_login varchar(255) NOT NULL, + email varchar(255) NOT NULL, + anonymousIdent varchar(255) NOT NULL, conf text NOT NULL, last_connect datetime NOT NULL, KEY userID (userID) @@ -227,10 +189,10 @@ -- -------------------------------------------------------- -- --- Structure of table progressWork +-- Structure of table work -- -CREATE TABLE IF NOT EXISTS progressWork ( +CREATE TABLE IF NOT EXISTS work ( id int(10) unsigned NOT NULL AUTO_INCREMENT, project varchar(255) NOT NULL, lang varchar(10) NOT NULL, @@ -241,9 +203,24 @@ reviewed varchar(50) NOT NULL, maintainer varchar(255) NOT NULL, user varchar(255) NOT NULL, - email varchar(255) NOT NULL, + anonymousIdent varchar(255) NOT NULL, date datetime NOT NULL, type enum('new','delete','update','patch') NOT NULL, - in_progress smallint(6) unsigned DEFAULT '100', + progress smallint(6) unsigned DEFAULT '100', + module enum('workInProgress','PatchesForReview') NOT NULL, + patchID int(11) DEFAULT NULL, KEY id (id) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; \ No newline at end of file +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; + +-- +-- Structure of table patches +-- + +CREATE TABLE IF NOT EXISTS patches ( + id int(10) unsigned NOT NULL AUTO_INCREMENT, + project varchar(255) NOT NULL, + name varchar(255) NOT NULL, + user varchar(255) NOT NULL, + anonymousIdent varchar(255) NOT NULL, + PRIMARY KEY (id) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; \ No newline at end of file

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