/*
Navicat Oracle Data Transfer
Oracle Client Version : 11.2.0.1.0

Source Server         : mrbird
Source Server Version : 110200
Source Host           : localhost:1521
Source Schema         : MRBIRD

Target Server Type    : ORACLE
Target Server Version : 110200
File Encoding         : 65001

Date: 2018-03-19 14:35:18
*/


-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
CREATE TABLE "QRTZ_BLOB_TRIGGERS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"TRIGGER_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"TRIGGER_GROUP" VARCHAR2(200 BYTE) NOT NULL ,
"BLOB_DATA" BLOB NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_BLOB_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
CREATE TABLE "QRTZ_CALENDARS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"CALENDAR_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"CALENDAR" BLOB NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_CALENDARS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
CREATE TABLE "QRTZ_CRON_TRIGGERS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"TRIGGER_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"TRIGGER_GROUP" VARCHAR2(200 BYTE) NOT NULL ,
"CRON_EXPRESSION" VARCHAR2(120 BYTE) NOT NULL ,
"TIME_ZONE_ID" VARCHAR2(80 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
INSERT INTO "QRTZ_CRON_TRIGGERS" VALUES ('MyScheduler', 'TASK_3', 'DEFAULT', '0/1 * * * * ?', 'Asia/Shanghai');
INSERT INTO "QRTZ_CRON_TRIGGERS" VALUES ('MyScheduler', 'TASK_11', 'DEFAULT', '0/5 * * * * ?', 'Asia/Shanghai');
INSERT INTO "QRTZ_CRON_TRIGGERS" VALUES ('MyScheduler', 'TASK_1', 'DEFAULT', '0/1 * * * * ?', 'Asia/Shanghai');
INSERT INTO "QRTZ_CRON_TRIGGERS" VALUES ('MyScheduler', 'TASK_2', 'DEFAULT', '0/10 * * * * ?', 'Asia/Shanghai');

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
CREATE TABLE "QRTZ_FIRED_TRIGGERS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"ENTRY_ID" VARCHAR2(95 BYTE) NOT NULL ,
"TRIGGER_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"TRIGGER_GROUP" VARCHAR2(200 BYTE) NOT NULL ,
"INSTANCE_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"FIRED_TIME" NUMBER(13) NOT NULL ,
"SCHED_TIME" NUMBER(13) NOT NULL ,
"PRIORITY" NUMBER(13) NOT NULL ,
"STATE" VARCHAR2(16 BYTE) NOT NULL ,
"JOB_NAME" VARCHAR2(200 BYTE) NULL ,
"JOB_GROUP" VARCHAR2(200 BYTE) NULL ,
"IS_NONCONCURRENT" VARCHAR2(1 BYTE) NULL ,
"REQUESTS_RECOVERY" VARCHAR2(1 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_FIRED_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
CREATE TABLE "QRTZ_JOB_DETAILS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"JOB_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"JOB_GROUP" VARCHAR2(200 BYTE) NOT NULL ,
"DESCRIPTION" VARCHAR2(250 BYTE) NULL ,
"JOB_CLASS_NAME" VARCHAR2(250 BYTE) NOT NULL ,
"IS_DURABLE" VARCHAR2(1 BYTE) NOT NULL ,
"IS_NONCONCURRENT" VARCHAR2(1 BYTE) NOT NULL ,
"IS_UPDATE_DATA" VARCHAR2(1 BYTE) NOT NULL ,
"REQUESTS_RECOVERY" VARCHAR2(1 BYTE) NOT NULL ,
"JOB_DATA" BLOB NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
INSERT INTO "QRTZ_JOB_DETAILS" VALUES ('MyScheduler', 'TASK_3', 'DEFAULT', null, 'cc.mrbird.job.util.ScheduleJob', '0', '0', '0', '0', HexToRaw('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161CFB9AA327874000D302F31202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B020000787000000000000000037400047465737474000B68656C6C6F20776F726C6474002BE69C89E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF952CE6AF8FE99A94E4B880E7A792E8A7A6E58F91740001307800'));
INSERT INTO "QRTZ_JOB_DETAILS" VALUES ('MyScheduler', 'TASK_1', 'DEFAULT', null, 'cc.mrbird.job.util.ScheduleJob', '0', '0', '0', '0', HexToRaw('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161C6EB73297874000D302F35202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740004746573747400066D7262697264740018E69C89E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF95740001307800'));
INSERT INTO "QRTZ_JOB_DETAILS" VALUES ('MyScheduler', 'TASK_2', 'DEFAULT', null, 'cc.mrbird.job.util.ScheduleJob', '0', '0', '0', '0', HexToRaw('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161C71033977874000E302F3130202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740005746573743170740018E697A0E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF95740001307800'));
INSERT INTO "QRTZ_JOB_DETAILS" VALUES ('MyScheduler', 'TASK_11', 'DEFAULT', null, 'cc.mrbird.job.util.ScheduleJob', '0', '0', '0', '0', HexToRaw('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161D01BAFA97874000D302F35202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000B740005746573743274000074000CE6B58BE8AF95E5BC82E5B8B8740001317800'));

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
CREATE TABLE "QRTZ_LOCKS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"LOCK_NAME" VARCHAR2(40 BYTE) NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
INSERT INTO "QRTZ_LOCKS" VALUES ('MyScheduler', 'STATE_ACCESS');
INSERT INTO "QRTZ_LOCKS" VALUES ('MyScheduler', 'TRIGGER_ACCESS');

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
CREATE TABLE "QRTZ_PAUSED_TRIGGER_GRPS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"TRIGGER_GROUP" VARCHAR2(200 BYTE) NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
CREATE TABLE "QRTZ_SCHEDULER_STATE" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"INSTANCE_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"LAST_CHECKIN_TIME" NUMBER(13) NOT NULL ,
"CHECKIN_INTERVAL" NUMBER(13) NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
INSERT INTO "QRTZ_SCHEDULER_STATE" VALUES ('MyScheduler', 'SC-2018020120491521424676624', '1521441319044', '15000');

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
CREATE TABLE "QRTZ_SIMPLE_TRIGGERS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"TRIGGER_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"TRIGGER_GROUP" VARCHAR2(200 BYTE) NOT NULL ,
"REPEAT_COUNT" NUMBER(7) NOT NULL ,
"REPEAT_INTERVAL" NUMBER(12) NOT NULL ,
"TIMES_TRIGGERED" NUMBER(10) NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_SIMPLE_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
CREATE TABLE "QRTZ_SIMPROP_TRIGGERS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"TRIGGER_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"TRIGGER_GROUP" VARCHAR2(200 BYTE) NOT NULL ,
"STR_PROP_1" VARCHAR2(512 BYTE) NULL ,
"STR_PROP_2" VARCHAR2(512 BYTE) NULL ,
"STR_PROP_3" VARCHAR2(512 BYTE) NULL ,
"INT_PROP_1" NUMBER(10) NULL ,
"INT_PROP_2" NUMBER(10) NULL ,
"LONG_PROP_1" NUMBER(13) NULL ,
"LONG_PROP_2" NUMBER(13) NULL ,
"DEC_PROP_1" NUMBER(13,4) NULL ,
"DEC_PROP_2" NUMBER(13,4) NULL ,
"BOOL_PROP_1" VARCHAR2(1 BYTE) NULL ,
"BOOL_PROP_2" VARCHAR2(1 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_SIMPROP_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
CREATE TABLE "QRTZ_TRIGGERS" (
"SCHED_NAME" VARCHAR2(120 BYTE) NOT NULL ,
"TRIGGER_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"TRIGGER_GROUP" VARCHAR2(200 BYTE) NOT NULL ,
"JOB_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"JOB_GROUP" VARCHAR2(200 BYTE) NOT NULL ,
"DESCRIPTION" VARCHAR2(250 BYTE) NULL ,
"NEXT_FIRE_TIME" NUMBER(13) NULL ,
"PREV_FIRE_TIME" NUMBER(13) NULL ,
"PRIORITY" NUMBER(13) NULL ,
"TRIGGER_STATE" VARCHAR2(16 BYTE) NOT NULL ,
"TRIGGER_TYPE" VARCHAR2(8 BYTE) NOT NULL ,
"START_TIME" NUMBER(13) NOT NULL ,
"END_TIME" NUMBER(13) NULL ,
"CALENDAR_NAME" VARCHAR2(200 BYTE) NULL ,
"MISFIRE_INSTR" NUMBER(2) NULL ,
"JOB_DATA" BLOB NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
INSERT INTO "QRTZ_TRIGGERS" VALUES ('MyScheduler', 'TASK_3', 'DEFAULT', 'TASK_3', 'DEFAULT', null, '1521425274000', '1521425273000', '5', 'PAUSED', 'CRON', '1519608506000', '0', null, '2', HexToRaw('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161CFB9A6907874000D302F31202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B020000787000000000000000037400047465737474000B68656C6C6F20776F726C6474002BE69C89E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF952CE6AF8FE99A94E4B880E7A792E8A7A6E58F91740001317800'));
INSERT INTO "QRTZ_TRIGGERS" VALUES ('MyScheduler', 'TASK_11', 'DEFAULT', 'TASK_11', 'DEFAULT', null, '1519614930000', '-1', '5', 'PAUSED', 'CRON', '1519614930000', '0', null, '2', HexToRaw('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161D01BAC507874000D302F35202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000B74000574657374327074000CE6B58BE8AF95E5BC82E5B8B8740001317800'));
INSERT INTO "QRTZ_TRIGGERS" VALUES ('MyScheduler', 'TASK_1', 'DEFAULT', 'TASK_1', 'DEFAULT', null, '1521425308000', '1521425307000', '5', 'PAUSED', 'CRON', '1519460774000', '0', null, '2', HexToRaw('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161C6EB70707874000D302F31202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740004746573747400066D7262697264740018E69C89E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF95740001317800'));
INSERT INTO "QRTZ_TRIGGERS" VALUES ('MyScheduler', 'TASK_2', 'DEFAULT', 'TASK_2', 'DEFAULT', null, '1519463190000', '-1', '5', 'PAUSED', 'CRON', '1519463183000', '0', null, '2', HexToRaw('ACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372001863632E6D72626972642E6A6F622E646F6D61696E2E4A6F62058D52AC1093A3040200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C000673746174757371007E00097870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000161C71032987874000E302F3130202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740005746573743170740018E697A0E58F82E4BBBBE58AA1E8B083E5BAA6E6B58BE8AF95740001317800'));

-- ----------------------------
-- Table structure for T_DEPT
-- ----------------------------
CREATE TABLE "T_DEPT" (
"DEPT_ID" NUMBER NOT NULL ,
"PARENT_ID" NUMBER NOT NULL ,
"DEPT_NAME" VARCHAR2(100 BYTE) NOT NULL ,
"ORDER_NUM" NUMBER NULL ,
"CREATE_TIME" DATE NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of T_DEPT
-- ----------------------------
INSERT INTO "T_DEPT" VALUES ('1', '0', '开发部', null, TO_DATE('2018-01-04 15:42:26', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_DEPT" VALUES ('3', '1', '开发二部', null, TO_DATE('2018-01-04 15:42:29', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_DEPT" VALUES ('5', '0', '人事部', null, TO_DATE('2018-01-04 15:42:32', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_DEPT" VALUES ('2', '1', '开发一部', null, TO_DATE('2018-01-04 15:42:34', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_DEPT" VALUES ('4', '0', '市场部', null, TO_DATE('2018-01-04 15:42:36', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_DEPT" VALUES ('6', '0', '测试部', null, TO_DATE('2018-01-04 15:42:38', 'YYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for T_DICT
-- ----------------------------
CREATE TABLE "T_DICT" (
"DICT_ID" NUMBER NOT NULL ,
"KEY" NUMBER NOT NULL ,
"VALUE" VARCHAR2(100 BYTE) NOT NULL ,
"FIELD_NAME" VARCHAR2(100 BYTE) NOT NULL ,
"TABLE_NAME" VARCHAR2(100 BYTE) NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of T_DICT
-- ----------------------------
INSERT INTO "T_DICT" VALUES ('2', '1', '女', 'ssex', 't_user');
INSERT INTO "T_DICT" VALUES ('6', '0', '菜单', 'type', 't_menu');
INSERT INTO "T_DICT" VALUES ('3', '2', '保密', 'ssex', 't_user');
INSERT INTO "T_DICT" VALUES ('4', '1', '有效', 'status', 't_user');
INSERT INTO "T_DICT" VALUES ('5', '0', '锁定', 'status', 't_user');
INSERT INTO "T_DICT" VALUES ('1', '0', '男', 'ssex', 't_user');
INSERT INTO "T_DICT" VALUES ('7', '1', '按钮', 'type', 't_menu');
INSERT INTO "T_DICT" VALUES ('30', '0', '正常', 'status', 't_job');
INSERT INTO "T_DICT" VALUES ('31', '1', '暂停', 'status', 't_job');
INSERT INTO "T_DICT" VALUES ('32', '0', '成功', 'status', 't_job_log');
INSERT INTO "T_DICT" VALUES ('33', '1', '失败', 'status', 't_job_log');

-- ----------------------------
-- Table structure for T_JOB
-- ----------------------------
CREATE TABLE "T_JOB" (
"JOB_ID" NUMBER NOT NULL ,
"BEAN_NAME" VARCHAR2(100 BYTE) NOT NULL ,
"METHOD_NAME" VARCHAR2(100 BYTE) NOT NULL ,
"PARAMS" VARCHAR2(200 BYTE) NULL ,
"CRON_EXPRESSION" VARCHAR2(100 BYTE) NOT NULL ,
"STATUS" CHAR(2 BYTE) NOT NULL ,
"REMARK" VARCHAR2(200 BYTE) NULL ,
"CREATE_TIME" DATE NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON COLUMN "T_JOB"."JOB_ID" IS '任务id';
COMMENT ON COLUMN "T_JOB"."BEAN_NAME" IS 'spring bean名称';
COMMENT ON COLUMN "T_JOB"."METHOD_NAME" IS '方法名';
COMMENT ON COLUMN "T_JOB"."PARAMS" IS '参数';
COMMENT ON COLUMN "T_JOB"."CRON_EXPRESSION" IS 'cron表达式';
COMMENT ON COLUMN "T_JOB"."STATUS" IS '任务状态  0：正常  1：暂停';
COMMENT ON COLUMN "T_JOB"."REMARK" IS '备注';
COMMENT ON COLUMN "T_JOB"."CREATE_TIME" IS '创建时间';

-- ----------------------------
-- Records of T_JOB
-- ----------------------------
INSERT INTO "T_JOB" VALUES ('3', 'testTask', 'test', 'hello world', '0/1 * * * * ?', '1 ', '有参任务调度测试,每隔一秒触发', TO_DATE('2018-02-26 09:28:26', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB" VALUES ('1', 'testTask', 'test', 'mrbird', '0/1 * * * * ?', '1 ', '有参任务调度测试', TO_DATE('2018-02-24 16:26:14', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB" VALUES ('2', 'testTask', 'test1', null, '0/10 * * * * ?', '1 ', '无参任务调度测试', TO_DATE('2018-02-24 17:06:23', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB" VALUES ('11', 'testTask', 'test2', null, '0/5 * * * * ?', '1 ', '测试异常', TO_DATE('2018-02-26 11:15:30', 'YYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for T_JOB_LOG
-- ----------------------------
CREATE TABLE "T_JOB_LOG" (
"LOG_ID" NUMBER NOT NULL ,
"JOB_ID" NUMBER NOT NULL ,
"BEAN_NAME" VARCHAR2(100 BYTE) NOT NULL ,
"METHOD_NAME" VARCHAR2(100 BYTE) NOT NULL ,
"PARAMS" VARCHAR2(200 BYTE) NULL ,
"STATUS" CHAR(2 BYTE) NOT NULL ,
"ERROR" VARCHAR2(2000 BYTE) NULL ,
"TIMES" NUMBER(11) NULL ,
"CREATE_TIME" DATE NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON COLUMN "T_JOB_LOG"."LOG_ID" IS '任务日志id';
COMMENT ON COLUMN "T_JOB_LOG"."JOB_ID" IS '任务id';
COMMENT ON COLUMN "T_JOB_LOG"."BEAN_NAME" IS 'spring bean名称';
COMMENT ON COLUMN "T_JOB_LOG"."METHOD_NAME" IS '方法名';
COMMENT ON COLUMN "T_JOB_LOG"."PARAMS" IS '参数';
COMMENT ON COLUMN "T_JOB_LOG"."STATUS" IS '任务状态    0：成功    1：失败';
COMMENT ON COLUMN "T_JOB_LOG"."ERROR" IS '失败信息';
COMMENT ON COLUMN "T_JOB_LOG"."TIMES" IS '耗时(单位：毫秒)';
COMMENT ON COLUMN "T_JOB_LOG"."CREATE_TIME" IS '创建时间';

-- ----------------------------
-- Records of T_JOB_LOG
-- ----------------------------
INSERT INTO "T_JOB_LOG" VALUES ('2430', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:22', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2432', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:24', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2412', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:05', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2413', '1', 'testTask', 'test', 'mrbird', '0 ', null, '10', TO_DATE('2018-03-19 10:08:05', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2415', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:07', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2417', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:09', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2419', '1', 'testTask', 'test', 'mrbird', '0 ', null, '3', TO_DATE('2018-03-19 10:08:11', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2421', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:13', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2423', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:15', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2425', '1', 'testTask', 'test', 'mrbird', '0 ', null, '2', TO_DATE('2018-03-19 10:08:17', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2427', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:19', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2428', '1', 'testTask', 'test', 'mrbird', '0 ', null, '10', TO_DATE('2018-03-19 10:08:20', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2434', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:26', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2436', '11', 'testTask', 'test2', null, '1 ', 'java.lang.NoSuchMethodException: cc.mrbird.job.task.TestTask.test2()', '3', TO_DATE('2018-03-19 10:08:34', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2394', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:38', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2395', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:39', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2396', '3', 'testTask', 'test', 'hello world', '0 ', null, '2', TO_DATE('2018-03-19 10:07:40', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2398', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:42', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2401', '3', 'testTask', 'test', 'hello world', '0 ', null, '0', TO_DATE('2018-03-19 10:07:45', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2403', '3', 'testTask', 'test', 'hello world', '0 ', null, '6', TO_DATE('2018-03-19 10:07:47', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2405', '3', 'testTask', 'test', 'hello world', '0 ', null, '0', TO_DATE('2018-03-19 10:07:49', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2409', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:53', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2392', '3', 'testTask', 'test', 'hello world', '0 ', null, '29', TO_DATE('2018-03-19 10:07:36', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2406', '3', 'testTask', 'test', 'hello world', '0 ', null, '0', TO_DATE('2018-03-19 10:07:50', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2393', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:37', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2397', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:41', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2399', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:43', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2400', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:44', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2402', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:46', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2404', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:48', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2407', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:51', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2408', '3', 'testTask', 'test', 'hello world', '0 ', null, '1', TO_DATE('2018-03-19 10:07:52', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2414', '1', 'testTask', 'test', 'mrbird', '0 ', null, '2', TO_DATE('2018-03-19 10:08:06', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2416', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:08', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2418', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:10', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2420', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:12', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2422', '1', 'testTask', 'test', 'mrbird', '0 ', null, '3', TO_DATE('2018-03-19 10:08:14', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2424', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:16', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2426', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:18', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2429', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:21', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2431', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:23', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2433', '1', 'testTask', 'test', 'mrbird', '0 ', null, '1', TO_DATE('2018-03-19 10:08:25', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_JOB_LOG" VALUES ('2435', '1', 'testTask', 'test', 'mrbird', '0 ', null, '5', TO_DATE('2018-03-19 10:08:27', 'YYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for T_LOG
-- ----------------------------
CREATE TABLE "T_LOG" (
"ID" NUMBER(20) NOT NULL ,
"USERNAME" VARCHAR2(50 BYTE) NULL ,
"OPERATION" VARCHAR2(500 BYTE) NULL ,
"TIME" NUMBER(11) NULL ,
"METHOD" VARCHAR2(4000 BYTE) NULL ,
"PARAMS" VARCHAR2(4000 BYTE) NULL ,
"IP" VARCHAR2(64 BYTE) NULL ,
"CREATE_TIME" DATE NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of T_LOG
-- ----------------------------
INSERT INTO "T_LOG" VALUES ('737', 'MrBird', '暂停任务', '11', 'cc.mrbird.job.controller.JobController.pauseJob()', 'jobIds: 1', '127.0.0.1', TO_DATE('2018-03-19 10:08:27', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_LOG" VALUES ('738', 'MrBird', '执行任务', '14', 'cc.mrbird.job.controller.JobController.runJob()', 'jobIds: 11', '127.0.0.1', TO_DATE('2018-03-19 10:08:34', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_LOG" VALUES ('745', 'MrBird', '删除用户', '117', 'cc.mrbird.system.controller.UserController.deleteUsers()', 'ids: 69,87,90,163', '127.0.0.1', TO_DATE('2018-03-19 10:38:19', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_LOG" VALUES ('746', 'MrBird', '删除用户', '8', 'cc.mrbird.system.controller.UserController.deleteUsers()', 'ids: 64', '127.0.0.1', TO_DATE('2018-03-19 10:38:25', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_LOG" VALUES ('730', 'MrBird', '恢复任务', '55', 'cc.mrbird.job.controller.JobController.resumeJob()', 'jobIds: 3', '127.0.0.1', TO_DATE('2018-03-19 10:07:32', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_LOG" VALUES ('731', 'MrBird', '执行任务', '40', 'cc.mrbird.job.controller.JobController.runJob()', 'jobIds: 3', '127.0.0.1', TO_DATE('2018-03-19 10:07:36', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_LOG" VALUES ('733', 'MrBird', '暂停任务', '10', 'cc.mrbird.job.controller.JobController.pauseJob()', 'jobIds: 3', '127.0.0.1', TO_DATE('2018-03-19 10:07:53', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_LOG" VALUES ('734', 'MrBird', '恢复任务', '17', 'cc.mrbird.job.controller.JobController.resumeJob()', 'jobIds: 1', '127.0.0.1', TO_DATE('2018-03-19 10:08:02', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_LOG" VALUES ('735', 'MrBird', '执行任务', '13', 'cc.mrbird.job.controller.JobController.runJob()', 'jobIds: 1', '127.0.0.1', TO_DATE('2018-03-19 10:08:05', 'YYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for T_MENU
-- ----------------------------
CREATE TABLE "T_MENU" (
"MENU_ID" NUMBER NOT NULL ,
"PARENT_ID" NUMBER NOT NULL ,
"MENU_NAME" VARCHAR2(50 BYTE) NOT NULL ,
"URL" VARCHAR2(100 BYTE) NULL ,
"PERMS" VARCHAR2(500 BYTE) NULL ,
"ICON" VARCHAR2(50 BYTE) NULL ,
"TYPE" CHAR(2 BYTE) NOT NULL ,
"ORDER_NUM" NUMBER NULL ,
"CREATE_TIME" DATE NOT NULL ,
"MODIFY_TIME" DATE NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of T_MENU
-- ----------------------------
INSERT INTO "T_MENU" VALUES ('101', '0', '任务调度', null, null, 'zmdi zmdi-alarm', '0 ', null, TO_DATE('2018-02-24 15:52:57', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('86', '58', 'One 一个', null, null, null, '0 ', null, TO_DATE('2018-01-26 09:42:41', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-26 09:43:46', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_MENU" VALUES ('87', '86', '绘画', 'one/painting', null, null, '0 ', null, TO_DATE('2018-01-26 09:47:14', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-26 09:48:28', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_MENU" VALUES ('88', '86', '语文', 'one/yuwen', null, null, '0 ', null, TO_DATE('2018-01-26 09:47:40', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-26 09:48:15', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_MENU" VALUES ('89', '86', '散文', 'one/essay', null, null, '0 ', null, TO_DATE('2018-01-26 09:48:05', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('81', '58', '影视资讯', null, null, null, '0 ', null, TO_DATE('2018-01-22 14:12:59', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('82', '81', '正在热映', 'movie/hot', null, null, '0 ', null, TO_DATE('2018-01-22 14:13:47', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('83', '81', '即将上映', 'movie/coming', null, null, '0 ', null, TO_DATE('2018-01-22 14:14:36', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('6', '1', '部门管理', 'dept', null, null, '0 ', '4', TO_DATE('2017-12-27 16:57:33', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('8', '2', '在线用户', 'session', null, null, '0 ', '1', TO_DATE('2017-12-27 16:59:33', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('10', '2', '系统日志', 'log', null, null, '0 ', '3', TO_DATE('2017-12-27 17:00:50', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('20', '6', '新增部门', null, 'dept:add', null, '1 ', null, TO_DATE('2017-12-27 17:09:24', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('21', '6', '修改部门', null, 'dept:update', null, '1 ', null, TO_DATE('2017-12-27 17:09:24', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('22', '6', '删除部门', null, 'dept:delete', null, '1 ', null, TO_DATE('2017-12-27 17:09:24', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('24', '10', '删除日志', null, 'log:delete', null, '1 ', null, TO_DATE('2017-12-27 17:11:45', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('14', '4', '新增角色', null, 'role:add', null, '1 ', null, TO_DATE('2017-12-27 17:06:38', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('15', '4', '修改角色', null, 'role:update', null, '1 ', null, TO_DATE('2017-12-27 17:06:38', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('16', '4', '删除角色', null, 'role:delete', null, '1 ', null, TO_DATE('2017-12-27 17:06:38', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('1', '0', '系统管理', null, null, 'zmdi zmdi-settings', '0 ', '1', TO_DATE('2017-12-27 16:39:07', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('2', '0', '系统监控', null, null, 'zmdi zmdi-shield-security', '0 ', '2', TO_DATE('2017-12-27 16:45:51', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-17 17:08:28', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_MENU" VALUES ('3', '1', '用户管理', 'user', null, null, '0 ', '1', TO_DATE('2017-12-27 16:47:13', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-22 16:44:09', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_MENU" VALUES ('4', '1', '角色管理', 'role', null, null, '0 ', '2', TO_DATE('2017-12-27 16:48:09', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('5', '1', '菜单管理', 'menu', null, null, '0 ', '3', TO_DATE('2017-12-27 16:48:57', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('11', '3', '新增用户', null, 'user:add', null, '1 ', null, TO_DATE('2017-12-27 17:02:58', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('12', '3', '修改用户', null, 'user:update', null, '1 ', null, TO_DATE('2017-12-27 17:04:07', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('13', '3', '删除用户', null, 'user:delete', null, '1 ', null, TO_DATE('2017-12-27 17:04:58', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('17', '5', '新增菜单', null, 'menu:add', null, '1 ', null, TO_DATE('2017-12-27 17:08:02', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('18', '5', '修改菜单', null, 'menu:update', null, '1 ', null, TO_DATE('2017-12-27 17:08:02', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('19', '5', '删除菜单', null, 'menu:delete', null, '1 ', null, TO_DATE('2017-12-27 17:08:02', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('23', '8', '踢出用户', null, 'user:kickout', null, '1 ', null, TO_DATE('2017-12-27 17:11:13', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('59', '58', '天气查询', 'weather', null, null, '0 ', null, TO_DATE('2018-01-12 15:40:02', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('61', '58', '每日一文', 'article', null, null, '0 ', null, TO_DATE('2018-01-15 17:17:14', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('58', '0', '网络资源', null, null, 'zmdi zmdi-globe-alt', '0 ', null, TO_DATE('2018-01-12 15:28:48', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-22 19:49:26', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_MENU" VALUES ('65', '64', '新增字典', null, 'dict:add', null, '1 ', null, TO_DATE('2018-01-18 19:10:08', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('66', '64', '修改字典', null, 'dict:update', null, '1 ', null, TO_DATE('2018-01-18 19:10:27', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('67', '64', '删除字典', null, 'dict:delete', null, '1 ', null, TO_DATE('2018-01-18 19:10:47', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('64', '1', '字典管理', 'dict', null, null, '0 ', null, TO_DATE('2018-01-18 10:38:25', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-18 18:59:33', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_MENU" VALUES ('102', '101', '定时任务', 'job', null, null, '0 ', null, TO_DATE('2018-02-24 15:53:53', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('103', '102', '新增任务', null, 'job:add', null, '1 ', null, TO_DATE('2018-02-24 15:55:10', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('104', '102', '修改任务', null, 'job:update', null, '1 ', null, TO_DATE('2018-02-24 15:55:53', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('105', '102', '删除任务', null, 'job:delete', null, '1 ', null, TO_DATE('2018-02-24 15:56:18', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('106', '102', '暂停任务', null, 'job:pause', null, '1 ', null, TO_DATE('2018-02-24 15:57:08', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('107', '102', '恢复任务', null, 'job:resume', null, '1 ', null, TO_DATE('2018-02-24 15:58:21', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('108', '102', '立即执行任务', null, 'job:run', null, '1 ', null, TO_DATE('2018-02-24 15:59:45', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('109', '101', '调度日志', 'jobLog', null, null, '0 ', null, TO_DATE('2018-02-24 16:00:45', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_MENU" VALUES ('110', '109', '删除日志', null, 'jobLog:delete', null, '1 ', null, TO_DATE('2018-02-24 16:01:21', 'YYYY-MM-DD HH24:MI:SS'), null);

-- ----------------------------
-- Table structure for T_ROLE
-- ----------------------------
CREATE TABLE "T_ROLE" (
"ROLE_ID" NUMBER NOT NULL ,
"ROLE_NAME" VARCHAR2(100 BYTE) NOT NULL ,
"REMARK" VARCHAR2(100 BYTE) NULL ,
"CREATE_TIME" DATE NOT NULL ,
"MODIFY_TIME" DATE NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of T_ROLE
-- ----------------------------
INSERT INTO "T_ROLE" VALUES ('23', '用户管理员', '负责用户的增删改操作', TO_DATE('2018-01-09 15:32:41', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_ROLE" VALUES ('1', '管理员', '管理员', TO_DATE('2017-12-27 16:23:11', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-02-24 16:01:45', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_ROLE" VALUES ('2', '测试账号', '测试账号', TO_DATE('2017-12-27 16:25:09', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-23 09:11:11', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_ROLE" VALUES ('3', '注册账户', '注册账户，只可查看，不可操作', TO_DATE('2017-12-29 16:00:15', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-02-24 17:33:45', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_ROLE" VALUES ('24', '系统监控员', '可查看系统监控信息，但不可操作', TO_DATE('2018-01-09 15:52:01', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-07 19:05:33', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_ROLE" VALUES ('25', '用户查看', '查看用户，无相应操作权限', TO_DATE('2018-01-09 15:56:30', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_ROLE" VALUES ('63', '影院工作者', '可查看影视信息', TO_DATE('2018-02-06 08:48:28', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-07 19:05:26', 'YYYY-MM-DD HH24:MI:SS'));
INSERT INTO "T_ROLE" VALUES ('64', '天气预报员', '可查看天气预报信息', TO_DATE('2018-02-27 08:47:04', 'YYYY-MM-DD HH24:MI:SS'), null);
INSERT INTO "T_ROLE" VALUES ('65', '文章审核', '文章类', TO_DATE('2018-02-27 08:48:01', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-13 11:20:34', 'YYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for T_ROLE_MENU
-- ----------------------------
CREATE TABLE "T_ROLE_MENU" (
"ROLE_ID" NUMBER NOT NULL ,
"MENU_ID" NUMBER NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of T_ROLE_MENU
-- ----------------------------
INSERT INTO "T_ROLE_MENU" VALUES ('3', '58');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '59');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '61');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '81');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '82');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '83');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '86');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '87');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '88');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '89');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '1');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '3');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '4');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '5');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '6');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '64');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '2');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '8');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '10');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '101');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '102');
INSERT INTO "T_ROLE_MENU" VALUES ('3', '109');
INSERT INTO "T_ROLE_MENU" VALUES ('63', '58');
INSERT INTO "T_ROLE_MENU" VALUES ('63', '81');
INSERT INTO "T_ROLE_MENU" VALUES ('63', '82');
INSERT INTO "T_ROLE_MENU" VALUES ('63', '83');
INSERT INTO "T_ROLE_MENU" VALUES ('24', '8');
INSERT INTO "T_ROLE_MENU" VALUES ('24', '2');
INSERT INTO "T_ROLE_MENU" VALUES ('24', '10');
INSERT INTO "T_ROLE_MENU" VALUES ('65', '86');
INSERT INTO "T_ROLE_MENU" VALUES ('65', '88');
INSERT INTO "T_ROLE_MENU" VALUES ('65', '89');
INSERT INTO "T_ROLE_MENU" VALUES ('65', '58');
INSERT INTO "T_ROLE_MENU" VALUES ('65', '61');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '81');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '61');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '24');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '82');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '83');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '58');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '59');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '2');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '8');
INSERT INTO "T_ROLE_MENU" VALUES ('2', '10');
INSERT INTO "T_ROLE_MENU" VALUES ('23', '11');
INSERT INTO "T_ROLE_MENU" VALUES ('23', '12');
INSERT INTO "T_ROLE_MENU" VALUES ('23', '13');
INSERT INTO "T_ROLE_MENU" VALUES ('23', '3');
INSERT INTO "T_ROLE_MENU" VALUES ('23', '1');
INSERT INTO "T_ROLE_MENU" VALUES ('25', '1');
INSERT INTO "T_ROLE_MENU" VALUES ('25', '3');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '59');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '2');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '3');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '67');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '1');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '4');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '5');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '6');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '20');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '21');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '22');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '10');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '8');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '58');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '66');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '11');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '12');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '64');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '13');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '14');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '65');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '15');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '16');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '17');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '18');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '23');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '81');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '82');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '83');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '19');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '24');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '61');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '86');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '87');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '88');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '89');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '101');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '102');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '103');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '104');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '105');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '106');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '107');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '108');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '109');
INSERT INTO "T_ROLE_MENU" VALUES ('1', '110');
INSERT INTO "T_ROLE_MENU" VALUES ('64', '59');
INSERT INTO "T_ROLE_MENU" VALUES ('64', '58');

-- ----------------------------
-- Table structure for T_USER
-- ----------------------------
CREATE TABLE "T_USER" (
"USER_ID" NUMBER NOT NULL ,
"USERNAME" VARCHAR2(50 BYTE) NOT NULL ,
"PASSWORD" VARCHAR2(128 BYTE) NOT NULL ,
"DEPT_ID" NUMBER NULL ,
"EMAIL" VARCHAR2(128 BYTE) NULL ,
"MOBILE" VARCHAR2(20 BYTE) NULL ,
"STATUS" CHAR(1 BYTE) NOT NULL ,
"CRATE_TIME" DATE NOT NULL ,
"MODIFY_TIME" DATE NULL ,
"LAST_LOGIN_TIME" DATE NULL ,
"SSEX" CHAR(1 BYTE) NULL ,
"THEME" VARCHAR2(10 BYTE) NULL ,
"AVATAR" VARCHAR2(100 BYTE) NULL ,
"DESCRIPTION" VARCHAR2(100 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of T_USER
-- ----------------------------
INSERT INTO "T_USER" VALUES ('162', 'beibei', 'b5ce06e87e255d097fb6956f7fb0d8b3', '5', 'beibei@qq.com', '13488873263', '1', TO_DATE('2018-02-24 17:34:14', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-01 16:11:43', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-14 11:41:39', 'YYYY-MM-DD HH24:MI:SS'), '2', 'green', '17e420c250804efe904a09a33796d5a10.jpg', '我是贝贝。');
INSERT INTO "T_USER" VALUES ('41', 'hippo', 'ed08932437f80522619de4b7f87fcdda', '4', 'hq@qq.com', '18067887364', '1', TO_DATE('2017-12-29 19:53:03', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-02-06 11:33:22', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-02-06 11:37:14', 'YYYY-MM-DD HH24:MI:SS'), '1', 'teal', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('4', 'MrBird', '42ee25d1e43e9f57119a00d0a39e5250', '1', '852252812@qq.com', '17720888889', '1', TO_DATE('2017-12-27 15:47:19', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-01 16:07:39', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-19 14:12:47', 'YYYY-MM-DD HH24:MI:SS'), '0', 'green', '595ba7b05f2e485eb50565a50cb6cc3c.jpeg', '我就是我 颜色不一样的烟火...');
INSERT INTO "T_USER" VALUES ('6', 'tester', '243e29429b340192700677d48c09d992', '6', 'tester@qq.com', '13888888888', '1', TO_DATE('2017-12-27 17:35:14', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-01 16:52:30', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-23 09:17:27', 'YYYY-MM-DD HH24:MI:SS'), '1', 'teal', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('23', 'scott', 'ac3af72d9f95161a502fd326865c2f15', '6', 'scott@qq.com', '15134627389', '1', TO_DATE('2017-12-29 16:16:39', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-01 16:11:33', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-19 14:14:35', 'YYYY-MM-DD HH24:MI:SS'), '1', 'blue-grey', 'default.jpg', '我是scott');
INSERT INTO "T_USER" VALUES ('24', 'smith', '228208eafc74e48c44619cc543fc0efe', '3', 'smith@qq.com', '13364754932', '1', TO_DATE('2017-12-29 16:21:31', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-02-27 08:48:16', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-02-27 08:48:27', 'YYYY-MM-DD HH24:MI:SS'), '1', 'teal', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('25', 'allen', '83baac97928a113986054efacaeec1d2', '3', 'allen@qq.com', '13427374857', '0', TO_DATE('2017-12-29 16:21:54', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-17 11:28:16', 'YYYY-MM-DD HH24:MI:SS'), null, '1', 'indigo', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('26', 'martin', 'b26c9edca9a61016bca1f6fb042e679e', '4', 'martin@qq.com', '15562736678', '1', TO_DATE('2017-12-29 16:22:24', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-25 09:23:15', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-25 17:24:50', 'YYYY-MM-DD HH24:MI:SS'), '1', 'teal', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('27', 'ford', '0448f0dcfd856b0e831842072b532141', '6', 'ford@qq.com', '15599998373', '0', TO_DATE('2017-12-29 16:22:52', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-13 11:19:56', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-03-08 16:31:59', 'YYYY-MM-DD HH24:MI:SS'), '0', 'cyan', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('68', 'kangkang', '9983fe3651aaef335ec77159712009af', '2', 'kangkang@hotmail.com', '18874783892', '1', TO_DATE('2018-01-03 17:23:24', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-17 11:27:39', 'YYYY-MM-DD HH24:MI:SS'), null, '0', 'green', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('92', 'userLook', '815bffb1baa36e14e8b0b5887a853291', '3', 'userlook@163.com', '13455998888', '1', TO_DATE('2018-01-09 15:56:58', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-17 11:17:42', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-09 15:57:09', 'YYYY-MM-DD HH24:MI:SS'), '1', 'indigo', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('125', '卑微的浮萍', 'c1cc7ea10ee9b41fd33f129394480612', '6', 'BWDFP@163.com', '17728872787', '0', TO_DATE('2018-01-17 15:05:15', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-19 09:20:35', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-17 15:05:27', 'YYYY-MM-DD HH24:MI:SS'), '2', 'green', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('91', '系统监控员', '7c28d1cd33414ac15832f7be92668b7a', '6', 'xtjk@qq.com', '18088736652', '1', TO_DATE('2018-01-09 15:52:56', 'YYYY-MM-DD HH24:MI:SS'), null, TO_DATE('2018-01-09 15:53:12', 'YYYY-MM-DD HH24:MI:SS'), '0', 'cyan', 'default.jpg', null);
INSERT INTO "T_USER" VALUES ('161', 'hero', '1ab36105101bab2e665eeeb954ee4aa2', '4', 'hero@qq.com', '13477589012', '0', TO_DATE('2018-02-05 14:54:25', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-02-27 14:57:20', 'YYYY-MM-DD HH24:MI:SS'), null, '0', 'green', 'default.jpg', null);

-- ----------------------------
-- Table structure for T_USER_ROLE
-- ----------------------------
CREATE TABLE "T_USER_ROLE" (
"USER_ID" NUMBER NOT NULL ,
"ROLE_ID" NUMBER NOT NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of T_USER_ROLE
-- ----------------------------
INSERT INTO "T_USER_ROLE" VALUES ('27', '3');
INSERT INTO "T_USER_ROLE" VALUES ('24', '65');
INSERT INTO "T_USER_ROLE" VALUES ('161', '64');
INSERT INTO "T_USER_ROLE" VALUES ('4', '1');
INSERT INTO "T_USER_ROLE" VALUES ('23', '3');
INSERT INTO "T_USER_ROLE" VALUES ('23', '24');
INSERT INTO "T_USER_ROLE" VALUES ('23', '25');
INSERT INTO "T_USER_ROLE" VALUES ('162', '1');
INSERT INTO "T_USER_ROLE" VALUES ('162', '3');
INSERT INTO "T_USER_ROLE" VALUES ('26', '3');
INSERT INTO "T_USER_ROLE" VALUES ('26', '23');
INSERT INTO "T_USER_ROLE" VALUES ('26', '24');
INSERT INTO "T_USER_ROLE" VALUES ('92', '25');
INSERT INTO "T_USER_ROLE" VALUES ('68', '1');
INSERT INTO "T_USER_ROLE" VALUES ('92', '2');
INSERT INTO "T_USER_ROLE" VALUES ('92', '3');
INSERT INTO "T_USER_ROLE" VALUES ('25', '3');
INSERT INTO "T_USER_ROLE" VALUES ('125', '3');
INSERT INTO "T_USER_ROLE" VALUES ('91', '24');
INSERT INTO "T_USER_ROLE" VALUES ('165', '3');
INSERT INTO "T_USER_ROLE" VALUES ('41', '1');
INSERT INTO "T_USER_ROLE" VALUES ('6', '2');

-- ----------------------------
-- Sequence structure for SEQ_DEPT
-- ----------------------------
CREATE SEQUENCE "SEQ_DEPT"
 INCREMENT BY 1
 MINVALUE 1
 MAXVALUE 9999999999999999999999999999
 START WITH 163
 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_DICT
-- ----------------------------
CREATE SEQUENCE "SEQ_DICT"
 INCREMENT BY 1
 MINVALUE 1
 MAXVALUE 9999999999999999999999999999
 START WITH 50
 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_JOB
-- ----------------------------
CREATE SEQUENCE "SEQ_JOB"
 INCREMENT BY 1
 MINVALUE 1
 MAXVALUE 9999999999999999999999999999
 START WITH 21
 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_JOB_LOG
-- ----------------------------
CREATE SEQUENCE "SEQ_JOB_LOG"
 INCREMENT BY 1
 MINVALUE 1
 MAXVALUE 9999999999999999999999999999
 START WITH 2441
 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_LOG
-- ----------------------------
CREATE SEQUENCE "SEQ_LOG"
 INCREMENT BY 1
 MINVALUE 1
 MAXVALUE 9999999999999999999999999999
 START WITH 775
 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_MENU
-- ----------------------------
CREATE SEQUENCE "SEQ_MENU"
 INCREMENT BY 1
 MINVALUE 1
 MAXVALUE 9999999999999999999999999999
 START WITH 141
 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_ROLE
-- ----------------------------
CREATE SEQUENCE "SEQ_ROLE"
 INCREMENT BY 1
 MINVALUE 1
 MAXVALUE 9999999999999999999999999999
 START WITH 84
 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_USER
-- ----------------------------
CREATE SEQUENCE "SEQ_USER"
 INCREMENT BY 1
 MINVALUE 1
 MAXVALUE 9999999999999999999999999999
 START WITH 182
 CACHE 20;

-- ----------------------------
-- Indexes structure for table QRTZ_BLOB_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Checks structure for table QRTZ_BLOB_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD CHECK ("TRIGGER_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD CHECK ("TRIGGER_GROUP" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_BLOB_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Indexes structure for table QRTZ_CALENDARS
-- ----------------------------

-- ----------------------------
-- Checks structure for table QRTZ_CALENDARS
-- ----------------------------
ALTER TABLE "QRTZ_CALENDARS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_CALENDARS" ADD CHECK ("CALENDAR_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_CALENDARS" ADD CHECK ("CALENDAR" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_CALENDARS
-- ----------------------------
ALTER TABLE "QRTZ_CALENDARS" ADD PRIMARY KEY ("SCHED_NAME", "CALENDAR_NAME");

-- ----------------------------
-- Indexes structure for table QRTZ_CRON_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Checks structure for table QRTZ_CRON_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CHECK ("TRIGGER_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CHECK ("TRIGGER_GROUP" IS NOT NULL);
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CHECK ("CRON_EXPRESSION" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_CRON_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Indexes structure for table QRTZ_FIRED_TRIGGERS
-- ----------------------------
CREATE INDEX "IDX_QRTZ_FT_INST_JOB_REQ_RCVRY"
ON "QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "INSTANCE_NAME" ASC, "REQUESTS_RECOVERY" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_FT_JG"
ON "QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "JOB_GROUP" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_FT_J_G"
ON "QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "JOB_NAME" ASC, "JOB_GROUP" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_FT_TG"
ON "QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_GROUP" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_FT_TRIG_INST_NAME"
ON "QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "INSTANCE_NAME" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_FT_T_G"
ON "QRTZ_FIRED_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_NAME" ASC, "TRIGGER_GROUP" ASC)
LOGGING
VISIBLE;

-- ----------------------------
-- Checks structure for table QRTZ_FIRED_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CHECK ("ENTRY_ID" IS NOT NULL);
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CHECK ("TRIGGER_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CHECK ("TRIGGER_GROUP" IS NOT NULL);
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CHECK ("INSTANCE_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CHECK ("FIRED_TIME" IS NOT NULL);
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CHECK ("SCHED_TIME" IS NOT NULL);
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CHECK ("PRIORITY" IS NOT NULL);
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CHECK ("STATE" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_FIRED_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD PRIMARY KEY ("SCHED_NAME", "ENTRY_ID");

-- ----------------------------
-- Indexes structure for table QRTZ_JOB_DETAILS
-- ----------------------------
CREATE INDEX "IDX_QRTZ_J_GRP"
ON "QRTZ_JOB_DETAILS" ("SCHED_NAME" ASC, "JOB_GROUP" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_J_REQ_RECOVERY"
ON "QRTZ_JOB_DETAILS" ("SCHED_NAME" ASC, "REQUESTS_RECOVERY" ASC)
LOGGING
VISIBLE;

-- ----------------------------
-- Checks structure for table QRTZ_JOB_DETAILS
-- ----------------------------
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CHECK ("JOB_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CHECK ("JOB_GROUP" IS NOT NULL);
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CHECK ("JOB_CLASS_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CHECK ("IS_DURABLE" IS NOT NULL);
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CHECK ("IS_NONCONCURRENT" IS NOT NULL);
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CHECK ("IS_UPDATE_DATA" IS NOT NULL);
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CHECK ("REQUESTS_RECOVERY" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_JOB_DETAILS
-- ----------------------------
ALTER TABLE "QRTZ_JOB_DETAILS" ADD PRIMARY KEY ("SCHED_NAME", "JOB_NAME", "JOB_GROUP");

-- ----------------------------
-- Indexes structure for table QRTZ_LOCKS
-- ----------------------------

-- ----------------------------
-- Checks structure for table QRTZ_LOCKS
-- ----------------------------
ALTER TABLE "QRTZ_LOCKS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_LOCKS" ADD CHECK ("LOCK_NAME" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_LOCKS
-- ----------------------------
ALTER TABLE "QRTZ_LOCKS" ADD PRIMARY KEY ("SCHED_NAME", "LOCK_NAME");

-- ----------------------------
-- Indexes structure for table QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------

-- ----------------------------
-- Checks structure for table QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
ALTER TABLE "QRTZ_PAUSED_TRIGGER_GRPS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_PAUSED_TRIGGER_GRPS" ADD CHECK ("TRIGGER_GROUP" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
ALTER TABLE "QRTZ_PAUSED_TRIGGER_GRPS" ADD PRIMARY KEY ("SCHED_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Indexes structure for table QRTZ_SCHEDULER_STATE
-- ----------------------------

-- ----------------------------
-- Checks structure for table QRTZ_SCHEDULER_STATE
-- ----------------------------
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD CHECK ("INSTANCE_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD CHECK ("LAST_CHECKIN_TIME" IS NOT NULL);
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD CHECK ("CHECKIN_INTERVAL" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_SCHEDULER_STATE
-- ----------------------------
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD PRIMARY KEY ("SCHED_NAME", "INSTANCE_NAME");

-- ----------------------------
-- Indexes structure for table QRTZ_SIMPLE_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Checks structure for table QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CHECK ("TRIGGER_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CHECK ("TRIGGER_GROUP" IS NOT NULL);
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CHECK ("REPEAT_COUNT" IS NOT NULL);
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CHECK ("REPEAT_INTERVAL" IS NOT NULL);
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CHECK ("TIMES_TRIGGERED" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Indexes structure for table QRTZ_SIMPROP_TRIGGERS
-- ----------------------------

-- ----------------------------
-- Checks structure for table QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD CHECK ("TRIGGER_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD CHECK ("TRIGGER_GROUP" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Indexes structure for table QRTZ_TRIGGERS
-- ----------------------------
CREATE INDEX "IDX_QRTZ_T_C"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "CALENDAR_NAME" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_G"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_GROUP" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_J"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "JOB_NAME" ASC, "JOB_GROUP" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_JG"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "JOB_GROUP" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_NEXT_FIRE_TIME"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "NEXT_FIRE_TIME" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_NFT_MISFIRE"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "MISFIRE_INSTR" ASC, "NEXT_FIRE_TIME" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_NFT_ST"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_STATE" ASC, "NEXT_FIRE_TIME" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_NFT_ST_MISFIRE"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "MISFIRE_INSTR" ASC, "NEXT_FIRE_TIME" ASC, "TRIGGER_STATE" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_NFT_ST_MISFIRE_GRP"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "MISFIRE_INSTR" ASC, "NEXT_FIRE_TIME" ASC, "TRIGGER_GROUP" ASC, "TRIGGER_STATE" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_N_G_STATE"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_GROUP" ASC, "TRIGGER_STATE" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_N_STATE"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_NAME" ASC, "TRIGGER_GROUP" ASC, "TRIGGER_STATE" ASC)
LOGGING
VISIBLE;
CREATE INDEX "IDX_QRTZ_T_STATE"
ON "QRTZ_TRIGGERS" ("SCHED_NAME" ASC, "TRIGGER_STATE" ASC)
LOGGING
VISIBLE;

-- ----------------------------
-- Checks structure for table QRTZ_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_TRIGGERS" ADD CHECK ("SCHED_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_TRIGGERS" ADD CHECK ("TRIGGER_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_TRIGGERS" ADD CHECK ("TRIGGER_GROUP" IS NOT NULL);
ALTER TABLE "QRTZ_TRIGGERS" ADD CHECK ("JOB_NAME" IS NOT NULL);
ALTER TABLE "QRTZ_TRIGGERS" ADD CHECK ("JOB_GROUP" IS NOT NULL);
ALTER TABLE "QRTZ_TRIGGERS" ADD CHECK ("TRIGGER_STATE" IS NOT NULL);
ALTER TABLE "QRTZ_TRIGGERS" ADD CHECK ("TRIGGER_TYPE" IS NOT NULL);
ALTER TABLE "QRTZ_TRIGGERS" ADD CHECK ("START_TIME" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table QRTZ_TRIGGERS
-- ----------------------------
ALTER TABLE "QRTZ_TRIGGERS" ADD PRIMARY KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Indexes structure for table T_DEPT
-- ----------------------------

-- ----------------------------
-- Checks structure for table T_DEPT
-- ----------------------------
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("PARENT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_NAME" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("PARENT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_NAME" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("PARENT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_NAME" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("PARENT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_NAME" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("PARENT_ID" IS NOT NULL);
ALTER TABLE "T_DEPT" ADD CHECK ("DEPT_NAME" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table T_DEPT
-- ----------------------------
ALTER TABLE "T_DEPT" ADD PRIMARY KEY ("DEPT_ID");

-- ----------------------------
-- Indexes structure for table T_DICT
-- ----------------------------

-- ----------------------------
-- Checks structure for table T_DICT
-- ----------------------------
ALTER TABLE "T_DICT" ADD CHECK ("DICT_ID" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("KEY" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("VALUE" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("FIELD_NAME" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("TABLE_NAME" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("DICT_ID" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("KEY" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("VALUE" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("FIELD_NAME" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("TABLE_NAME" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("DICT_ID" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("KEY" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("VALUE" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("FIELD_NAME" IS NOT NULL);
ALTER TABLE "T_DICT" ADD CHECK ("TABLE_NAME" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table T_DICT
-- ----------------------------
ALTER TABLE "T_DICT" ADD PRIMARY KEY ("DICT_ID");

-- ----------------------------
-- Indexes structure for table T_JOB
-- ----------------------------

-- ----------------------------
-- Checks structure for table T_JOB
-- ----------------------------
ALTER TABLE "T_JOB" ADD CHECK ("JOB_ID" IS NOT NULL);
ALTER TABLE "T_JOB" ADD CHECK ("BEAN_NAME" IS NOT NULL);
ALTER TABLE "T_JOB" ADD CHECK ("METHOD_NAME" IS NOT NULL);
ALTER TABLE "T_JOB" ADD CHECK ("CRON_EXPRESSION" IS NOT NULL);
ALTER TABLE "T_JOB" ADD CHECK ("STATUS" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table T_JOB
-- ----------------------------
ALTER TABLE "T_JOB" ADD PRIMARY KEY ("JOB_ID");

-- ----------------------------
-- Indexes structure for table T_JOB_LOG
-- ----------------------------

-- ----------------------------
-- Checks structure for table T_JOB_LOG
-- ----------------------------
ALTER TABLE "T_JOB_LOG" ADD CHECK ("LOG_ID" IS NOT NULL);
ALTER TABLE "T_JOB_LOG" ADD CHECK ("JOB_ID" IS NOT NULL);
ALTER TABLE "T_JOB_LOG" ADD CHECK ("BEAN_NAME" IS NOT NULL);
ALTER TABLE "T_JOB_LOG" ADD CHECK ("METHOD_NAME" IS NOT NULL);
ALTER TABLE "T_JOB_LOG" ADD CHECK ("STATUS" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table T_JOB_LOG
-- ----------------------------
ALTER TABLE "T_JOB_LOG" ADD PRIMARY KEY ("LOG_ID");

-- ----------------------------
-- Checks structure for table T_LOG
-- ----------------------------
ALTER TABLE "T_LOG" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "T_LOG" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "T_LOG" ADD CHECK ("ID" IS NOT NULL);

-- ----------------------------
-- Checks structure for table T_MENU
-- ----------------------------
ALTER TABLE "T_MENU" ADD CHECK ("MENU_ID" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("PARENT_ID" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("MENU_NAME" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("TYPE" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("CREATE_TIME" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("MENU_ID" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("PARENT_ID" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("MENU_NAME" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("TYPE" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("CREATE_TIME" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("MENU_ID" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("PARENT_ID" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("MENU_NAME" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("TYPE" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("CREATE_TIME" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("MENU_ID" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("PARENT_ID" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("MENU_NAME" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("TYPE" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("CREATE_TIME" IS NOT NULL);
ALTER TABLE "T_MENU" ADD CHECK ("MENU_ID" IS NOT NULL);

-- ----------------------------
-- Checks structure for table T_ROLE
-- ----------------------------
ALTER TABLE "T_ROLE" ADD CHECK ("ROLE_ID" IS NOT NULL);
ALTER TABLE "T_ROLE" ADD CHECK ("ROLE_NAME" IS NOT NULL);
ALTER TABLE "T_ROLE" ADD CHECK ("CREATE_TIME" IS NOT NULL);
ALTER TABLE "T_ROLE" ADD CHECK ("ROLE_ID" IS NOT NULL);
ALTER TABLE "T_ROLE" ADD CHECK ("ROLE_NAME" IS NOT NULL);
ALTER TABLE "T_ROLE" ADD CHECK ("CREATE_TIME" IS NOT NULL);

-- ----------------------------
-- Checks structure for table T_ROLE_MENU
-- ----------------------------
ALTER TABLE "T_ROLE_MENU" ADD CHECK ("ROLE_ID" IS NOT NULL);
ALTER TABLE "T_ROLE_MENU" ADD CHECK ("MENU_ID" IS NOT NULL);
ALTER TABLE "T_ROLE_MENU" ADD CHECK ("ROLE_ID" IS NOT NULL);
ALTER TABLE "T_ROLE_MENU" ADD CHECK ("MENU_ID" IS NOT NULL);

-- ----------------------------
-- Checks structure for table T_USER
-- ----------------------------
ALTER TABLE "T_USER" ADD CHECK ("USER_ID" IS NOT NULL);
ALTER TABLE "T_USER" ADD CHECK ("USERNAME" IS NOT NULL);
ALTER TABLE "T_USER" ADD CHECK ("PASSWORD" IS NOT NULL);
ALTER TABLE "T_USER" ADD CHECK ("STATUS" IS NOT NULL);
ALTER TABLE "T_USER" ADD CHECK ("CRATE_TIME" IS NOT NULL);
ALTER TABLE "T_USER" ADD CHECK ("USER_ID" IS NOT NULL);
ALTER TABLE "T_USER" ADD CHECK ("USERNAME" IS NOT NULL);
ALTER TABLE "T_USER" ADD CHECK ("PASSWORD" IS NOT NULL);
ALTER TABLE "T_USER" ADD CHECK ("STATUS" IS NOT NULL);
ALTER TABLE "T_USER" ADD CHECK ("CRATE_TIME" IS NOT NULL);

-- ----------------------------
-- Checks structure for table T_USER_ROLE
-- ----------------------------
ALTER TABLE "T_USER_ROLE" ADD CHECK ("USER_ID" IS NOT NULL);
ALTER TABLE "T_USER_ROLE" ADD CHECK ("ROLE_ID" IS NOT NULL);
ALTER TABLE "T_USER_ROLE" ADD CHECK ("USER_ID" IS NOT NULL);
ALTER TABLE "T_USER_ROLE" ADD CHECK ("ROLE_ID" IS NOT NULL);

-- ----------------------------
-- Foreign Key structure for table "QRTZ_BLOB_TRIGGERS"
-- ----------------------------
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Foreign Key structure for table "QRTZ_CRON_TRIGGERS"
-- ----------------------------
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Foreign Key structure for table "QRTZ_SIMPLE_TRIGGERS"
-- ----------------------------
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Foreign Key structure for table "QRTZ_SIMPROP_TRIGGERS"
-- ----------------------------
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD FOREIGN KEY ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP") REFERENCES "QRTZ_TRIGGERS" ("SCHED_NAME", "TRIGGER_NAME", "TRIGGER_GROUP");

-- ----------------------------
-- Foreign Key structure for table "QRTZ_TRIGGERS"
-- ----------------------------
ALTER TABLE "QRTZ_TRIGGERS" ADD FOREIGN KEY ("SCHED_NAME", "JOB_NAME", "JOB_GROUP") REFERENCES "QRTZ_JOB_DETAILS" ("SCHED_NAME", "JOB_NAME", "JOB_GROUP");