【无标题】

最新推荐文章于 2024-09-25 10:59:43 发布

慕清阙

最新推荐文章于 2024-09-25 10:59:43 发布

阅读量82

点赞数 3

文章标签： java 前端 javascript

本文链接：https://blog.csdn.net/xiaoxiaojx/article/details/138214721

版权

41到45

CREATE TABLE `log_sms` (
  `smsld` int(11) NOT NULL AUTO_INCREMENT,
  `smsSrc` tinyint(4) NOT NULL DEFAULT '0',
  `smsUserld` int(11) NOT NULL DEFAULT '0',
  `smsContent` varchar(255) NOT NULL,
  `smsPhoneNumber` int(11) NOT NULL,
  `smsReturnCode` varchar(255) NOT NULL,
  `smsCode` varchar(255) NOT NULL,
  `smsFunc` varchar(50) NOT NULL,
  `smsIP` varchar(16) NOT NULL,
  `create Time` datetime NOT NULL,
  PRIMARY KEY (`smsld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `log_staff_logins` (
  `loginId` int(11) NOT NULL AUTO_INCREMENT,
  `staffId` int(11) NOT NULL DEFAULT '0',
  `login Time` datetime NOT NULL,
  `loginIP` varchar(16) NOT NULL,
  PRIMARY KEY (`loginId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `log_user_longins` (
  `longinId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `login Time` datetime NOT NULL,
  `loginIp` varchar(16) NOT NULL,
  `loginSrc` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `loginRemark` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`longinId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `menus` (
  `menuId` int(11) NOT NULL AUTO_INCREMENT,
  `parentId` int(11) NOT NULL,
  `menuName` varchar(100) NOT NULL,
  `menuSort` int(11) NOT NULL DEFAULT '0',
  `dataFlag` tinyint(4) NOT NULL DEFAULT '0',
  `menuMake` varchar(50) DEFAULT NULL,
  `isShow` tinyint(4) DEFAULT '1',
  `menulcon` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`menuId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msgType` tinyint(4) NOT NULL DEFAULT '0',
  `sendUserId` int(11) NOT NULL DEFAULT '0',
  `receiveUserId` int(11) NOT NULL DEFAULT '0',
  `msgContent` text NOT NULL,
  `msgStatus` tinyint(4) NOT NULL DEFAULT '0',
  `msgJson` varchar(255) DEFAULT NULL,
  `dataFlag` tinyint(4) NOT NULL DEFAULT '1',
  `create Time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;