Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or download
iBase4J.sql 33.64 KB
Copy Edit Web IDE Raw Blame History
ShenHuaJie authored 2016-12-29 15:49 . 简化调度
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602
-- --------------------------------------------------------
-- 主机: 127.0.0.1
-- 服务器版本: 5.6.10 - MySQL Community Server (GPL)
-- 服务器操作系统: Win32
-- HeidiSQL 版本: 9.3.0.4984
-- --------------------------------------------------------
-- 导出 ibase4j 的数据库结构
DROP DATABASE IF EXISTS `ibase4j`;
CREATE DATABASE IF NOT EXISTS `ibase4j` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ibase4j`;
-- 导出 表 ibase4j.qrtz_fired_triggers 结构
DROP TABLE IF EXISTS `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_job_details 结构
DROP TABLE IF EXISTS `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_triggers 结构
DROP TABLE IF EXISTS `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_locks 结构
DROP TABLE IF EXISTS `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_paused_trigger_grps 结构
DROP TABLE IF EXISTS `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_scheduler_state 结构
DROP TABLE IF EXISTS `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_simple_triggers 结构
DROP TABLE IF EXISTS `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_simprop_triggers 结构
DROP TABLE IF EXISTS `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_cron_triggers 结构
DROP TABLE IF EXISTS `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.sys_catalog 结构
DROP TABLE IF EXISTS `sys_catalog`;
CREATE TABLE IF NOT EXISTS `sys_catalog` (
`id_` BIGINT(32) NOT NULL COMMENT '流水号',
`cascade_id` varchar(255) NOT NULL COMMENT '节点语义ID',
`root_key` varchar(255) NOT NULL COMMENT '科目标识键',
`root_name` varchar(255) NOT NULL COMMENT '科目名称',
`name_` varchar(255) NOT NULL COMMENT '分类名称',
`hotkey_` varchar(255) DEFAULT NULL COMMENT '热键',
`parent_id` BIGINT(32) NOT NULL COMMENT '父节点流水号',
`is_leaf_` varchar(255) NOT NULL DEFAULT '1' COMMENT '是否叶子节点',
`is_auto_expand` varchar(255) NOT NULL DEFAULT '0' COMMENT '是否自动展开',
`icon_name` varchar(255) DEFAULT NULL COMMENT '图标文件名称',
`sort_no` int(10) DEFAULT NULL COMMENT '排序号',
`enable_` tinyint(1) DEFAULT '1',
`remark_` varchar(5000) DEFAULT '1',
`create_by` BIGINT(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`),
UNIQUE KEY `sys_catalog_ukey` (`cascade_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分类表';
-- 正在导出表 ibase4j.sys_catalog 的数据:~12 rows (大约)
/*!40000 ALTER TABLE `sys_catalog` DISABLE KEYS */;
INSERT INTO `sys_catalog` (`id_`, `cascade_id`, `root_key`, `root_name`, `name_`, `hotkey_`, `parent_id`, `is_leaf_`, `is_auto_expand`, `icon_name`, `sort_no`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
('1', '0.001', 'PARAM_TYPE', '参数分类科目', '参数分类', NULL, '0', '0', '0', 'book.png', 0, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('10', '0.001.002.003', 'PARAM_TYPE', '参数分类科目', '其它', NULL, '4', '1', '0', 'icon150.png', 9, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('11', '0.001.002.004', 'PARAM_TYPE', '参数分类科目', '导航与菜单', NULL, '4', '1', '0', 'icon152.png', 3, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('12', '0.002.001.001', 'DIC_TYPE', '词典分类科目', '工作流', NULL, '5', '1', '0', 'folder6.png', 1, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('2', '0.002', 'DIC_TYPE', '词典分类科目', '数据字典分类', NULL, '0', '0', '0', 'book.png', 2, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('3', '0.001.001', 'PARAM_TYPE', '参数分类科目', '业务参数', NULL, '1', '1', '0', 'user20.png', 2, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('4', '0.001.002', 'PARAM_TYPE', '参数分类科目', '系统参数', NULL, '1', '0', '1', 'folder22.png', 1, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('5', '0.002.001', 'DIC_TYPE', '词典分类科目', '系统管理', NULL, '2', '0', '1', 'folder22.png', 2, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('6', '0.002.002', 'DIC_TYPE', '词典分类科目', '全局通用', NULL, '2', '1', '0', 'folder24.png', 3, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('7', '0.002.006', 'DIC_TYPE', '词典分类科目', '平台配置', NULL, '2', '1', '0', 'folder2.png', 1, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('8', '0.001.002.001', 'PARAM_TYPE', '参数分类科目', '验证码', NULL, '4', '1', '0', 'ok3.png', 2, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29'),
('9', '0.001.002.002', 'PARAM_TYPE', '参数分类科目', '界面显示', NULL, '4', '1', '0', 'icon59.png', 1, 1, '1', '1', '2016-06-13 14:07:29', '1', '2016-06-13 14:07:29');
/*!40000 ALTER TABLE `sys_catalog` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_dept 结构
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE IF NOT EXISTS `sys_dept` (
`id_` BIGINT(32) NOT NULL COMMENT '部门编号',
`dept_name` varchar(50) DEFAULT NULL COMMENT '部门名称',
`parent_id` BIGINT(32) 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(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部门';
-- 正在导出表 ibase4j.sys_dept 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_dept` DISABLE KEYS */;
INSERT INTO `sys_dept` (`id_`, `dept_name`, `parent_id`, `sort_no`, `leaf_`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
('1', 'ibase4j', '0', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:06');
/*!40000 ALTER TABLE `sys_dept` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_dic 结构
DROP TABLE IF EXISTS `sys_dic`;
CREATE TABLE IF NOT EXISTS `sys_dic` (
`id_` BIGINT(32) NOT NULL,
`index_id` BIGINT(32) DEFAULT NULL,
`code_` varchar(50) DEFAULT NULL,
`code_text` varchar(100) 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(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`),
UNIQUE KEY `field_id_code` (`index_id`,`code_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典明细表';
-- 正在导出表 ibase4j.sys_dic 的数据:~30 rows (大约)
/*!40000 ALTER TABLE `sys_dic` DISABLE KEYS */;
INSERT INTO `sys_dic` (`id_`, `index_id`, `code_`, `code_text`, `sort_no`, `editable_`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
('1', '1', '0', '未知', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:13'),
('10', '4', '1', '叶子节点', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:07'),
('11', '5', '0', '只读', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:06'),
('12', '5', '1', '可编辑', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:06'),
('13', '6', '0', '禁用', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:05'),
('14', '6', '1', '启用', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:04'),
('15', '7', '1', '访问权限', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:03'),
('16', '7', '2', '管理权限', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:02'),
('17', '8', '1', '系统菜单', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:03'),
('18', '8', '2', '业务菜单', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:01'),
('19', '9', '1', '经办员', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:03:50'),
('2', '1', '1', '男', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:12'),
('20', '9', '2', '管理员', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:03:48'),
('21', '9', '3', '系统内置用户', 3, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:03:47'),
('22', '10', '0', '收缩', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:03:47'),
('23', '10', '1', '展开', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:03:46'),
('24', '11', 'add', '新增', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:03:56'),
('25', '11', 'read', '查询', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:03:58'),
('26', '11', 'update', '修改', 3, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:03:59'),
('27', '11', 'delete', '删除', 4, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:03:59'),
('28', '11', 'open', '打开', 5, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:00'),
('29', '11', 'close', '关闭', 6, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:01'),
('3', '1', '2', '女', 3, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:11'),
('30', '11', 'run', '执行', 7, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:01'),
('4', '2', '0', '激活', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:11'),
('5', '2', '1', '锁定', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:10'),
('6', '3', '1', '业务角色', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:09'),
('7', '3', '2', '管理角色', 2, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:09'),
('8', '3', '3', '系统内置角色', 3, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:08'),
('9', '4', '0', '树枝节点', 1, 0, 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-06-28 18:04:07');
/*!40000 ALTER TABLE `sys_dic` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_dic_index 结构
DROP TABLE IF EXISTS `sys_dic_index`;
CREATE TABLE IF NOT EXISTS `sys_dic_index` (
`id_` BIGINT(32) NOT NULL,
`catalog_id` BIGINT(32) NOT NULL DEFAULT '0',
`key_` varchar(50) DEFAULT NULL,
`name_` varchar(200) DEFAULT NULL,
`enable_` tinyint(1) DEFAULT '1',
`remark_` varchar(1000) DEFAULT NULL,
`create_by` BIGINT(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`),
UNIQUE KEY `code` (`key_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典索引表';
-- 正在导出表 ibase4j.sys_dic_index 的数据:~11 rows (大约)
/*!40000 ALTER TABLE `sys_dic_index` DISABLE KEYS */;
INSERT INTO `sys_dic_index` (`id_`, `catalog_id`, `key_`, `name_`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
('1', '6', 'SEX', '性别', 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-07-30 00:06:53'),
('10', '6', 'EXPAND', '展开状态', 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-07-30 00:06:52'),
('11', '5', 'CRUD', '操作类型', 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-07-30 00:06:51'),
('2', '6', 'LOCKED', '锁定', 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-07-30 00:06:49'),
('3', '5', 'ROLETYPE', '角色类型', 1, NULL, '1', '2016-07-30 00:06:30', '1', '2016-07-30 00:06:50'),
('4', '6', 'LEAF', '节点类型', 1, NULL, '1', '2016-06-28 18:04:06', '1', '2016-07-30 00:06:48'),
('5', '5', 'EDITABLE', '编辑模式', 1, NULL, '1', '2016-07-30 00:06:33', '1', '2016-07-30 00:06:47'),
('6', '5', 'ENABLE', '启用状态', 1, NULL, '1', '2016-07-30 00:06:35', '1', '2016-07-30 00:06:45'),
('7', '5', 'AUTHORIZELEVEL', '权限级别', 1, NULL, '1', '2016-07-30 00:06:37', '1', '2016-07-30 00:06:44'),
('8', '5', 'MENUTYPE', '菜单类型', 1, NULL, '1', '2016-07-30 00:06:38', '1', '2016-07-30 00:06:40'),
('9', '5', 'USERTYPE', '人员类型', 1, NULL, '1', '2016-07-30 00:06:43', '1', '2016-07-30 00:06:41');
/*!40000 ALTER TABLE `sys_dic_index` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_event 结构
DROP TABLE IF EXISTS `sys_event`;
CREATE TABLE IF NOT EXISTS `sys_event` (
`id_` BIGINT(32) 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(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT 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 结构
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE IF NOT EXISTS `sys_menu` (
`id_` BIGINT(32) NOT NULL COMMENT '菜单编号',
`menu_name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
`menu_type` tinyint(1) DEFAULT '2' COMMENT '菜单类型(0:CURD;1:系统菜单;2:业务菜单;)',
`parent_id` BIGINT(32) 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(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单';
-- 正在导出表 ibase4j.sys_menu 的数据:~17 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', 'glyphicon glyphicon-cog', '#', 0, 1, 1, 'sys', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-29 08:19:19'),
('12', '调度管理', 1, '9', 'glyphicon glyphicon-random', 'main.task.scheduled.list', 0, 3, 1, 'task.scheduled', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-30 14:24:02'),
('13', '调度日志', 1, '9', 'glyphicon glyphicon-file', 'main.task.log.list', 0, 4, 1, 'task.log', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-28 18:08:48'),
('14', '清除缓存', 1, '1', 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, '1', NULL, NULL, 0, 10, 0, 'user.menu', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-29 09:39:27'),
('16', '用户角色', 1, '1', NULL, NULL, 0, 11, 0, 'user.role', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-29 09:39:29'),
('17', '角色权限', 1, '1', NULL, NULL, 0, 12, 0, 'role.menu', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-29 09:39:33'),
('2', '用户管理', 1, '1', 'glyphicon glyphicon-user', 'main.sys.user.list', 0, 1, 1, 'sys.user', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-29 08:38:35'),
('3', '部门管理', 1, '1', 'glyphicon glyphicon-flag', 'main.sys.dept.list', 0, 2, 1, 'sys.dept', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-28 18:07:43'),
('4', '菜单管理', 1, '1', 'glyphicon glyphicon-list', 'main.sys.menu.list', 0, 3, 1, 'sys.menu', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-28 18:07:45'),
('5', '角色管理', 1, '1', 'glyphicon glyphicon-tags', 'main.sys.role.list', 0, 4, 1, 'sys.role', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-28 18:07:47'),
('6', '会话管理', 1, '1', 'glyphicon glyphicon-earphone', 'main.sys.session.list', 0, 6, 1, 'sys.session', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-28 18:07:49'),
('7', '字典管理', 1, '1', 'glyphicon glyphicon-book', 'main.sys.dic.list', 0, 7, 1, 'sys.dic', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-28 18:07:50'),
('8', '参数管理', 1, '1', 'glyphicon glyphicon-wrench', 'main.sys.param.list', 0, 8, 1, 'sys.param', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-28 18:07:52'),
('9', '调度中心', 1, '0', 'glyphicon glyphicon-fire', '#', 0, 2, 1, 'task', NULL, 1, '1', '2016-06-20 09:16:56', '1', '2016-06-30 14:23:57');
/*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_param 结构
DROP TABLE IF EXISTS `sys_param`;
CREATE TABLE IF NOT EXISTS `sys_param` (
`id_` BIGINT(32) NOT NULL COMMENT '参数编号',
`param_key` varchar(50) DEFAULT NULL COMMENT '参数键名',
`param_value` varchar(100) DEFAULT NULL COMMENT '参数键值',
`catalog_id` BIGINT(32) DEFAULT NULL,
`remark_` varchar(100) DEFAULT NULL COMMENT '备注',
`enable_` tinyint(1) DEFAULT '1',
`create_by` BIGINT(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) 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 结构
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE IF NOT EXISTS `sys_role` (
`id_` BIGINT(32) NOT NULL COMMENT '角色编号',
`role_name` varchar(50) DEFAULT NULL COMMENT '角色名称',
`dept_id` BIGINT(32) 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(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色信息表';
-- 正在导出表 ibase4j.sys_role 的数据:~0 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', '2016-06-20 09:16:56');
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_role_menu 结构
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE IF NOT EXISTS `sys_role_menu` (
`role_id` BIGINT(32) NOT NULL,
`menu_id` BIGINT(32) NOT NULL,
`permission_` varchar(50) NOT NULL COMMENT '权限标识',
`enable_` tinyint(1) DEFAULT '1',
`remark_` varchar(5000) DEFAULT NULL,
`create_by` BIGINT(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`role_id`,`menu_id`,`permission_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色授权表';
-- 正在导出表 ibase4j.sys_role_menu 的数据:~45 rows (大约)
/*!40000 ALTER TABLE `sys_role_menu` DISABLE KEYS */;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `permission_`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
('1', '1', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:04'),
('1', '12', 'update', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:13'),
('1', '12', 'close', 1, NULL, '1', '2016-06-29 08:45:21', '1', '2016-06-29 08:45:21'),
('1', '12', 'open', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:13'),
('1', '12', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:13'),
('1', '12', 'run', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:13'),
('1', '13', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:14'),
('1', '14', 'update', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:43:18'),
('1', '15', 'update', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:43:33'),
('1', '16', 'update', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:43:34'),
('1', '17', 'update', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:43:35'),
('1', '2', 'add', 1, NULL, '1', '2016-06-29 09:10:10', '1', '2016-06-29 09:10:10'),
('1', '2', 'delete', 1, NULL, '1', '2016-06-29 09:10:29', '1', '2016-06-29 09:10:29'),
('1', '2', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:07'),
('1', '2', 'update', 1, NULL, '1', '2016-06-29 09:10:20', '1', '2016-06-29 09:10:20'),
('1', '3', 'add', 1, NULL, '1', '2016-06-29 09:10:50', '1', '2016-06-29 09:10:50'),
('1', '3', 'delete', 1, NULL, '1', '2016-06-29 09:11:18', '1', '2016-06-29 09:11:18'),
('1', '3', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:08'),
('1', '3', 'update', 1, NULL, '1', '2016-06-29 09:11:01', '1', '2016-06-29 09:11:01'),
('1', '4', 'add', 1, NULL, '1', '2016-06-29 09:12:14', '1', '2016-06-29 09:12:14'),
('1', '4', 'delete', 1, NULL, '1', '2016-06-29 09:18:43', '1', '2016-06-29 09:18:43'),
('1', '4', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:08'),
('1', '4', 'update', 1, NULL, '1', '2016-06-29 09:18:33', '1', '2016-06-29 09:18:33'),
('1', '5', 'add', 1, NULL, '1', '2016-06-29 09:19:00', '1', '2016-06-29 09:19:00'),
('1', '5', 'delete', 1, NULL, '1', '2016-06-29 09:19:24', '1', '2016-06-29 09:19:24'),
('1', '5', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:09'),
('1', '5', 'update', 1, NULL, '1', '2016-06-29 09:19:10', '1', '2016-06-29 09:19:10'),
('1', '6', 'delete', 1, NULL, '1', '2016-06-29 09:19:35', '1', '2016-06-29 09:19:35'),
('1', '6', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:09'),
('1', '7', 'add', 1, NULL, '1', '2016-06-29 09:19:58', '1', '2016-06-29 09:19:58'),
('1', '7', 'delete', 1, NULL, '1', '2016-06-29 09:20:18', '1', '2016-06-29 09:20:18'),
('1', '7', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:10'),
('1', '7', 'update', 1, NULL, '1', '2016-06-29 09:20:08', '1', '2016-06-29 09:20:08'),
('1', '8', 'add', 1, NULL, '1', '2016-06-29 09:20:34', '1', '2016-06-29 09:20:34'),
('1', '8', 'delete', 1, NULL, '1', '2016-06-29 09:20:53', '1', '2016-06-29 09:20:53'),
('1', '8', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:11'),
('1', '8', 'update', 1, NULL, '1', '2016-06-29 09:20:44', '1', '2016-06-29 09:20:44'),
('1', '9', 'read', 1, NULL, '1', '2016-06-28 18:18:50', '1', '2016-06-29 08:23:11');
/*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_session 结构
DROP TABLE IF EXISTS `sys_session`;
CREATE TABLE IF NOT EXISTS `sys_session` (
`id_` BIGINT(32) 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(32) NULL DEFAULT NULL,
`update_time` datetime NOT NULL,
`update_by` BIGINT(32) NULL DEFAULT NULL,
PRIMARY KEY (`id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会话管理';
-- 导出 表 ibase4j.sys_user 结构
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE IF NOT EXISTS `sys_user` (
`id_` BIGINT(32) NOT NULL,
`account_` varchar(20) DEFAULT NULL COMMENT '登陆帐户',
`password_` varchar(50) DEFAULT NULL COMMENT '密码',
`phone_` varchar(50) DEFAULT NULL COMMENT '电话',
`sex_` int(1) NOT NULL DEFAULT '0' COMMENT '性别(0:未知;1:男;2:女)',
`user_name` varchar(30) DEFAULT NULL COMMENT '用户名',
`avatar_` varchar(500) DEFAULT NULL,
`user_type` int(1) DEFAULT '1' COMMENT '人员类型(1:经办员;2:管理员;3:系统内置人员;)',
`dept_id` BIGINT(32) DEFAULT '1' COMMENT '部门编号',
`locked_` tinyint(1) DEFAULT '0' COMMENT '锁定标志(1:锁定;0:激活)',
`enable_` tinyint(1) DEFAULT '1',
`remark_` varchar(5000) DEFAULT '1',
`create_time` datetime NOT NULL,
`create_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
PRIMARY KEY (`id_`),
UNIQUE KEY `account` (`account_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 正在导出表 ibase4j.sys_user 的数据:~2 rows (大约)
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` (`id_`, `account_`, `password_`, `phone_`, `sex_`, `user_name`, `avatar_`, `user_type`, `dept_id`, `locked_`, `enable_`, `remark_`, `create_time`, `create_by`, `update_time`, `update_by`) VALUES
('1', 'admin', 'i/sV2VpTPy7Y+ppesmkCmM==', '15333821711', 0, 'admin', 'res/img/favicon.jpg', 3, '1', 0, 1, '1', '2016-05-06 10:06:52', '1', '2016-06-13 14:04:38', '1'),
('2', 'test', 'i/sV2VpTPy7Y+ppesmkCmM==', '12345678901', 0, 'test', NULL, 1, '1', 0, 1, '1', '2016-05-13 16:58:17', '1', '2016-06-13 14:04:38', '1');
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
-- 导出 表 ibase4j.sys_user_menu 结构
DROP TABLE IF EXISTS `sys_user_menu`;
CREATE TABLE IF NOT EXISTS `sys_user_menu` (
`user_id` BIGINT(32) NOT NULL,
`menu_id` BIGINT(32) NOT NULL,
`permission_` varchar(50) NOT NULL COMMENT '权限标识',
`enable_` tinyint(1) DEFAULT NULL,
`remark_` varchar(5000) DEFAULT NULL,
`create_by` BIGINT(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`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 结构
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE IF NOT EXISTS `sys_user_role` (
`user_id` BIGINT(32) NOT NULL,
`role_id` BIGINT(32) NOT NULL,
`enable_` tinyint(1) DEFAULT NULL,
`remark_` varchar(5000) DEFAULT NULL,
`create_by` BIGINT(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户授权表';
-- 正在导出表 ibase4j.sys_user_role 的数据:~0 rows (大约)
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
INSERT INTO `sys_user_role` (`user_id`, `role_id`, `enable_`, `remark_`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES
('1', '1', NULL, 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 结构
DROP TABLE IF EXISTS `sys_user_thirdparty`;
CREATE TABLE IF NOT EXISTS `sys_user_thirdparty` (
`id_` BIGINT(32) NOT NULL,
`user_id` BIGINT(32) 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(32) NOT NULL,
`create_time` datetime NOT NULL,
`update_by` BIGINT(32) 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 结构
DROP TABLE IF EXISTS `task_fire_log`;
CREATE TABLE IF NOT EXISTS `task_fire_log` (
`id_` BIGINT(32) 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;

Comment ( 0 )

Sign in for post a comment