Subversion Repositories ALCASAR

Rev

Rev 426 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 426 Rev 828
Line 313... Line 313...
313 
DROP TABLE IF EXISTS `userinfo`;
 313 
DROP TABLE IF EXISTS `userinfo`;
314 
SET @saved_cs_client     = @@character_set_client;
 314 
SET @saved_cs_client     = @@character_set_client;
315 
SET character_set_client = utf8;
 315 
SET character_set_client = utf8;
316 
CREATE TABLE `userinfo` (
 316 
CREATE TABLE `userinfo` (
317 
  `id` int(10) NOT NULL auto_increment,
 317 
  `id` int(10) NOT NULL auto_increment,
318 
  `UserName` varchar(30) collate utf8_unicode_ci default NULL,
 318 
  `UserName` varchar(64) collate utf8_unicode_ci default NULL,
319 
  `Name` varchar(200) collate utf8_unicode_ci default NULL,
 319 
  `Name` varchar(200) collate utf8_unicode_ci default NULL,
320 
  `Mail` varchar(200) collate utf8_unicode_ci default NULL,
 320 
  `Mail` varchar(200) collate utf8_unicode_ci default NULL,
321 
  `Department` varchar(200) collate utf8_unicode_ci default NULL,
 321 
  `Department` varchar(200) collate utf8_unicode_ci default NULL,
322 
  `WorkPhone` varchar(200) collate utf8_unicode_ci default NULL,
 322 
  `WorkPhone` varchar(200) collate utf8_unicode_ci default NULL,
323 
  `HomePhone` varchar(200) collate utf8_unicode_ci default NULL,
 323 
  `HomePhone` varchar(200) collate utf8_unicode_ci default NULL,