svn: /web/doc-editor/trunk/install/ doc-editor.sql
| From: | Yannick Torres | 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