最新SSH集成示例_2016-11-08

/* SQLyog Ultimate v12.09 (64 bit) MySQL - 5.1.47-community-log : Database - webhadoop ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!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' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; USE `webhadoop`; /*Table structure for table `mig_sync_config` */ DROP TABLE IF EXISTS `mig_sync_config`; CREATE TABLE `mig_sync_config` ( `CONFIG_ID` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `MIG_GROUP` int(4) NOT NULL COMMENT '分组', `MIG_TABLE` varchar(30) NOT NULL COMMENT '表名', `MIG_AUTHOR` varchar(20) NOT NULL COMMENT '作者', `SRC_TYPE` int(4) NOT NULL DEFAULT '1' COMMENT '源数据库类型', `SRC_IP` varchar(20) NOT NULL COMMENT '源数据库IP', `SRC_PORT` int(5) NOT NULL COMMENT '源数据库端口', `SRC_SCHEMA` varchar(30) NOT NULL COMMENT '源数据库Schema', `SRC_USER` varchar(20) DEFAULT NULL COMMENT '源数据库用户名', `SRC_PASSWORD` varchar(40) DEFAULT NULL COMMENT '源数据库密码', `DST_TYPE` int(4) NOT NULL DEFAULT '1' COMMENT '目标数据库类型', `DST_IP` varchar(20) NOT NULL COMMENT '目标数据库IP', `DST_PORT` int(5) NOT NULL COMMENT '目标数据端口', `DST_SCHEMA` varchar(30) NOT NULL COMMENT '目标数据库Schema', `DST_USER` varchar(20) DEFAULT NULL COMMENT '目标数据库用户名', `DST_PASSWORD` varchar(40) DEFAULT NULL COMMENT '目标数据库密码', `MIG_WHERE` varchar(1024) DEFAULT NULL COMMENT '过滤条件，如：where domain=4 and num=45', `MIG_MODE` int(4) NOT NULL DEFAULT '5' COMMENT '1-add: append to target table;2-update: update row the same as src in dst;3-add or update: update if exists in dst or else add it;4-delete: delete rows in dst the same as src;5-copy, delete all rows in dst and import from src;6-drop, drop table and create', `MIG_DESC` varchar(128) DEFAULT NULL COMMENT 'remark', `MTIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'modify time', PRIMARY KEY (`CONFIG_ID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='迁移同步表清单'; /*Data for the table `mig_sync_config` */ insert into `mig_sync_config`(`CONFIG_ID`,`MIG_GROUP`,`MIG_TABLE`,`MIG_AUTHOR`,`SRC_TYPE`,`SRC_IP`,`SRC_PORT`,`SRC_SCHEMA`,`SRC_USER`,`SRC_PASSWORD`,`DST_TYPE`,`DST_IP`,`DST_PORT`,`DST_SCHEMA`,`DST_USER`,`DST_PASSWORD`,`MIG_WHERE`,`MIG_MODE`,`MIG_DESC`,`MTIME`) values (1,2,'ca_account_21_0','daizd',1,'10.226.4.234',3306,'AD','mig123','mig123',1,'10.226.4.237',3306,'AD','mig123','mig123',NULL,5,NULL,'2014-07-29 09:39:10'); /*Table structure for table `mig_sync_log` */ DROP TABLE IF EXISTS `mig_sync_log`; CREATE TABLE `mig_sync_log` ( `LOG_ID` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `MIG_GROUP` int(4) NOT NULL COMMENT '分组', `MIG_TABLE` varchar(30) NOT NULL COMMENT '表名', `MIG_AUTHOR` varchar(20) NOT NULL COMMENT '作者', `SRC_TYPE` int(4) NOT NULL DEFAULT '1' COMMENT '源数据库类型', `SRC_IP` varchar(20) NOT NULL COMMENT '源数据库IP', `SRC_PORT` int(5) NOT NULL COMMENT '源数据库端口', `SRC_SCHEMA` varchar(30) NOT NULL COMMENT '源数据库Schema', `SRC_USER` varchar(20) NOT NULL COMMENT '源数据库用户名', `SRC_PASSWORD` varchar(40) NOT NULL COMMENT '源数据库密码', `DST_TYPE` int(4) NOT NULL DEFAULT '1' COMMENT '目标数据库类型', `DST_IP` varchar(20) NOT NULL COMMENT '目标数据库IP', `DST_PORT` int(5) NOT NULL COMMENT '目标数据端口', `DST_SCHEMA` varchar(30) NOT NULL COMMENT '目标数据库Schema', `DST_USER` varchar(20) NOT NULL COMMENT '目标数据库用户名', `DST_PASSWORD` varchar(40) NOT NULL COMMENT '目标数据库密码', `MIG_WHERE` varchar(1024) DEFAULT NULL COMMENT '过滤条件，如：where domain=4 and num=45', `MIG_MODE` int(4) NOT NULL DEFAULT '5' COMMENT '1-add: append to target table;2-update: update row the same as src in dst;3-add or update: update if exists in dst or else add it;4-delete: delete rows in dst the same as src;5-copy, delete all rows in dst and import from src;6-drop, drop table and create', `MIG_DESC` varchar(128) DEFAULT NULL COMMENT 'remark', `MTIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'modify time', `BATCH_NO` int(8) NOT NULL COMMENT '批次号', `DRYRUN_ID` int(4) DEFAULT NULL COMMENT 'DRYRUN_ID', `DRYRUN_ENV` varchar(6) DEFAULT NULL COMMENT 'DRYRUN环境', `BEG_TIME` datetime DEFAULT NULL COMMENT '开始时间', `END_TIME` datetime DEFAULT NULL COMMENT '结束时间', `STATUS` int(4) NOT NULL DEFAULT '1' COMMENT '状态|1：初始，2：等待执行，3：执行中，4：执行成功，-1：报错', `SRC_COUNT` bigint(11) DEFAULT NULL COMMENT '源表数据量', `DST_COUNT1` bigint(11) DEFAULT NULL COMMENT '迁移前目标表数据量', `DST_COUNT2` bigint(11) DEFAULT NULL COMMENT '迁移后目标表数据量', `DST_ADD` bigint(11) DEFAULT NULL COMMENT '目标表增加的数量', `DST_UPDATE` bigint(11) DEFAULT NULL COMMENT '目标表被更新的数量', `DST_DELETE` bigint(11) DEFAULT NULL COMMENT '目标表被删除数量', PRIMARY KEY (`LOG_ID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='迁移同步日志'; /*Data for the table `mig_sync_log` */ insert into `mig_sync_log`(`LOG_ID`,`MIG_GROUP`,`MIG_TABLE`,`MIG_AUTHOR`,`SRC_TYPE`,`SRC_IP`,`SRC_PORT`,`SRC_SCHEMA`,`SRC_USER`,`SRC_PASSWORD`,`DST_TYPE`,`DST_IP`,`DST_PORT`,`DST_SCHEMA`,`DST_USER`,`DST_PASSWORD`,`MIG_WHERE`,`MIG_MODE`,`MIG_DESC`,`MTIME`,`BATCH_NO`,`DRYRUN_ID`,`DRYRUN_ENV`,`BEG_TIME`,`END_TIME`,`STATUS`,`SRC_COUNT`,`DST_COUNT1`,`DST_COUNT2`,`DST_ADD`,`DST_UPDATE`,`DST_DELETE`) values (1,2,'ca_account_21_0','daizd',1,'10.226.4.234',3306,'AD','mig123','mig123',1,'10.226.4.237',3306,'AD','mig123','mig123',NULL,5,NULL,'2016-03-20 22:22:20',1,1,'R','2016-03-20 22:22:20',NULL,2,NULL,NULL,NULL,NULL,NULL,NULL); /*Table structure for table `t_authority_button` */ DROP TABLE IF EXISTS `t_authority_button`; CREATE TABLE `t_authority_button` ( `n_bid` int(8) NOT NULL AUTO_INCREMENT COMMENT '按钮ID', `c_bcode` varchar(30) NOT NULL COMMENT '按钮代码|目前填功能代码。可能用于页面js变量名', `c_bname` varchar(30) NOT NULL COMMENT '按钮名称', `url` varchar(180) NOT NULL COMMENT '请求路径', `remark` varchar(1024) DEFAULT NULL COMMENT '备注', `n_mid` int(8) NOT NULL COMMENT '模块ID', PRIMARY KEY (`n_bid`), UNIQUE KEY `UK_authortiy_button` (`n_mid`,`c_bcode`) ) ENGINE=MyISAM AUTO_INCREMENT=212 DEFAULT CHARSET=utf8; /*Data for the table `t_authority_button` */ insert into `t_authority_button`(`n_bid`,`c_bcode`,`c_bname`,`url`,`remark`,`n_mid`) values (137,'export_wizard','导出向导','exp/migJobInfoEXPexportXLS.action','',10036),(136,'export','导出','exp/migJobInfoEXPexportXLS.action','',10036),(125,'print','打印','print/migAuditvConfigPRINTprint.action','',10055),(124,'search','查询','print/migAuditvConfigPRINTprint.action','',10055),(122,'export','导出','exp/migAuditvConfigEXPexportXLS.action','',10055),(123,'export_wizard','导出向导','exp/migAuditvConfigEXPexportXLS.action','',10055),(121,'import_wizard','导入向导','imp/migAuditvConfigIMPimportXLS.action','',10055),(119,'delete2','删除(all mine)','query/commonJEasyUIQUERYdfind.action','',10055),(120,'import','导入','imp/migAuditvConfigIMPimportXLS.action','',10055),(117,'delete','删除','curd/commonCURDdelete.action','删除本人的某条记录用',10055),(118,'delete1','删除(owner)','curd/commonCURDdelete.action','删除本人所有的记录用',10055),(116,'read1','查看(owner)','curd/commonCURDdelete.action','',10055),(