db-mysql建表

 

 

DROP TABLE IF EXISTS `access_system_user`;

CREATE TABLE `access_system_user` (
  `serialno` varchar(32) NOT NULL,
  `systembrief` varchar(10) DEFAULT NULL,
  `systemfullname` varchar(80) DEFAULT NULL,
  `operateuserid` varchar(40) DEFAULT NULL,
  `operateusername` varchar(80) DEFAULT NULL,
  `operateorgid` varchar(40) DEFAULT NULL,
  `operateorgname` varchar(80) DEFAULT NULL,
  `orgcode` varchar(20) DEFAULT NULL,
  `inputuserid` varchar(40) DEFAULT NULL,
  `inputtime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`serialno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;