私信发送成功
Watch Star Fork

iBase4J / iBase4JJavaApache-2.0GVP

JAVA分布式快速开发平台:SpringBoot,SpringMVC,Mybatis,mybatis-plus,motan/dubbo分布式,Redis缓存,Shiro权限管理,Spring-Session单点登录,Quartz分布式集群调度,Restful服务,QQ/微信登录,App token登录,微信/支付宝支付;日期转换、数据类型转换、序列化、汉字转拼音、身份证号码验证、数字转人民币、发送短信、发送邮件、加密解密、图片处理、excel导入导出、FTP/SFTP/fastDFS上传下载、二维码、XML读写、高精度计算、系统配置工具类等等。SpringBoot版本:https://gitee.com/iBase4J/iBase4J-SpringBoot https://www.oschina.net/p/iBase4J
克隆/下载
一键复制 编辑 原始数据 按行查看 历史
iBase4J.sql 52.87 KB A♂展羽 提交于 2017-11-02 16:32 . 修改响应标识
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872
-- --------------------------------------------------------
-- 主机: 127.0.0.1
-- 服务器版本: 5.6.10 - MySQL Community Server (GPL)
-- 服务器操作系统: Win32
-- HeidiSQL 版本: 9.4.0.5143
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- 导出 ibase4j 的数据库结构
CREATE DATABASE IF NOT EXISTS `ibase4j` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ibase4j`;
-- 导出 表 ibase4j.qrtz_cron_triggers 结构
CREATE TABLE IF NOT EXISTS `qrtz_cron_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`CRON_EXPRESSION` varchar(200) NOT NULL,
`TIME_ZONE_ID` varchar(80) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.qrtz_cron_triggers 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `qrtz_cron_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_cron_triggers` ENABLE KEYS */;
-- 导出 表 ibase4j.qrtz_fired_triggers 结构
CREATE TABLE IF NOT EXISTS `qrtz_fired_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`ENTRY_ID` varchar(95) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`INSTANCE_NAME` varchar(200) NOT NULL,
`FIRED_TIME` bigint(13) NOT NULL,
`SCHED_TIME` bigint(13) NOT NULL,
`PRIORITY` int(11) NOT NULL,
`STATE` varchar(16) NOT NULL,
`JOB_NAME` varchar(200) DEFAULT NULL,
`JOB_GROUP` varchar(200) DEFAULT NULL,
`IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
`REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.qrtz_fired_triggers 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `qrtz_fired_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_fired_triggers` ENABLE KEYS */;
-- 导出 表 ibase4j.qrtz_job_details 结构
CREATE TABLE IF NOT EXISTS `qrtz_job_details` (
`SCHED_NAME` varchar(120) NOT NULL,
`JOB_NAME` varchar(200) NOT NULL,
`JOB_GROUP` varchar(200) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`JOB_CLASS_NAME` varchar(250) NOT NULL,
`IS_DURABLE` varchar(1) NOT NULL,
`IS_NONCONCURRENT` varchar(1) NOT NULL,
`IS_UPDATE_DATA` varchar(1) NOT NULL,
`REQUESTS_RECOVERY` varchar(1) NOT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.qrtz_job_details 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `qrtz_job_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_job_details` ENABLE KEYS */;
-- 导出 表 ibase4j.qrtz_locks 结构
CREATE TABLE IF NOT EXISTS `qrtz_locks` (
`SCHED_NAME` varchar(120) NOT NULL,
`LOCK_NAME` varchar(40) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.qrtz_locks 的数据:~2 rows (大约)
/*!40000 ALTER TABLE `qrtz_locks` DISABLE KEYS */;
INSERT INTO `qrtz_locks` (`SCHED_NAME`, `LOCK_NAME`) VALUES
('iBase4J-Scheduler', 'STATE_ACCESS'),
('iBase4J-Scheduler', 'TRIGGER_ACCESS');
/*!40000 ALTER TABLE `qrtz_locks` ENABLE KEYS */;
-- 导出 表 ibase4j.qrtz_paused_trigger_grps 结构
CREATE TABLE IF NOT EXISTS `qrtz_paused_trigger_grps` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.qrtz_paused_trigger_grps 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `qrtz_paused_trigger_grps` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_paused_trigger_grps` ENABLE KEYS */;
-- 导出 表 ibase4j.qrtz_scheduler_state 结构
CREATE TABLE IF NOT EXISTS `qrtz_scheduler_state` (
`SCHED_NAME` varchar(120) NOT NULL,
`INSTANCE_NAME` varchar(200) NOT NULL,
`LAST_CHECKIN_TIME` bigint(13) NOT NULL,
`CHECKIN_INTERVAL` bigint(13) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.qrtz_scheduler_state 的数据:~1 rows (大约)
/*!40000 ALTER TABLE `qrtz_scheduler_state` DISABLE KEYS */;
INSERT INTO `qrtz_scheduler_state` (`SCHED_NAME`, `INSTANCE_NAME`, `LAST_CHECKIN_TIME`, `CHECKIN_INTERVAL`) VALUES
('iBase4J-Scheduler', 'ShenHuaJie-PC1495967340844', 1495971226462, 20000);
/*!40000 ALTER TABLE `qrtz_scheduler_state` ENABLE KEYS */;
-- 导出 表 ibase4j.qrtz_simple_triggers 结构
CREATE TABLE IF NOT EXISTS `qrtz_simple_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`REPEAT_COUNT` bigint(7) NOT NULL,
`REPEAT_INTERVAL` bigint(12) NOT NULL,
`TIMES_TRIGGERED` bigint(10) NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.qrtz_simple_triggers 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `qrtz_simple_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_simple_triggers` ENABLE KEYS */;
-- 导出 表 ibase4j.qrtz_simprop_triggers 结构
CREATE TABLE IF NOT EXISTS `qrtz_simprop_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`STR_PROP_1` varchar(512) DEFAULT NULL,
`STR_PROP_2` varchar(512) DEFAULT NULL,
`STR_PROP_3` varchar(512) DEFAULT NULL,
`INT_PROP_1` int(11) DEFAULT NULL,
`INT_PROP_2` int(11) DEFAULT NULL,
`LONG_PROP_1` bigint(20) DEFAULT NULL,
`LONG_PROP_2` bigint(20) DEFAULT NULL,
`DEC_PROP_1` decimal(13,4) DEFAULT NULL,
`DEC_PROP_2` decimal(13,4) DEFAULT NULL,
`BOOL_PROP_1` varchar(1) DEFAULT NULL,
`BOOL_PROP_2` varchar(1) DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.qrtz_simprop_triggers 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `qrtz_simprop_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_simprop_triggers` ENABLE KEYS */;
-- 导出 表 ibase4j.qrtz_triggers 结构
CREATE TABLE IF NOT EXISTS `qrtz_triggers` (
`SCHED_NAME` varchar(120) NOT NULL,
`TRIGGER_NAME` varchar(200) NOT NULL,
`TRIGGER_GROUP` varchar(200) NOT NULL,
`JOB_NAME` varchar(200) NOT NULL,
`JOB_GROUP` varchar(200) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
`PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
`PRIORITY` int(11) DEFAULT NULL,
`TRIGGER_STATE` varchar(16) NOT NULL,
`TRIGGER_TYPE` varchar(8) NOT NULL,
`START_TIME` bigint(13) NOT NULL,
`END_TIME` bigint(13) DEFAULT NULL,
`CALENDAR_NAME` varchar(200) DEFAULT NULL,
`MISFIRE_INSTR` smallint(2) DEFAULT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.qrtz_triggers 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `qrtz_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_triggers` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_article 结构
CREATE TABLE IF NOT EXISTS `sys_article` (
`id_` bigint(20) NOT NULL,
`type_` varchar(2) DEFAULT NULL COMMENT '类型',
`author_` varchar(16) DEFAULT NULL COMMENT '作者',
`title_` varchar(128) DEFAULT NULL COMMENT '标题',
`content_` longtext COMMENT '内容',
`out_url` varchar(512) DEFAULT NULL COMMENT '外部链接',
`seo_keyword` varchar(64) DEFAULT NULL COMMENT 'seo关键字',
`seo_description` varchar(256) DEFAULT NULL COMMENT 'seo描述',
`is_top` tinyint(1) DEFAULT NULL COMMENT '是否置顶',
`enable_` tinyint(1) DEFAULT NULL COMMENT '启用状态',
`remark_` varchar(100) DEFAULT NULL COMMENT '备注',
`create_by` bigint(20) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`update_by` bigint(20) DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章';
-- 正在导出表 ibase4j.sys_article 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_article` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_article` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_dept 结构
CREATE TABLE IF NOT EXISTS `sys_dept` (
`id_` bigint(20) NOT NULL COMMENT '部门编号',
`unit_id` bigint(20) NOT NULL COMMENT '隶属单位',
`dept_name` varchar(50) DEFAULT NULL COMMENT '部门名称',
`parent_id` bigint(20) DEFAULT NULL COMMENT '上级部门编号',
`sort_no` int(3) DEFAULT NULL COMMENT '排序号',
`leaf_` int(1) DEFAULT NULL COMMENT '叶子节点(0:树枝节点;1:叶子节点)',
`enable_` tinyint(1) DEFAULT NULL COMMENT '启用状态',
`remark_` varchar(100) DEFAULT NULL COMMENT '备注',
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部门';
-- 正在导出表 ibase4j.sys_dept 的数据:~3 rows (大约)
/*!40000 ALTER TABLE `sys_dept` DISABLE KEYS */;
INSERT INTO `sys_dept` (`id_`, `unit_id`, `dept_name`, `parent_id`, `sort_no`, `leaf_`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
(1, 1, 'iBase4J', 0, 1, 0, 1, 'qw', 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:06'),
(2, 1, '市场部', 1, 1, 1, 1, 't', 0, '2016-06-28 18:04:06', 0, '2016-06-28 18:04:06'),
(825363166504628224, 1, '技术部', 1, 2, NULL, NULL, NULL, 1, '2017-01-28 23:21:28', 1, '2017-02-21 15:11:35');
/*!40000 ALTER TABLE `sys_dept` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_dic 结构
CREATE TABLE IF NOT EXISTS `sys_dic` (
`id_` bigint(20) NOT NULL,
`type_` varchar(50) NOT NULL,
`code_` varchar(50) DEFAULT NULL,
`code_text` varchar(100) DEFAULT NULL,
`parent_type` varchar(50) DEFAULT NULL,
`parent_code` varchar(50) DEFAULT NULL,
`sort_no` int(2) DEFAULT NULL,
`editable_` tinyint(1) NOT NULL DEFAULT '1',
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`remark_` varchar(500) DEFAULT NULL,
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_`),
UNIQUE KEY `type__code_` (`type_`,`code_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典明细表';
-- 正在导出表 ibase4j.sys_dic 的数据:~43 rows (大约)
/*!40000 ALTER TABLE `sys_dic` DISABLE KEYS */;
INSERT INTO `sys_dic` (`id_`, `type_`, `code_`, `code_text`, `parent_type`, `parent_code`, `sort_no`, `editable_`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
(1, 'SEX', '0', '未知', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:13'),
(2, 'SEX', '1', '男', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:12'),
(3, 'SEX', '2', '女', NULL, NULL, 3, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:11'),
(4, 'LOCKED', '0', '激活', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:11'),
(5, 'LOCKED', '1', '锁定', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:10'),
(6, 'ROLETYPE', '1', '业务角色', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:09'),
(7, 'ROLETYPE', '2', '管理角色', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:09'),
(8, 'ROLETYPE', '3', '系统内置角色', NULL, NULL, 3, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:08'),
(9, 'LEAF', '0', '树枝节点', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:07'),
(10, 'LEAF', '1', '叶子节点', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:07'),
(11, 'EDITABLE', '0', '只读', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:06'),
(12, 'EDITABLE', '1', '可编辑', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:06'),
(13, 'ENABLE', '0', '禁用', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:05'),
(14, 'ENABLE', '1', '启用', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:04'),
(15, 'AUTHORIZELEVEL', '1', '访问权限', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:03'),
(16, 'AUTHORIZELEVEL', '2', '管理权限', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:02'),
(17, 'MENUTYPE', '1', '系统菜单', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:03'),
(18, 'MENUTYPE', '2', '业务菜单', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:01'),
(19, 'USERTYPE', '1', '经办员', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:03:50'),
(20, 'USERTYPE', '2', '管理员', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:03:48'),
(21, 'USERTYPE', '3', '系统内置用户', NULL, NULL, 3, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:03:47'),
(22, 'EXPAND', '0', '收缩', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:03:47'),
(23, 'EXPAND', '1', '展开', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:03:46'),
(24, 'CRUD', 'add', '新增', NULL, NULL, 1, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:03:56'),
(25, 'CRUD', 'read', '查询', NULL, NULL, 2, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:03:58'),
(26, 'CRUD', 'update', '修改', NULL, NULL, 3, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:03:59'),
(27, 'CRUD', 'delete', '删除', NULL, NULL, 4, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:03:59'),
(28, 'CRUD', 'open', '打开', NULL, NULL, 5, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:00'),
(29, 'CRUD', 'close', '关闭', NULL, NULL, 6, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:01'),
(30, 'CRUD', 'run', '执行', NULL, NULL, 7, 0, 1, NULL, 1, '2016-06-28 18:04:06', 1, '2016-06-28 18:04:01'),
(31, 'NEWSTYPE', '1', '国内新闻', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(32, 'NEWSTYPE', '2', '国际新闻', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(33, 'NEWSTYPE', '3', '社会新闻', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(34, 'NEWSTYPE', '4', '体育新闻', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(35, 'NEWSTYPE', '5', '娱乐新闻', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(36, 'NEWSTYPE', '6', '科技新闻', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(37, 'NEWSTYPE', '7', '行业新闻', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(38, 'NEWSTYPE', '8', '其他新闻', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(39, 'NOTICETYPE', '1', '会议通知', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(40, 'NOTICETYPE', '2', '活动公告', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(41, 'NOTICETYPE', '3', '社会公告', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(42, 'NOTICETYPE', '4', '内部公告', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46'),
(43, 'NOTICETYPE', '5', '其他公告', NULL, NULL, 1, 1, 1, NULL, 0, '2017-02-02 12:52:46', 0, '2017-02-02 12:52:46');
/*!40000 ALTER TABLE `sys_dic` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_email 结构
CREATE TABLE IF NOT EXISTS `sys_email` (
`id_` bigint(20) NOT NULL COMMENT '邮件编号',
`email_name` varchar(128) NOT NULL COMMENT '邮件名称',
`sender_` varchar(32) NOT NULL COMMENT '使用发送',
`email_title` varchar(256) NOT NULL COMMENT '发送标题',
`email_content` text NOT NULL COMMENT '发送内容',
`remark_` varchar(500) DEFAULT NULL,
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮件表';
-- 正在导出表 ibase4j.sys_email 的数据:~1 rows (大约)
/*!40000 ALTER TABLE `sys_email` DISABLE KEYS */;
INSERT INTO `sys_email` (`id_`, `email_name`, `sender_`, `email_title`, `email_content`, `remark_`, `enable_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
(1, 'test', 't', 'a', '并蒂芙蓉', NULL, 1, 1, '2017-02-02 16:37:54', 1, '2017-02-02 16:37:54');
/*!40000 ALTER TABLE `sys_email` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_email_config 结构
CREATE TABLE IF NOT EXISTS `sys_email_config` (
`id_` bigint(20) NOT NULL COMMENT '邮件配置编号',
`smtp_host` varchar(32) NOT NULL COMMENT 'SMTP服务器',
`smtp_port` varchar(8) NOT NULL COMMENT 'SMTP服务器端口',
`send_method` varchar(16) NOT NULL COMMENT '发送方式',
`sender_name` varchar(64) NOT NULL COMMENT '名称',
`sender_account` varchar(32) NOT NULL COMMENT '发邮件邮箱账号',
`sender_password` varchar(32) NOT NULL COMMENT '发邮件邮箱密码',
`remark_` varchar(500) DEFAULT NULL,
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮件配置表';
-- 正在导出表 ibase4j.sys_email_config 的数据:~1 rows (大约)
/*!40000 ALTER TABLE `sys_email_config` DISABLE KEYS */;
INSERT INTO `sys_email_config` (`id_`, `smtp_host`, `smtp_port`, `send_method`, `sender_name`, `sender_account`, `sender_password`, `remark_`, `enable_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
(828157583909109760, 'smtp.163.com', '101', '0', 'iBase4J', 'iBase4J@163.com', 'BK5sgjz5JOOsFuD4w0mbe7==', NULL, 1, 1, '2017-02-05 16:25:29', 1, '2017-02-05 16:37:50');
/*!40000 ALTER TABLE `sys_email_config` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_email_template 结构
CREATE TABLE IF NOT EXISTS `sys_email_template` (
`id_` bigint(20) NOT NULL COMMENT '邮件模版编号',
`email_name` varchar(128) NOT NULL COMMENT '邮件名称',
`email_account` varchar(32) DEFAULT NULL COMMENT '发送邮件帐号',
`sort_` int(5) DEFAULT NULL COMMENT '排序号',
`title_` varchar(512) DEFAULT NULL COMMENT '标题模版',
`template_` text COMMENT '内容模板',
`remark_` varchar(500) DEFAULT NULL,
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮件模版表';
-- 正在导出表 ibase4j.sys_email_template 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_email_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_email_template` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_event 结构
CREATE TABLE IF NOT EXISTS `sys_event` (
`id_` bigint(20) NOT NULL,
`title_` varchar(50) DEFAULT NULL,
`request_uri` varchar(50) DEFAULT NULL,
`parameters_` varchar(500) DEFAULT NULL,
`method_` varchar(20) DEFAULT NULL,
`client_host` varchar(50) DEFAULT NULL,
`user_agent` varchar(300) DEFAULT NULL,
`status_` int(3) DEFAULT NULL,
`enable_` tinyint(1) DEFAULT NULL,
`remark_` text,
`create_by` bigint(20) DEFAULT NULL,
`create_time` datetime NOT NULL,
`update_by` bigint(20) DEFAULT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.sys_event 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_event` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_event` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_menu 结构
CREATE TABLE IF NOT EXISTS `sys_menu` (
`id_` bigint(20) NOT NULL COMMENT '菜单编号',
`menu_name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
`menu_type` smallint(2) DEFAULT '2' COMMENT '菜单类型(0:CURD;1:系统菜单;2:业务菜单;)',
`parent_id` bigint(20) DEFAULT NULL COMMENT '上级菜单编号',
`iconcls_` varchar(50) DEFAULT NULL COMMENT '节点图标CSS类名',
`request_` varchar(100) DEFAULT NULL COMMENT '请求地址',
`expand_` tinyint(1) NOT NULL DEFAULT '0' COMMENT '展开状态(1:展开;0:收缩)',
`sort_no` int(2) DEFAULT NULL COMMENT '排序号',
`is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '叶子节点(0:树枝节点;1:叶子节点)',
`permission_` varchar(50) DEFAULT NULL COMMENT '权限标识',
`remark_` varchar(100) DEFAULT NULL COMMENT '备注',
`enable_` tinyint(1) DEFAULT '1',
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单';
-- 正在导出表 ibase4j.sys_menu 的数据:~36 rows (大约)
/*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
INSERT INTO `sys_menu` (`id_`, `menu_name`, `menu_type`, `parent_id`, `iconcls_`, `request_`, `expand_`, `sort_no`, `is_show`, `permission_`, `remark_`, `enable_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
(1, '主控面板', 1, 0, 'icon-home4', '/main/welcome.html', 0, 1, 1, 'main.index', NULL, 1, 1, '2016-06-20 09:16:56', 2, '2017-03-18 17:09:08'),
(2, '系统管理', 1, 0, 'glyphicon glyphicon-cog', '#', 0, 1, 1, 'sys', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-29 08:19:19'),
(3, '基础管理', 1, 2, NULL, '#', 0, 1, 1, 'sys.base', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-20 09:16:56'),
(4, '用户管理', 1, 3, NULL, '/main/admin/user.html', 0, 1, 1, 'sys.base.user', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-03-07 17:45:37'),
(5, '部门管理', 1, 3, NULL, '/main/admin/department.html', 0, 2, 1, 'sys.base.dept', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-02-02 21:46:00'),
(6, '单位管理', 1, 3, NULL, '/main/admin/unit.html', 0, 2, 1, 'sys.base.unit', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-03-07 17:45:51'),
(7, '角色管理', 1, 3, NULL, '/main/admin/role.html', 0, 4, 1, 'sys.base.role', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-02-02 21:46:01'),
(8, '菜单管理', 1, 3, NULL, '/main/admin/menu.html', 0, 5, 1, 'sys.base.menu', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-02-02 21:46:02'),
(9, '会话管理', 1, 3, NULL, '/main/admin/session.html', 0, 6, 0, 'sys.base.session', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-02-02 21:46:03'),
(10, '字典管理', 1, 3, NULL, '/main/admin/dic.html', 0, 7, 1, 'sys.base.dic', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-02-02 21:46:04'),
(11, '参数管理', 1, 3, NULL, '/main/admin/param.html', 0, 8, 1, 'sys.base.param', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-02-02 21:46:05'),
(12, '操作日志', 1, 3, NULL, '/main/admin/systemLog.html', 0, 9, 1, 'sys.base.event', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-20 09:16:56'),
(13, '权限管理', 1, 2, NULL, '#', 0, 2, 1, '', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-20 09:16:56'),
(14, '清除缓存', 1, 13, NULL, NULL, 0, 9, 0, 'sys.cache', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-29 09:39:25'),
(15, '人员角色', 1, 13, NULL, '/main/admin/personalRole.html', 0, 1, 1, 'sys.permisson.userRole', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-29 09:39:25'),
(16, '人员菜单', 1, 13, NULL, '/main/admin/personalMenu.html', 0, 2, 1, 'sys.permisson.userMenu', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-29 09:39:27'),
(17, '角色菜单', 1, 13, NULL, '/main/admin/roleMenu.html', 0, 3, 1, 'sys.permisson.roleMenu', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-29 09:39:33'),
(18, '人员操作权限', 1, 13, NULL, '/main/admin/personalPermission.html', 0, 4, 1, 'sys.permisson.user', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-29 09:39:29'),
(19, '角色操作权限', 1, 13, NULL, '/main/admin/rolePermission.html', 0, 5, 1, 'sys.permisson.role', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-29 09:39:29'),
(20, '公共信息管理', 1, 2, NULL, '#', 0, 3, 1, 'sys.cms', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-03-07 17:18:50'),
(21, '新闻中心', 1, 20, NULL, '/main/cms/news.html', 0, 2, 1, 'sys.cms.news', NULL, 1, 1, '2017-01-29 12:56:57', 1, '2017-03-07 17:19:50'),
(30, '邮件管理', 1, 2, NULL, '#', 0, 4, 1, 'sys.email', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-20 09:16:56'),
(31, '邮件管理列表', 1, 30, NULL, '/main/admin/email.html', 0, 1, 1, 'sys.email.list', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-20 09:16:56'),
(32, '邮件发送设置', 1, 30, NULL, '/main/admin/emailSend.html', 0, 2, 1, 'sys.email.config', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-02-03 14:55:15'),
(33, '邮件模版设置', 1, 30, NULL, '/main/admin/emailTemplate.html', 0, 3, 1, 'sys.email.template', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2016-06-20 09:16:56'),
(40, '任务调度', 1, 2, NULL, '#', 0, 6, 1, 'sys.task', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-03-08 11:08:49'),
(41, '调度管理', 1, 40, NULL, '/main/admin/timedTask.html', 0, 1, 1, 'sys.task.scheduled', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-02-02 21:46:32'),
(42, '调度日志', 1, 40, NULL, '/main/admin/taskLog.html', 0, 2, 1, 'sys.task.log', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-02-02 21:46:33'),
(51, '消息管理', 1, 0, 'icon-envelop2', '#', 0, 10, 1, 'cms', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-03-07 17:42:37'),
(53, '系统消息', 1, 51, '', '#', 0, 1, 1, 'cms.sys', NULL, 1, 1, '2016-06-20 09:16:56', 1, '2017-05-28 18:56:03'),
(54, '通知公告', 1, 53, NULL, '/main/cms/notice.html', 0, 1, 1, 'cms.notice', NULL, 1, 1, '2017-01-29 12:57:58', 2, '2017-03-12 18:55:52'),
(839042852275175424, '文章管理', 2, 20, NULL, '/main/cms/article.html', 0, 1, 1, 'cms.article', NULL, 1, 1, '2017-03-07 17:19:39', 2, '2017-03-12 18:54:29'),
(839042997045772288, '反馈管理', 2, 20, NULL, '/main/cms/feedback.html', 0, 3, 1, 'cms.feedback', NULL, 1, 1, '2017-03-07 17:20:14', 2, '2017-03-12 18:55:02'),
(839046535817805824, '短信管理', 2, 2, NULL, '#', 0, 5, 1, NULL, NULL, 1, 1, '2017-03-07 17:34:18', 1, '2017-03-07 17:34:18'),
(839046688716963840, '短信管理列表', 2, 839046535817805824, NULL, '/main/msg/msg.html', 0, 1, 1, 'msg.list', NULL, 1, 1, '2017-03-07 17:34:54', 2, '2017-03-14 11:16:29'),
(839047074626486272, '短信发送设置', 2, 839046535817805824, NULL, '/main/msg/msgConfig.html', 0, 2, 1, 'msg.config', NULL, 1, 1, '2017-03-07 17:36:26', 2, '2017-03-14 11:16:42');
/*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_msg 结构
CREATE TABLE IF NOT EXISTS `sys_msg` (
`id_` bigint(20) NOT NULL,
`biz_id` varchar(64) NOT NULL COMMENT '平台编号',
`type_` varchar(32) NOT NULL COMMENT '类型',
`phone_` varchar(20) NOT NULL COMMENT '接收短信号码',
`content_` varchar(256) NOT NULL COMMENT '短信内容',
`send_state` varchar(1) NOT NULL COMMENT '发送状态',
`enable_` tinyint(1) DEFAULT NULL COMMENT '启用状态',
`remark_` varchar(100) DEFAULT NULL COMMENT '备注',
`create_by` bigint(20) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`update_by` bigint(20) DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='短信';
-- 正在导出表 ibase4j.sys_msg 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_msg` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_msg` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_msg_config 结构
CREATE TABLE IF NOT EXISTS `sys_msg_config` (
`id_` bigint(20) NOT NULL,
`sms_plat_url` varchar(128) DEFAULT NULL COMMENT '短信平台地址',
`sms_plat_account` varchar(32) DEFAULT NULL COMMENT '短信平台帐号',
`sms_plat_password` varchar(64) DEFAULT NULL COMMENT '短信平台密码',
`send_phone` varchar(11) DEFAULT NULL COMMENT '发送短信',
`sender_name` varchar(32) DEFAULT NULL COMMENT '发送短信签名',
`order_is_send` tinyint(1) DEFAULT NULL COMMENT '客户下订单时是否给商家发短信',
`pay_is_send` tinyint(1) DEFAULT NULL COMMENT '客户付款时是否给商家发短信',
`send_goods_is_send` tinyint(1) DEFAULT NULL COMMENT '商家发货时是否给客户发短信',
`regist_is_send` tinyint(1) DEFAULT NULL COMMENT '用户注册时是否给客户发短信',
`advice_goods_is_send` tinyint(1) DEFAULT NULL COMMENT '用户付款后是否给客户发收货验证码',
`enable_` tinyint(1) DEFAULT NULL COMMENT '启用状态',
`remark_` varchar(100) DEFAULT NULL COMMENT '备注',
`create_by` bigint(20) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`update_by` bigint(20) DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.sys_msg_config 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_msg_config` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_msg_config` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_news 结构
CREATE TABLE IF NOT EXISTS `sys_news` (
`id_` bigint(20) NOT NULL COMMENT '新闻编号',
`news_title` varchar(64) NOT NULL COMMENT '新闻标题',
`news_type` varchar(8) NOT NULL COMMENT '新闻类型',
`send_time` datetime NOT NULL COMMENT '发布时间',
`author_` varchar(32) NOT NULL COMMENT '作者',
`editor_` varchar(32) NOT NULL COMMENT '编辑',
`tags_` varchar(128) DEFAULT NULL COMMENT 'Tag标签',
`keys_` varchar(128) DEFAULT NULL COMMENT '关键字',
`content_` text COMMENT '内容',
`reader_times` int(11) NOT NULL DEFAULT '0' COMMENT '阅读次数',
`status_` varchar(2) NOT NULL DEFAULT '1' COMMENT '发布状态',
`remark_` varchar(500) DEFAULT NULL,
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='新闻表';
-- 正在导出表 ibase4j.sys_news 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_news` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_news` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_notice 结构
CREATE TABLE IF NOT EXISTS `sys_notice` (
`id_` bigint(20) NOT NULL COMMENT '公告编号',
`notice_title` varchar(128) NOT NULL COMMENT '公告标题',
`notice_type` varchar(8) NOT NULL COMMENT '公告类型',
`send_time` datetime DEFAULT NULL COMMENT '发布时间',
`info_sources` varchar(256) DEFAULT NULL COMMENT '信息来源',
`sources_url` varchar(2048) DEFAULT NULL COMMENT '来源地址',
`content_` text COMMENT '内容',
`reader_times` int(11) NOT NULL DEFAULT '0' COMMENT '阅读次数',
`status_` varchar(2) NOT NULL DEFAULT '1' COMMENT '发布状态',
`remark_` varchar(500) DEFAULT NULL,
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='通知公告表';
-- 正在导出表 ibase4j.sys_notice 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_notice` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_notice` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_param 结构
CREATE TABLE IF NOT EXISTS `sys_param` (
`id_` bigint(20) NOT NULL COMMENT '参数编号',
`param_key` varchar(50) DEFAULT NULL COMMENT '参数键名',
`param_value` varchar(100) DEFAULT NULL COMMENT '参数键值',
`catalog_id` bigint(20) DEFAULT NULL,
`remark_` varchar(100) DEFAULT NULL COMMENT '备注',
`enable_` tinyint(1) DEFAULT '1',
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全局参数表';
-- 正在导出表 ibase4j.sys_param 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_param` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_param` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_role 结构
CREATE TABLE IF NOT EXISTS `sys_role` (
`id_` bigint(20) NOT NULL COMMENT '角色编号',
`role_name` varchar(50) DEFAULT NULL COMMENT '角色名称',
`dept_id` bigint(20) DEFAULT NULL COMMENT '所属部门编号',
`role_type` int(1) NOT NULL DEFAULT '1' COMMENT '角色类型(1:业务角色;2:管理角色 ;3:系统内置角色)',
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`remark_` varchar(100) DEFAULT NULL COMMENT '备注',
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色信息表';
-- 正在导出表 ibase4j.sys_role 的数据:~1 rows (大约)
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` (`id_`, `role_name`, `dept_id`, `role_type`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
(1, '管理员', 1, 1, 1, NULL, 1, '2016-06-20 09:16:56', 1, '2017-01-29 10:11:20');
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_role_menu 结构
CREATE TABLE IF NOT EXISTS `sys_role_menu` (
`id_` bigint(20) NOT NULL,
`role_id` bigint(20) NOT NULL,
`menu_id` bigint(20) NOT NULL,
`permission_` varchar(50) NOT NULL COMMENT '权限标识',
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`remark_` varchar(5000) DEFAULT NULL,
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_`),
UNIQUE KEY `sys_role_menu_key1` (`role_id`,`menu_id`,`permission_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色授权表';
-- 正在导出表 ibase4j.sys_role_menu 的数据:~100 rows (大约)
/*!40000 ALTER TABLE `sys_role_menu` DISABLE KEYS */;
INSERT INTO `sys_role_menu` (`id_`, `role_id`, `menu_id`, `permission_`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
(868778355060875264, 1, 1, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355073458176, 1, 2, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355098624000, 1, 3, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355119595520, 1, 4, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355136372736, 1, 5, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355178315776, 1, 6, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355195092992, 1, 7, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355211870208, 1, 8, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355232841728, 1, 9, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355249618944, 1, 10, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355262201856, 1, 11, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355274784768, 1, 12, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355295756288, 1, 13, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355316727808, 1, 15, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355329310720, 1, 16, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355341893632, 1, 17, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355350282240, 1, 18, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355362865152, 1, 19, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355379642368, 1, 14, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355392225280, 1, 20, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355404808192, 1, 839042852275175424, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355417391104, 1, 21, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355425779712, 1, 839042997045772288, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355442556928, 1, 30, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355455139840, 1, 31, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355467722752, 1, 32, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355484499968, 1, 33, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355501277184, 1, 839046535817805824, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355513860096, 1, 839046688716963840, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355530637312, 1, 839047074626486272, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355539025920, 1, 40, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355555803136, 1, 41, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355568386048, 1, 42, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355589357568, 1, 51, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355597746176, 1, 53, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868778355614523392, 1, 54, 'read', 1, NULL, 1, '2017-05-28 18:37:56', 1, '2017-05-28 18:37:56'),
(868784518229893120, 1, 4, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518238281728, 1, 4, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518246670336, 1, 4, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518255058944, 1, 5, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518263447552, 1, 5, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518267641856, 1, 5, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518280224768, 1, 6, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518297001984, 1, 6, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518313779200, 1, 6, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518322167808, 1, 7, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518330556416, 1, 7, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518338945024, 1, 7, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518347333632, 1, 8, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518376693760, 1, 8, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518427025408, 1, 8, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518447996928, 1, 9, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518464774144, 1, 9, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518477357056, 1, 9, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518489939968, 1, 10, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518519300096, 1, 10, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518540271616, 1, 10, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518569631744, 1, 11, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518594797568, 1, 11, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518611574784, 1, 11, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518615769088, 1, 15, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518674489344, 1, 16, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518699655168, 1, 17, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518724820992, 1, 18, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518741598208, 1, 19, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518749986816, 1, 14, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518762569728, 1, 839042852275175424, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518783541248, 1, 839042852275175424, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518800318464, 1, 839042852275175424, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518825484288, 1, 21, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518842261504, 1, 21, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518846455808, 1, 21, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518859038720, 1, 839042997045772288, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518871621632, 1, 839042997045772288, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518884204544, 1, 839042997045772288, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518892593152, 1, 31, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518913564672, 1, 31, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518947119104, 1, 31, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518972284928, 1, 32, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784518997450752, 1, 32, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519010033664, 1, 32, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519022616576, 1, 33, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519043588096, 1, 33, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519077142528, 1, 33, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519098114048, 1, 839046688716963840, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519110696960, 1, 839046688716963840, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519140057088, 1, 839046688716963840, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519156834304, 1, 839047074626486272, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519169417216, 1, 839047074626486272, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519190388736, 1, 839047074626486272, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519202971648, 1, 41, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519223943168, 1, 41, 'close', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519261691904, 1, 41, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519295246336, 1, 41, 'open', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519312023552, 1, 41, 'run', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519328800768, 1, 41, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519358160896, 1, 42, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519387521024, 1, 54, 'add', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519408492544, 1, 54, 'delete', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25'),
(868784519421075456, 1, 54, 'update', 1, NULL, 1, '2017-05-28 19:02:25', 1, '2017-05-28 19:02:25');
/*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_session 结构
CREATE TABLE IF NOT EXISTS `sys_session` (
`id_` bigint(20) NOT NULL,
`session_id` varchar(50) DEFAULT NULL,
`account_` varchar(50) DEFAULT NULL,
`ip_` varchar(50) DEFAULT NULL,
`start_time` datetime NOT NULL,
`enable_` tinyint(1) DEFAULT NULL,
`remark_` varchar(5000) DEFAULT NULL,
`create_time` datetime NOT NULL,
`create_by` bigint(20) DEFAULT NULL,
`update_time` datetime NOT NULL,
`update_by` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会话管理';
-- 正在导出表 ibase4j.sys_session 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_session` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_session` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_unit 结构
CREATE TABLE IF NOT EXISTS `sys_unit` (
`id_` bigint(20) NOT NULL,
`unit_name` varchar(128) NOT NULL COMMENT '单位名称',
`principal_` varchar(32) DEFAULT NULL COMMENT '负责人',
`phone_` varchar(32) DEFAULT NULL COMMENT '联系电话',
`address_` varchar(256) DEFAULT NULL COMMENT '地址',
`sort_` int(5) DEFAULT NULL COMMENT '排序号',
`enable_` tinyint(1) DEFAULT NULL COMMENT '启用状态',
`remark_` varchar(1024) DEFAULT NULL,
`create_time` datetime NOT NULL,
`create_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL,
`update_by` bigint(20) NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='单位表';
-- 正在导出表 ibase4j.sys_unit 的数据:~1 rows (大约)
/*!40000 ALTER TABLE `sys_unit` DISABLE KEYS */;
INSERT INTO `sys_unit` (`id_`, `unit_name`, `principal_`, `phone_`, `address_`, `sort_`, `enable_`, `remark_`, `create_time`, `create_by`, `update_time`, `update_by`) VALUES
(1, 'iBase4J', '经理', '13945678911', '中国', 1, NULL, NULL, '2017-01-12 00:00:00', 1, '2017-01-28 23:51:57', 1);
/*!40000 ALTER TABLE `sys_unit` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_user 结构
CREATE TABLE IF NOT EXISTS `sys_user` (
`id_` bigint(20) NOT NULL,
`account_` varchar(20) DEFAULT NULL COMMENT '登陆帐户',
`password_` varchar(50) DEFAULT NULL COMMENT '密码',
`user_type` varchar(2) DEFAULT '1' COMMENT '用户类型(1普通用户2管理员3系统用户)',
`user_name` varchar(30) DEFAULT NULL COMMENT '姓名',
`name_pinyin` varchar(64) DEFAULT NULL COMMENT '姓名拼音',
`sex_` int(1) NOT NULL DEFAULT '0' COMMENT '性别(0:未知;1:男;2:女)',
`avatar_` varchar(500) DEFAULT NULL COMMENT '头像',
`phone_` varchar(50) DEFAULT NULL COMMENT '电话',
`email_` varchar(64) DEFAULT NULL COMMENT '邮箱',
`id_card` varchar(18) DEFAULT NULL COMMENT '身份证号码',
`wei_xin` varchar(32) DEFAULT NULL COMMENT '微信',
`wei_bo` varchar(32) DEFAULT NULL COMMENT '微博',
`qq_` varchar(32) DEFAULT NULL COMMENT 'QQ',
`birth_day` date DEFAULT NULL COMMENT '出生日期',
`dept_id` bigint(20) DEFAULT NULL COMMENT '部门编号',
`position_` varchar(64) DEFAULT NULL COMMENT '职位',
`address_` varchar(256) DEFAULT NULL COMMENT '详细地址',
`staff_no` varchar(32) DEFAULT NULL COMMENT '工号',
`enable_` tinyint(1) DEFAULT '1',
`remark_` varchar(1024) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`create_by` bigint(20) DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`update_by` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id_`),
UNIQUE KEY `account` (`account_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户管理';
-- 正在导出表 ibase4j.sys_user 的数据:~2 rows (大约)
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` (`id_`, `account_`, `password_`, `user_type`, `user_name`, `name_pinyin`, `sex_`, `avatar_`, `phone_`, `email_`, `id_card`, `wei_xin`, `wei_bo`, `qq_`, `birth_day`, `dept_id`, `position_`, `address_`, `staff_no`, `enable_`, `remark_`, `create_time`, `create_by`, `update_time`, `update_by`) VALUES
(1, 'admin', 'i/sV2VpTPy7Y+ppesmkCmM==', '3', '管理员', 'GUANLIYUAN', 0, 'http://118.190.43.148/group1/M00/00/00/dr4rlFjNBguAfJl7AAcOE67NTFk744.png', '15333821711', '12@12', NULL, NULL, NULL, NULL, '2017-01-27', 2, '213', NULL, NULL, 1, '1', '2016-05-06 10:06:52', 1, '2017-03-18 18:03:55', 1),
(2, 'test', 'i/sV2VpTPy7Y+ppesmkCmM==', '1', 'admin', 'CESHIRENYUAN', 1, 'http://118.190.43.148/group1/M00/00/00/dr4rlFj3H0iATcqFAAv7S9z_iMg689.png', '12345678901', '123@163.com', NULL, NULL, NULL, NULL, '2017-02-01', 825363166504628224, '测试', NULL, NULL, 1, '1', '2016-05-13 16:58:17', 1, '2017-04-19 16:26:49', 2);
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_user_menu 结构
CREATE TABLE IF NOT EXISTS `sys_user_menu` (
`id_` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`menu_id` bigint(20) NOT NULL,
`permission_` varchar(50) NOT NULL COMMENT '权限标识',
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`remark_` varchar(5000) DEFAULT NULL,
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_`),
UNIQUE KEY `sys_user_menu_key1` (`user_id`,`menu_id`,`permission_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户授权表';
-- 正在导出表 ibase4j.sys_user_menu 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_user_menu` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_user_menu` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_user_role 结构
CREATE TABLE IF NOT EXISTS `sys_user_role` (
`id_` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`role_id` bigint(20) NOT NULL,
`enable_` tinyint(1) NOT NULL DEFAULT '1',
`remark_` varchar(5000) DEFAULT NULL,
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_`),
UNIQUE KEY `user_id_role_id` (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户授权表';
-- 正在导出表 ibase4j.sys_user_role 的数据:~1 rows (大约)
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
INSERT INTO `sys_user_role` (`id_`, `user_id`, `role_id`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
(1, 1, 1, 1, NULL, 1, '2016-06-16 15:59:56', 1, '2016-06-16 15:59:56');
/*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_user_thirdparty 结构
CREATE TABLE IF NOT EXISTS `sys_user_thirdparty` (
`id_` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`provider_` varchar(50) NOT NULL COMMENT '第三方类型',
`open_id` varchar(50) NOT NULL COMMENT '第三方Id',
`enable_` tinyint(1) DEFAULT NULL,
`remark_` varchar(5000) DEFAULT NULL,
`create_by` bigint(20) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` bigint(20) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`),
UNIQUE KEY `user_id_provider__open_id` (`user_id`,`provider_`,`open_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='第三方用户';
-- 正在导出表 ibase4j.sys_user_thirdparty 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_user_thirdparty` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_user_thirdparty` ENABLE KEYS */;
-- 导出 表 ibase4j.task_fire_log 结构
CREATE TABLE IF NOT EXISTS `task_fire_log` (
`id_` bigint(20) NOT NULL,
`group_name` varchar(50) NOT NULL,
`task_name` varchar(50) NOT NULL,
`start_time` datetime NOT NULL,
`end_time` datetime DEFAULT NULL,
`status_` varchar(1) NOT NULL DEFAULT 'I',
`server_host` varchar(50) DEFAULT NULL COMMENT '服务器名',
`server_duid` varchar(50) DEFAULT NULL COMMENT '服务器网卡序列号',
`fire_info` text,
PRIMARY KEY (`id_`),
UNIQUE KEY `group_name_task_name_start_time` (`group_name`,`task_name`,`start_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.task_fire_log 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `task_fire_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `task_fire_log` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

评论 (0)

你可以在登录后,对此项目发表评论