oa/相关文档/MASTER1/数据库/master1.sql

/**
 * 个人配置桌面表
 */
DROP TABLE IF EXISTS `master1_desk_conf`;

CREATE TABLE `master1_desk_conf` (
  `universalid` bigint(30) NOT NULL,
  `deskId` varchar(64) DEFAULT NULL,
  `pos` bigint(3) DEFAULT NULL,
  `userId` bigint(30) DEFAULT NULL,
  `toolId` varchar(64) DEFAULT NULL,
  `addDateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`universalid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/**
 * 个人桌面导航
 */
DROP TABLE IF EXISTS `master1_nav_conf`;

CREATE TABLE `master1_nav_conf` (
  `universalid` bigint(30) DEFAULT NULL,
  `taskKey` varchar(256) DEFAULT NULL,
  `state` bigint(2) DEFAULT '1',
  `userId` bigint(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;