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

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

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