CREATE TABLE `sys_user` (
`id` bigint(20)NOT NULL,
`userId` varchar(50)NOT NULL,
`userName` varchar(20)NOT NULL,
`password` varchar(50)NOT NULL,
`telphone` varchar(20)NOT NULL,
`mail` varchar(50)NOT NULL,
`deptId` varchar(20)NOT NULL,
`deptName` varchar(20)NOT NULL,
`isAdmin` bit(1)NOT NULL,
`isAuditor` bit(1)NOT NULL,
`status` bit(1)NOT NULL,
`creatTm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modifyTm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#REF!
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sys_dept` (
`deptId` bigint(20)NOT NULL,
`deptName` varchar(20)NOT NULL,
`parentDeptId` bigint(6)NOT NULL,
`deptSort` int(6)NOT NULL,
`deptLevel` int(6)NOT NULL,
`status` int(6)NOT NULL,
`createTm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modifyTm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`deptId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_leave` (
`id` bigint(20)NOT NULL,
`submitter` varchar(50)NOT NULL,
`leaveUser` varchar(50),
`deptId` bigint(20)NOT NULL,
`beginTm` datetimeNOT NULL,
`endTm` datetimeNOT NULL,
`totalHours` int(6),
`leaveReason` varchar(200),
`submitTm` datetimeNOT NULL,
`approveTm` datetimeNOT NULL,
`approveHours` int(6),
`approvers` varchar(50),
`approveOpinion` varchar(200),
`status` int(6),
`leaveType` varchar(10)NOT NULL, PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_work` (
`id` bigint(20)NOT NULL,
`submitterId` varchar(50)NOT NULL,
`submitter` varchar(50)NOT NULL,
`leaveUserId` varchar(50)NOT NULL,
`leaveUser` varchar(50),
`beginTm` datetimeNOT NULL,
`endTm` datetimeNOT NULL,
`totalHours` int(6),
`leaveReason` varchar(200),
`submitTm` datetimeNOT NULL,
`approveTm` datetime,
`approveHours` int(6),
`approverId` varchar(50),
`approvers` varchar(50),
`approveOpinion` varchar(200),
`upApproverId` varchar(50),
`upApprovers` varchar(50),
`upApproveOpinion` varchar(200),
`status` varchar(6),
PRIMARY KEY(`submitTm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_integral_rule` (
`id` bigint(20)NOT NULL,
`integral_id` varchar(80)NOT NULL,
`action_id` bigint(I9320)NOT NULL,
`function_id` bigint(I9320),
`integral` int(6)NOT NULL,
`daily_limit` int(6)NOT NULL,
`describe` varchar(300),
`status` int(1)NOT NULL,
`create_tm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modify_tm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_comment` (
`comment_id` bigint(20)NOT NULL,
`article_id` bigint(20)NOT NULL,
`content` varchar(300)NOT NULL,
`from_uid` bigint(20),
`nick_name` varchar(50),
`small_icon` varchar(300),
`is_top` int(1)NOT NULL,
`is_hot` int(1),
`is_reply` int(1)NOT NULL,
`status` int(1)NOT NULL,
`create_tm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modify_tm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`comment_id`)
CREATE TABLE `ms_comment` (
CREATE TABLE `ms_comment_reply` (
`reply_id` bigint(20)NOT NULL,
`comment_id` bigint(20)NOT NULL,
`parent_reply_id` int(1),
`content` varchar(300)NOT NULL,
`to_uid` bigint(20),
`to_nick_name` varchar(50),
`from_uid` bigint(20),
`from_small_icon` varchar(50),
`from_nick_name` varchar(300),
`is_author` int(1)NOT NULL,
`status` int(1)NOT NULL,
`create_tm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modify_tm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`reply_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_collect` (
`collect_id` bigint(20)NOT NULL,
`article_id` bigint(20)NOT NULL,
`user_id` bigint(20)NOT NULL,
`create_tm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modify_tm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`collect_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_user visit` (
`user visit_id` bigint(20)NOT NULL,
`user_id` bigint(20)NOT NULL,
`user_data_id` bigint(20)NOT NULL,
`begin_time` datetimeNOT NULL,
`end_time` datetime,
`stop_time` bigint(10),
PRIMARY KEY(`user visit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_msg_box` (
`msg_box_id` bigint(20)NOT NULL,
`user_id` bigint(20)NOT NULL,
`title` varchar(50)NOT NULL,
`content` varchar(4000)NOT NULL,
`receive_date` datetimeNOT NULL,
`is_read` int(1)NOT NULL,
`read_date` datetime,
`create_tm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modify_tm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`msg_box_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_shortcut_panel` (
`shortcut_panel_id` bigint(20)NOT NULL, `title` varchar(50)NOT NULL,
`content` varchar(500)NOT NULL,
`original_img` varchar(100)NOT NULL,
`is_user_edit` int(1)NOT NULL,
`user_edit_type` int(1)NOT NULL,
`user_edit_value` varchar(3000)NOT NULL,
`order` int(4)NOT NULL,
`create_tm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modify_tm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`shortcut_panel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_shortcut_panel_user` (
`shortcut_panel_user_id` bigint(20)NOT NULL, `user_id` bigint(20)NOT NULL,
`panel_id` bigint(20)NOT NULL,
`panel_user_content` varchar(4000),
`order` int(4)NOT NULL,
`status` int(1)NOT NULL,
`create_tm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modify_tm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`shortcut_panel_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_label_user` (
`label_user_id` bigint(20)NOT NULL,
`user_id` bigint(20)NOT NULL,
`label_id` bigint(20)NOT NULL,
`status` int(1)NOT NULL,
`create_tm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modify_tm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`label_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `commons` (
`id` bigint(20)NOT NULL,
`commons_key` varchar(30)NOT NULL,
`commons_key_name` varchar(50)NOT NULL,
`commons_value` varchar(30)NOT NULL,
`commons_value_name` varchar(50)NOT NULL,
`status` int(1)NOT NULL,
`describe` varchar(300),
`create_tm` datetimeNOT NULL,
`creator` varchar(50)NOT NULL,
`modify_tm` datetimeNOT NULL,
`modifier` varchar(50),
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_view` (
`view_id` bigint(20)NOT NULL,
`article_id` bigint(20)NOT NULL,
`user_id` bigint(20)NOT NULL,
`create_tm` datetimeNOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `ms_article_like` (
`like_id` bigint(20)NOT NULL,
`article_id` bigint(20)NOT NULL,
`user_id` bigint(20)NOT NULL,
`create_tm` datetimeNOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `article_count` (
`article_id` bigint(20)NOT NULL,
`view_total` bigint(20)NOT NULL,
`new_view` bigint(20)NOT NULL,
`comment_total` bigint(20)NOT NULL, `new_comment` bigint(20)NOT NULL,
`like_total` bigint(20)NOT NULL,
`new_like` bigint(20)NOT NULL,
`collect_total` bigint(20)NOT NULL, `new_collect` bigint(20)NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ms_comment_like` (
`id` bigint(20)NOT NULL,
FALSE
`reply_id` bigint(20),
`user_id` bigint(20)NOT NULL,
`create_tm` datetimeNOT NULL, PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `ms_comment_count` (
`id` bigint(20)NOT NULL,
`like_total` bigint(20),
`new_like` bigint(20),
`reply_toal` bigint(20),
`new_reply` bigint(20),