ValetJava/db/奖励规则.sql

/*
 Navicat Premium Data Transfer

 Source Server         : ShardingSphere
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : 192.168.99.232:3307
 Source Schema         : hxds

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 10/09/2022 01:25:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_award_rule
-- ----------------------------
DROP TABLE IF EXISTS `tb_award_rule`;
CREATE TABLE `tb_award_rule`  (
  `id` bigint NOT NULL COMMENT '主键ID',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规则编码',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规则名称',
  `rule` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规则代码',
  `status` tinyint NOT NULL COMMENT '状态代码，1有效，2关闭',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_status`(`status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '司机奖励规则表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_award_rule
-- ----------------------------
INSERT INTO `tb_award_rule` VALUES (689878827820101633, 'Y2022N1', '2022年奖励规则01版', '207C4334EEE5E5789B0106FC3F25D033660BFB61760E258B46EF134869DB51E5EF7802EA371CB22F763CD0793BF6A91908B0ECA2294B8B71197AC85F0E0C21031EC29A86F4F4B07B84CC1BD547FC73026CE4A73E8E528ADA404FD770DBA87A3F47AB63115DCF604C595FA134DE27B0A98F40FE90DD4171A48F865560A35277EE0DD509115459DB1BB69D1A24D09DAD9E7CC63AEBCB4B05047CC72536B62182FCA65769729A7B5B507E6451DC2748FAEAF055DD27814CE88F3B1268F3C11BBEF6E3983C8A96CD690CE7DB7B7D74D28009EA90022669EFB20E46492D250CEB81B5A1219BE3F7AC34361A86FD26FBEAE4443D20EDFFA07C74A611876249C31BCD4EF5960FD5BF3A37118359B4DBE5D6FC357917787F1A73540E74D34C6CE0A60E190A9C5102CBD76930C4D349B2FAFFF61EE4D291B8BFFE170E710E7B6DF8029F8108EFDBF223321AA2C57740CE844C76AEED892D6A909A6548E29CF5BB6A32797E9557EAB428844CE652F4F5AD6CCE1E687EEBF8993B882E54B9F636D872E4B45C24F5BB8595E3AA2A435922727930C95E707B0245BEF14D54960647D7DC2688B77662FE486BF1A42502F290828DFC6EDA0CF7FB7A24EB90583B8CAEF0AE48B5BD6686939637A550772AB5A5593E10B7E7B7D797556984A27ACC19398CFEA1FBBE810F111D48F63EBD5D1DF1217B2BA0C8399C4BE85E1A0C10B7D9F3B647EDEC4A80F31D0CCA30EAE947421FCFDFD2FA6A8FBE4FA38C461235C3E7E151F4799012587B3DA3CE82C30B749FC75E1465FE96559D50D4A2708C23160A2BDA25F0D90911CE6B9A1F0AB54820D76AE3E844CAFAC1B058365558E69B13C820C25BA36FA451D815D512D58E92FB40A8CA025B63BC2B1267558DDD31954BF40085791336EA956C037122124AD23F21C0CADDDDED0A39AD4CB77F7548E598D9DDA2711CDBB54EAD43C8166A830DC178BF46D02074FFABAD5503B99B8117D81B253D459B5F0E8FA7A6024467F013F7D1CEC1A8F380BEC0D6203BA8259D0263A0511F882DD2DFC6C654D3A93EC2969445CE51CD89E576CFDA2F0BEFE88D6EA77E83B045BFECF82009D355B3C0E09262F8D8F27F20D717D3F7F56BC6EE9C061368AE441D009CE86EC7EF7484AEEE6049CDA81176B60AFE2CFA3418398ADF591D7CBFFD43D2538692C77BD14C8FD08215FA968D9F9916E2C5E3EBD2043745FFC8C73B7DE0AB02867E66D1AFD4F88AE1AD44789CA2F648CFD1D277E0CF35BCDA756934C89FB4C8F0F62A826EEE38C5A35734F8F65240F663F7B54C9DDA82D3B89237B90420907219D3DCF917679DE0D73C34109832DF776DE8213D534FE3D44AD36E98445D9641638CF71E48930D36B1C718600E7D6182FDB3A13B2C24FBDCC8598EDB05A4D2140C435D71AA2EAD76B734A7BEC31645ED16C320AEC56728634AEBA7F4B118AB0D11F5383DB340F286F641AC3525517852D1584F3C671CA1785AEB9B10777B1FCB72A6A58D523865864DF773AF4839A5292F45F90FD0A49D72C2A760225DB682833F7553ABF59F9F1D5A4338411D8E202BAD7E66AB8839E4FAF82DB141C76D52E6DC7E66D1AFD4F88AE1AD44789CA2F648CFD1D277E0CF35BCDA756934C89FB4C8F082A8FAA2B333D351951E6D036C7D32C2F7B54C9DDA82D3B89237B904209072193A44A519F904A73F12ADBBEE046085B1BD2DFFDD652F3E1503DB35046C79DD74D310A0D98BBDABE3B2E84552DBB923B333645F92D9D10206941566DCBB4DDB0BD7182B378CD85EDFCF02B4C897BF940DEF78C0683E21CB37E8015B9410AF8B4B5E2FECE296ED8A5D872383A2F7D95B4E8BD615435EE7DC0F92130F681699FCF36EC7EF7484AEEE6049CDA81176B60AFE2CFA3418398ADF591D7CBFFD43D2538605436C285BBE6791D7A48E23A82901A01EAAA88C3B835D4F3F9CBB40E2BB2406C3DC8D863F310DDBF3CAE2CAFC5E3A96D1CFA3BB73EF0DD2CDC91E56D3A331FB4AE3A072D5896402339C80A948C46BCE2791A26620C04C96ED5531A58EE379EF76FC8C917715569C3E8A0FC5C20FE5A91454FCB8287C89DCFC4CB9639F1C374F7C18A9D4E6A30263255A9D3CA9A0E96223A65F4AF766CEF7DA44C90D36CB9A013A4F2A829F303AA3791CC969732012EFA1EFB12B1C84D87F289628FC0B828C51648234E2AB8E94420A125D29BEAD9073A69770EDE0BC00EA738C535306A21DC72181D2179A5EC8090BA027B7EC0438A2628C1A681C5B4770D848AEBE42FFB3CAD4EAC2EDC7A54518FDA625D2367F86E7F47056C5D708C0F1AD0ADDB9E978D7FD9E9C4A71CE4A6DE5B03EC03FC52B7D1292ADED6F473B09C05E85CC286D97D93859F4416D4E2779502C30F702A6E996E8D25BB6A57207B87E619226ADA73AAFABBDB2692CB9A8005FD2247909450A90A5587431BC88D8037F375955BFC629BDEC77E4BC7DB880DA3794DA855438070640B69220AD6B3A0209CD56C01F2B0913627B34DFBE502B619EBBB4753F7D358543129000D957C62903F6A262A19EECCC68C74E2023A29582A96A4FC4030C152EEA985A393E59BA9272C8E87D44D1C75FD0AF2BC4EBC9495C6715224EE625816042A4AAE34622B28F561B5D7141B4222E2F33D7D4CBEA95E796AF284F4C02A54641E4833E0F96AA3E00A9F45F1770E6217D05C0C1C9D9FD47E71D5C54621B19D65BEAB1826F02FCAA8569958D3A67E9D98B810F111D48F63EBD5D1DF1217B2BA0C8399C4BE85E1A0C10B7D9F3B647EDEC4AC84CC03EB7E150170E959A15907BED718FBE4FA38C461235C3E7E151F4799012587B3DA3CE82C30B749FC75E1465FE96559D50D4A2708C23160A2BDA25F0D90918837589F702766B0A01B87359023811096CE3C024E8DF5FC20CA40E1585AC60BEFCD1B1DFC20E575F0EA7E9434D841AA136B2CF39FF9D4B369293372B3A4BFE3BC1C66A2F0779182FDF16D11E25B68EB7DEE3C3212FE40C1F097ED85D7561A038EB3A2FE8FBE8D979062A17C479C8006E35E5B3663EF451909167E2B9B9D1762397A83C9B5D8CBA47A3D1E713267CB17D60CD2772099C3DF4861C32A50BBC1644293CDCA517FB4DF28ED28D940380907DCA12C682CD202B0DBF011FAC145A96F4330FE317AE73DAA6FC4A6443F262139EEF28B072E10A45053154B801551D93256EFA5357B5868FB94359697618A7B5F6DA85496B0D382788B53BA6C220F5EB7BED2F449A3DB26186A1B41A1906D348800F9E46AB2A8501D5BA95E4182AA6A33E70A9FBDFAC9880B66D67330024637891CA5B0F8F4397BF748B0D7789F9A3876A38F1E09F1C5EDF6E939E22B519C3548B0F39443EA2993EFEC8677CD6FA902BF3F1013177AAD05065F446D1C68089A84F6B82A9A2491660CDC3F2D46881368740FCEC0ECEB43D0D7F5A8F89A275AED02AC273440F6B7B29B59FE8E395B0E54B9D2CCA05DF589B8BB185368C590B58D3401AB3E79F5E39E0B32A02D5AED29AA26458B02CDBEA004BDE2FEC5C5553A2578006AB3C8148D62B0AF71823759B08A527C5EBE17D817DE06B685CFB7C68AC40D67ECFDEEC19163805502ADDBF475A8310F6D3C30BC20E7F2E73038139F732F035FDEC54532906848CBFA39FA15E43AF39B344A25BB4D7C6E4E143DD4650C41B4D16F60D32A100B506DEB850461961069B2E699C832EF7709C5E02F99427E250FCBF052FA2F7DC125CB99611DC6A750CB51B17F7F66046AF5943A73A9A652C3BC3565148D571B1C66D64ADF3370DBBFDA8D754ED3AAB6F9C33368A6F6C92164B989D076B8913834790780A89514BDDE428712A7BEC44DAABCCA359C1D89E843C96F2D66D9850BB13D9F55F6F416250236333A4BAEA630F39799D4B5F0B23C95FF5ADC82E684B4BFE8309C54B51B4FA25', 1, '2022-01-17 16:52:09');

SET FOREIGN_KEY_CHECKS = 1;