 MySQL Backup
 Source Server Version: 5.0.22
 Source Database: jsh_erp
-Date: 2017-09-26 22:48:49
+Date: 2017-09-28 23:46:06
 */
 
 SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+--  Table structure for `databasechangelog`
+-- ----------------------------
+DROP TABLE IF EXISTS `databasechangelog`;
+CREATE TABLE `databasechangelog` (
+  `ID` varchar(255) NOT NULL,
+  `AUTHOR` varchar(255) NOT NULL,
+  `FILENAME` varchar(255) NOT NULL,
+  `DATEEXECUTED` datetime NOT NULL,
+  `ORDEREXECUTED` int(11) NOT NULL,
+  `EXECTYPE` varchar(10) NOT NULL,
+  `MD5SUM` varchar(35) default NULL,
+  `DESCRIPTION` varchar(255) default NULL,
+  `COMMENTS` varchar(255) default NULL,
+  `TAG` varchar(255) default NULL,
+  `LIQUIBASE` varchar(20) default NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- ----------------------------
+--  Table structure for `databasechangeloglock`
+-- ----------------------------
+DROP TABLE IF EXISTS `databasechangeloglock`;
+CREATE TABLE `databasechangeloglock` (
+  `ID` int(11) NOT NULL,
+  `LOCKED` bit(1) NOT NULL,
+  `LOCKGRANTED` datetime default NULL,
+  `LOCKEDBY` varchar(255) default NULL,
+  PRIMARY KEY  (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- ----------------------------
 --  Table structure for `jsh_account`

-- ----------------------------
--  Records 
-- ----------------------------
INSERT INTO `jsh_account` VALUES ('4','南通建行','652346523465234623','1200','215','建行账户'), ('9','流动总账','65234624523452364','2000','393','现在账户'), ('10','支付宝','123456789@qq.com','10000',NULL,''), ('11','微信','13000000000','10000',NULL,''), ('12','上海农行','65324345234523211','10000','0','');
INSERT INTO `jsh_accounthead` VALUES ('57','收预付款','8','3',NULL,'1000',NULL,'2342134','2017-06-27 00:00:00',''), ('61','收预付款','9','3',NULL,'33',NULL,'SYF2017062901721','2017-06-29 00:00:00','aaaaaa'), ('67','收预付款','10','4',NULL,'2100',NULL,'SYF2017070222414','2017-07-02 00:00:00',''), ('68','收入','6','3','200','200','4','SR20170703233610','2017-07-03 00:00:00',''), ('70','支出','4','3','-60','-60','4','ZC20170703233735','2017-07-03 00:00:00',''), ('72','付款','4','3',NULL,'-200',NULL,'FK20170703233852','2017-07-03 00:00:00',''), ('74','转账',NULL,'3','-100','-100','4','ZZ2017070323489','2017-07-03 00:00:00',''), ('75','付款','4','3',NULL,'-300',NULL,'FK201707040746','2017-07-04 00:00:00',''), ('77','收入','2','3','40','40','4','SR20170704222634','2017-07-04 00:00:00',''), ('78','收预付款','9','3',NULL,'200',NULL,'SYF201707050257','2017-07-05 00:00:00',''), ('79','收预付款','9','3',NULL,'100',NULL,'SYF20170705076','2017-07-05 00:00:00',''), ('80','付款','1','3',NULL,'-200',NULL,'FK20170705088','2017-07-05 00:00:00',''), ('81','收款','2','4',NULL,'500',NULL,'SK201707050836','2017-07-05 00:00:00','');
INSERT INTO `jsh_accountitem` VALUES ('58','57','9',NULL,'1000',''), ('62','61','4',NULL,'33',''), ('68','67','4',NULL,'2100',''), ('69','68',NULL,'15','200',''), ('71','70',NULL,'11','60',''), ('73','72','9',NULL,'200',''), ('75','74','9',NULL,'100',''), ('76','75','9',NULL,'-300',''), ('78','77',NULL,'14','40',''), ('79','78','9',NULL,'200',''), ('80','79','9',NULL,'100',''), ('81','80','9',NULL,'-200',''), ('82','81','9',NULL,'500','');

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `jsh_systemconfig`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_systemconfig`;
CREATE TABLE `jsh_systemconfig` (
  `id` bigint(20) NOT NULL auto_increment COMMENT '编号',
  `type` varchar(50) default NULL COMMENT '类型',
  `name` varchar(100) default NULL COMMENT '名称',
  `value` varchar(200) default NULL COMMENT '值',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统参数';

-- ----------------------------
--  Table structure for `jsh_unit`
-- ----------------------------
DROP TABLE IF EXISTS `jsh_unit`;
