svn: /web/doc-editor/trunk/install/ doc-editor.sql
| From: | Alexander Moskaliov | Date: | Sat, 22 Oct 2011 17:46:12 +0000 |
| Subject: | svn: /web/doc-editor/trunk/install/ doc-editor.sql | ||
| Groups: | php.doc.web | ||
| Request: | Send a blank email to doc-web+get-2186@lists.php.net to get a copy of this message | ||
irker Sat, 22 Oct 2011 17:46:12 +0000
Revision: http://svn.php.net/viewvc?view=revision&revision=318323
Log:
Change codepage in sql sheme creator script to utf8, and add two missed fields to definition of
users table
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 2011-10-22 14:08:24 UTC (rev 318322)
+++ web/doc-editor/trunk/install/doc-editor.sql 2011-10-22 17:46:12 UTC (rev 318323)
@@ -20,7 +20,7 @@
date datetime NOT NULL,
PRIMARY KEY (id),
KEY id (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Structure of table staticValue
@@ -34,7 +34,7 @@
value LONGTEXT NOT NULL,
date datetime NOT NULL,
KEY id (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
@@ -48,7 +48,7 @@
text text NOT NULL,
user varchar(255) NOT NULL,
KEY id (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
@@ -67,7 +67,7 @@
value_lang varchar(255) NOT NULL,
type varchar(255) NOT NULL,
KEY id (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
@@ -101,7 +101,7 @@
check_noexamples int(11) DEFAULT NULL,
check_noerrors int(11) DEFAULT NULL,
KEY id (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
@@ -119,24 +119,28 @@
vcs varchar(255) NOT NULL,
editor varchar(255) NOT NULL,
KEY id (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure of table users
--
+ -> | authService | varchar(255) | NO | | VCS | |
+ -> | authServiceID | text | NO | | NULL | |
CREATE TABLE IF NOT EXISTS users (
userID int(10) unsigned NOT NULL AUTO_INCREMENT,
project varchar(255) NOT NULL,
+ authService varchar(255) NOT NULL DEFAULT 'VCS',
+ authServiceID text 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)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
@@ -150,7 +154,7 @@
log mediumtext NOT NULL,
date datetime NOT NULL,
PRIMARY KEY (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
@@ -167,7 +171,7 @@
lastUser varchar(255) NOT NULL,
lastDate datetime NOT NULL,
PRIMARY KEY (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
@@ -183,7 +187,7 @@
user varchar(50) NOT NULL,
date datetime NOT NULL,
PRIMARY KEY (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
@@ -210,7 +214,7 @@
module enum('workInProgress','PatchesForReview') NOT NULL,
patchID int(11) DEFAULT NULL,
KEY id (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Structure of table patches
@@ -226,4 +230,4 @@
anonymousIdent varchar(255) NOT NULL,
date datetime DEFAULT NULL,
PRIMARY KEY (id)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;