123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666 |
- SET NAMES utf8mb4;
- SET FOREIGN_KEY_CHECKS = 0;
- -- ----------------------------
- -- Table structure for QRTZ_BLOB_TRIGGERS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
- CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `BLOB_DATA` blob NULL,
- PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
- CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_CALENDARS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
- CREATE TABLE `QRTZ_CALENDARS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `CALENDAR` blob NOT NULL,
- PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_CRON_TRIGGERS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
- CREATE TABLE `QRTZ_CRON_TRIGGERS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `CRON_EXPRESSION` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
- CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_FIRED_TRIGGERS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
- CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `ENTRY_ID` varchar(95) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `FIRED_TIME` bigint(13) NOT NULL,
- `SCHED_TIME` bigint(13) NOT NULL,
- `PRIORITY` int(11) NOT NULL,
- `STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_JOB_DETAILS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
- CREATE TABLE `QRTZ_JOB_DETAILS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `IS_DURABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `JOB_DATA` blob NULL,
- PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_LOCKS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_LOCKS`;
- CREATE TABLE `QRTZ_LOCKS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `LOCK_NAME` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
- CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_SCHEDULER_STATE
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
- CREATE TABLE `QRTZ_SCHEDULER_STATE` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
- `CHECKIN_INTERVAL` bigint(13) NOT NULL,
- PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_SIMPLE_TRIGGERS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
- CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `REPEAT_COUNT` bigint(7) NOT NULL,
- `REPEAT_INTERVAL` bigint(12) NOT NULL,
- `TIMES_TRIGGERED` bigint(10) NOT NULL,
- PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
- CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_SIMPROP_TRIGGERS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
- CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `STR_PROP_1` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `STR_PROP_2` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `STR_PROP_3` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `INT_PROP_1` int(11) NULL DEFAULT NULL,
- `INT_PROP_2` int(11) NULL DEFAULT NULL,
- `LONG_PROP_1` bigint(20) NULL DEFAULT NULL,
- `LONG_PROP_2` bigint(20) NULL DEFAULT NULL,
- `DEC_PROP_1` decimal(13, 4) NULL DEFAULT NULL,
- `DEC_PROP_2` decimal(13, 4) NULL DEFAULT NULL,
- `BOOL_PROP_1` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `BOOL_PROP_2` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
- CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for QRTZ_TRIGGERS
- -- ----------------------------
- DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
- CREATE TABLE `QRTZ_TRIGGERS` (
- `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `NEXT_FIRE_TIME` bigint(13) NULL DEFAULT NULL,
- `PREV_FIRE_TIME` bigint(13) NULL DEFAULT NULL,
- `PRIORITY` int(11) NULL DEFAULT NULL,
- `TRIGGER_STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `START_TIME` bigint(13) NOT NULL,
- `END_TIME` bigint(13) NULL DEFAULT NULL,
- `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `MISFIRE_INSTR` smallint(2) NULL DEFAULT NULL,
- `JOB_DATA` blob NULL,
- PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
- INDEX `SCHED_NAME`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
- CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for access_log
- -- ----------------------------
- DROP TABLE IF EXISTS `access_log`;
- CREATE TABLE `access_log` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `resource_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `resource_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `access_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `access_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
- `duration` int(11) NULL DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for dashboard
- -- ----------------------------
- DROP TABLE IF EXISTS `dashboard`;
- CREATE TABLE `dashboard` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `thumbnail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `status` tinyint(6) NOT NULL DEFAULT 1,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for datachart
- -- ----------------------------
- DROP TABLE IF EXISTS `datachart`;
- CREATE TABLE `datachart` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `view_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `thumbnail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `status` tinyint(6) NULL DEFAULT 1,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `view_id`(`view_id`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for download
- -- ----------------------------
- DROP TABLE IF EXISTS `download`;
- CREATE TABLE `download` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `path` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `last_download_time` timestamp(0) NULL DEFAULT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `create_by` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `status` tinyint(6) NOT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `create_by`(`create_by`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for folder
- -- ----------------------------
- DROP TABLE IF EXISTS `folder`;
- CREATE TABLE `folder` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `rel_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `rel_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `parent_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `index` double(16, 8) NULL DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `name_unique`(`name`, `org_id`, `parent_id`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE,
- INDEX `rel_id`(`rel_id`) USING BTREE,
- INDEX `parent_id`(`parent_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for link
- -- ----------------------------
- DROP TABLE IF EXISTS `link`;
- CREATE TABLE `link` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `rel_type` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `rel_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `expiration` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for org_settings
- -- ----------------------------
- DROP TABLE IF EXISTS `org_settings`;
- CREATE TABLE `org_settings` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `type` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `config` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for organization
- -- ----------------------------
- DROP TABLE IF EXISTS `organization`;
- CREATE TABLE `organization` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `update_time` datetime(0) NULL DEFAULT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `orgName`(`name`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for rel_role_resource
- -- ----------------------------
- DROP TABLE IF EXISTS `rel_role_resource`;
- CREATE TABLE `rel_role_resource` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `resource_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `resource_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `permission` int(11) NOT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `role_id_2`(`role_id`, `resource_id`, `resource_type`) USING BTREE,
- INDEX `role_id`(`role_id`) USING BTREE,
- INDEX `resource_id`(`resource_id`) USING BTREE,
- INDEX `resource_type`(`resource_type`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for rel_role_user
- -- ----------------------------
- DROP TABLE IF EXISTS `rel_role_user`;
- CREATE TABLE `rel_role_user` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `user_role`(`user_id`, `role_id`) USING BTREE,
- INDEX `user_id`(`user_id`) USING BTREE,
- INDEX `role_id`(`role_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for rel_subject_columns
- -- ----------------------------
- DROP TABLE IF EXISTS `rel_subject_columns`;
- CREATE TABLE `rel_subject_columns` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `view_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `subject_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `subject_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `column_permission` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `view_id`(`view_id`) USING BTREE,
- INDEX `subject_id`(`subject_id`) USING BTREE,
- INDEX `subject_type`(`subject_type`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for rel_user_organization
- -- ----------------------------
- DROP TABLE IF EXISTS `rel_user_organization`;
- CREATE TABLE `rel_user_organization` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `org_user`(`org_id`, `user_id`) USING BTREE,
- INDEX `user_id`(`user_id`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for rel_variable_subject
- -- ----------------------------
- DROP TABLE IF EXISTS `rel_variable_subject`;
- CREATE TABLE `rel_variable_subject` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `variable_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `subject_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `subject_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
- `use_default_value` tinyint(4) NOT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `user_var`(`variable_id`, `subject_type`, `subject_id`) USING BTREE,
- INDEX `variable_id`(`variable_id`) USING BTREE,
- INDEX `subject_id`(`subject_id`) USING BTREE,
- INDEX `subject_type`(`subject_type`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for rel_widget_element
- -- ----------------------------
- DROP TABLE IF EXISTS `rel_widget_element`;
- CREATE TABLE `rel_widget_element` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `widget_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `rel_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `rel_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `rel_id`(`rel_id`) USING BTREE,
- INDEX `rel_type`(`rel_type`) USING BTREE,
- INDEX `widget_id`(`widget_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for rel_widget_widget
- -- ----------------------------
- DROP TABLE IF EXISTS `rel_widget_widget`;
- CREATE TABLE `rel_widget_widget` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `source_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `target_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `config` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `source_id`(`source_id`) USING BTREE,
- INDEX `target_id`(`target_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for role
- -- ----------------------------
- DROP TABLE IF EXISTS `role`;
- CREATE TABLE `role` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `ord_and_name`(`org_id`, `name`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE,
- INDEX `type`(`type`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for schedule
- -- ----------------------------
- DROP TABLE IF EXISTS `schedule`;
- CREATE TABLE `schedule` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `active` tinyint(4) NOT NULL,
- `cron_expression` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `start_date` timestamp(0) NULL DEFAULT NULL,
- `end_date` timestamp(0) NULL DEFAULT NULL,
- `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `parent_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `is_folder` tinyint(1) NULL DEFAULT NULL,
- `index` int(11) NULL DEFAULT NULL,
- `status` tinyint(6) NOT NULL DEFAULT 1,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE,
- INDEX `create_by`(`create_by`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for schedule_log
- -- ----------------------------
- DROP TABLE IF EXISTS `schedule_log`;
- CREATE TABLE `schedule_log` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `schedule_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `start` timestamp(0) NULL DEFAULT NULL,
- `end` timestamp(0) NULL DEFAULT NULL,
- `status` int(11) NOT NULL,
- `message` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `schedule_id`(`schedule_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for source
- -- ----------------------------
- DROP TABLE IF EXISTS `source`;
- CREATE TABLE `source` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `status` tinyint(6) NOT NULL DEFAULT 1,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `org_name`(`name`, `org_id`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for storyboard
- -- ----------------------------
- DROP TABLE IF EXISTS `storyboard`;
- CREATE TABLE `storyboard` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `status` tinyint(6) NOT NULL DEFAULT 1,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for storypage
- -- ----------------------------
- DROP TABLE IF EXISTS `storypage`;
- CREATE TABLE `storypage` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `storyboard_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `rel_type` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `rel_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `config` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `storyboard_id`(`storyboard_id`) USING BTREE,
- INDEX `rel_type`(`rel_type`) USING BTREE,
- INDEX `rel_id`(`rel_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for user
- -- ----------------------------
- DROP TABLE IF EXISTS `user`;
- CREATE TABLE `user` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `active` tinyint(1) NULL DEFAULT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `username`(`username`) USING BTREE,
- UNIQUE INDEX `email`(`email`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for user_settings
- -- ----------------------------
- DROP TABLE IF EXISTS `user_settings`;
- CREATE TABLE `user_settings` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `rel_type` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `rel_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
- `config` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `user_id`(`user_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for variable
- -- ----------------------------
- DROP TABLE IF EXISTS `variable`;
- CREATE TABLE `variable` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `view_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `value_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `permission` int(11) NULL DEFAULT NULL,
- `encrypt` tinyint(4) NULL DEFAULT NULL,
- `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `default_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `expression` tinyint(4) NULL DEFAULT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `org_id`(`org_id`, `view_id`, `name`) USING BTREE,
- INDEX `org_id_2`(`org_id`) USING BTREE,
- INDEX `view_id`(`view_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for view
- -- ----------------------------
- DROP TABLE IF EXISTS `view`;
- CREATE TABLE `view` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `org_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `source_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `script` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `model` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- `parent_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `is_folder` tinyint(1) NULL DEFAULT NULL,
- `index` double(16, 8) NULL DEFAULT NULL,
- `status` tinyint(6) NOT NULL DEFAULT 1,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `unique_name`(`name`, `org_id`, `parent_id`) USING BTREE,
- INDEX `org_id`(`org_id`) USING BTREE,
- INDEX `source_id`(`source_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for widget
- -- ----------------------------
- DROP TABLE IF EXISTS `widget`;
- CREATE TABLE `widget` (
- `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `dashboard_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `config` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `parent_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `create_time` timestamp(0) NULL DEFAULT NULL,
- `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `dashboard_id`(`dashboard_id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- SET FOREIGN_KEY_CHECKS = 1;
|