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

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 ;