5.5.49mysql

最新推荐文章于 2024-06-23 20:26:34 发布
最新推荐文章于 2024-06-23 20:26:34 发布
阅读量1.3w 收藏
点赞数
分类专栏： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u014069688/article/details/84964754
版权

原项目地址

https://github.com/cy576013581/swallow

数据库SQL可改为

/*
Navicat MySQL Data Transfer

Source Server         : 39.108.143.76
Source Server Version : 50723
Source Host           : 39.108.143.76:3306
Source Database       : example

Target Server Type    : MYSQL
Target Server Version : 50723
File Encoding         : 65001

Date: 2018-09-16 15:38:18
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for act_evt_log
-- ----------------------------
DROP TABLE IF EXISTS `act_evt_log`;
CREATE TABLE `act_evt_log` (
  `LOG_NR_` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `TYPE_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_STAMP_` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `USER_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `DATA_` LONGBLOB,
  `LOCK_OWNER_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` TIMESTAMP NULL DEFAULT NULL,
  `IS_PROCESSED_` TINYINT(4) DEFAULT '0',
  PRIMARY KEY (`LOG_NR_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_evt_log
-- ----------------------------

-- ----------------------------
-- Table structure for act_ge_bytearray
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_bytearray`;
CREATE TABLE `act_ge_bytearray` (
  `ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` INT(11) DEFAULT NULL,
  `NAME_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTES_` LONGBLOB,
  `GENERATED_` TINYINT(4) DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_ge_bytearray
-- ----------------------------
INSERT INTO `act_ge_bytearray` VALUES ('17502', '1', 'leaveBill.bpmn', '17501', 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0A3C646566696E6974696F6E7320786D6C6E733D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A6F6D6764633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A6F6D6764693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44492220747970654C616E67756167653D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D61222065787072657373696F6E4C616E67756167653D22687474703A2F2F7777772E77332E6F72672F313939392F585061746822207461726765744E616D6573706163653D22687474703A2F2F7777772E61637469766974692E6F72672F74657374223E0A20203C70726F636573732069643D224C6561766542696C6C22206E616D653D224C6561766542696C6C50726F636573732220697345786563757461626C653D2274727565223E0A202020203C73746172744576656E742069643D2273746172746576656E743122206E616D653D225374617274223E3C2F73746172744576656E743E0A202020203C757365725461736B2069643D22757365727461736B3122206E616D653D22E68F90E4BAA4E794B3E8AFB7222061637469766974693A61737369676E65653D22247B696E707574557365727D222061637469766974693A666F726D4B65793D22776F726B666C6F77416374696F6E5F61756469742E616374696F6E223E3C2F757365725461736B3E0A202020203C73657175656E6365466C6F772069643D22666C6F77312220736F757263655265663D2273746172746576656E743122207461726765745265663D22757365727461736B31223E3C2F73657175656E6365466C6F773E0A202020203C757365725461736B2069643D22757365727461736B3222206E616D653D22E7BB8FE7BAAAE4BABAE5AEA1E689B9222061637469766974693A666F726D4B65793D22776F726B666C6F77416374696F6E5F61756469742E616374696F6E223E0A2020202020203C657874656E73696F6E456C656D656E74733E0A20202020202020203C61637469766974693A7461736B4C697374656E6572206576656E743D226372656174652220636C6173733D22636F6D2E63792E6578616D706C652E737570706C656D656E742E61637469766974692E4D616E616765725461736B48616E646C6572223E3C2F61637469766974693A7461736B4C697374656E65723E0A2020202020203C2F657874656E73696F6E456C656D656E74733E0A202020203C2F757365725461736B3E0A202020203C73657175656E6365466C6F772069643D22666C6F77322220736F757263655265663D22757365727461736B3122207461726765745265663D22757365727461736B32223E3C2F73657175656E6365466C6F773E0A202020203C757365725461736B2069643D22757365727461736B3322206E616D653D22E88081E680BBE5AEA1E689B9222061637469766974693A666F726D4B65793D22776F726B666C6F77416374696F6E5F61756469742E616374696F6E223E0A2020202020203C657874656E73696F6E456C656D656E74733E0A20202020202020203C61637469766974693A7461736B4C697374656E6572206576656E743D226372656174652220636C6173733D22636F6D2E63792E6578616D706C652E737570706C656D656E742E61637469766974692E4D616E616765725461736B48616E646C6572223E3C2F61637469766974693A7461736B4C697374656E65723E0A2020202020203C2F657874656E73696F6E456C656D656E74733E0A202020203C2F757365725461736B3E0A202020203C73657175656E6365466C6F772069643D22666C6F77332220736F757263655265663D22757365727461736B3222207461726765745265663D22757365727461736B33223E3C2F73657175656E6365466C6F773E0A202020203C656E644576656E742069643D22656E646576656E743122206E616D653D22456E64223E3C2F656E644576656E743E0A202020203C73657175656E6365466C6F772069643D22666C6F77342220736F757263655265663D22757365727461736B3322207461726765745265663D22656E646576656E7431223E3C2F73657175656E6365466C6F773E0A20203C2F70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F4C6561766542696C6C223E0A202020203C62706D6E64693A42504D4E506C616E652062706D6E456C656D656E743D224C6561766542696C6C222069643D2242504D4E506C616E655F4C6561766542696C6C223E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D2273746172746576656E7431222069643D2242504D4E53686170655F73746172746576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233352E30222077696474683D2233352E302220783D223239302E302220793D2236302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B31222069643D2242504D4E53686170655F757365727461736B31223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223235352E302220793D223134302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B32222069643D2242504D4E53686170655F757365727461736B32223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223235352E302220793D223233302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22757365727461736B33222069643D2242504D4E53686170655F757365727461736B33223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2235352E30222077696474683D223130352E302220783D223235352E302220793D223331302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652062706D6E456C656D656E743D22656E646576656E7431222069643D2242504D4E53686170655F656E646576656E7431223E0A20202020202020203C6F6D6764633A426F756E6473206865696768743D2233352E30222077696474683D2233352E302220783D223239302E302220793D223430302E30223E3C2F6F6D6764633A426F756E64733E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7731222069643D2242504D4E456467655F666C6F7731223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330372E302220793D2239352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330372E302220793D223134302E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7732222069643D2242504D4E456467655F666C6F7732223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330372E302220793D223139352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330372E302220793D223233302E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7733222069643D2242504D4E456467655F666C6F7733223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330372E302220793D223238352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330372E302220793D223331302E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652062706D6E456C656D656E743D22666C6F7734222069643D2242504D4E456467655F666C6F7734223E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330372E302220793D223336352E30223E3C2F6F6D6764693A776179706F696E743E0A20202020202020203C6F6D6764693A776179706F696E7420783D223330372E302220793D223430302E30223E3C2F6F6D6764693A776179706F696E743E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F646566696E6974696F6E733E, '0');
INSERT INTO `act_ge_bytearray` VALUES ('17503', '1', 'leaveBill.png', '17501', 0x89504E470D0A1A0A0000000D49484452000002C3000001B808020000002FE37D8A0000247A49444154789CEDDD6F6C53D7FDC7716B85E1A14DCDB46E89F6A4AEF6003FD888B5560A8F868334E249DB6A6955E3ED01B334A90555EBAA69EAC226CAB49645D3DAA1A943746B99B589DF3C55014BA55D564897B14033FE8400A5758114B701EA02A16624E492D8F1F9DD5CC3E5E2C4C676E29C7377DE2F7D1519FBDEEB7B72D4EFF9D48EAF3D020000A0561ED9270000005C8C240100006A4792000000B52349000080DA9124000040ED48120000A07624090000503B92040000A81D49020000D48E240100006A4792000000B52349000080DA9124000040ED48120000A07624090000503B92040000A81D49020000D48E240100006A4792000000B52349000080DA9124000040ED48120000A07624090000503B92040000A81D49020000D48E240100006A4792000000B52349000080DA9124000040ED48120000A07624090000503B92040000A81D49020000D48E240100006A4792000000B52349000080DA9124000040ED48120000A07624090000503B92040000A81D49020000D48E240100006A4792000000B52349000080DA9124000040ED48120000A07624090000503B92040000A81D49020000D48E240100006A4792000000B52349000080DA9124000040ED48120000A07624090000503B92040000A81D49020000D48E240100006A4792000000B52349004A300C2391486CDCB8311C0E076F0A8542E63DF1783C93C9C83E4100981D490290CC0C106662F07ABD668630734357D78E3D3D6F146AD7ABAF6DD8F054241269686858B162452C16937DB200508C240148333838180C06CD00612686C96CAE7CF5EDDBBF66CDF70381406F6FAFEC1307805B4812801C9D9D9D662CD8D3F3C61D3384B30E1D1E58B972E5DAB56B0DC3903D020098469200169A19022291484747475519C259BFDFB225180CA6D369D94301009204B0B0CC18B162C58A783C5E738CB0DFEC308F934AA5640F0880EE4812C0828A4422738F11F63B1D6698E06D0E007291248085D3D9D939973735665657D78E70382C7B5800B446920016C8E0E060201098C71851A8471E7974EBD6ADB20707405F240960819831E2D0E181794F12C367CFDD7BAF8FF73800C8429200164222910887C3F31E230AF5F8E33FDABC79B3EC2102D01449025808C160B0DA4B4754F5B244535393EC2102D0144902A8BB4C26D3D0D050A71851A8969696FEFE7ED90305A02392045077B1582C1A8DD635493CB36953474787EC8102D0114902A8BBB56BD76EDDBAB5AE49624FCF1BC16050F64001E8882401D45D2814AAE43BBAE652A78786EEBDD7277BA00074449200EAAE4E9FFF74D6D5D131AFD72B7BA00074449200EAAEA9A969F8ECB9BA2609B33C1EFE73062001AD07A83BBFDFFFD68913240900FF93683D40DDD5F56212FC9D0400B9481240DD45A3D197B66DAB6B92E8DBB7BFA5A545F64001E8882401D4DDE6CD9B1F7FFC47754D12665259B3E6FBB2070A40472409A0EE52A994CFE7AB6B92686B6BEBEEEE963D50003A2249000BA1AE7F74797574ACA1A181AF0305200549025808757D83E3D9E79E330F2E7B880034459200168261183E9FAF1E5795B83A3A76EFBDBE743A2D7B88003445920016483C1E7FB8BD9D172400FC8F2149000BE7DB0F3ED8D5B5631E63C45B274E3437375F1D1D933D3200FA2249000B2793C9B4B4B4CCD79F5E5EBC3462C688D34343B28705406B24096041259349334C98CBFFDC63C4B71F7C70D7ABAFC91E1000DD91248085363838D8DCDCDCB76FFF5CDED430E3083102800A48128004994C66E5CA951B363C75F1D2485519E2EAE8D8B3CF3D57788B44F62000601A490290C3300C33492C5BE6379381990F2A89112F6DDB666EFFF8E33F32F387ECD307801B4812804CE974FA89279E686868F8F6830F9A41E1D0E181A2F460DEB37DFBFF3DDCDE6E6EB366CDF753A994EC530680DB902400F90CC3482412D168B4B9B9D9733BF31E3346C4E3F14C2623FB340160162409404566AA907D0A0050119204A0228F87FF3601B803DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50114902805BD0AD0015912400B805DD0A50453C1E370384D7EB0D0402E68DA6A626F3E7D2A54B93C9A4EC530380924812802A76EEDCE999A1B5B5359148C83E350028892401A8C2308C254B963863C4F2E5CB9B9A9A32998CEC5303809248128042D6AF5FBF68D1223B49AC5BB7AEA3A343F6490140392409402D8D8D8D8518D1DEDEEEF3F90CC3907D4600500E490250CBDEBD7B172F5E6C26895028C45F4800501F490250CEAA55AB0A4942F68900C09D912400E5A4D3693349F0E14F00AE40920054C495A900B805DD0AB8C5308C783C1E894482C1A0CFE79B7975074D9863377F03E17038168BF1195400E59124801BBABBBBCD15D48C11DBB76FDFD3D3737A6868329BD5B3CCB19BBF81AEAEAE356BD698BF13334FC89E1C00EA224900C2FCDFEE6834DAD6D6367C7678323B4939EBE2A58B669E307F39E9745AF6440150114902BA33634420107869DB8B93D909AA54ED7A75574B4B4B2A95923D5D0094439280EEA2D1A81523AE53E56B4FCFEE952BBF267BBA0028872401AD757777B7B5ADCEE60CAA927AF2A73FD9B4E969D99306402D2409E8CB300C9FCF77F65C2A9B1BA72AA9D1B18F9B9B9773A10B004E2409E82B168B45A3D16CEE9A5DADA16F56F83949E75E5AD5A64DBFE44BC500389124A0AF7038DCB5E36FB762C4EAB60F85787F4A9CCA8AB727C4D109716834B779C71BAF9FBB726052FCC710070CD1774DECBE2E7ED777FC91B58F4A5FD4A5D4E181FE4020207BEA00288424017DF9FDFE13278E64736385F2783CA3428CE5C5959CB83C29AE09F1E39F3DE5F9C4A757AC0E9FCB8AE109317C5DA40C713A275E7EF3A8F5B2C49886353A36E2F57A654F1D00859024A0AF8686864B23E7B2B9D14299E1E0DA9498989A7E28979FFEF9CA6BFFF8E297BEFCF3679ECD09713527AE64C5E5ACC808B1FBE0312B498CEA591EAEE40DC0818E007D5969E0AA5DE63FC77262645C4C4EDDD82093C9FCF6F9179EFECDF3C3E7A72FCA94CD8B492B61EC3F7CB4685FAD8A2401C0898E007D5969E0BF764D27892971F19AF868546485989C98F02F5BE6F1DCE5F1781FFAEE1AE78E87068E14EDAB5591240038D111A02F2B0D5CB1ABF0EEC6C8B8387F555CB82E0E9D78AFB1B1F1AE459FFCD4DDF744BE775B92387878A0685FAD8A2401C0898E007D5969206397F9CFF1BCB86C4CBF2671F1BAE83998FC4AF3FDF77CFE0B77377CF6853FBF7C5D88D109716D627AC7BEFE8345FB6A552409004E7404E8CB5C1173B98FED2A2C906698B892151F4F8AF357B3FB8FA79ABFFA40EBD7BF7161427C64880B861899106696E83B70B0685FAD8A2401C0898E007D15A58160EBCA63EF9C3A743CD93F98DC3790DC77E4E4FE6343FF3CF0F69BC7CFEC1D38F9EF8177F71D79B7FFE8C9E3A73ED8F2876D0FB73F2C7D4527490050011D01FAB292C465673DF6D8A3955CE0F23B0F3D54B4A356459200E0444780BEAC243142555B2409004E7404E86B3A494C5DA2AA2D920400273A02F46525898B54B5459200E0444780BEAC247181AAB64812009CE808D09795243EA2AA2D920400273A02F465258934556D91240038D111A02F92044902C0DCD111A02F2B497C48555B2409004E7404E8CB5C11A7A6CE53D516490280131D01FAB292C439AADA22490070A223405F5692384B555B2409004E7404E8CB4A12C3F528FBC8455FD8517EE34A0E78C7FBEB3728E753C89E3A000AA123405FD6A2FB413DCA3EB2F3299C779657E680A51EAAF038F3353AD9530740217404E8AB1E6B6DD1425E7E699F3567CC7AA8CA2342FD02044902C0ACE808D097B5E8BE5F8FB28FEC7C8AA2A79BF9EC653628731CFBCED90247BD46277BEA0028848E007D4DAFB5F9543DEAC6427EF3C6ADA5DDB181FDB3CC3D255F93B8FD598A9EBA4E83723E85ECA903A0103A02F4652DBA67E6BD6E2EF0E53628BA5174BBFCA3B3DE2E1138E67F7485E7923D750014424780BEACB5F6BDF9ADC231ED9FB3ADEEC51BCFBC5DFED16A6FD7638CB2A70E8042E808D097B5DC0ED5A3EC23176E9479A2321B947D77A3F889666E5FA7A1159E48F6D40150081D01FAB296DBD3F528FBC8851B8ED5BDDCC6951C70D6FB9D3F2B3FE65C46277BEA0028848E007D59CBEDA97A54E1C8F6CF524F643F54661BE701CB1CC1BEED482D75195AE189644F1D0085D011A0AF7A2CB7B3AEE54577965AECCB84803249E28EB7491200EA8A8E007D992B623E7F92AAB64812009CE808D0979524DEA5AA2D920400273A02F465258924556D91240038D111A02F2B49BC43555B2409004E7404E8CBEBF58E8F1FC9E7DFA6AA2A920400273A02F4E5F3F9CE9C793D9F3F4155552409004E7404E82B140AFDBD7B6B5EBC45555EEF245FF1FBFDB2A70E80424812D05767676747C70FA4AFCDEEAA3FC59E8946A3B2A70E80424812D0572A95F2FBEF1B370EE5C571AAC20A8757251209D9530740212409686DE3B4B579718CAAA4FE1AFF752412923D6900D4429280D60CC308061FE8EFFF8B1047A9F2954EF7F8FDF765327DB2270D805A4812D05D32990C04962593092106A95265C6083372F5F6BE287BBA002887240188FEFE7E334C7476FE508823D4CC4A249EF3FB7DBDBD7F943D510054449200A61986D1D1110D06EF8FC57E914EEF166280CA64FE158FFF2A12690B8783E66DD9530440512409E096DEDEDE68F45B4D4D9FF3C0E36968F84C24B2DA0C13B2A70580D24812808AB8660300B72049002AF270456A002E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254118FC7CD00E1F57A03818079A3A9A9C9FCB974E9D2643229FBD400A0249204A08A9D3B777A66686D6D4D2412B24F0D004A224900AA300C63C99225CE18B17CF9F2A6A6A64C2623FBD400A0249204A090F5EBD72F5AB4C84E12EBD6ADEBE8E8907D5200500E4902504B6363632146B4B7B7FB7C3EC330649F110094439200D4B277EFDEC58B179B4922140AF1171200D447920094B36AD5AA4292907D2200706724094039E974DA4C127CF813802B9024001571652A006E41B7026E310C231E8F4722916030E8F3F9665EDD4113E6D8CDDF40381C8EC5627C061540792409E086EEEE6E73053563C4F6EDDBF7F4F49C1E1A9ACC66F52C73ECE66FA0ABAB6BCD9A35E6EFC4CC13B2270780BA48128030FFB73B1A8DB6B5B50D9F1D9ECC4E52CEBA78E9A29927CC5F4E3A9D963D510054449280EECC181108045EDAF6E26476822A55BB5EDDD5D2D2924AA5644F1700E59024A0BB68346AC588EB54F9DAD3B37BE5CAAFC99E2E00CA2149406BDDDDDD6D6DABB33983AAA49EFCE94F366D7A5AF6A401500B4902FA320CC3E7F39D3D97CAE6C6A94A6A74ECE3E6E6E55CE80280134902FA8AC562D168349BBB66576BE89B157E4ED2B99756B569D32FF95231004E2409E82B1C0E77EDF8DBAD18B1BAED4321DE9F12A7B2E2ED097174421C1ACD6DDEF1C6EBE7AE1C9814FF31C40143F45D13BBAF8BDFF51D7F64EDA3D21775297578A03F1008C89E3A000A2149405F7EBFFFC48923D9DC58A13C1ECFA81063797125272E4F8A6B42FCF8674F793EF1E915ABC3E7B26278420C5F1729439CCE8997DF3C6ABD2C31A6618D8E8D78BD5ED9530740212409E8ABA1A1E1D2C8B96C6EB4506638B8362526A6A61FCAE5A77FBEF2DA3FBEF8A52FFFFC996773425CCD892B5971392B3242EC3E78CC4A12A37A96872B790370A023405F561AB86A97F9CFB19C18191793533736C86432BF7DFE85A77FF3FCF0F9E98B3265F362D24A18FB0F1F2DDA57AB22490070A223405F561AF8AF5DD349624A5CBC263E1A155921262726FCCB96793C77793CDE87BEBBC6B9E3A1812345FB6A552409004E7404E8CB4A0357EC2ABCBB31322ECE5F1517AE8B4327DE6B6C6CBC6BD1273F75F73D91EFDD96240E1E1E28DA57AB22490070A223405F561AC8D865FE733C2F2E1BD3AF495CBC2E7A0E26BFD27CFF3D9FFFC2DD0D9F7DE1CF2F5F176274425C9B98DEB1AFFF60D1BE5A15490280131D01FA3257C45CEE63BB0A0BA41926AE64C5C793E2FCD5ECFEE3A9E6AF3ED0FAF56F5C98101F19E282214626849925FA0E1C2CDA57AB22490070A223405F456920D8BAF2D83BA70E1D4FF60F26F70D24F71D39B9FFD8D03F0FBCFDE6F1337B074EFE7BE0DD7D47DEED3F7AF2F8A90FB6FC61DBC3ED0F4B5FD149120054404780BEAC2471D9598F3DF6682517B8FCCE430F15EDA85591240038D111A02F2B498C50D516490280131D01FA9A4E125397A86A8B2401C0898E007D5949E222556D91240038D111A02F2B495CA0AA2D920400273A02F46525898FA86A8B2401C0898E007D5949224D555B2409004E7404E88B2441920030777404E8CB4A121F52D516490280131D01FA3257C4A9A9F354B5459200E0444780BEAC24718EAAB64812009CE808D0979524CE52D516490280131D01FAB292C4F0DCAB709C995FCF31739B5977ACFCFE0AB7B11F9A7963BEC62B7BEA0028848E007D59EBEB0773AF99C72973CF6C81E3CE079C75C752C7713E579903CE65BCB2A70E8042E808D0D7BCACAF952CDBA51E2A750295C78BA2478B82054902C002A023405FD6FAFAFE5CCA3E82F3C6CD85BCE436331FAAF0FE0AB799F5AC2A3C6C85A3963D750014424780BEA657D67C6A2E752B37DCFCA7F3A152DBDCF6CA4189C3967FBA59DEDA986D77FBA132CF55DBA8654F1D0085D011A02F6B713D33F72A1C67E6D1EC7B9C0FDDF1494B1DADCC718A36BE991B663F817919AFECA903A0103A02F465ADAFEFCDB10A07B17FDEFE3AC1AD0D9C8F567EC0990F957E4D6296A79879635E8A2401C0898E007D59EBEBD05CCAB172DF7667996DEEB871A987CA3C5AEA20A59E74EEA3963D750014424780BEACF5F5F4BCD4CDAC70E376F92D2BFCE7CCE3947D4D629683146ED81BCCD7784912009CE808D097B5B29E9A4B3916F2DBEE2CB5E5CC479DFF9CB9639933ACE4A1A2279DFB78EDC3CA9E3A000AA123405FF3B5B216A58ADB5F2AB8B59C97DA72D66D6646904A924451B2298A14240900F5404780BECC15319F3F49555B2409004E7404E8CB4A12EF52D516490280131D01FAB2924492AAB64812009CE808D0979524DEA1AA2D920400273A02F4E5F57AC7C78FE4F36F535515490280131D01FAF2F97C67CEBC9ECF9FA0AA2A920400273A02F4150A85FEDEBD352FDEA22AAF7792AFF8FD7ED9530740212409E8ABB3B3B3A3E307D2D76677D59F62CF44A351D9530740212409E82B954AF9FDF78D1B87F2E238556185C3AB128984ECA903A0109204B4B671DADABC384655527F8DFF3A1209C99E34006A2149406B866104830FF4F7FF4588A354F94AA77BFCFEFB32993ED99306402D2409E82E994C0602CB92C984108354A932638419B97A7B5F943D5D0094439200447F7FBF19263A3B7F28C4116A662512CFF9FDBEDEDE3FCA9E28002A224900D30CC3E8E8880683F7C762BF48A7770B31406532FF8AC77F1589B485C341F3B6EC2902A0289204704B6F6F6F34FAADA6A6CFCDFA15E1BA6968F84C24B2DA0C13B2A70580D24812808AB8660300B72049002AF270456A002E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254449200E016742B40452409006E41B70254118FC7CD00E1F57A03818079A3A9A9C9FCB974E9D2643229FBD400A0249204A08A9D3B777A66686D6D4D2412B24F0D004A224900AA300C63C99225CE18B17CF9F2A6A6A64C2623FBD400A0249204A090F5EBD72F5AB4C84E12EBD6ADEBE8E8907D5200500E4902504B6363632146B4B7B7FB7C3EC330649F110094439200D4B277EFDEC58B179B4922140AF1171200D447920094B36AD5AA4292907D2200706724094039E974DA4C127CF813802B9024001571652A006E41B7026E310C231E8F4722916030E8F3F9665EDD4113E6D8CDDF40381C8EC5627C061540792409E086EEEE6E73053563C4F6EDDBF7F4F49C1E1A9ACC66F52C73ECE66FA0ABAB6BCD9A35E6EFC4CC13B2270780BA48128030FFB73B1A8DB6B5B50D9F1D9ECC4E52CEBA78E9A29927CC5F4E3A9D963D510054449280EECC181108045EDAF6E26476822A55BB5EDDD5D2D2924AA5644F1700E59024A0BB68346AC588EB54F9DAD3B37BE5CAAFC99E2E00CA2149406BDDDDDD6D6DABB33983AAA49EFCE94F366D7A5AF6A401500B4902FA320CC3E7F39D3D97CAE6C6A94A6A74ECE3E6E6E55CE80280134902FA8AC562D168349BBB66576BE89B157E4ED2B99756B569D32FF95231004E2409E82B1C0E77EDF8DBAD18B1BAED4321DE9F12A7B2E2ED097174421C1ACD6DDEF1C6EBE7AE1C9814FF31C40143F45D13BBAF8BDFF51D7F64EDA3D21775297578A03F1008C89E3A000A2149405F7EBFFFC48923D9DC58A13C1ECFA81063797125272E4F8A6B42FCF8674F793EF1E915ABC3E7B26278420C5F1729439CCE8997DF3C6ABD2C31A6618D8E8D78BD5ED9530740212409E8ABA1A1E1D2C8B96C6EB4506638B8362526A6A61FCAE5A77FBEF2DA3FBEF8A52FFFFC996773425CCD892B5971392B3242EC3E78CC4A12A37A96872B790370A023405F561AB86A97F9CFB19C18191793533736C86432BF7DFE85A77FF3FCF0F9E98B3265F362D24A18FB0F1F2DDA57AB22490070A223405F561AF8AF5DD349624A5CBC263E1A155921262726FCCB96793C77793CDE87BEBBC6B9E3A1812345FB6A552409004E7404E8CB4A0357EC2ABCBB31322ECE5F1517AE8B4327DE6B6C6CBC6BD1273F75F73D91EFDD96240E1E1E28DA57AB22490070A223405F561AC8D865FE733C2F2E1BD3AF495CBC2E7A0E26BFD27CFF3D9FFFC2DD0D9F7DE1CF2F5F176274425C9B98DEB1AFFF60D1BE5A15490280131D01FA3257C45CEE63BB0A0BA41926AE64C5C793E2FCD5ECFEE3A9E6AF3ED0FAF56F5C98101F19E282214626849925FA0E1C2CDA57AB22490070A223405F456920D8BAF2D83BA70E1D4FF60F26F70D24F71D39B9FFD8D03F0FBCFDE6F1337B074EFE7BE0DD7D47DEED3F7AF2F8A90FB6FC61DBC3ED0F4B5FD149120054404780BEAC2471D9598F3DF6682517B8FCCE430F15EDA85591240038D111A02F2B498C50D516490280131D01FA9A4E125397A86A8B2401C0898E007D5949E222556D91240038D111A02F2B495CA0AA2D920400273A02F46525898FA86A8B2401C0898E007D5949224D555B2409004E7404E88B2441920030777404E8CB4A121F52D516490280131D01FA3257C4A9A9F354B5459200E0444780BEAC24718EAAB64812009CE808D0979524CE52D516490280131D01FAB292C4705DABFC53381FAD7CCB520FCDBC51BF41C99E3A000AA123405FD68AFB415DCBF914B33E5DE1CE990FDDF15BC4661E76E68DFA0D4AF6D40150081D01FAAAD38A7BC7B5BF92CDCA9F9B9D3F9C7B91240048414780BEAC15F7FDBA56E129667DA2CAEF2C73BFF3A1A21BF51B1D490280131D01FA9A5E6BF3A9F9AD3BBF2BE1D872D6DD2B39D4ACBBD80FCDDC66DEC7287BEA0028848E007D59CBED99BA5699A7289D1266D9B7D46DFB38CEFBEB3D2E920400273A02F465ADB8EFD5AFECE3DF5CECABDEBD74DAB86D83994F57EF71C99E3A000AA123405FD68A3B54A7BA7DE12FB98DFDD37963E63F4BDD9E75F7BA8EAB707CD9530740217404E8CB5A714FD7A30A472E3ABEF39F451BCCBC51B85DFA3589590E6B1F73D6679FDFD1C99E3A000AA123405FD65A7B6A7EEBE6427EE376D14345B767DD60D6B32A73AACEA7731EA11EA3B39F48F6D40150081D01FAAADF5AEB5CDA6F7F2D6196B57FE6061526893B1E9624016001D011A02F7345CCE74F52D516490280131D01FAB292C4BB54B5459200E0444780BEAC2491A4AA2D920400273A02F465258977A86A8B2401C0898E007D79BDDEF1F123F9FCDB5455459200E0444780BE7C3EDF9933AFE7F327A8AA8A2401C0898E007D8542A1BF776FCD8BB7A8CAEB9DE42B7EBF5FF6D40150084902FAEAECECECE8F881F4B5D95DF5A7D833D16854F6D40150084902FA4AA5527EFF7DE3C6A1BC384E5558E1F0AA4422217BEA0028842401AD6D9CB6362F8E5195D45FE3BF8E4442B2270D805A4812D09A6118C1E003FDFD7F11E22855BED2E91EBFFFBE4CA64FF6A401500B4902BA4B269381C0B2643221C42055AACC186146AEDEDE17654F1700E5902400D1DFDF6F8689CECE1F0A71849A5989C4737EBFAFB7F78FB2270A808A4812C034C3303A3AA2C1E0FDB1D82FD2E9DD420C5099CCBFE2F15F45226DE170D0BC2D7B8A00288A2401DCD2DBDB1B8D7EABA9E97333BFEF5B430D0D9F8944569B6142F6B400501A49025011D76C00E016240940451EAE480DC025E856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856808A481200DC826E05A8882401C02DE856802AE2F1B81920BC5E6F2010306F343535993F972E5D9A4C26659F1A009444920054B173E74ECF0CADADAD894442F6A90140492409401586612C59B2C41923962F5FDED4D494C964649F1A009444920014B27EFDFA458B16D94962DDBA751D1D1DB24F0A00CA2149006A696C6C2CC488F6F6769FCF671886EC330280724812805AF6EEDDBB78F1623349844221FE420280FA4812807256AD5A554812B24F0400EE8C240128279D4E9B49820F7F0270059204A022AE4C05C02DE85680120CC34824121B376E0C87C3C19B42A190794F2C164BA7D3B24F10006647920024330384991E665E93AA482010D8BA752B1FE500A01A9204204D6F6FEF8A152BEE98219C7C3E1F1FE800A014920420816118D16874E6AB0E4F3EF9D3AEAE1D7B7ADEB06BC386A7DADADA8AB60C87C35CF81280224812C0424BA7D3452F453CFEF88F4E0F0D4D6673A5EAE2A591DF6FD952F84E2FFBC589C1C141D94301009204B0B052A9941902EC40100A85CA6788A23CB161C353F6BE5EAFB7BFBF5FF68000E88E24012C1CC3309CAF463CB369538519C259DBB7FF9F9921EC5726F8580700B94812C0C2894422768CE8EADA51438C28D4A1C3030D0D0D85E3048341D9C302A0359204B0401289C41C5F8D70D6AE575FB38FB679F366D98303A02F9204B040028180FDB711738C1185B2FF66A2A9A989EB4C00908524012C84783C6EFF99E4F0D973F39224AE8E8ED99FE678E28927640F1180A64812C042080683F6073EE7254614EAA56DDB0A876D6868903D44009A2249007597C964ECBF6998AF1724ECBAF7DE1B9F29EDEDED953D50003A22490075178BC5ECCF59CC6F8C30EB91471E2D1CBCA3A343F64001E8882401D4DDDAB56BE7EB231B336B4FCF1B8583AF58B142F64001E8882401D45D28142A2CF6BB5E7D6DDE93C4E9A121FB2A55B2070A40472409A0EEECCF7F1E3A3C30EF49C22CFB8F30640F14808E683D40DDD99FD5ACFC2B36AA2AFBF8B2070A4047B41EA0EEFC7E7F61A57FEBC4897A2409FB6B38640F14808E683D40DDD91793D8D3F3C6BCC7888B9746B8A4040089481240DD45A3D1C262FFFB2D5BE63D49BC75E244E1E0814040F64001E8882401D45D67676761B15FB3E6FBF39E249ED9B4A970F04824227BA00074449200EA2E994CDA6F405C1D1D9BDF24B172E5CAC2C163B198EC8102D011490258083EDF8D6B5A7775ED98C718615F4CC294C964648F12808E4812C042E8E8E828ACF7CDCDCDF3F8B2C4B71F7CB070D870382C7B88003445920016422693B1AFFA305FD7CCEEDBB7DF7E4162707050F61001688A24012C90CD9B3717567DAFD73BF78F839E1E1AB2A3C9DAB56B650F0E80BE4812C0C259B1624561ED3743C05CAE77797574ACB9B9D93E543A9D963D3200FA2249000B27954A353434D809A0B6AFE1183E7BCE8E115EAFB7B7B757F6B000688D24012C2873E1B7FFB8C1CC01D55EABAA6FDF7EFB4D0DD3E6CD9B650F0880EE4812C0424B2412F62B13854F7354F26DE3C367CF3DDCDEEE71204600500149029020994CDA5FEB65E7890D1B9E9AF9155F6680F8FD962D6D6D6DCE8DCD20C29B1A0014419200E4C864321B376EB4BFC6B3484B4B4BA9872291087F6209401D240940263313D8DFEF7547C160B0BFBF5FF62903C06D4812807C8661C4E3713352040281A2F4E0F3F9C2E1F0D6AD5B791D02809A48120000A07624090000503B92040000A81D49020000D48E240100006AF7FF8405534DB8D113C80000000049454E44AE426082, '0');

-- ----------------------------
-- Table structure for act_ge_property
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_property`;
CREATE TABLE `act_ge_property` (
  `NAME_` VARCHAR(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `VALUE_` VARCHAR(300) COLLATE utf8_bin DEFAULT NULL,
  `REV_` INT(11) DEFAULT NULL,
  PRIMARY KEY (`NAME_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_ge_property
-- ----------------------------
INSERT INTO `act_ge_property` VALUES ('next.dbid', '30001', '13');
INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(5.22.0.0)', '1');
INSERT INTO `act_ge_property` VALUES ('schema.version', '5.22.0.0', '1');

-- ----------------------------
-- Table structure for act_hi_actinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_actinst`;
CREATE TABLE `act_hi_actinst` (
  `ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `ACT_ID_` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `TASK_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `CALL_PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_NAME_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `ACT_TYPE_` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `ASSIGNEE_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` DATETIME DEFAULT NULL,
  `END_TIME_` DATETIME DEFAULT NULL,
  `DURATION_` BIGINT(20) DEFAULT NULL,
  `TENANT_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_hi_actinst
-- ----------------------------
INSERT INTO `act_hi_actinst` VALUES ('17506', 'LeaveBill:1:17504', '17505', '17505', 'startevent1', NULL, NULL, 'Start', 'startEvent', NULL, '2017-12-26 11:27:39.000', '2017-12-26 11:27:39.000', '7', '');
INSERT INTO `act_hi_actinst` VALUES ('17509', 'LeaveBill:1:17504', '17505', '17505', 'usertask1', '17510', NULL, '提交申请', 'userTask', '8', '2017-12-26 11:27:39.000', '2017-12-26 11:27:55.000', '16045', '');
INSERT INTO `act_hi_actinst` VALUES ('17512', 'LeaveBill:1:17504', '17505', '17505', 'usertask2', '17513', NULL, '经纪人审批', 'userTask', '9', '2017-12-26 11:27:55.000', NULL, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('20002', 'LeaveBill:1:17504', '20001', '20001', 'startevent1', NULL, NULL, 'Start', 'startEvent', NULL, '2017-12-26 11:42:03.000', '2017-12-26 11:42:03.000', '1', '');
INSERT INTO `act_hi_actinst` VALUES ('20005', 'LeaveBill:1:17504', '20001', '20001', 'usertask1', '20006', NULL, '提交申请', 'userTask', '8', '2017-12-26 11:42:03.000', '2017-12-26 11:43:15.000', '72739', '');
INSERT INTO `act_hi_actinst` VALUES ('20008', 'LeaveBill:1:17504', '20001', '20001', 'usertask2', '20009', NULL, '经纪人审批', 'userTask', '9', '2017-12-26 11:43:15.000', NULL, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('22504', 'LeaveBill:1:17504', '22503', '22503', 'startevent1', NULL, NULL, 'Start', 'startEvent', NULL, '2017-12-26 11:52:25.000', '2017-12-26 11:52:25.000', '2', '');
INSERT INTO `act_hi_actinst` VALUES ('22507', 'LeaveBill:1:17504', '22503', '22503', 'usertask1', '22508', NULL, '提交申请', 'userTask', '8', '2017-12-26 11:52:25.000', '2017-12-26 11:52:53.000', '28660', '');
INSERT INTO `act_hi_actinst` VALUES ('22510', 'LeaveBill:1:17504', '22503', '22503', 'usertask2', '22511', NULL, '经纪人审批', 'userTask', '9', '2017-12-26 11:52:53.000', NULL, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('22514', 'LeaveBill:1:17504', '22513', '22513', 'startevent1', NULL, NULL, 'Start', 'startEvent', NULL, '2017-12-26 12:13:30.000', '2017-12-26 12:13:30.000', '15', '');
INSERT INTO `act_hi_actinst` VALUES ('22517', 'LeaveBill:1:17504', '22513', '22513', 'usertask1', '22518', NULL, '提交申请', 'userTask', '8', '2017-12-26 12:13:30.000', '2017-12-26 12:13:41.000', '11840', '');
INSERT INTO `act_hi_actinst` VALUES ('22520', 'LeaveBill:1:17504', '22513', '22513', 'usertask2', '22521', NULL, '经纪人审批', 'userTask', '9', '2017-12-26 12:13:41.000', NULL, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('22524', 'LeaveBill:1:17504', '22523', '22523', 'startevent1', NULL, NULL, 'Start', 'startEvent', NULL, '2017-12-26 13:20:48.000', '2017-12-26 13:20:48.000', '0', '');
INSERT INTO `act_hi_actinst` VALUES ('22527', 'LeaveBill:1:17504', '22523', '22523', 'usertask1', '22528', NULL, '提交申请', 'userTask', '8', '2017-12-26 13:20:48.000', '2017-12-26 13:21:42.000', '54912', '');
INSERT INTO `act_hi_actinst` VALUES ('22530', 'LeaveBill:1:17504', '22523', '22523', 'usertask2', '22531', NULL, '经纪人审批', 'userTask', '9', '2017-12-26 13:21:42.000', NULL, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('25002', 'LeaveBill:1:17504', '25001', '25001', 'startevent1', NULL, NULL, 'Start', 'startEvent', NULL, '2017-12-26 13:39:29.000', '2017-12-26 13:39:29.000', '1', '');
INSERT INTO `act_hi_actinst` VALUES ('25005', 'LeaveBill:1:17504', '25001', '25001', 'usertask1', '25006', NULL, '提交申请', 'userTask', '8', '2017-12-26 13:39:29.000', '2018-02-23 17:41:47.000', '5112138109', '');
INSERT INTO `act_hi_actinst` VALUES ('27502', 'LeaveBill:1:17504', '27501', '27501', 'startevent1', NULL, NULL, 'Start', 'startEvent', NULL, '2018-02-23 17:41:14.000', '2018-02-23 17:41:14.000', '31', '');
INSERT INTO `act_hi_actinst` VALUES ('27505', 'LeaveBill:1:17504', '27501', '27501', 'usertask1', '27506', NULL, '提交申请', 'userTask', '8', '2018-02-23 17:41:14.000', NULL, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('27509', 'LeaveBill:1:17504', '25001', '25001', 'usertask2', '27510', NULL, '经纪人审批', 'userTask', '9', '2018-02-23 17:41:47.000', NULL, NULL, '');

-- ----------------------------
-- Table structure for act_hi_attachment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_attachment`;
CREATE TABLE `act_hi_attachment` (
  `ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `REV_` INT(11) DEFAULT NULL,
  `USER_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `URL_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  `CONTENT_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` DATETIME DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_hi_attachment
-- ----------------------------

-- ----------------------------
-- Table structure for act_hi_comment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_comment`;
CREATE TABLE `act_hi_comment` (
  `ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` DATETIME DEFAULT NULL,
  `USER_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `ACTION_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `MESSAGE_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  `FULL_MSG_` LONGBLOB,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_hi_comment
-- ----------------------------
INSERT INTO `act_hi_comment` VALUES ('27508', 'comment', '2018-02-23 17:41:47.000', '8', '25006', '25001', 'AddComment', ' 打的 ', 0x09E68993E79A84090909);

-- ----------------------------
-- Table structure for act_hi_detail
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_detail`;
CREATE TABLE `act_hi_detail` (
  `ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_INST_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `REV_` INT(11) DEFAULT NULL,
  `TIME_` DATETIME DEFAULT NULL,
  `BYTEARRAY_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` DOUBLE DEFAULT NULL,
  `LONG_` BIGINT(20) DEFAULT NULL,
  `TEXT_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_hi_detail
-- ----------------------------

-- ----------------------------
-- Table structure for act_hi_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_identitylink`;
CREATE TABLE `act_hi_identitylink` (
  `ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `GROUP_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_hi_identitylink
-- ----------------------------
INSERT INTO `act_hi_identitylink` VALUES ('17511', NULL, 'participant', '8', NULL, '17505');
INSERT INTO `act_hi_identitylink` VALUES ('17514', NULL, 'participant', '9', NULL, '17505');
INSERT INTO `act_hi_identitylink` VALUES ('20007', NULL, 'participant', '8', NULL, '20001');
INSERT INTO `act_hi_identitylink` VALUES ('20010', NULL, 'participant', '9', NULL, '20001');
INSERT INTO `act_hi_identitylink` VALUES ('22509', NULL, 'participant', '8', NULL, '22503');
INSERT INTO `act_hi_identitylink` VALUES ('22512', NULL, 'participant', '9', NULL, '22503');
INSERT INTO `act_hi_identitylink` VALUES ('22519', NULL, 'participant', '8', NULL, '22513');
INSERT INTO `act_hi_identitylink` VALUES ('22522', NULL, 'participant', '9', NULL, '22513');
INSERT INTO `act_hi_identitylink` VALUES ('22529', NULL, 'participant', '8', NULL, '22523');
INSERT INTO `act_hi_identitylink` VALUES ('22532', NULL, 'participant', '9', NULL, '22523');
INSERT INTO `act_hi_identitylink` VALUES ('25007', NULL, 'participant', '8', NULL, '25001');
INSERT INTO `act_hi_identitylink` VALUES ('27507', NULL, 'participant', '8', NULL, '27501');
INSERT INTO `act_hi_identitylink` VALUES ('27511', NULL, 'participant', '9', NULL, '25001');

-- ----------------------------
-- Table structure for act_hi_procinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_procinst`;
CREATE TABLE `act_hi_procinst` (
  `ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `BUSINESS_KEY_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `START_TIME_` DATETIME DEFAULT NULL,
  `END_TIME_` DATETIME DEFAULT NULL,
  `DURATION_` BIGINT(20) DEFAULT NULL,
  `START_USER_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `START_ACT_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `END_ACT_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `SUPER_PROCESS_INSTANCE_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `DELETE_REASON_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT '',
  `NAME_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_hi_procinst
-- ----------------------------
INSERT INTO `act_hi_procinst` VALUES ('17505', '17505', 'LeaveBill.1', 'LeaveBill:1:17504', '2017-12-26 11:27:39.000', NULL, NULL, NULL, 'startevent1', NULL, NULL, NULL, '', NULL);
INSERT INTO `act_hi_procinst` VALUES ('20001', '20001', 'LeaveBill.6', 'LeaveBill:1:17504', '2017-12-26 11:42:03.000', NULL, NULL, NULL, 'startevent1', NULL, NULL, NULL, '', NULL);
INSERT INTO `act_hi_procinst` VALUES ('22503', '22503', 'LeaveBill.7', 'LeaveBill:1:17504', '2017-12-26 11:52:25.000', NULL, NULL, NULL, 'startevent1', NULL, NULL, NULL, '', NULL);
INSERT INTO `act_hi_procinst` VALUES ('22513', '22513', 'LeaveBill.8', 'LeaveBill:1:17504', '2017-12-26 12:13:30.000', NULL, NULL, NULL, 'startevent1', NULL, NULL, NULL, '', NULL);
INSERT INTO `act_hi_procinst` VALUES ('22523', '22523', 'LeaveBill.9', 'LeaveBill:1:17504', '2017-12-26 13:20:48.000', NULL, NULL, NULL, 'startevent1', NULL, NULL, NULL, '', NULL);
INSERT INTO `act_hi_procinst` VALUES ('25001', '25001', 'LeaveBill.10', 'LeaveBill:1:17504', '2017-12-26 13:39:29.000', NULL, NULL, NULL, 'startevent1', NULL, NULL, NULL, '', NULL);
INSERT INTO `act_hi_procinst` VALUES ('27501', '27501', 'LeaveBill.11', 'LeaveBill:1:17504', '2018-02-23 17:41:14.000', NULL, NULL, NULL, 'startevent1', NULL, NULL, NULL, '', NULL);

-- ----------------------------
-- Table structure for act_hi_taskinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_taskinst`;
CREATE TABLE `act_hi_taskinst` (
  `ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` DATETIME DEFAULT NULL,
  `CLAIM_TIME_` DATETIME DEFAULT NULL,
  `END_TIME_` DATETIME DEFAULT NULL,
  `DURATION_` BIGINT(20) DEFAULT NULL,
  `DELETE_REASON_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` INT(11) DEFAULT NULL,
  `DUE_DATE_` DATETIME DEFAULT NULL,
  `FORM_KEY_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` VARCHAR(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_hi_taskinst
-- ----------------------------
INSERT INTO `act_hi_taskinst` VALUES ('17510', 'LeaveBill:1:17504', 'usertask1', '17505', '17505', '提交申请', NULL, NULL, NULL, '8', '2017-12-26 11:27:40.000', NULL, '2017-12-26 11:27:55.000', '15039', 'completed', '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('17513', 'LeaveBill:1:17504', 'usertask2', '17505', '17505', '经纪人审批', NULL, NULL, NULL, '9', '2017-12-26 11:27:55.000', NULL, NULL, NULL, NULL, '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('20006', 'LeaveBill:1:17504', 'usertask1', '20001', '20001', '提交申请', NULL, NULL, NULL, '8', '2017-12-26 11:42:03.000', NULL, '2017-12-26 11:43:15.000', '72644', 'completed', '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('20009', 'LeaveBill:1:17504', 'usertask2', '20001', '20001', '经纪人审批', NULL, NULL, NULL, '9', '2017-12-26 11:43:15.000', NULL, NULL, NULL, NULL, '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('22508', 'LeaveBill:1:17504', 'usertask1', '22503', '22503', '提交申请', NULL, NULL, NULL, '8', '2017-12-26 11:52:25.000', NULL, '2017-12-26 11:52:53.000', '28659', 'completed', '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('22511', 'LeaveBill:1:17504', 'usertask2', '22503', '22503', '经纪人审批', NULL, NULL, NULL, '9', '2017-12-26 11:52:53.000', NULL, NULL, NULL, NULL, '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('22518', 'LeaveBill:1:17504', 'usertask1', '22513', '22513', '提交申请', NULL, NULL, NULL, '8', '2017-12-26 12:13:30.000', NULL, '2017-12-26 12:13:41.000', '11838', 'completed', '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('22521', 'LeaveBill:1:17504', 'usertask2', '22513', '22513', '经纪人审批', NULL, NULL, NULL, '9', '2017-12-26 12:13:41.000', NULL, NULL, NULL, NULL, '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('22528', 'LeaveBill:1:17504', 'usertask1', '22523', '22523', '提交申请', NULL, NULL, NULL, '8', '2017-12-26 13:20:48.000', NULL, '2017-12-26 13:21:42.000', '54909', 'completed', '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('22531', 'LeaveBill:1:17504', 'usertask2', '22523', '22523', '经纪人审批', NULL, NULL, NULL, '9', '2017-12-26 13:21:42.000', NULL, NULL, NULL, NULL, '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('25006', 'LeaveBill:1:17504', 'usertask1', '25001', '25001', '提交申请', NULL, NULL, NULL, '8', '2017-12-26 13:39:29.000', NULL, '2018-02-23 17:41:47.000', '5112138064', 'completed', '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('27506', 'LeaveBill:1:17504', 'usertask1', '27501', '27501', '提交申请', NULL, NULL, NULL, '8', '2018-02-23 17:41:14.000', NULL, NULL, NULL, NULL, '50', NULL, 'workflowAction_audit.action', NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('27510', 'LeaveBill:1:17504', 'usertask2', '25001', '25001', '经纪人审批', NULL, NULL, NULL, '9', '2018-02-23 17:41:47.000', NULL, NULL, NULL, NULL, '50', NULL, 'workflowAction_audit.action', NULL, '');

-- ----------------------------
-- Table structure for act_hi_varinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_varinst`;
CREATE TABLE `act_hi_varinst` (
  `ID_` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` VARCHAR(100) COLLATE utf8_bin DEFAULT NULL,
  `REV_` INT(11) DEFAULT NULL,
  `BYTEARRAY_ID_` VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` DOUBLE DEFAULT NULL,
  `LONG_` BIGINT(20) DEFAULT NULL,
  `TEXT_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` VARCHAR(4000) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` DATETIME DEFAULT NULL,
  `LAST_UPDATED_TIME_` DATETIME DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`) USING BTREE,
  KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of act_hi_varinst
-- ----------------------------
INSERT INTO `act_hi_varinst` VALUES ('17507', '17505', '17505', NULL, 'objId', 'string', '0', NULL, NULL, NULL, 'LeaveBill.1', NULL, '2017-12-26 11:27:39.000', '2017-12-26 11:27:39.000');
INSERT INTO `act_hi_varinst` VALUES ('17508', '17505', '17505', NULL, 'inputUser', 'long', '0', NULL, NULL, '8', '8', NULL, '2017-12-26 11:27:39.000', '2017-12-26 11:27:39.000');
INSERT INTO `act_hi_varinst` VALUE

最低0.47元/天 解锁文章
秋刀鱼亦会过期
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql5.5.49
04-10
MySQL 5.5.49 是 MySQL 数据库管理系统的一个重要版本，主要针对 Windows 操作系统。MySQL 是一种广泛使用的开源关系型数据库系统，以其高效、可靠和易用性著称。在 MySQL 5.5 版本中，有许多显著的改进和特性增强，...
php根级别上的数据无效,C# 读取XML 根级别上的数据无效。 第 1 行，位置 1。
weixin_39801991的博客
03-18 1972
string blogValue = "0xEFBBBF3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0D0A0D0A3C70726F63657373206E616D653D22E680BBE79B91E5A794E4BBBBE4B9A6E794B3E8AFB72220786D6C6E733D...
二月份的精选奇趣网站（收藏--轉）
oracle_1010g的专栏
06-17 5397
2008年二月份的精选奇趣网站 1，看看自己具有哪个大明星的脸型　http://www.play-analogia.com/cgi-bin/index/ 2，超有意思的Flash网站，虚拟办公　http://agencynet.com 3，亲自动手给美女画纹身　http://www.crustydemons.co.uk/UK/tattoo_parlour/index.html 4，输入...
【database1】mysql：DDL/DML/DQL，外键约束/多表/子查询，事务/连接池
最新发布
OpenBMC开发
06-23 2063
文章目录1.mysql安装：存储：集合（内存：临时），IO流（硬盘：持久化）1.1 服务端1.2 客户端2.DDL/DML：char不用动态变化，效率高3.DQL：select（相当于System.out）第一个但在倒数第二执行，备份4.约束和自增长：字段约束（字段的赋值规范）/主键约束（唯一非空且一张表只有一个主键）5.单表缺点和外键约束：多从外 引出6.三种多表关系：中间表两外键7.多表查询：表..join表on7.1 外连接：左外=左表+内连接8.子查询：优先于主查询产生结果9.事务：一组操作，要么同
Dockerfile 指令的使用方法
Insomnia_Mr的博客
05-25 321
dockerfile，相当于是一个文档，客户可以基于dockerfile生成新的容器 dockerfile仅仅是用来制作镜像的源码文件，是构建容器过程中的指令，docker能够读取dockerfile的指定进行自动构建容器，基于dockerfile制作镜像，每一个指令都会创建一个镜像层，即镜像都是多层叠加而成，因此，层越多，效率越低，创建镜像，层越少越好。因此能在一个指令完成的动作尽量通过一个指令定义。 例子： Dockerfile： FROM centos RUN yum install -y vim C
教你如何爬取某哪儿网酒店数据
qq_44902227的博客
05-01 2083
声明 本文章中所有内容仅供学习交流，抓包内容、敏感网址、数据接口均已做脱敏处理，严禁用于商业用途和非法用途，否则由此产生的一切后果均与作者无关，若有侵权，请联系我立即删除！ 1、目标 URL：68747470733A2F2F686F74656C2E71756E61722E636F6D2F636E2F6265696A696E675F636974792F3F66726F6D446174653D323032322D30342D333026746F446174653D323032322D30352D30312663
前端八股文
weixin_53013159的博客
08-02 502
前端八股文
mysql-5.5.49-win32.zip
10-13
MySQL是世界上最受欢迎的开源关系型数据库管理系统之一，其5.5.49版本虽然相较于当前的版本略显陈旧，但因其稳定性和广泛的应用，仍被许多用户所青睐。在这个"mysql-5.5.49-win32.zip"压缩包中，包含的是MySQL ...
MySQL 5.5.49(免费)
08-10
MySQL 5.5.49 是一款开源、免费的关系型数据库管理系统，由Oracle公司提供支持。这个版本在MySQL的历史上占据着重要的位置，因为它引入了许多关键的改进和优化，为开发者和管理员提供了更强大、更稳定的数据库解决...
mysql-5.5.49-win32
04-04
mysql-5.5.49-win32 mysql-5.5.49-win32 mysql-5.5.49-win32
mysql-5.5.49-win32.msi
10-29
这里的“mysql-5.5.49-win32.msi”文件是MySQL 5.5.49版本针对Windows 32位操作系统的安装程序。这个安装包允许用户在Windows系统上简便地安装和配置MySQL服务器。 MySQL 5.5版是MySQL的一个重大更新，它在性能、可...
C++编程，数据结构，算法类面试题集
rongwenbin的专栏
01-13 8856
1. 在linked list中找倒数第N个结点 2. 倒转linked list 3. 二叉树的结点有指向parent的指针，求最近公共祖先 4. 给一个数组,如何打印该数组成员构成集合的全部子集合. 5. 有两个字符串，一个是text,一个是command, Command有四种：    ‘+’: 在text中前进一位    ‘-’: 在text中后退一位    ‘a’: 在当前
C++开发工程师面试题
likui360的专栏
02-03 2011
1.    指出以下变量数据存储位置 全局变量int(*g_pFun)(int);g_pFun=myFunction;g_pFun存储的位置(A ) 为全局的函数指针 指向空间的位置( B) 所有函数代码位于TEXT段 函数内部变量 static int nCount;       ( A) 静态变量总是在DATA段或BSS段中 函数内部变量 char p[]=”AAA”;
一举首
u011523728的专栏
07-27 6217
张,开始小心保护儿子,并且为录像带的内容指引,回想起多年以前,差点成为母亲样子的阿尔及利亚遗孤马吉德。乔治怀疑录像带的始作俑者即为马吉德,于是登门拜访,却引发了意外的结局……5. 《狼族时间Temps对于越来越烂,越来越没有诚意的国产电影的一次愤怒的咆哮与反抗。在《异星战场》和《诸神之怒》已成强弩之末的四月份,在国产烂片在道且透支了观众预期的四月份,一部已经在留名影史的经典大片,用破纪录的成绩,给
Cross-site Scripting (XSS)
weixin_30325487的博客
01-10 2300
<!-- Project Name : Cross Site Scripting ( XSS ) Vulnerability Payload List --> <!-- Author : Ismail Tasdelen --> <!-- Linkedin : https://www.linkedin.com/in/ismailtasdel...
2020美亚团队赛复盘
wuwuliuliu0524的博客
08-01 1万+
团队赛veracrypt密码FvIDu!WZvamS!案件背景你的电子数据取证调查结果发现一个国际黑客组织牵涉这宗案件。经深入调查后，调查队伍相信该黑客组织入侵了一个名为Zello的本地网上商店官网，黑客组织也针对另一家网上商店Xeno发动网络攻击，使其系统产生故障。调查期间发现三名男子张伟华、冯启礼及罗俊杰疑与该案有关。警方在搜查他们的住宅及公司后扣押了数十台电子设备。请分析电子数据证据并重建入侵痕迹。1.编号详情档案路径1Zello服务器的镜像文件编号详情档案路径1编号。................
【Android UI】色板
热门推荐
幻影浪子
03-10 7万+
<br />Hex CodeColor#FFFFFF #FFFFCC #FFFF99 #FFFF66 #FFFF33 #FFFF00 #FFCCFF #FFCCCC #FFCC99 #FFCC66 #FFCC33 #FFCC00 #FF99FF #FF99CC #FF9999 #FF9966 #FF9933 #FF9900 #FF66FF #FF66CC #FF6699 #FF6666 #FF6633 #FF6600 #FF33FF #FF33CC #FF3399 #FF3366 #FF3333 #FF33
2019ICPC南京区域赛ABCHIJK
Hytidel的博客
03-27 1万+
2019ICPC南京区域赛ABCHIJK题解(文字+视频).
signature=bf4dd3e681d64c12951e9bd1efab070c,mame/pgm.cpp at 1f786226cb3b42da77bafef70105311b64166732 ...
weixin_39637975的博客
05-29 2万+
// license:BSD-3-Clause// copyright-holders:David Haywood, ElSemi/* PGM System (c)1997 IGSBased on Information from ElSemiA flexible cartridge based platform some would say was designed to compete wit...
mysql5.5.49安装
09-23
mysql5.5.49可以通过以下步骤进行安装： 1. 下载mysql5.5.49的安装包。 2. 解压安装包并进入解压后的目录。 3. 配置MySQL的安装目录以及相关参数。 4. 执行安装命令，等待安装完成。 5. 配置MySQL的环境变量。 6. ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值