Fetch the repository succeeded.
This action will force synchronization from iBase4J/iBase4J, which will overwrite any changes that you have made since you forked the repository, and can not be recovered!!!
Synchronous operation will process in the background and will refresh the page when finishing processing. Please be patient.
-- --------------------------------------------------------
-- 主机: 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;
Sign in for post a comment
Comment ( 0 )