dsfsdfs
时间:2006-11-07 来源:zhujun3r
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`UserId` varchar(50) NOT NULL default '',
`UserName` varchar(50) NOT NULL default '',
`UserPassword` varchar(50) NOT NULL default '',
`CreateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
`LastAccessTime` timestamp NOT NULL default '0000-00-00 00:00:00',
`Active` tinyint(1) NOT NULL default '0',
`TerminalClass` tinyint(1) NOT NULL default '0',
`coname` varchar(45) default '',
`coaddress` varchar(45) default '',
`fax` varchar(45) default '',
`email` varchar(45) default '',
`qqcode` varchar(45) default '',
`telephone` varchar(45) default '',
`mobile` varchar(45) default '',
`linkman` varchar(45) default '',
PRIMARY KEY (`UserId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `sys_user` (
`UserId` varchar(50) NOT NULL default '',
`UserName` varchar(50) NOT NULL default '',
`UserPassword` varchar(50) NOT NULL default '',
`CreateTime` timestamp NOT NULL default '0000-00-00 00:00:00',
`LastAccessTime` timestamp NOT NULL default '0000-00-00 00:00:00',
`Active` tinyint(1) NOT NULL default '0',
`TerminalClass` tinyint(1) NOT NULL default '0',
`coname` varchar(45) default '',
`coaddress` varchar(45) default '',
`fax` varchar(45) default '',
`email` varchar(45) default '',
`qqcode` varchar(45) default '',
`telephone` varchar(45) default '',
`mobile` varchar(45) default '',
`linkman` varchar(45) default '',
PRIMARY KEY (`UserId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
相关阅读 更多 +