33 lines
870 B
SQL
33 lines
870 B
SQL
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : webmagic
|
|
Source Server Version : 50537
|
|
Source Host : 127.0.0.1:3306
|
|
Source Database : db
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50537
|
|
File Encoding : 65001
|
|
|
|
Date: 2015-02-01 10:30:34
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for migrationtask
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `migrationtask`;
|
|
CREATE TABLE `migrationtask` (
|
|
`BeginID` int(11) NOT NULL,
|
|
`EndID` int(11) NOT NULL,
|
|
`IsDone` bit(1) DEFAULT b'0',
|
|
`BeginTime` datetime DEFAULT NULL,
|
|
`EndTime` datetime DEFAULT NULL,
|
|
`flow` varchar(255) DEFAULT NULL,
|
|
`SourceTableName` varchar(32) NOT NULL,
|
|
`TargetTableName` varchar(32) NOT NULL,
|
|
PRIMARY KEY (`BeginID`,`EndID`,`SourceTableName`,`TargetTableName`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|