--
-- Host: localhost    Database: dicdb
-- ------------------------------------------------------


--
-- Table structure for table `userinfo`
--

CREATE TABLE `userinfo` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `login_name` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `login_pass` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `realname` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `u_email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `u_bday` date NOT NULL,
  `u_sex` tinyint(4) NOT NULL DEFAULT '0',
  `u_active` tinyint(4) NOT NULL DEFAULT '0',
  `u_regd` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `userinfo`
--

INSERT INTO `userinfo` VALUES (1,'4040cxxx','4040cxxx','鳥哥',NULL,'0000-00-00',1,0,'2017-12-12 08:30:40.421077'),(2,'4040c001','4040c001','薛品瑜',NULL,'0000-00-00',0,0,'2017-12-12 08:34:29.100923'),(3,'4040c002','4040c002','黃才容',NULL,'0000-00-00',0,0,'2017-12-12 08:34:38.189954'),(4,'4040c003','4040c003','程鈺凱',NULL,'0000-00-00',1,0,'2017-12-12 08:32:18.128960'),(5,'4040c004','4040c004','林育正',NULL,'0000-00-00',1,0,'2017-12-12 08:32:29.463895'),(6,'4040c005','4040c005','陳信宏',NULL,'0000-00-00',1,0,'2017-12-12 08:32:42.880956'),(7,'4040c008','4040c008','李采真',NULL,'0000-00-00',0,0,'2017-12-12 08:34:42.996963'),(8,'4040c011','4040c011','鄭高沇',NULL,'0000-00-00',1,0,'2017-12-12 08:33:10.719994');



