[mysql] 123
Viewer
- CREATE TABLE `jbi_tree` (
- `id` int(11) NOT NULL,
- `text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `parent` int(11) NULL DEFAULT 0,
- `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
- `status` int(1) NULL DEFAULT 0,
- `info` json NULL,
- `variant` json NULL,
- `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `lvl` int(2) NULL DEFAULT 0,
- `bread` json NULL,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `id`(`id`) USING BTREE,
- INDEX `type`(`type`) USING BTREE,
- INDEX `status`(`status`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
Editor
You can edit this paste and save as new: